The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | Apr 2017 |
| Last Sign in: | 103 Weeks Ago, 3 Days Ago |
| Questions Answered: | 4870 |
| Tutorials Posted: | 4863 |
MBA IT, Mater in Science and Technology
Devry
Jul-1996 - Jul-2000
Professor
Devry University
Mar-2010 - Oct-2016
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: