Databases
Objectives:
(a) Design a database for an information system based on certain (given) business rules, (b) Implement the database on a Relational Database Management System (RDBMS), (c) Master SQL to manage the contents of a relational database, (d) Perform OLAP analysis on Data Warehouses.
Skills:
Acquire theoretical knowledge and practical skills on the design, implementation and management of relational databases.
Prerequisites:
-
Content:
Entity-Relationship model, Relational model, CASE tools for database synchronization and reverse engineering, SQL, normalization, database management issues, forms, reports, OLAP.
Textbooks:
Database Management Systems (3rd edition), by Raghu Ramakrishnan and Johannes Gehrke, McGraw-Hill, 2002.
Database Systems: The Complete Book (2nd Edition), by Hector Garcia-Molina, Jeffrey D. Ullman, and Jennifer Widom, Prentice Hall, 2008.
Assessment:
Four (4) Homework Assignments (50%)
Final Written Examination (50%)