Assume that you have the following entities with attributes. The primary key for
ID: 3598308 • Letter: A
Question
Assume that you have the following entities with attributes. The primary key for each entity is highlighted in bold. The date is requested to be printed in this format: YYYY Staff (Staff_ID, Staff Lname, Staff_Fname, Staff_HireDate, Job_Code, Emp_Years) Job (Job_Code, Job_Description, Job_Chg Hour, Job_Last_Update) Project (Proj_Num, Proj_Name, Proj_Value, Proj_Balance) Workltem (Workl Num, Workl Date, Proj_Num, Staff ID, Workl Job, Workl Chg_Hr, Workl_Hours, WorkI_Charge) The diagram below illustrates the relationship among the entities. Staff perform M Workltem has has Job Project Fig. I ERD Answer the following questionsExplanation / Answer
a) SELECT * FROM Staff WHERE Staff_HHireDate BETWEEN 2014-01-01
AND 2014-12-13;
b)SELECT * FROM Project ORDERBY Proj_value desc;
c)UPDATE Project SET Proj_Balance = 'RM150000' WHERE Proj_num = 23;
d)SELECT S.Staff_ID,P.Proj_num,W.WorkI_Hours from Staff S,Project P,WorkItem W where S.Staff_ID=W.Staff_ID,W.Proj_Num=P.Proj_Num ORDERBY S.Staff_ID;