Need Help with HW uploaded. I believe the HW is on file. thanks

 

MMIS 630: Homework 2, Due 10 a.m. on October 7Consider the following instance of this database. The Primary key (PK) and Foreign Keys (FK)areiden±²ed for each table.Table: EMPLOYEEPK: employeeID;FK: empBranch references BRANCH;FK: empSupervisor references EMPLOYEEEMPLOYEEIDEMPLNAMEEMPFNAMEEMPTITLEEMPSTARTDATEEMPBRANCHEMPSALARYEMPSUPERVISORe1AdamAlanCEO11-JAN-02b1600000-e2BrysonBradbranch_manager01-FEB-03b2400000e1e3ClayCedricbranch_manager21-JUN-01b3450000e1e4DayDaisybranch_manager17-AUG-03b4480000e1e5EngleEvasalesperson01-JAN-04b2120000e2e6FalconFredsalesperson01-JAN-02b280000e2e7GandhiGagansalesperson01-JAN-03b390000e3e8HeeHwangsalesperson01-JUN-04b395000e3e9IngramIrenesalesperson24-SEP-02b4110000e4e10JeromeJohnsalesperson25-AUG-02b475000e4Table: BRANCHPK: branchNumberFK: branchManager references EMPLOYEEBRANCHNUMBERBRANCHNAMEBRANCHSTREETBRANCHCITYBRANCHSTATEBRANCHZIPREVENUETARGETBRANCHMANAGERb1branch19700 NW 41 StMiamiFL33178800000e1b2branch28700 SW 24 StMiamiFL33170600000e2b3branch3E 200 47 StNew YorkNY110101000000e3b4branch4300 Park AvenueNew YorkNY100101200000e4Table: CUSTOMERPK: customerIDCUSTOMERIDCUSTNAMECUSTSTREETCUSTCITYCUSTSTATECUSTZIPCUSTPHONEc1cust1-MiamiFL33164-c2cust2-MiamiFL33120-c3cust3-MiamiFL33110-c4cust4-MiamiFL33178-c5cust5-New YorkNY11021-c6cust6-New YorkNY11001-Table: PRODUCTPK: productCodePRODUCTCODEPRODDESCRIPTIONPRICESTOCKLEVELp1carpet4010000p2tile20100000p3pergo5050000Table: INSTALLATIONPK: installationType

Attachments:

• 1496035625-hw2_m630_F20151.docx