Question: Employee (E) eid 101 102 103 104 105 Work On (W) eid 101 101 102 102 102 103 104 salary 150,000 150,000 100,000 100,000 80,000

Employee (E) eid 101 102 103 104 105 Work On (W) eid 101 101 102 102 102 103 104 salary 150,000 150,000 100,000 100,000 80,000 ename James Ma John Patricia Robert year 2015 2016 2015 2016 2017 2017 2018 Project (P) mgr eid 102 103 104 budget 30,000,000 20,000,000 10,000,000 pname DataBase DataMinin BigData 5) ename ( E D, w D, pname-DataBase, or pname: Data warehouse. P ) (TT eid, ename E)Wx TT pid, pname pname TT pid 'DataMining, P ) II eid, ename eid, pid x e e eid-w eid and w-pid-P-pid EWP ename, p-pname 7) ( M ( 1-) m-eid29m-ename), eid, ename E ) ename, m ename ( (TT eid, ename E) Da w Da P DdP.mgreid= M.m-eid M ) 10) TT ename ( (TT eid.pid w / pid P ) Da E )
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
