steps to get partial credit Consider the following tables in an Order Entry data
ID: 3676524 • Letter: S
Question
steps to get partial credit Consider the following tables in an Order Entry database. The primary keys of the tables are CustNo for Customer, EmpNo for Employee and OrdNo for OrderTbl $20. Gordon C0954327 She 80111-0033 98103-1121 98178-3311 98013-1095 98668-1289 . ..$200.00 $500.00 $200.00 $0.00 C2388597Beh 01R :C3340959 Betty C3499503 Bob Mann WA 543321 Ron Eme EmpFinstName EmplastName |EmpPhone EmpEmail E1329594 Land E8S44399 Joe E8843211 Amy ES345771 Calin E9854325 Thomas E9954302 Mary Santos (303) 789-1234 LSantos@bigco.com (303) 221-9875 JJenkins@bigco.com (303) 556-4321 ATang@bigco.corm (303) 221-4453 CWhite@bigco.com (303) 556-9987 TJohnson@bigco.com (303) 556-9871 MHill@bigco.com OrderTbl OrdNo OrdDateCustNo EmpNo 01116324 02334661 01/142013 CO954327 E1329594 03331222 01/13/2013 C1010398 02233457 04714845 01/11/2013 C2388597 E1329584 0551136501/22/2013 C3340959 E9884325 07989497 01/16/2013 C3493503 ER 45771 01856777 02112013 C8543321 07959898 02192013 C8543321 E8544399 01/232013 CO954327 E8544399 01/132013 C101398 01/122013 C238597 E9684325 , 1. Draw the Crow foot notation for this database. 2. Identify the foreign keys and draw the entity relationship diagram for this database.Explanation / Answer
4.(b). select CustFirstName,CustLastName from Customer where CustCity = Seattle and CustState = WA
4.(c).select CustFirstName,CustLastName from Customer
4.(e).select CustFirstName,CustLastName,OrdNo from Customer c,Order Tbl o where c.CustNo = o.CustNo and CustCity =( Seattle OR Denver)
4.(f).select EmpEmail from Employee e , Order Tbl o where e.EmpNo = o.EmpNo and OrderNo = 05511365
4.(g).select CustFirstName , CustLastName from Customer where CustBal > $200
4.(h).select OrderNo , CustNo from Employee e , Order Tbl o where e.EmpNo = o.EmpNo
4.(a).select OrderNo , CustNo from Order Tbl where Year(record_date) = 2013 and Month(record_date) = 01
4.(d).select EmpNo,EmpFirstName,EmpLastName,EmpPhone,EmpEmail,OrdNo,CustNo,Orddate from Employee Natural Join Order Tbl.
EmpNo attribute should be used because here it is comman in these 2 tables and acts as foreign key.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.