Assignment2_FernandezJavier
docx
keyboard_arrow_up
School
Florida State College at Jacksonville *
*We aren’t endorsed by this school
Course
4212
Subject
Industrial Engineering
Date
Feb 20, 2024
Type
docx
Pages
4
Uploaded by SuperPolarBearMaster24
ISM4212 – Assignment 2 Javier
Fernandez 01/21/2024
Directions: Answer Problems 1 -5. Refer to Module 1 in the course for directions on submitting
the completed file. Point values are listed after each problem. Assignment total points = 70
.
Use the contents of Figure 2.1 to work problems 1-3.
1.
Write the business rule(s)
that governs the relationship between AGENT and CUSTOMER.
(8pts)
A: One Agent can insure many customers
A customer can only be insured by one agent.
Customer belongs to insurance once insured by Agent.
2.
Given the business rule(s) you wrote in Problem 1, create the basic Crow’s Foot ERD
.
(Please copy and paste your diagram into this Word document).
(10pts)
ISM4212 – Assignment 2 Javier
Fernandez 01/21/2024
3.
Using the ERD you drew in Problem 2, create the equivalent Object representation and
UML class diagram. (Use Figure 2.4 as your guide.) (Please copy and paste your diagram
into this Word document).
(12pts)
ISM4212 – Assignment 2 Javier
Fernandez 01/21/2024
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
ISM4212 – Assignment 2 Javier
Fernandez 01/21/2024
Using Figure P2.4 as your guide, work Problems 4–5. The DealCo relational diagram shows
the initial entities and attributes for the DealCo stores, located in two regions of the country.
Figure P2.4 The DealCo relational diagram
4.
Identify each relationship type and write all of the business rules. (20pts)
A: One Region can locate many stores. Many stores can be located in one region.
One store has many employees. Employees can only work at one store and have only one job (position) under that
store.
REGION and STORE are 1:M
STORE and EMPLOYEE are 1:M
JOB and EMPLOYEE are 1:M
5.
Create the basic Crow’s Foot ERD for DealCo. (Please copy and paste your diagram into this
Word document).
(20pts)