Database System Technology

Running head: DATABASE SYSTEM TECHNOLOGY
Database System Technology
Name of the Student
Name of the University
Author’s note:

1DATABASE SYSTEM TECHNOLOGY
Database Structure:
CREATE TABLE tbl_buyer (
buyerID number(10) NOT NULL,
first_name varchar2(150) NOT NULL,
last_name varchar2(150) NOT NULL,
address varchar2(150) NOT NULL,
contact_number varchar2(150) NOT NULL
);
CREATE TABLE tbl_car (
car_number number(10) NOT NULL,
make varchar2(150) NOT NULL,
model varchar2(150) NOT NULL,
color varchar2(150) NOT NULL,
price number(10,2) NOT NULL,
year number(4) NOT NULL,
mileage number(10) NOT NULL,
body_type varchar2(150) NOT NULL,
fuel_type varchar2(150) NOT NULL,
engine_size varchar2(150) NOT NULL,
fuel_consumption varchar2(150) NOT NULL,
CO2_emission varchar2(150) NOT NULL
);
CREATE TABLE tbl_car_owner (
car_number number(10) NOT NULL,
buyer_id number(10) NOT NULL,
from_date date NOT NULL,
to_date date NOT NULL
);
CREATE TABLE tbl_sales_invoice (

2DATABASE SYSTEM TECHNOLOGY
sales_number number(10) NOT NULL,
car_number number(10) NOT NULL,
seller_id number(10) NOT NULL,
buyer_id number(10) NOT NULL,
purchase_date date NOT NULL,
sold_date date NOT NULL,
sold_price number(10,2) NOT NULL
);
CREATE TABLE tbl_seller (
seller_id number(10) NOT NULL,
last_name varchar2(150) NOT NULL,
first_name varchar2(150) NOT NULL,
address varchar2(150) NOT NULL,
contact_number varchar2(150) NOT NULL
);
ALTER TABLE tbl_buyer
ADD PRIMARY KEY (buyerID);
ALTER TABLE tbl_car
ADD PRIMARY KEY (car_number);
ALTER TABLE tbl_car_owner
ADD PRIMARY KEY (car_number,buyer_id);
ALTER TABLE tbl_sales_invoice
ADD PRIMARY KEY (sales_number);
ALTER TABLE tbl_seller
ADD PRIMARY KEY (seller_id);