close

Enter your search term & enter. Esc or X to close.

School ofSciences

cs 471

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.

Topics:
Introduction to database systems
Entity relationship model
Relational design
Relational algebra
SQL, UML, ODL
Programming with SQL
Views, authorization
Transactions, constraints, triggers
Recursion, object oriented design
Object relational SQL
Data warehousing, data mining, XML

Final Exam: The final exam is comprehensive.