CCN2240 Database Systems
Tutorial 5
Page 1 of 4
Tutorial 5
Relational Database Model
Learning Outcomes
Apply the relational model on different real world problem
Enforce referential integrity in Relational Database Model
Exercise 1
The DealCo relational diagram shows the initial entities and attributes for the DealCo stores, located in two
regions of the country.
a.
Identify each relationship type and write all of the business rules
b.
Create the basic ERD for DealCo
CCN2240 Database Systems
Tutorial 5
Page 2 of 4
Exercise 2
Use the database shown below to answer the questions.
a.
For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key,
write
None
in the space provided.
TABLE
PRIMARY KEY
FOREIGN KEY(S)
EMPLOYEE
STORE
REGION
CCN2240 Database Systems
Tutorial 5
Page 3 of 4
b.
Do the tables exhibit entity integrity? Answer yes or no and then explain your answer.
TABLE
ENTITY INTEGRITY
EXPLANATION
EMPLOYEE
STORE
REGION
c.
Do the tables exhibit referential integrity? Answer yes or no and then explain your answer. Write
