Given the information below, create the fully labeled Crow's Foot ERD using a specialization hierarchy where...

Question

Question

Given the information below, create the fully labeled Crow's Foot ERD using a specialization hierarchy where...

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.

engineering Computer-Science

Add a comment Improve this question Transcribed image text

Answer 1

Answer #1

Add a comment

Answer 2

Similar Homework Help Questions

Given the information below, create the fully labeled Crow's Foot ERD using a specialization hierarchy where...

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: In a small IT company, each assignment is related to performing a tech check up or working on a new project. All assignments share common attributes such as the assignment code and the description. In addition, unique attributes are used to describe each...
QUESTION 1 1. Use the following business rules to draw the fully labeled Crow's Foot ERD...

QUESTION 1 1. Use the following business rules to draw the fully labeled Crow's Foot ERD in Visio. The diagram must include all entities, attributes, and relationships. Primary keys and foreign keys must be clearly identified on the diagram. Write all appropriate connectivities and cardinalities on the ERD. a). Each city may have many sport teams. The number of teams is limited to 20 per city. b). Each team belongs to one and only city. c). Each team has at...
QUESTION 1 1. Use the following business rules to draw the fully labeled Crow's Foot ERD...

QUESTION 1 1. Use the following business rules to draw the fully labeled Crow's Foot ERD in Visio. The diagram must include all entities, attributes, and relationships. Primary keys and foreign keys must be clearly identified on the diagram. Write all appropriate connectivities and cardinalities on the ERD. a). Each city may have many sport teams. The number of teams is limited to 20 per city. b). Each team belongs to one and only city. c). Each team has at...

Given the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy if appropriate

2. Given the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy if appropriate. Tiny Hospital keeps information on patients and hospital rooms. The system assigns each patient a patient ID number. In addition, the patient’s name and date of birth are recorded. Some patients are resident patients who spend at least one night in the hospital, and others are outpatients who are treated and released. Resident patients are assigned a room. Each room is identified by...
Create a crows foot erd using a specialization hierarchy if appropriate. Granite sales company keeps information...

Create a crows foot erd using a specialization hierarchy if appropriate. Granite sales company keeps information on its employees and the departments in which they work. For each department, the department name,internal mailbox server, and office phone extension are kept. A department can have many assigned employees, and each employee is assigned to only one department. Employees can be salaried, hourly, or work on contract. All employees are assigned an employee number, which is kept along with the employee's name...
11. medical clinic Using the Crow's Foot notation, create an ERD that can be implemented for...

11. medical clinic Using the Crow's Foot notation, create an ERD that can be implemented for a medical clinic, using at least the following business rules: a. A patient can make many appointments with one or more doctors in the clinic, and a doctor can accept appointments with many patients. However, each appointment is made with only one doctor and one patient. b. Emergency cases do not require an appointment. However, for appointment management purposes, an emergency is entered in...

Given the following business scenarios, create Crow’s Foot ERDs using a specialization hierarchy if appropriate. (Make...

Given the following business scenarios, create Crow’s Foot ERDs using a specialization hierarchy if appropriate. (Make sure that you diagram parent-child relationships.) Two-Bit Drilling Company keeps information on employees and their dependents. Each employee has an employee number, name, date of hire, and title. If an employee is an inspector, then the date of certification and the renewal date for that certification should also be recorded in the system. For all employees, the SSN and department names should be kept....
Consider the following tables: PAINTER(P_NUMBER, P_LNAME, P_FNAME, P_MAIL) PAINTING(PAINT_CODE, PAINT_TITLE, P_NUMBER) For the tables given above,...

Consider the following tables: PAINTER(P_NUMBER, P_LNAME, P_FNAME, P_MAIL) PAINTING(PAINT_CODE, PAINT_TITLE, P_NUMBER) For the tables given above, work on the problems below: 1. For each table, identify the primary key. 2. For each table, identify the foreign key(s). 3. Identify at least one candidate key. If there are no candidate keys, give an example of an attribute that could be used as a candidate key. 4. For one of the tables, give examples of a superkey and a secondary key. 5....
Draw YOUR entity relationship diagram (ERD) using Crow's foot notation to indicate entities, relationships, connectives, and...

Draw YOUR entity relationship diagram (ERD) using Crow's foot notation to indicate entities, relationships, connectives, and participations. The administrators of Tiny College are so pleased with your design and implemen- tation of their student registration and tracking system that they want you to expand the design to include the database for their motor vehicle pool. A brief description of operations follows: • Faculty members may use the vehicles owned by Tiny College for officially sanc- tioned travel. For example, the...

This is about database system. Thank you. Question B1 Create a Crow's Foot ERD with the...

This is about database system. Thank you. Question B1 Create a Crow's Foot ERD with the business rules described below. Write all appropriate connectivities and cardinalities in the ERD. A music store would like to develop a database to manage information about the CDs, or vinyl collection, the customers and transactions information. It stores the relationships between artists, albums, tracks, customers and transactions. Here is the list of requirements for the database: The collection consists of albums. An album is...

Given the information below, create the fully labeled Crow's Foot ERD using a specialization hierarchy where...

Homework Answers