Database Systems And Business Intelligence
The database approach: Advantages and costs; how it contrasts with the conventional fileoriented approach. The relational model: What a data model is; the structural part of the relational model (structure of tables, attributes, tuple and keys); the relational algebra; entity and referential…
Learning outcomes
Upon completion of this course the student should be able to: 1. identify, design, implement and evaluate some basic business database solutions; 2. perform data manipulation and information retrieval operations; 3. understand the characteristics, strengths and limitations of current database systems; 4. synthesize information collected from a variety of sources, including other modules; 5. evaluate database and data management issues; 6. display skills in the application of programming; and 7. identify data base applications and architecture.
Course contents
The database approach: Advantages and costs; how it contrasts with the conventional fileoriented approach. The relational model: What a data model is; the structural part of the relational model (structure of tables, attributes, tuple and keys); the relational algebra; entity and referential integrity rules; architecture of a relational database management system (RDBMS) and its relationship to the relational model. SQL: Data query from single and multiple tables. Database design: Entity relationship modelling; relational data design; functional dependence; normalization, physical data design. Database housekeeping: Security, concurrency, integrity, and database administration. Use of a proprietary relational database management system. Limitations of the relational model. The gap between theory and practice. A survey of advanced database systems. Theoretical concepts. Relational model conformity and Integrity. Advanced SQL programming. Query optimization. Normalization Techniques. Concurrency control and transaction management. Database performance tuning. Distributed relational systems and data replication. Security considerations. New data base applications and architecture. Data warehousing. Multimedia. Mobility. Multitaskers. NoSQL. Native XML databases (NXD). Internet.