CSE532 Project Demo Data (Fall 2001)

Very important: please input the following demo data before your scheduled demo time slot. Failure or the delay of doing so would result your failure in the demo or points being taken off from your project grade.

It's also very important for you to read the demo requirement and go over the general description of the project carefully. The demo test will be given ONLY based on these two specifications and the following demo data.

Customer

Social Security Number	Password	First name	Last name	Email	Videos Rented	Videos Downloaded	Outstanding balance
111111111	1111	Wen	Xie	wenxie@cs.sunysb.edu	<none>	<none>	$0.00
222222222	2222	Yan	Rong	yanrong@cs.sunysb.edu	<none>	<none>	$0.00

Supplier

Supplier ID	Password	Company name	Telephone	Videos Supplied
555555555	5555	company5	555-555-5555	4001,4002
666666666	6666	company6	666-666-6666	4003

Employees

Social Security Number	Password	First name	Last name	Representative/Manger
888888888	8888	Mike	Smith	Representative
999999999	9999	Bill	Johnson	Representative
000000000	0000	root	root	Manager

Categories:

Category name	Parent category name	Representative
category1	root	888888888 (Mike)
category2	category1	888888888 (Mike)
category3	category1	999999999 (Bill)
category4	category3	999999999 (Bill)
category5	category4	999999999 (Bill)
category6(to be created)	(TBA)	(TBA)

Thus we have category1 under root, category1 contains category2 and category3, and so on. Category6 might be inserted to the database when you present the demo.

Videos

ID	Title	Stars	Under category	Video	Number of Rentals
4001	Pearl Harbor	star1,star2,star3	category1	here	0
4002	Shrek	star1,star2	category2	here	0
4003	The Godfather	star1	category3	here	0
4004	Star Wars	star2	(TBA)	here	0

Please download the above video files and insert them into your database under the specified categories before the demo. You will be asked to upload and insert video 4004 into the database under one of the categories.

Transaction examples

Customer Wen (SSN:111111111, password: 1111) rents "Pearl Harbor" on 12/1/2001.
Customer Yan (SSN:222222222, password: 2222) rents "Shrek" on 12/5/2001.
Customer Representative Mike Smith (SSN:888888888, password: 8888) records the above two rentals . (eg, <Wen, "Pearl Harbor", 12/1/2001, price, Mike>, <Yan, "Shrek", 12/5/2001, price, Mike>)

Perform these three transactions before the demo.

Demo checklist

User's guide (for customers, employees, and managers)
Programmer guide (E-R and relational design & Justification, User Interface and Query design)
New user registration, Login in and log out
Customer-Level Transactions
Customer-Representative-Level Transactions
Manager-Level Transactions
Supplier-Level Transactions

Read the demo requirement and the general description of the project for detailed requirements.