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)

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!