Information Systems MIS 3306 Assignment
MIS3306 Database Management Systems
Module 3 Exercise
40 points
Required for Grading:
I am (type your full name) and I complete this assignment following the UHD academic integrity policy.
Instructions:
· Use Microsoft Visio or Draw.io to draw the diagram. Diagrams made by any other tools will not be graded.
· Use IE (crow’s foot) notation. Diagrams with any other notations will not be graded.
· The diagram should specify entities, keys, attributes, and maximum numbers on each side. Relationship labels are not needed. Grading is based on the completeness of the diagram. Identifying/non-identifying relationship specifications are not required in this exercise.
· Add a textbox with your full name inside the diagram (no point without your name). The figure below is an example. (Note: For this exercise, attributes are not needed.)
· Your answer is required when you see the red answer box like the box below.
|
Answer here: <<This is an example. Answer whenever you see this.>>
|
· Upload this document to Blackboard as your submission.
Questions and Answers:
1. (18 points) Use the database shown in the figure below to answer the following questions.
a. For each table, identify the primary keys and foreign keys. Write “None” or “NA” when there’s no foreign keys.
|
Answer here:
|
b. Explain entity integrity. Do the tables exhibit entity integrity?
|
Answer here: Entity integrity means ____
|
c. Explain referential integrity. Do the tables exhibit referential integrity? Write “None” or “NA” when there’s no foreign keys.
|
Answer here: Referential integrity means ____
|
d. Describe the relationship between STORE and REGION. The description should include numbers to each table. For example, one CUSTOMER has many ORDERs.
|
Answer here:
|
e. Describe the relationship between EMPLOYEE and STORE. The description should include numbers to each table. For example, one CUSTOMER has many ORDERs.
|
Answer here:
|
f. Create the data model for these tables and relationships.
|
Paste Your Answer Diagram Here:
|
2. (18 points) Use the database shown in the figure below to answer the following questions.
a. For each table, identify the primary keys and foreign keys. Write “None” or “NA” when there’s no foreign keys.
|
Answer here:
|
b. Explain entity integrity. Do the tables exhibit entity integrity?
|
Answer here: Entity integrity means ____
|
c. Explain referential integrity. Do the tables exhibit referential integrity? Write “None” or “NA” when there’s no foreign keys.
|
Answer here: Referential integrity means ____
|
d. Describe the relationship between STUDENT and ADVISOR. The description should include numbers to each table. For example, one CUSTOMER has many ORDERs.
|
Answer here:
|
e. Describe the relationship between ADVISOR and DEPARTMENT. The description should include numbers to each table, and in both directions. The description should include numbers to each table. For example, one CUSTOMER has many ORDERs.
|
Answer here:
|
f. Create the data model for these tables and relationships.
|
Paste Your Answer Diagram Here:
|
Review
1. (4 points) Choose among the learning objectives of this module listed below and answer the question a and b.
· Identify the relational model’s basic components
· Describe the relational database model’s logical structure – tables and their characteristics
· Explain functional dependence, types of keys, and integrity rules
· Understand relational database operators that manipulate relational tables
· Identify appropriate entities and the relationships among the entities in the relational database model
· Explain data dictionary and its purpose
a. Which learning objective have you learned the best? Why?
|
Answer here:
|
b. What hands-on skill(s) have you learned?
|
Answer here:
|
2
image3.png
image1.emf
Microsoft_Visio_Drawing.vsdx
DEPARTMENT Dept_ID int FK PK Dept_Name int FK PK Made by Shuaifu Lin