Using SQL Language
Posted: Sat May 14, 2022 7:49 pm
Using SQL Language
4. Consider the following table and answer the following questions. (5 points) EmpNo StoreNo Store Address EmpName EmpRank HoursPWeek E1111 S001 Brockport, NY, 14622 John Assistant 20 E1111 S003 Rochester, NY, 14623 John Assistant 20 E2222 S001 Brockport, NY, 14622 Mariama Assistant 10 E2222 S003 Rochester, NY, 14623 Mariama Assistant 18 a. Identify the functional dependencies for this table? b. What is the table primary Key? c. What is the normal form this table in? d. Put the table in 2NF?
- Using Sql Language 1 (222.35 KiB) Viewed 42 times