|
Home
|
Sign up!
|
Projects
|
Seminars
|
Research Notes
|
Today's Lecture
|
About
|
Update Project Form
Course:
Project Topic:
Project Description:
This project is a joint venture by Deepika Saxena and I.The database proposed to be prepared is expected to exhibit a online shopping database.
The database to be prepared and compiled under this topic include:-
1.list of all the products available for purchase.
2.list of orders placed by customers(date-wise ie. according to the date they placed an order on).An order_ID will be assigned to each order with the help of auto-increment; this will help the customer in checking the status of the order.
3.each order will be assigned a unique order no., so that the customer can check the status of the order.
The look of the project-
My SQL will be used to prepare the backend
and the front end will be a MS-Access spreadsheet.
Primary keys of each table-
Table Primary Key
Product Table item_name
Order Table order_id
Technologies used for this project are-
MySQL, php programming and HTML or MS Access
for latest update on this project,please refer to Deepika's account
Database created-
Creating database andTables in MySQL (commands,fields,etc)
create database online_shopping;
create table product
(pid integer not null,company_name char(20),description char(20),market_price integer,max_you_pay integer,item_name char(10),primary key(pid));
create table orders
(oid integer not null,customer_name char(20),account_no integer,email_id char(20),age integer,sex char(1),mobile_no integer,date char(10),primary key(oid));
create table category
(cid integer not null,category char(20),primary key(cid));
create table po
(pid integer not null,oid integer not null,status char(10),primary key(pi,cid),foreign key(pid)references product,foreign key(oid) references orders);
create table pc
(cid integer not null,pid integer not null,no_of_pieces integer,primary key(cid,pid),foreign key(cid)references category,foreign key(pid)references product);
The above mentioned database ie. online_shopping can be viewed at PC no.15 in Lab 1.
Your Password:
Prof. Ashay Dharwadker