CSC 484 Database Management Systems

Course Goals

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.


Course Outcomes

A student who successfully completes this course should, at a minimum, be able to: 

  1. Understand the impact of database management systems on organizations.
  2. Know the purpose of the three-level database architecture and their mapping, and understand the terminology of the relational model.
  3. Identify the candidate, primary, and foreign keys in a relational database, and recognize the meaning and the enforcement of integrity constraints.
  4. Use entity-relationship diagrams (ERDs) in database design, and the mapping from ERD into a relational database.
  5. Write SQL queries, scripts, and stored procedures for manipulating and defining data.
  6. Create databases, populate them, and access and update the databases using various Database Servers from client software and web applications.
  7. Understand functional dependencies and the normalization process, identify anomalies and redundancies in relational databases, and apply normalization rules to ill-designed database tables.
  8. Understand the concept of a database transaction and its properties; recognize the purpose of concurrency control, database recovery, locks, and serializability.
 
  Computer Science Student Outcomes
Course Outcomes #1 #2 #3 #4 #5 #6 #7
1             X
2         X    
3         X    
4 X            
5 X            
6 X            
7              
8         X