CSC (0145) 263 - Database Management System

Credits: 3.00

Students manipulate structured data using different data management techniques, and analyze data requirements. Students learn to design relational databases and use SQL to define, query, and update them. Students explore non-relational schemaless databases, and query them.

Prerequisite 1: CSC 156 and CSC 175
Repeatable: No Grade Type: Regular
Course Learning Goals: Students will:

• Have an appreciation of the role of data, files, and databases in information systems. This will be measured by Quizzes 1, 2, and the Mid-Term Examination.

• Understand the database development activities during the System Development Life Cycle (SDLC). This will be measured by Quizzes 3, 4, and the Mid-Term Examination.

• Be familiar with the data modeling concepts (Entity-Relationship and Class diagrams) that are used in database design. This will be measured by Quiz 5 and the Mid-Term Examination.

• Be able to create databases and pose complex SQL queries of relational databases. This will be measured by Lab Assignments 1, 2, and the Final Examination.

• Be knowledgeable about several Database Management Systems (DBMS’s such as MSAccess, Microsoft SQL Server, and ORACLE). This will be measured by Quizzes 6, 7, and the Final Examination.

• Be familiar with a broad range of data management issues including data integrity and security. This will be measured by Lab Assignment 3 and the Final Examination.

• Know how to utilize a CASE tool for data modeling and schema creation. This will be measured by the Final Examination.