COMP3311 Week 02 Lecture
Exercise: MessageBoard
Assignment 1
Assignment 1
Movies
Movie People
Photos
Movie Releases
Movie Organisations
Movie People at Work
Awards
Users
User Contributions
Relational Data Model
Relational Data Model
Example Database Schema
Example Database (Instance)
Integrity Constraints
Referential Integrity
Relational Databases
Mapping ER Designs to Relational Schemas
ER to Relational Mapping
Relational Model vs ER Model
Mapping Strong Entities
Mapping Weak Entities
Mapping N:M Relationships
Mapping 1:N Relationships
Mapping 1:1 Relationships
Exercise: ER-to-Relational (1)
Mapping Composite Attributes
Mapping Multi-valued Attributes
Exercise: ER-to-Relational (2)
Mapping Subclasses
Exercise: ER-to-Relational (3)
Exercise: ER-to-Relational (4)
Produced: 19 Mar 2009
![[index]](icon/up.gif){kind=icon}