|
Home
|
Sign up!
|
Projects
|
Seminars
|
Research Notes
|
Today's Lecture
|
About
|
Update Project Form
Course:
Project Topic:
Project Description:
Group members are me and Kulmeet .We are planning to make an online_shopping database.
you can see kulmeets page for updates.I'll describe the tables of the database.
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(10), account_no integer, email_id char(20), age integer, sex char(10), 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(pid, oid), 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);
Your Password:
Prof. Ashay Dharwadker