INSTRUCTIONS Auto Repair Database: You\'ve been asked to establish a new databas

Question

INSTRUCTIONS Auto Repair Database: You've been asked to establish a new database for the local auto repair shop. The owner has given you the following data categories that he feels should be in the database. Organize the data categories into two tables, label each table with a name, and identify in each table the primary key field. Then, make a list of other forms, reports, queries, etc that would be needed in the Database Customer ID Car Make Last Name Address Model year Model State hone ehicle ID ity irst Name License Plate

Explanation / Answer

Solution:

The database can be designed with the two tables and they will be

Customer(Customer_ID, Vehicle_ID, FirstName, LastName, Phone, City, Address, State)

Primary key: Customer_ID

Foreign_Key: Vehicle_ID

Vehicle(Vehicle_ID, CarMake, Model, LicensePlate, ModelYear)

Primary key: Vehicle_ID

These tables can be created using the query below:

CREATE TABLE Customer(
    Customer_ID int(20),

FirstName varchar(40),

LastName varchar(40),

phone int(20),

city varchar(20),

address varchar(20),

Vehicle_ID int (20),

State varchar(20),
PRIMARY KEY (Customer_ID),

CONSTRAINT FK_VehicleID FOREIGN KEY (Vehicle_ID)
    REFERENCES CONSULTANT(Vehicle_ID)

);

CREATE TABLE Vehicle(
Vehicle_ID int NOT NULL,
CarMake varchar(20),
Model varchar(20),
LisensePlate varchar(20),

ModelYear date,
    PRIMARY KEY (Vehicle_ID),
  
);

I hope this helps if you find any problem. Please comment below. Don't forget to give a thumbs up if you liked it. :)

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.