Week03_HW3_Chapter3_Problems (2)
docx
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
104
Subject
Information Systems
Date
Dec 6, 2023
Type
docx
Pages
4
Uploaded by ProfPuppy14029
Chapter 3 The Relational Database Model
NAME:
HOMEWORK PROBLEMS: 1-11
Part 1 of 2: Use the database shown to answer Problems 1-7.
1.
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
42
Chapter 3 The Relational Database Model
2.
Do the tables exhibit entity integrity? Answer yes or no and then explain your answer.
TABLE
ENTITY INTEGRITY
EXPLANATION
EMPLOYEE
.
STORE
REGION
.
3.
Do the tables exhibit referential integrity? Answer yes or no and then explain your answer.
Write
NA
(Not Applicable) if the table does not have a foreign key.
TABLE
REFERENTIAL INTEGRITY
EXPLANATION
EMPLOYEE
STORE
REGION
4.
Describe the type(s) of relationship(s) between STORE and REGION.
(1:1, 1:M, M:N)
5.
Create the ERD to show the relationship between STORE and REGION.
Note: See an example of ERDs on slides #25 - #26.
Note that each store is located in a single region, but that each region can have many stores located
in it.
6.
Create the relational diagram to show the relationship between STORE and REGION.
Note: See an example of a relational diagram on slide #27.
Note (again) that the location of the entities is immaterial … the relationships are carried along with
the entity. Therefore, it does not matter whether you locate the REGION on the left side or on the
right side of the display. But you always read from the “1” side to the “M” side, regardless of the
entity location.
43
Chapter 3 The Relational Database Model
Part 2 of 2: Use the database shown to answer Problems 8-12.
7. 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)
TRUCK
BASE
TYPE
44
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Chapter 3 The Relational Database Model
8. Do the tables exhibit entity integrity? Answer yes or no and then explain your answer.
TABLE
ENTITY INTEGRITY
EXPLANATION
TRUCK
BASE
TYPE
9. Do the tables exhibit referential integrity? Answer yes or no and then explain your answer.
Write
NA
(Not Applicable) if the table does not have a foreign key.
TABLE
REFERENTIAL INTEGRITY
EXPLANATION
TRUCK
BASE
TYPE
10. Create the ERD for this database.
Note: See an example of ERDs on slides #25 - #26.
11. Create the relational diagram for this database.
Note: See an example of a relational diagram on slide #27.
45