Question: company Limits value attributes) Repeat answering the questions (1)-(3) for the revised design: (Scenario 2: making Company a multi-value attributes) 1 4 SS Nam Ag
company Limits value attributes) Repeat answering the questions (1)-(3) for the revised design: (Scenario 2: making Company a multi-value attributes) 1 4 SS Nam Ag C- Compan (S1OOK # # e e id Y Salary sl Lajuan 21 cl Ford 11 Josep 2 52 th 22 2 Walmart 22 3 53 Dan 23 c3 Target 33 $4 J) 24 c4 5 $1 Lajuan 21 c2 Walmart 55 Josep 6 52 h 22 c3 Target 66 FIGURE 3/5/2020: (Personal Salary in a Company) Consider the data shown in FIGURE 3/5/2020, which illustrates personal data and respective salary in a company (0) Based on this storage of the data, find the drawbacks or problems causing difficulties: (1)-(3) Answer the following for the revised design: Scenario 1. making Company an entity (1) Correct FIGURE 3/5/2020 to avoid the problems by redrawing the table(s) with records: (2) Represent the revised version above in an ER diagram, by notation of respectively, Chen's (2A) Crow's Foot (2B) UML (20) and Object-Oriented data model (2D) In the diagram, specify degrees? (2) cardinalities? (2) connectivities? (29) primary keys and foreign keys (p.k. and f.k.)? (2h) and associate (bridge) entities? (21) (3) Give relational schemas for the revised design company Limits value attributes) Repeat answering the questions (1)-(3) for the revised design: (Scenario 2: making Company a multi-value attributes) 1 4 SS Nam Ag C- Compan (S1OOK # # e e id Y Salary sl Lajuan 21 cl Ford 11 Josep 2 52 th 22 2 Walmart 22 3 53 Dan 23 c3 Target 33 $4 J) 24 c4 5 $1 Lajuan 21 c2 Walmart 55 Josep 6 52 h 22 c3 Target 66 FIGURE 3/5/2020: (Personal Salary in a Company) Consider the data shown in FIGURE 3/5/2020, which illustrates personal data and respective salary in a company (0) Based on this storage of the data, find the drawbacks or problems causing difficulties: (1)-(3) Answer the following for the revised design: Scenario 1. making Company an entity (1) Correct FIGURE 3/5/2020 to avoid the problems by redrawing the table(s) with records: (2) Represent the revised version above in an ER diagram, by notation of respectively, Chen's (2A) Crow's Foot (2B) UML (20) and Object-Oriented data model (2D) In the diagram, specify degrees? (2) cardinalities? (2) connectivities? (29) primary keys and foreign keys (p.k. and f.k.)? (2h) and associate (bridge) entities? (21) (3) Give relational schemas for the revised design
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
