After the completion of the logical model the physical model is to be made. The oracle 10 G will be used as a database server and all the tables with their column are created and indexing approach also included.
The create table command are as fellows.
CUSTOMER TABLE
CREATE TABLE CUSTOMER(
CUSTOMERID NUMBER(4) PRIMARY KEY,
FIRST_NAME VARCHAR(20) NOT NULL,
LAST_NAME VARCHAR(20) ,
ADDRESS VARCHR(50) ,
CONTACT_NUMBER NUMBER(15) NOT NULL
STATE VARCHAR(10)
)
MATERIAL TABLE
CREATE TABLE MATERIAL(
MATERIALID NUMBER(4) PRIMARY KEY,
MATERIALNAME VARCHAR(10) NOT NULL,
COSTID VARCHAR(10))
LOCATION TABLE
CREATE TABLE LOCATION(
LOCATIONID NUMBER(4) PRIMARY KEY,
LOCATION NAME VARCHAR(20),
QUADRANTID NUMBER(4),
CONSTRAINT FK_LOCATIONID_SUB FOREIGN KEY(LOCATIONID)
REFERENCES LOCATION (LOCATIONID))
EMPLOYEE TABLE
CREATE TABLE EMPLOYEE(
EMPLOYEEID NUMBER(4) PRIMARY KEY,
NAME VARCHAR(20),
SALARY NUMEBR(10),
ADDRESS VARCHAR(50),
PHONE NUMBER(15))
DISTRICT TABLE
CREATE TABLE DISTRICT(
DISTRICTID NUMBER(4) PRIMARY KEY,
DISTRICTNAME VARCHAR(20))
OPERATOR TABLE
CREATE TABLE OPERATOR(
OPERATORID NUMBER(4) PRIMARY KEY,
OPERATORNAME(4) PRIMARY KEY,
))