create database

create database AutoVision;

USE AutoVision;

SET SQL_SAFE_UPDATES = 0;

# Create Customer Table

CREATE TABLE Customer (

Customer_id INT PRIMARY KEY,

Name VARCHAR(100),

Phone VARCHAR(20),

Email VARCHAR(100)

);

# Create AutoAdvisor Table

CREATE TABLE AutoAdvisor (

Advisor_id INT PRIMARY KEY,

Name VARCHAR(100),

Phone VARCHAR(20),

Email VARCHAR(100)

);

# Create Branch Table

CREATE TABLE Branch (

Branch_id INT PRIMARY KEY,

Location VARCHAR(100),

Contact_Number VARCHAR(20)

);

# Create Vehicle Table

CREATE TABLE Vehicle (

Vehicle_id INT PRIMARY KEY,

Model VARCHAR(50),

Type VARCHAR(50),

Year INT,

Price DECIMAL(10,2)

);

# Create Transaction Table

CREATE TABLE Transaction (

Transaction_id INT PRIMARY KEY,

Customer_id INT,

Vehicle_id INT,

Branch_id INT,

Advisor_id INT,

Date DATE,

Note TEXT,

Payment_method VARCHAR(50),

FOREIGN KEY (Customer_id) REFERENCES Customer(Customer_id),

FOREIGN KEY (Vehicle_id) REFERENCES Vehicle(Vehicle_id),

FOREIGN KEY (Branch_id) REFERENCES Branch(Branch_id),

FOREIGN KEY (Advisor_id) REFERENCES AutoAdvisor(Advisor_id)

);