Week: WEEK 4: RELATIONAL DATA MODEL, KEYS, AND INTEGRITY CONSTRAINTS | Data Management | NUEL

Section outline

- Select activity Constraint in DBMS
  
  Constraint in DBMS URL
- Select activity Week 4
  
  Week 4 Book
  
  Teaching and Learning Methods to be Employed
  
      i.         Lecture with relational model concepts and worked examples
  
  ii.         ER-to-relational mapping exercise
  
  iii.         Lab: Creating tables with constraints in MySQL
  
  iv.         Quiz on entity and referential integrity
  
  Learning Outcomes / Objectives
  
  By the end of this week, students should be able to:
  
  1.    Describe the relational data model using formal terminology.
  
  2.    Convert an ER diagram into a relational schema.
  
  3.    Define and distinguish between different types of keys.
  
  4.    Explain and implement entity integrity and referential integrity constraints.
  
  5.    Write SQL DDL statements to create tables with constraints.
- Select activity SQL Lab Exercise 1
  
  SQL Lab Exercise 1 Page
  
  Not available unless: The activity Course Outline is marked complete
- Select activity Course Discussion Forum
  
  Course Discussion Forum
  
  Due: Thursday, 25 June 2026, 7:05 PM