Sports Club Entity Model Essay Example | Topics and Well Written Essays - 2000 words

Sports Club Entity Model - Essay Example The various functionalities would include scalability of various operations, ease of performing updations and modifications of data, maintaining the integrity of data, security of data is ensured, efficient recovery manager, maintains concurrency control and plan for recovery techniques and many more. All this would promote the functioning of the airline reservation system. Choosing a database model is of greater importance. The relational data model is based on relational data structures, integrity constraints and smooth access to Data Definition Language and Data Manipulation Language statement for creation and retrieval of data. It is based on relational algebra (Navathe, 2004). The database for family budgeting system would include features like atomic values, primary and foreign key relationships, and normalization process to reduce redundancy and anomalies of insertion, modification and deletion errors, row and column structure of the database tables and all kind of relationshi ps are possible, one-to-one, one-to-many, many-to-one and many-to-many. Â  Data warehousing is a concept that is used for storing organization’s data and is usually termed as corporate memory. It contains the raw material for an enterprise’s MIS or DSS system. The analyst can perform complex queries which would be used for getting results and further interpretation of the data and the resultant information (William, 2000). The subject-oriented feature of the data warehousing takes into account the various elements that take place in the real world. It is non-volatile and integrated with respect to the data that they are never deleted and contains all the information with regard to business processing by the enterprise for all its operations. Â