Nov 21, 2024  
2020-2021 Academic Catalog 
    
2020-2021 Academic Catalog [ARCHIVED CATALOG]

CSC2741 Special Topics: 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. Prerequisite of CSC2635  Computer Science II with a grade of “C” or higher. Credits: 3.000

CSC2635   Lecture Min Credits: 3.00 Min Grade: C