Create a code for implement database of a car company, PHP Web Programming

Creating Table

create table cars (Vin_num varchar(30),primary key(Vin_Num),Make varchar(15),Model varchar(20),Year int,Price varchar(20));
Inserting Records:
insert into cars values ('1A2A3A4A','Toyota','Camry',2005,'$14,500');
insert into cars values ('1B2B3B4B','Nissan','Altima',2007,'$16,550');
insert into cars values ('1C2C3C4C','Honda','Civic',1999,'$9,999');
insert into cars values ('1D2D3D4D','Chevrolet','Camero',2009,'$27,500');
insert into cars values ('1E2E3E4E','Chrysler','Crossfire',2010,'$35,499');
insert into cars values ('1F2F3F4F','Ford','Focus',1998,'$6,500');
insert into cars values ('1G2G3G4G','Dodge','Ram', 2008,'$6,555');

Table: customers

Creating Table

create table customers(Cust_ID varchar(8),primary key(Cust_ID),Cust_Name varchar(20), Address varchar(60),Phone varchar(15));
Inserting Records:
insert into customers values ('CUS001','John','625,Quincy Ave,Scranton,PA','435-345-3455');
insert into customers values ('CUS002','Peter','302, Phelps St,Scranton,PA','345-234-5234');
insert into customers values ('CUS003','Kevin','90, Richmond St,Dunmore,PA','345-345-2642') ;
insert into customers values ('CUS004','Sujal','114,S Irving Ave, Avoca,PA','655-854-8899');
insert into customers values ('CUS005','Rich','225, N Main St,Dicksoncity,PA','556-889-8896');
insert into customers values ('CUS006','Frank','850, Adams Ave, Kingston,PA','545-879-9988');

Table: employees

Creating Table

create table employees(Emp_ID varchar(8),primary key(Emp_ID),Emp_Name varchar(20),Position varchar(45),Salary varchar(10));
Inserting Records:
insert into employees values ('EMP001','Chris','Manager','$52,500');
insert into employees values ('EMP002','Kelly','Area Manager','$48,000');
insert into employees values ('EMP003','Andrew','Sales Manager ','$46,500');
insert into employees values ('EMP004','Tom','Executive','$45,000');
insert into employees values ('EMP005','Rick','Salesman','$35,500');
insert into employees values ('EMP006','Harris','Accountant','$30,500');

Table: sales

Creating Table

create table sales (Sale_ID varchar(8),primary key(sale_ID),Cust_ID varchar(8),Vin_Num varchar(10),Emp_ID varchar(8),foreign key (Cust_ID) references customers(Cust_ID),
foreign key (Vin_Num) references cars(Vin_Num), foreign key (Emp_ID) references employees(Emp_ID));
Inserting Records:
insert into sales values ('SLS001','CUS002','1C2C3C4C','EMP001');
insert into sales values ('SLS002','CUS002','1D2D3D4D','EMP002');
insert into sales values ('SLS003','CUS003','1E2E3E4E','EMP004');
insert into sales values ('SLS004','CUS004','1C2C3C4C','EMP003');
insert into sales values ('SLS005','CUS005','1F2F3F4F','EMP005');
insert into sales values ('SLS006','CUS001','1B2B3B4B','EMP006'); 
ERD:
Also I put Primary key(pk) and Foreign key(fk) into chart.

538_Create a Code for Implement Database of a car company.png

   

Need to be use it.

I need just PHP coding for 4 tables (car, customer, employees, and sales).
Also you can see first 2 pages are needed to be used information for PHP coding.
 Also I put Example for inserting a record, updating a record, and deleting a record. You can see on the following pages.
But when you do PHP coding make sure uppercase is uppercase (Capital letter) and lowercase is lowercase (small letter).
Also you can see in ERD chart what's going on.
Each table need to be 3 files. (Car has 3 files, employees has 3 files, customer has 3 files, sales has 3 files)
For example, Always use to Add Vin_Num,etc.......
 So, total 12 files.
Don't worry about this part I will fix it myself. Leave it same.
$conn = mysql_connect("database host", "username", "password");             
$result = mysql_select_db("database name", $conn);

Posted Date: 3/2/2013 2:15:14 AM | Location : United States







Related Discussions:- Create a code for implement database of a car company, Assignment Help, Ask Question on Create a code for implement database of a car company, Get Answer, Expert's Help, Create a code for implement database of a car company Discussions

Write discussion on Create a code for implement database of a car company
Your posts are moderated
Related Questions
We need help in Financial Application Support Enhance our account aggregation process using Yodlee API. We want to fix several bugs in our existing process as well as change fro

We are looking for Wordpress Theme Install & Customization Greenable.net is hiring a candidate to install as well as customize the Avada Wordpress theme according to the demo si

Development of ecommerce store in cakephp Project Description: We want to get help finishing off a project based in cakephp (because we don't have time). Things that would re

How do I select lets say 2columns eg(Name and Payment plan)when I type in a a telephone number like 665528 to get the one row corresponding to the number I have typed?

Need a Expert Wordpress Programmer and Designer We are in search of an ongoing wordpress expert designer and programmer for ongoing tasks. For this project you will make an auth

Video player/thumbnail swap-out script needed I want a video player thumbnail script. There will be one big, main video, adjacent to either three or four thumbnails of other vid

Magento community with Enterprise features on Amazon AWS We are concerned to run Multiple Magento community instances on Amazon AWS to support very high traffic. We as well like

(a) For electronic transactions (1) authentication and (2) non-repudiation are important legal concerns. Describe what each is and why each is of particular concern in electronic t

We need help in Custom Hook for a Wordpress plugin We are in search of someone that can create a custom hook from one plugin into another. The logic is that while a user clic

I have two projects that need to be completed Project 1: This website wouldn't be for me. I'm not seeking to profit from the work you do on this job. Just helping out a friend.