CSC 484 Database Management Systems
The main objective of this course is to provide students with an understanding of how data is maintained and accessed from a database system, by a user, a programmer, or from the WWW. The course will help students to recognize the importance of database systems in the implementation of software applications.
A student who successfully completes this course should, at a minimum, be able to:
- Understand the impact of database management systems on organizations.
- Know the purpose of the three-level database architecture and their mapping, and understand the terminology of the relational model.
- Identify the candidate, primary, and foreign keys in a relational database, and recognize the meaning and the enforcement of integrity constraints.
- Use entity-relationship diagrams (ERDs) in database design, and the mapping from ERD into a relational database.
- Write SQL queries, scripts, and stored procedures for manipulating and defining data.
- Create databases, populate them, and access and update the databases using various Database Servers from client software and web applications.
- Understand functional dependencies and the normalization process, identify anomalies and redundancies in relational databases, and apply normalization rules to ill-designed database tables.
- Understand the concept of a database transaction and its properties; recognize the purpose of concurrency control, database recovery, locks, and serializability.