For question #2 the ERD relationship is this many to many mandatory or many to m

Question

For question #2 the ERD relationship is this many to many mandatory or many to many optional or what im confused on which one to choose.

Use the database below to answer Database name: Ch03_StoreCo EMP Table name: EMPLOYEE EMP CODE EMP TITLE EMP STORE CODE 1 M 2 Ms 21-May-6 09-Feb-69 Greenboro Lotie 4 Ms 5 M 6 M 7 M Rumperstro Jernie Renselser Cary JohnssonEzabeth 01-Jun-71 31-14-62 19-Apr-55 21-Od-72 9 M 10 Ms 11 M 12 M 13 M 14 Ms 15 M 16 M 7 Ms 18 M 19 M 20 M 21 Ms Broderick Tom Washington l 12-Nov-70 Roserberg Andrew 06-Ma-70 11-Dec-74 Table name: STORE STORE CODE STORE STORE YTD REGION CODEEMP CODE 1000455 76 421987 39 966783 22 944568 56 2930098 45 1 Access Junction Datsbase Corne 3 Tuple Charge 4 ASrbute Aley 5 Primary Key Poirt 12 Table name: REGION 1 East (Questions) 1. For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None in the space provided 2. Create the ERD to show the relationship between STORE and REGION

Explanation / Answer

In an ERD you have to specify relationships withs their cardinalities and their participitations. And both the releationships are one to many. Between Store and Employee it is one to many from Stoe to Employee because it is like 1 store will employee more than 1 employee and the participitation would be total for both sides. And for store and region it would be one to many as well for many for store and one for region because one region can have more than 1 stores. Participation will be total for store and partial for region.

Do comment if you want me do both parts a and b. I'll edit it.

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.