Complete the ERD below by dragging the ends of crows feet and the specialization hierarchy symbols to their correct location. The XYZ Company has a motor pool and wants to track scheduled and unscheduled maintenance to each of the vehicles in its fleet. Each vehicle is assigned a unique unit number that will be used on all paperwork and is displayed on the vehicle. In addition to the unit number all vehicles have a unique Vehicle Identification Number (VIN) that is a long and complex string of letters and numbers, and all vehicles belong to one of three types "T" for trucks, "R" for trailers, and "A" for automobiles. For trucks, we need to know the Gross Vehicle Weight (GVW) and the type of trailer hitch (if it has one). For trailers, we need to know their length, the maximum weight allowed, the type of trailer (Van, Reefer, Low Boy, Flat…), and the required hitch type. For automobiles, we need to know how many adults it will seat, its color, and if it is a "4 wheel drive". Maintenance must be done to all vehicles regularly to keep them safe and serviceable. When maintenance is to be done, a ticket (with a unique number) is completed with the unit number, the technician’s number, the date of the maintenance, odometer reading from the vehicle, estimated cost, technician’s notes, and maintenance type. Presently there are five types of maintenance tickets: "O" for oil changes, "T" for new tires and rotations, "B" for brake work, "I" for inspections, and "M" for miscellaneous. For types "O" and "T" we keep additional information. For oil changes, we record type of oil, type of filter, and quarts of oil used. For tire work we record the number of tires replaced (zero or more) and if the tires were rotated. Behavior of Answer Shape/Pocket: You can only use one symbol only on

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

Related questions

Concept explainers

Question

Complete the ERD below by dragging the ends of crows feet and the specialization hierarchy symbols to their correct location. The XYZ Company has a motor pool and wants to track scheduled and unscheduled maintenance to each of the vehicles in its fleet. Each vehicle is assigned a unique unit number that will be used on all paperwork and is displayed on the vehicle. In addition to the unit number all vehicles have a unique Vehicle Identification Number (VIN) that is a long and complex string of letters and numbers, and all vehicles belong to one of three types "T" for trucks, "R" for trailers, and "A" for automobiles. For trucks, we need to know the Gross Vehicle Weight (GVW) and the type of trailer hitch (if it has one). For trailers, we need to know their length, the maximum weight allowed, the type of trailer (Van, Reefer, Low Boy, Flat…), and the required hitch type. For automobiles, we need to know how many adults it will seat, its color, and if it is a "4 wheel drive". Maintenance must be done to all vehicles regularly to keep them safe and serviceable. When maintenance is to be done, a ticket (with a unique number) is completed with the unit number, the technician’s number, the date of the maintenance, odometer reading from the vehicle, estimated cost, technician’s notes, and maintenance type. Presently there are five types of maintenance tickets: "O" for oil changes, "T" for new tires and rotations, "B" for brake work, "I" for inspections, and "M" for miscellaneous. For types "O" and "T" we keep additional information. For oil changes, we record type of oil, type of filter, and quarts of oil used. For tire work we record the number of tires replaced (zero or more) and if the tires were rotated. Behavior of Answer Shape/Pocket:

You can only use one symbol only once

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions