CSC2741 Database Design

This course introduces students to practical and theoretical relational database concepts. Database Management Systems (DBMS) are vital components of modern computer systems and range from small in-memory databases to large distributed databases. Through a combination of lectures and labs, students will learn to analyze persistent data using the standard Entity-Relationship Model (ERM), and produce design documents using logical relational schema and physical design techniques. Students will refine their designs by evaluating functional dependencies, applying normalization rules, and employing database tuning methods. Students will ultimately implement a database using the standards-based Structured Query Language (SQL) and database programming methods. Ethical uses and management of data will also be included in the course. Students may not earn credit for both this course and CSC3741 Special Topics: Database Design. Credits: 3.000

CSC2635 Lecture Min Credits: 3.00