Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

Pleas see attached question below regarding UNF ,1NF ,2NF and 3 NF forms

image text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intermediate Accounting

Authors: Donald E. Kieso, Jerry J. Weygandt, Terry D. Warfiel

17th edition

1119503663, 1119571480, 1-119-50368-2, 111950368X, 978-1119503668

More Books

Students also viewed these Accounting questions