Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Pleas see attached question below regarding UNF ,1NF ,2NF and 3 NF forms Oints) You work for a landscaping company named Inc. During the night
Pleas see attached question below regarding UNF ,1NF ,2NF and 3 NF forms
Oints) You work for a landscaping company named Inc. During the night of 10/9/18, the company's headquarters burns down. Unfortunately. the company did not complete off-site backups of its database and had no disaster recovery plan in place. As a result, it must build a new database from scratch. Thankfully, one of the managers had printed out a summary of the activity completed during the week of the fire (see next page). You decide to use this information to start creating a database. You also remember some aspects of A-Cut-Above's process for creating and assigning routes. Each morning, the ERP selects a list of customers that require a mowing on the current day of the week (using the Cust_Day attribute). Then, the computer uses a web service through Google to find the optimal routes for the day, which may include multiple stops. Each route is then assigned to an employee, who picks their equipment (i.e. truck and mower) for the day and notifies the computer of the truck ID and mower ID corresponding with the equipment they selected. Before departing, the employee also inputs the beginning mileage for the truck they selected. When a route is completed, the employee returns their equipment, notes all Stops were completed (stored as Comp_Desc), and enters the ending mileage reading for the truck that they used to complete the route. If the employee is unable to finish a route for whatever reason, they return to headquarters and enter a completion description (Comp_Desc) of "Not Complete" for any unfinished stops and "Complete" for finished stops. They may also add notes describing why a route was stopped. At that point, the computer formulates a new route (or routes) that include all unfinished jobs. The new routes are then assigned to employees similar to how they are assigned each morning. using the information from above and the report on the next page, specify a database in UNF, INF. 2NF, and 3NF using the notation taught during week 4's lecture. Place repeating groups inside of the following brackets: and ")". Place tables inside the following brackets: "l" and "l". DO not use character values as part of the primary key. Name tables if there more than one. underline the attributes comprising the primary key for each table. Finally, designate foreign keys for 3NF. Point allocation:
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started