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.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

What are the options for breaking a Deadlock?
What are the features of adjusting entries?
Complete the Python program to create a Horse table, insert one row, and display the row. The main program calls four functions: create_connection() creates a connection to the database. create_table() creates the Horse table. insert_horse() inserts one row into Horse. select_all_horses() outputs all Horse rows. Complete all four functions. Function parameters are described in the template. Do not modify the main program. The Horse table should have five columns, with the following names, data types, constraints, and values: Name Data type Constraints Value Id integer primary key, not null 1 Name text 'Babe' Breed text 'Quarter horse' Height double 15.3 BirthDate text '2015-02-10' The program output should be: All horses: (1, 'Babe', 'Quarter Horse', 15.3, '2015-02-10')
Susan is about to program a specific function for saving information into the database. She will need to use a dot operator to group related statements together with a name that indicates this function. TrueFalse
Which actions while using a program to access a database are relatively similar?
C## Write a program to connect to a database and retrieve records from a table
Create a C++ Bank Client Information Program that requires the follwowing: Search Record Delete Record
Database Schema: branch ( branch_name, branch_city, assets ) customer ( ID, customer_name, customer_street, customer_city ) loan ( loan_number, branch_name, amount ) borrower ( ID, loan_number ) account ( account_number, branch_name, balance ) depositor ( ID, account_number ) Write a (postgresql) "trigger function" and "create a trigger" to carry out the following action: On delete of an account, for each customer-owner of the account, check if the owner has any remaining accounts, and if she does not, delete her from the depositor relation.
The name given to the file that stores ordering characteristics that are not of a key-like form is the
Write a Python program for a movie database management system. The program should allow users to add movies, remove movies, and display the current collection. Each movie has a title, director, release year, and rating. The program should have the following features: 1. A menu-based system that allows users to choose between adding a movie, removing a movie, and displaying the collection. 2. When adding a movie, the user should input the title, director, release year, and rating. 3. When removing a movie, the user should input the title of the movie to be removed. 4. Display the current movie collection with details of each movie, including title, director, release year, and rating. Make sure to include comments that explain the purpose of the program, input and output details, and any complex logic. Use self-documenting variable names, white spaces, and indentation for readability. Test your program with sample data to ensure correct functionality and provide screenshots of two…
An example of a data type for a data field in the record of an Access table is "Number." True False
In a database, which of the following field types can store the most data? A) Text fields B) Currency fields C) Date/Time fields D) Yes/No fields