MIS3306 Module 5 Exercise S
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
6
Uploaded by jnicholson4
MIS3306 Database Management
Systems
Module 5 Exercise 1
Required for Grading:
I am Jordan Nicholson (type your full name) and I complete this assignment following the
UHD academic integrity policy.
Learning objectives:
Describe the main extended entity relationship (EER) model constructs and how they are represented in ERDs and EERDs
Use entity clusters to represent multiple entities and relationships in an entity relationship diagram (ERD)
Describe the characteristics of good primary keys and how to select them
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 (divide an attribute further into simple attributes when appropriate),
relationship types (identifying or non-identifying), and
cardinalities (MAX and min on each side).
Use a specialization hierarchy when appropriate. Grading is based on the completeness of the diagram.
Add a textbox with your full name inside the diagram (no point without your name). The figure below is an example.
1
Upload this document to Blackboard>Course Content>Module 5> Module 5 Exercise 1
as your submission. Questions and Answers:
1.
(15 points) The Granite Sales Company Create a Crow’s Foot ERD using the following scenario. Granite Sales Company keeps data about departments and the employees working for the department. A department has many employees, and each employee works for only one department. Each department has data about the department name, mail box number, and office phone extension. All employees have an employee number, the employee’s name, and his/her address. Each employee must be one of the following three types (cannot be two types simultaneously): hourly, salaried, or contract. For hourly employees, hourly wages and target weekly hours are kept in the system. For all salaried employees, the yearly salary is recorded in the system. Some salaried employees are salespeople who can earn a commission in addition to their base salary. Salespeople’s sales commission and profit commission are stored in the system. For contract employees, the beginning date and end date of their contracts are stored along with the billing rate for their hours.
A diagram is sufficient for the answer. Add a textbox with your full name inside the diagram (no point without your name).
2
2.
(10 points) Bank account system. A bank has three types of accounts: checking, saving, and loan. Each bank account must have a type and be exactly one of these types (cannot be two types at the same time). Following are the attributes for each type of account:
CHECKING: Acct No, Date Opened, Balance, Service Charge
SAVING: Acct No, Date Opened, Balance, Interest Rate
LOAN: Acct No, Date Opened, Balance, Interest Rate, Payment
You should move the common attributes into the supertype and leave the unique attributes in the corresponding subtypes. Create the EERD for the system.
Add a textbox with your full name inside the diagram (no point without your name).
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
3.
(13 points) Non-profit organization system. A nonprofit organization depend on a number of different types of persons. The system needs to maintain the following data for all persons: Person_ID, Name, Address, and email. There are three types of persons: employees, volunteers, and donors. Employees have a unique Date Hired attribute, and volunteers have a distinct Skill attribute. Donors donate items. Item has attributes like Item ID and Description. A donor may donate multiple items. An item may be associated with no donor or one donor.
Occasionally, there are persons other than the three types (employees, volunteers, and donors). In other words, a person may not belong to any of these three types. Also, a person may belong to two or more of these types (e.g., a person may be an employee and also a donor). Create the EERD for the system.
Add a textbox with your full name inside the diagram (no point without your name).
4
PERSON
PK
Person_In
Person_name
Person_phone
Person_address
Person_city
Person_state
Person_zip
Employee
PK,
FK1
Person_In
Date_Hired
Volunteer
PK,
FK1
Person_In
Skill
Donor
PK,
FK1
Person_In
Item
PK
ItemID
Person_name
Made by Jordan Nicholson
Review
4.
(2 points) Choose among the learning objectives of this module listed below and answer the following questions.
5
Describe the main extended entity relationship (EER) model constructs and how they are represented in ERDs and EERDs
Use entity clusters to represent multiple entities and relationships in an entity relationship diagram (ERD)
Describe the characteristics of good primary keys and how to select them
a.
Which learning objective have you learned the best? Why?
Answer:
Using clusters to represent many relationships and entities because it’s easier
b.
What hands-on skill(s) have you learned? (answer like: I can use ______ to ______. )
Answer:
I can use entity clusters to represent multiple relationships in a diagram which makes things easier to read and understand
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