Question: Normalise the following querries. 1.VEHICLE (VIN, Registration number, Make, Model, Colour, Current_Odometer, Availability) 2.MAINTENANCE RECORD (MaintenanceID, VIN, DateStarted, FinalCost, Description, Nature, Odometer Reading) 3.DRIVER (DriverLicence

Normalise the following querries.

1.VEHICLE (VIN, Registration number, Make, Model, Colour, Current_Odometer, Availability) 2.MAINTENANCE

1.VEHICLE (VIN, Registration number, Make, Model, Colour, Current_Odometer, Availability) 2.MAINTENANCE RECORD (MaintenanceID, VIN, DateStarted, FinalCost, Description, Nature, Odometer Reading) 3.DRIVER (DriverLicence Number, Languageode, DriverFname, DriverLname, Clearence Level, LanguageProficiency) 4.CARGO_VEHICLE (VIN, CapacityCFT, CapacityMT) 5.PASSENGER VEHICLE (VIN, SeatingCapacity) 6. BOOKING DETAILS (Booking number, StartDate, StartTime, EndDate, End Time, Official_ID, DriverLicenceNumber, Pickup Code, DropoffCode) 7. LANGUAGE (LanguageCode, LanguageName) 8.DROPOFF_LOCATION (DropoffCode, Location_ID) 9. PICKUP_LOCATION (PickupCode. Location_ID) 10.OFFICIAL (Official ID CountryCode, LanguageCode, Official Fname, OfficialLname, Role, Language Preference) 11.LOCATION (Location ID. StreetNum. SteetName. Suburb, State. Postcode. Type)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

It seems that you are asking to normalize a database schema Normalization is the process of organizing a database in a way that reduces redundancy and ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Illini leases another piece of equipment from Cubs Corporation under a four-year lease agreement on 1/1/20x1. The lease specifies annual payments on each 1/1 and the first payment of $10,000 is made...

The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...

For this lab, use Scanner, data types and multiple methods with parameters and returns to take in data from the user and print out their "new account" information, including the following features:...

Program 1. Vehicle Registration Program using netbeans .java This program will be used to calculate vehicle registration fees. It will include a Vehicle parent class, a Car subclass, and a Calculate...

Fordley Car Park is open between 7am and 9pm every day. They charge 2.30 per hour with a minimum fee of one hour and a 2 overnight charge for stays between 9pm and 7.30am. Payments are made at the...

show every step and the final solution should be like the example provided dont answer in any other way example the final solution should be like this Read and analyse the following specification of...

Part 1: You have been contracted to develop an online fleet management system that enables central administration of a companys vehicle fleet across five S. African provinces. The people who use the...

Task 2: Designing an Entity-Relationship Model Part A: Initial Design Quick Service Case Study Quick Service is an Australian vehicle repair centre. You are asked to design a database for managing...

Design a database for managing the vehicle service details. Requirements for the database are as follows: Vehicles are brought in for service. For each vehicle the database records the registration...

At a certain fast-food restaurant, 57% of customers order a chicken sandwich, 54% of customers order french fries, and 68% of customers order a chicken sandwich or french fries (or both items). What...

Discuss the importance of subcultural segmentation to marketers of food products. Identify a food product for which the marketing mix should be regionalized. Explain why and how the marketing mix...

A ) income loss benefits provide compensation for \ ( 8 5 \ % \ ) of gross income to a maximum of \ ( \ $ 2 5 0 \ ) per week B ) every person injured in Minnesota in a motor vehicle accident, or as a...

Explain why insurance sectors are considered as financial intermediary?

Suppose the price elasticity of demand for cheerios is -0.88. If so, the demand for it is ______. (Elastic, Inelastic or Unit-Elastic)? Assuming its price elasticity of demand changes to -0.21. Then...

The motions described in each of the questions take place at an intersection on a two-lane road with a stop sign in each direction. For each motion, select the correct position versus time graph. For...

Explain how marginal costs, direct costs and opportunity costs are different. Use an example from your personal life to illustrate each concept. Do you agree with Robert Moses? ideas of wiping out...

Estimating Demand and Total Revenue 1.(a) Use the following function: QW= 400-2p, to estimate the maximum total revenue. (b) Plot the average, marginal, and total revenue curves (c) What is the...

A worker's primary goal should be to:Multiple Choicepay his or her fair share of taxes while taking advantage of appropriate tax benefts.pey his or her taxes using evimenes for income and...

What must a computer have in order for it to execute Java programs?

The Skate Shop sells the skateboard products listed in Table 13-2. Data in Table 13-2. In addition, the Skate Shop sells the following miscellaneous products and services: Grip tape: $10 Bearings:...

Suppose the file MyApplet.java contains the Java source code for an applet. What tag would you write in an HTML document to run the applet in an area that is 400 pixels wide by 200 pixels high?

17. How do the pain-relieving effects of cannabinoids differ from those of opiates?

18. How do ibuprofen and other nonsteroidal anti-inflammatory drugs decrease pain?

2. What are the special difficulties of studying the evolution of behavior, given that behavior doesnt leave fossils (with a few exceptions such as footprints showing an animals gait)pg99