MIS3306 Module3 Exercise-3-1
docx
keyboard_arrow_up
School
University of Houston, Downtown *
*We aren’t endorsed by this school
Course
3306
Subject
Information Systems
Date
Apr 3, 2024
Type
docx
Pages
8
Uploaded by jnicholson4
MIS3306 Database Management
Systems
Module 3 Exercise
40 points
Required for Grading:
I am Jordan Nicholson
and I complete this assignment following the UHD academic integrity policy. (5 points)
Learning objectives:
Describe the basic data-modeling building blocks Identify the relational model’s basic components
Describe the relational database model’s logical structure – tables and their characteristics
Identify appropriate entities and the relationships among the entities in the relational database model
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,
relationships with maximum numbers on each side, and
relationship labels when appropriate.
The diagram at this stage does not
need:
keys
Identifying/non-identifying relationship specifications
Add a textbox with your full name inside the diagram (no point without your name). The figure below is an example. 1
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.
2
Answer here:
Table
Primary Key
Foreign Key(s)
EMPLOYEE
EMP_Code
STORE_CODE
STORE
STORE_CODE
REGION_CODE
REGION
REGION_CODE
N/A
b.
Explain entity integrity. Do the tables exhibit entity integrity?
Answer here:
Entity integrity means that each primary key value is unique and not null Table
Entity Integrity (Yes/No)
EMPLOYEE
YES
STORE
YES
REGION
YES
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 Each Foreign Key value matches a primary key value
Table
Referential Integrity (Yes/No)
EMPLOYEE
YES
STORE
YES
REGION
N/A
d.
Describe the relationship between STORE and REGION. The description should describe numbers to both tables, and in two directions. For example, one customer has many orders and one order belongs to one customer.
Answer here: One region has many stores and one store has one region so 1:M
e.
Describe the relationship between EMPLOYEE and STORE. The description should describe numbers to both tables, and in two directions. For example, one 3
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
customer has many orders and one order belongs to one customer.
Answer here: One employee belongs to one store and one store has many employees so this is a works relationship that equals M:1
Also, one store has one managing employee and one employee manages one store
As a result ,this is 1:1 relationship 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.
4
a.
For each table, identify the primary keys and foreign keys. Write “None” or “NA” when there’s no foreign keys.
Answer here:
Table
Primary Key
Foreign Key(s)
STUDENT
StudentID
AdvisorID
ADVISOR
AdvisorID
DeptID
DEPARTMENT
DeptID
N/A
b.
Explain entity integrity. Do the tables exhibit entity integrity?
Answer here:
Entity integrity means _ that each primary key value is unique and not null
Table
Entity Integrity (Yes/No)
STUDENT
NO
ADVISOR
YES
DEPARTMENT
YES
c.
Explain referential integrity. Do the tables exhibit referential integrity? Write “None” or “NA” when there’s no foreign keys.
5
Answer here:
Referential integrity means Each Foreign Key value matches a primary key value
Table
Referential Integrity (Yes/No)
STUDENT
YES
ADVISOR
YES
DEPARTMENT
N/A
d.
Describe the relationship between STUDENT and ADVISOR. The description should describe numbers to both tables, and in two directions. For example, one customer has many orders and one order belongs to one customer.
Answer here: One student has one advisor and one advisor has many students
This is a 1:M relationship e.
Describe the relationship between ADVISOR and DEPARTMENT. The description should describe numbers to both tables, and in two directions. For example, one customer has many orders and one order belongs to one customer.
Answer here:
One advisor belongs to one department and one department has many advisors so this is a works relationship that equals M:1
Also, one department has one managing advisor and one advisor manages one department
As a result, this is a 1:1 relationship f.
Create the data model for these tables and relationships. 6
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
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?
7
Answer here:
I learned to identify the appropriate entities and the relationships among the entities in the relational database model easiest because it made the entire table easy to learn such as drawing the data models. b.
What hands-on skill(s) have you learned?
Answer here:
The best skill I learned so far is creating data models to show business relationships. 8