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

Assignment Help:

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);


Related Discussions:- Create a code for implement database of a car company

Crud application criteria, CRUD application criteria -Use a proper data...

CRUD application criteria -Use a proper data model, this means using Object Oriented PHP if you choose PHP -This model should have around 6-8 properties -The model should

Social login plugin update for wordpress, Social login plugin update for wo...

Social login plugin update for wordpress We are looking to have this plugin updated to comprise a social login service that isn't on the list yet. Both the plugin service beside

Cell padding, You will make modify to the cells which contain text. Since y...

You will make modify to the cells which contain text. Since you can see, the text is too close to the edges of the cells. You will add padding to the cells to leave room among the

I want to have an intranet website, What i have: Linux based web-server to ...

What i have: Linux based web-server to test, later website can run on windows server2012 with active directory (keep care of lower/ upper letters and so on), Domain, MySQL Database

Help, Hello, I am a web designer looking for inspiration for a website desi...

Hello, I am a web designer looking for inspiration for a website design (for any purpose) or creating a system that would be also created with the aid of the web programming langua

.Management science an introduction to management sci, identify the feasibl...

identify the feasible region for a set of constraints 3a-2b>0 2a - 1b 1a a,b>0

How can images be optimized for use on web pages, Question: (a) Write ...

Question: (a) Write the HTML tags for the following text: Software List A. Module 1 • Adobe Illustrator CS3 B. Module 2 • Adobe Photoshop CS3 C. Module 3 • Maya •

Looking for a long term developer, Looking For a Long Term Developer I a...

Looking For a Long Term Developer I am seeking to expand my team further and in need of one more Developer to join us rapidly to handle multiple projects as and when required at

Differences between include(), Question: (a) What are the differences ...

Question: (a) What are the differences between include(), require() and include_once()? (b) Convert the below if-elseif code to its equivalent switch case version: $day

Want nodejs expert to slightly modify hipache, Want nodejs expert to slight...

Want nodejs expert to slightly modify hipache I am seeking a nodejs expert. Business Description- We vend proxies A proxy is a server that you connect to in order to anonymis

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd