The following data is 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).
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!