CS 471 Database Design
Catalog Data: The course stresses the design of databases and their implementation using a relational database management system. Topics include entity-relationship and relational data models and database design. Abstract query languages (relational algebra) and SQL (language for creating, querying, and modifying relational and object-relational databases). Views, integrity, constraints, triggers, transactions and security. Data warehouses, data mining, temporal databases, XML.
Prerequisite: Junior or Senior standing.
Textbook: A First Course in Database Systems, third edition, J. Ullman, J Widom, Prentice Hall, 2008.
Goals: The goals are to teach the fundamentals of database use and the implementation of database applications.
Introduction to database systems
Entity relationship model
SQL, UML, ODL
Programming with SQL
Transactions, constraints, triggers
Recursion, object oriented design
Object relational SQL
Data warehousing, data mining, XML
Final Exam: The final exam is comprehensive.