The following data should be used
to test the SQL DML statements you write for
Project Assignment No. 2. Please input the data into
your relational database system according to the schema design you produced for
Project Assignment No. 1 (or some version of the same
if you had to make changes).
As for Project Assignment No. 3,
please ensure that by the time you submit your assignment, you have initialized
your database with the data provided below, and that everything is ready to
go for the TA to evaluate your system and user interface.
Important!
Customers
| CustomerId |
LastName |
FirstName |
Address |
City |
State |
ZipCode |
Telephone |
Email |
CreditCard |
Rating |
| 111-11-1111 |
Yang |
Shang |
123 Success Street |
Stony Brook |
NY |
11790 |
516-632-8959 |
syang@cs.sunysb.edu |
1234-5678-1234-5678 |
1 |
| 222-22-2222 |
Du |
Victor |
456 Fortune Road |
Stony Brook |
NY |
11790 |
516-632-4360 |
vicdu@cs.sunysb.edu |
5678-1234-5678-1234 |
1 |
| 333-33-3333 |
Smith |
John |
789 Peace Blvd. |
Los Angeles |
CA |
93536 |
315-443-4321 |
jsmith@ic.sunysb.edu |
2345-6789-2345-6789 |
1 |
| 444-44-4444 |
Philip |
Lewis |
135 Knowledge Lane |
Stony Brook |
NY |
11794 |
516-666-8888 |
pml@cs.sunysb.edu |
6789-2345-6789-2345 |
1 |
Accounts
| CustomerId |
Account# |
AccountType |
AcctCreatDate |
Movie |
| 444-44-4444 |
1 |
unlimited-2 |
10-1-06 |
1 |
| 444-44-4444 |
1 |
unlimited-2 |
10-1-06 |
3 |
| 222-22-2222 |
2 |
limited |
10-15-06 |
2 |
| 222-22-2222 |
2 |
limited |
10-15-06 |
3 |
Actors
| ActorId |
ActorName# |
M/F |
Age |
Movie |
Rating |
| 1 |
Al Pacino |
M |
63 |
1 |
5 |
| 1 |
Al Pacino |
M |
63 |
3 |
5 |
| 2 |
Tim Robbins |
M |
53 |
1 |
2 |
Employees
| SSN |
LastName |
FirstName |
Address |
City |
State |
Zipcode |
Telephone |
StartDate |
HourlyRate |
| 123-45-6789 |
Smith |
David |
123 College road |
Stony Brook |
NY |
11790 |
516-215-2345 |
11-1-05 |
$60 |
| 789-12-3456 |
Warren |
David |
456 Sunken Street |
Stony Brook |
NY |
11794 |
631-632-9987 |
2-2-06 |
$50 |
*David Warren is the Manager
of the company.
Movies
| Id |
Name |
Type |
DistFee |
NumCopies |
Rating |
| 1 |
The Godfather |
Drama |
10,000 |
3 |
5 |
| 2 |
Shawshank Redemption |
Drama |
1,000 |
2 |
4 |
| 3 |
Borat |
Comedy |
500 |
1 |
3 |
Orders
| OrderId |
Account |
Movie |
DateTime |
ReturnDate |
| 1 |
1 |
1 |
11-11-09 10:00 |
11-14-09 |
| 2 |
2 |
3 |
11-11-09 18:15 |
-- |
| 3 |
1 |
3 |
11-12-09 9:30 |
-- |
| 4 |
2 |
2 |
11-21-09 22:22 |
-- |
Good luck!