Question: Given the information below, create the fully labeled Crow's Foot ERD using a specialization hierarchy where appropriate (use Visio). The ERD must contain all primary
Given the information below, create the fully labeled Crow's Foot ERD using a specialization hierarchy where appropriate (use Visio). The ERD must contain all primary keys, foreign keys, and main attributes. Business rules are defined as follows:
- A company owns three types of vehicles: cars, trucks, and motorcycles. When delivered, each vehicle goes through inspection. Each vehicle creates one record in the INSPECTION table. One record in the INSPECTION table is related to one vehicle.
- All vehicles share common basic attributes such as the vehicle ID, year, and model. In addition, each group of vehicles has unique attributes. The list of such attributes includes but is not limited to the following: the number of passengers (cars), the capacity (trucks), and the type (motorcycles).
- Each car can be either for sale or for rent, or both. The company wants to keep track of the price and the rental fee for each car. If a car was rented, the latest date must be recorded.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
