Online Bookstore Buyer Database

Buyer's Form

Property	Field name	Type	Key value	is empty
User ID	Userid	CHAR (5)	Primary key
User name	UserName	nvarchar (50)
User password	Userpwd	nvarchar (50)
User's real name	Userrealname	nvarchar (50)
User Address	UserAddress	nvarchar (100)
User Phone	Userphone	CHAR (11)

Shopping Cart Table

Property	Field name	Type	Key value	is empty
Shopping Cart ID	Cartid	CHAR (5)	Primary key
Number of books	Booknum	Int (5)
Date Created	CreateDate	Datetime
User ID	Userid	CHAR (5)	FOREIGN key

Order Form

Property	Field name	Type	Key value	is empty
Order number	OrderId	CHAR (15)	Primary key
User ID	Userid	CHAR (5)	FOREIGN key
Shopping Cart ID	Cartid	CHAR (5)	FOREIGN key
Order Status	Status	nvarchar (50)
Order Date	OrderDate	Datetime
Consignee Address	Recaddress	nvarchar (50)
Name of consignee	Recname	nvarchar (50)

Include table

Property	Field name	Type	Key value	is empty
Shopping Cart ID	Cartid	CHAR (5)	Primary key attribute/foreign key
Book ID	BookID	CHAR (5)	Primary key attribute/foreign key

Online Bookstore Buyer Database