SQL database creation in Oracle
smalls10
SQLDatabasecreation.docx
Employee Table information:
|
EmployeeID |
LastName |
FirstName |
Position |
|
143100 |
Hatcher |
Arthur |
Boss |
|
143101 |
Wilson |
Jonah |
Quality Control |
|
143102 |
Henderson |
James |
Sales |
|
CustomerID |
LastName |
FirstName |
Address |
City |
State |
ZipCode |
Phone |
|
|
101 |
Jones |
Mary |
1313 Mockingbird Lane |
Detroit |
MI |
48127 |
313-438-1255 |
[email protected] |
|
102 |
Smith |
Harold |
1087 Lawnwood St |
Lamoore |
CA |
93245 |
559-698-1013 |
[email protected] |
|
103 |
Acosta |
Janet |
611 Kent Ave |
Spokane |
WA |
99201 |
509-383-1147 |
[email protected] |
Order Table information:
|
OrderNumber |
CustomerID |
Product |
UPC |
PurchaseDate |
ShippingDate |
Quantity |
Price |
|
0001 |
102 |
Wallet |
67810 |
8/31/2019 |
9/01/2019 |
1 |
50.00 |
|
0002 |
103 |
Watch |
45125 |
09/03/2019 |
09/03/2019 |
2 |
240.00 |
|
0003 |
101 |
Watch |
32770 |
09/10/2019 |
09/11/2019 |
1 |
150.00 |
Product Table information:
|
UPC |
Product |
Color |
Price |
Quantity |
|
67810 |
Wallet |
Brown |
50.00 |
75 |
|
67811 |
Wallet |
Black |
50.00 |
53 |
|
45125 |
Watch |
Black |
120.00 |
11 |
|
45126 |
Watch |
Red |
120.00 |
3 |
|
32770 |
Watch |
Rose Gold |
150.00 |
14 |
Supplier table information:
|
CompanyName |
Product |
Price |
LastName |
FirstName |
City |
State |
ZipCode |
Phone |
|
|
Wallet Zone |
Wallet Black |
12.00 |
Montez |
Ericka |
Madison |
WI |
53558 |
866-689-1289 |
[email protected] |
|
Wallet Town |
Wallet Brown |
15.00 |
Lancaster |
Barry |
Las Vegas |
NV |
89143 |
800-555-1012 |
[email protected] |
|
Watch World |
Watch Black |
75.00 |
Shultz |
Amanda |
Phoenix |
AZ |
85001 |
888-323-8897 |
[email protected] |
|
Watch World |
Watch Rose Gold |
85.00 |
Shultz |
Amanda |
Phoenix |
AZ |
85001 |
888-323-8897 |
[email protected] |
