Science - Course - Database Systems

  • Course Code: CMPS342
  • Credits: 3
  • Hours Distribution: (3Crs.:2Lec,3Lab)
  • Course Type: Major Core (MJC)

Course Description

Data models and database systems architectures. Conceptual data modeling using entity-relationship diagrams (ERD and Enhanced ERD). The relational database model. Mapping conceptual data models into physical relational design. Theory of functional dependencies and normalization. Relational algebra and tuple relational calculus. Data definition and retrieval using SQL language. Pre-req.: CMPS 242