Database Implementation Assignment Report

Running head: DATABASE IMPLEMENTATION
Database Implementation
Name of the Student
Name of the University
Author’s note:

DATABASE IMPLEMENTATION1
Create Tables:
CREATE TABLE `customer` (
`customerID` int(11) NOT NULL,
`lastName` varchar(200) NOT NULL,
`firstName` varchar(200) NOT NULL,
`streetAddress` varchar(200) NOT NULL,
`city` varchar(200) NOT NULL,
`state` varchar(20) NOT NULL,
`zipCode` int(11) NOT NULL,
`currentBalance` decimal(12,2) NOT NULL,
`creditLimit` int(11) NOT NULL,
`salesRepID` int(11) NOT NULL
);
CREATE TABLE `orderlines` (
`orderID` int(11) NOT NULL,
`partID` char(10) NOT NULL,
`numberOrdered` int(11) NOT NULL,
`quotedPrice` decimal(12,2) NOT NULL

DATABASE IMPLEMENTATION2
);
CREATE TABLE `orders` (
`orderID` int(11) NOT NULL,
`orderDate` date NOT NULL,
`customerID` int(11) NOT NULL,
`shippingDate` date DEFAULT NULL
);
CREATE TABLE `parts` (
`partID` char(10) NOT NULL,
`partDescription` varchar(200) NOT NULL,
`unitsOnHand` int(11) NOT NULL,
`class` char(5) NOT NULL,
`warehouseNumber` int(11) NOT NULL,
`unitPrice` decimal(12,2) NOT NULL
);
CREATE TABLE `salesregion` (
`regionID` char(5) NOT NULL,
`regionDescription` varchar(200) NOT NULL,