In Access Module (Database) form please!!! Figure 11-332. Figure 11-34 contains sample data for pet sitters and customers who hire those sitters. Indiscussing the data with users, you find that customer IDsuniquely identify customers and their offered pay rate, and that sitter numbers uniquely identifypet sitters. Multiple customers can use the same sitter and customers can use more than onesitter. For example, Carl Rogers pet sits for Eileen Anderson and Anne Carlson.a. Convert the data in Figure 11-34 into a relation in first normal form (1NF) using theshorthand representation used in this module.b. Identify all functional dependencies using the notation demonstrated in the module.but not customer names –Pet SittersSitter NumberFirstNameLastNameCustomer NameAmount PaidHour21ArnoldKripsenAnne Carlson$20Eileen Anderson$21Fabio Lopez$19CarlRogersEileen Anderson$21Anne Carlson$2027JaimeFernandezBarb Lenton$1534JoseLorenzFabio Lopez$19Figure 11-34ConurighLoarningr in nartWCN O2-200-21024 Apply Your KnowledgeReinforce the skills and apply the concepts you learned in this module.Understanding Keys and NormalizationInstructions: Answer the following questions in the format specified by your instructor.1. Figure 11-33 contains sample data for a Student table that could have been used for a college.Use this figure to answer the following:Is the table in first normal form (1NF)? Why or why not?b. Is the table in second normal form (2NF)? Why or why not?Is the table in third normal form (3 NF)? Why or why not?d. Identify candidate keys for the table.а.с.StudentSIDFirstNameLastNameTeam IDSportName23483CoreyGomezBASK-1Basketball23423MichaelBlackSOC-1Soccer23480KathyReidSOF-1Softball23468MatthewStoneTEN-1TennisFigure 11-33

First Normal Form(1NF) A relation is said to be in 1NF, if there is an attribute or set of attribute…

2. Figure 11-34 contains sample data for pet sitters and customers who hire those sitters. In discussing the data with users, you find that customer IDs – but not customer names – uniquely identify customers and their offered pay rate, and that sitter numbers uniquely identify pet sitters. Multiple customers can use the same sitter and customers can use more than one sitter. For example, Carl Rogers pet sits for Eileen Anderson and Anne Carlson. Convert the data in Figure 11-34 into a relation in first normal form (1NF) using the shorthand representation used in this module. b. Identify all functional dependencies using the notation demonstrated in the module. a.

2. Figure 11-34 contains sample data for pet sitters and customers who hire those sitters. In discussing the data with users, you find that customer IDs – but not customer names – uniquely identify customers and their offered pay rate, and that sitter numbers uniquely identify pet sitters. Multiple customers can use the same sitter and customers can use more than one sitter. For example, Carl Rogers pet sits for Eileen Anderson and Anne Carlson. Convert the data in Figure 11-34 into a relation in first normal form (1NF) using the shorthand representation used in this module. b. Identify all functional dependencies using the notation demonstrated in the module. a.

Principles of Information Systems (MindTap Course List)

13th Edition

ISBN:9781305971776

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter5: Database Systems And Big Data

Section: Chapter Questions

Problem 4SAT: The ______________ model is a simple but highly useful way to organize data into collections of...

See similar textbooks