Answer these 4 questions(1) Draw the Relational Schema for the relationship(s) between STORE and REGION.(2) Describe the type(s) of relationship(s) between EMPLOYEE and STORE. (Hint: Each store employs many employees, one of whom manages the store.)(3) Draw the Relational Schema for the relationship(s) between EMPLOYEE and STORE.(4) Draw the Full Entity Relationship diagram showing the relationships among EMPLOYEE, STORE, and REGION. Table name: STORESTORE_CODE STORE_NAME STORE_YTD_SALES REGION_CODE EMP_CODE$1,003,455.76$1,421,987.39$986,783.221 Access Junction82 Database Corner2123 Tuple Charge174 Attribute Alley$944,568.5635 Primary Key Point$2,930,098.45115Table name: REGIONREGION_CODE REGION_DESCRIPTEast2 West Table name: EMPLOYEEEMP_CODE EMP_TITLE EMP_LNAME EMP_FNAME EMP_INITIAL EMP_DOB STORE_CODEMr.VilliamsonJohn21-May-642 Ms.RatulaNancy09-Feb-693 Ms.GreenboroLottie02-Oct-6144 Mrs.Rumpersfro Jennie01-Jun-715 Mr.6 Mr.7 Mr.8 Ms.9 Mr.SmithRobert23-Nov-593RenselaerCary25-Dec-651OgalloJohnssonRoberto31-Jul-623Elizabeth10-Sep-681EindsmarJack19-Apr-5510 Mrs.JonesRose06-Mar-66411 Mr.BroderickTom21-Oct-723+12 Mr.08-Sep-7425-Aug-6425-May-6624-May-64WashingtonAlanY13 Mr.SmithPeter314 Ms.SmithSherry4+15 Mr.OlenkoHoward16 Mr.ArchialoBarry03-Sep-60517 Ms.GrimaldoJeanineK12-Nov-70418 Mr.RosenbergAndrewD24-Jan-71419 Mr.RostenPeterF03-Oct-68420 Mr.MckeeRobert06-Mar-70121 Ms.BaumannJenniferA11-Dec-743.Table name: STORESTORE_CODE STORE_NAME STORE_YTD_SALES REGION_CODE EMP_CODE$1,003,455.761 Access Junction2 Database Corner3 Tuple Charge4 Attribute Alley5 Primary Key Point$1,421,987.392$986,783.221$944,568.563$2,930,098.451150273ZID>+ ++ ++ + + ++ ++ ++

As per our guidelines, we are supposed to answer only first three parts of a question. Kindly repost…

Answered: (1) Draw the Relational Schema for the…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

Answer these 4 questions

(1) Draw the Relational Schema for the relationship(s) between STORE and REGION.
(2) Describe the type(s) of relationship(s) between EMPLOYEE and STORE. (Hint: Each store
employs many employees, one of whom manages the store.)
(3) Draw the Relational Schema for the relationship(s) between EMPLOYEE and STORE.
(4) Draw the Full Entity Relationship diagram showing the relationships among EMPLOYEE,
STORE, and REGION.