Help with SQL, thank you. Below you have the tables and after the tables, I will

Question

Help with SQL, thank you. Below you have the tables and after the tables, I will post the questions>

Questions:

Table name: EMPLOYEE EMP CODE? EMP TITLE EMP?LNAME | EMP FNAME I EMP INITIAL I EMP DOB | STORE CODE 1 Mr 2 MS 3 Ms Williamson John Ratula Greenboo Lottie Rumpersfro Jennie 21-May-64 09-Feb-69 02-Oct-61 01 Jun-71 4 Mrs 5 Mr 6 Mr 7 Mr 8 Ms 9 Mr 10 Mrs 11 Mr 12 Mr 13 Mr 14 MS 15 Mr 16 Mr 17 MS 18 Mr 19 Mr 20 Mr 21 Ms Renselaer Ogallo 31-Jul-62 10-Sep-68 19-Apr-55 06-Mar-66 21-Oct-72 08-Sep-74 25-Aug-64 25-May-66 24-May-64 03-Sep-60 12-Nov-7 24-Jan-71 Elizabeth Broderick Tom ashington Alan Clenko Archialo Andrew Peter Rosten Mckee Baumann 06-Mar-70 11-Dec-74 Table name: STORE STORE CODE STORE NANE ? STORE YTD SALES ? REGION CODE I EMP CCCE 1 Access Junction 2 Database Corner 3 Tuple Charge 1003455.76 1421987.39 986783.22 12 Attribute Alley 5 Primary Key Point 2930098.45 Table name: REGION REGIONCODE REGIONDESCRIPT - - 1 East 2 West

Explanation / Answer

Q 2.3) Relationship between STORE and REGION? EMPLOYEE and STORE?

Answer)

Relationship between STORE and REGION is MANY : ONE as one REGION can have many STOREs.

Relationship between EMPLOYEE and STORE is MANY : ONE as many EMPLOYEEs can work in each store.

Q2.4) Business rules for relationships.

STORE and REGION

MANY STORES: can have : ONE REGION

The business rule will be that, each REGION can have multiple STOREs in the REGION. Also, that, MANY STOREs can have one single REGION.

EMPLOYEE and STORE

MANY EMPLOYEEs : work in : ONE STORE

Here the business rule will be that, many EMPLOYEEs may work in ONE STORE. On the other hand, ONE STORE can employ many EMPLOYEEs.

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

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