- Using Sql Language 1 (222.35 KiB) Viewed 41 times
Using SQL Language
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
Using SQL Language
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?
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?
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!