Normalise the following querries. 1.VEHICLE (VIN, Registration number, Make, Model, Colour, Current_Odometer, Availability) 2.MAINTENANCE RECORD (MaintenanceID, VIN,
Fantastic news! We've Found the answer you've been seeking!
Question:
Normalise the following querries.
Transcribed Image Text:
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) 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)
Expert Answer:
Answer rating: 100% (QA)
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 the full answer
Related Book For
Starting Out With Java From Control Structures Through Data Structures
ISBN: 9780133957051
6th Edition
Authors: Tony Gaddis
Posted Date:
Students also viewed these databases questions
-
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...
-
A star of a reality TV show: Real Housewives of Tacoma bought a house for her family 3 years ago. The houses asking price was $895,000. She put 20% down payment and a local bank lent her the...
-
Answer "true" or "false" to the following statements: 1. Some arguments, while not completely valid, are almost valid. 2. Inductive arguments allow for varying degrees of strength and weakness. 3....
-
In addition to a Gantt chart, youve drawn Brian a PERT diagram so that you can communicate the necessity to keep an eye on the critical path. Consult Figure which was derived from the data from...
-
Find the complex form of the Fourier series for the wave shown in Fig. 14.24(b). Figure 14.24(b):- 1 (b) Ox- 0 (1).x
-
Rowntown Cab Company has 70 drivers that it must schedule in three 8-hour shifts. However, the demand for cabs in the metropolitan area varies dramatically according to the time of day. The slowest...
-
The Log Jamboree amusement park ride at Six Flags over Georgia consists of an approximately rectangular flume that is 6 ft wide and is constructed from fiberglass (ks = 0.002 in). In the low-velocity...
-
Consider the stirred-tank reactor shown in Fig. P5-5. The reaction occurring is A ? B and it proceeds at a rate r = kCo where r = (moles A reacting)/(volume)(time) k = reaction rate constant Co (t) =...
-
You are auditing Blue Pool Supplies Ltd, a listed company that specializes in pool supplies for distribution throughout Australia. It is now 6 August 2019 and you are finalizing your audit of Blue...
-
The following bar graph shows net purchases of bond mutual funds. Does this graph tell us anything? $8 $6 $4 $2 $7.9 billion 0 J F M A M J J AS 1991 *Net inflow to bond funds excluding reinvested...
-
Using the graph in Fig. 2.17, answer the following questions: (a) Which company has the higher current ratio? (b) Which companys current ratio appears to be more stable over time? Fig. 2.17 0.6 0.5...
-
The accompanying pie chart presents data on why teenagers drink. Use information shown in the pie chart to answer the following questions: (a) For what reason do the highest numbers of teenagers...
-
Using the data in Fig. 2.3, analyze the average rates of return for (a) The DJIA (b) The S&P 500 (c) Tri-Continental Corporation Fig. 2.3 Rate of Return (%) 40 35 30- 25- 20- 15 10- 5 0 16.8 11....
-
Which type of graph presents these data more effectively? To answer question, use the following results of the election to the General Assembly from one New Jersey district in 1991. Batten Lookabaugh...
-
There are various main objectives in macroeconomic policy, each of which contributes to an explanation and understanding of macroeconomics. Briefly define the following macroeconomic objectives and...
-
Prove that the mean heat capacities C P H and C P S are inherently positive, whether T > T 0 or T < T 0 . Explain why they are well defined for T = T 0 .
-
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?
-
The life \(T\) in hours of a vibration transducer is found to follow exponential distribution \[p_{T}(t)= \begin{cases}\lambda e^{-\lambda t}, & t \geq 0 \\ 0, & t <0\end{cases}\] where \(\lambda\)...
-
Fill in the Blank. If any parameter of a vibrating system is not known precisely, the resulting vibration is called ____________ vibration.
-
The probability distribution function, \(P(\widetilde{x})\), denotes a. \(P(x \leq \tilde{x})\) b. \(P(x>\widetilde{x})\) c. \(P(\tilde{x} \leq x \leq \tilde{x}+\Delta x)\)
Study smarter with the SolutionInn App