Tutorial 5 - relational - CCN2240 Database Systems Tutorial 5 Tutorial 5 Relational Database Model Learning Outcomes Apply the relational model on

Tutorial 5 - relational - CCN2240 Database Systems Tutorial...

This preview shows page 1 - 4 out of 4 pages.

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
Image of page 1
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
Image of page 2
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
Image of page 3
Image of page 4

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture