CSC 401 + Lab: Database Management

Offered Under: B.Sc. in Computer Science (CSC)
Description

An introduction to database design and the use of database management systems. The course includes detailed coverage of the development process, database architectural principles, relational algebra and SQL using Oracle or SQL Server. Other key database topics covered are data modelling (E-R model, relational data model, integrity constraints, data model operations, normalization, object oriented data modelling), database security, administration and distributed systems.



Course Type Major
Credit Hour 4
Lecture Hour 60
Expected Outcome(s):
  • Proficiency in the design of database applications starting from the conceptual design to the implementation of database schemas and user interfaces.
  • Solid foundation on database design concepts, data models (E/R model, relational model), the database query language SQL, and components of a database management system.
  • Basic understanding of data access structures, query processing and optimization techniques, and transaction management.


Grading Policy:

Letter Grade Marks Grade Point
A 90 - 100 4.00
A- 85 - 89 3.70
B+ 80 - 84 3.30
B 75 - 79 3.00
B- 70 - 74 2.70
C+ 65 - 69 2.30
C 60 - 64 2.00
C- 55 - 59 1.70
D+ 50 - 54 1.30
D 45 - 49 1.00
F 00 - 44 0.00