Database Project - Chinedu Eleh and Hewan Shemtaga
Book | BookID | Title | UnitPrice | Author | Quantity | SupplierID | SubjectID |
|---|
|
| 1 | Book1 | 12.34 | author1 | 5 | 3 | 1 |
| 2 | Book2 | 56.78 | author2 | 2 | 3 | 1 |
| 3 | Book3 | 90.12 | author3 | 10 | 2 | 1 |
| 4 | Book4 | 34.56 | author4 | 12 | 3 | 2 |
| 5 | Book5 | 78.9 | author5 | 5 | 2 | 2 |
| 6 | Book6 | 12.34 | author6 | 30 | 1 | 3 |
| 7 | Book7 | 56.9 | author2 | 17 | 3 | 4 |
| 8 | Book8 | 33.44 | author7 | 2 | 1 | 3 |
| 9 | Book9 | 50 | author9 | 9 | 1 | 2 |
Customer | CustomerID | LastName | FirstName | Phone |
|---|
|
| 1 | lastname1 | firstname1 | 334-001-001 |
| 2 | lastname2 | firstname2 | 334-002-002 |
| 3 | lastname3 | firstname3 | 334-003-003 |
| 4 | lastname4 | firstname4 | 334-004-004 |
Employee | EmployeeID | LastName | FirstName |
|---|
|
| 1 | lastname5 | firstname5 |
| 2 | lastname6 | firstname6 |
| 3 | lastname6 | firstname9 |
Order_detail | BookID | OrderID | Quantity |
|---|
|
| 1 | 1 | 2 |
| 4 | 1 | 1 |
| 6 | 2 | 2 |
| 7 | 2 | 3 |
| 5 | 3 | 1 |
| 3 | 4 | 2 |
| 4 | 4 | 1 |
| 7 | 4 | 1 |
| 1 | 5 | 1 |
| 1 | 6 | 2 |
| 1 | 7 | 1 |
Orders | OrderID | CustomerID | EmployeeID | OrderDate | ShippedDate | ShipperID |
|---|
|
| 1 | 1 | 1 | 2016-08-01 | 2016-08-03 | 1 |
| 2 | 1 | 2 | 2016-08-04 | | |
| 3 | 2 | 1 | 2016-08-01 | 2016-08-04 | 2 |
| 4 | 4 | 2 | 2016-08-04 | 2016-08-04 | 1 |
| 5 | 1 | 1 | 2016-08-04 | 2016-08-05 | 1 |
| 6 | 4 | 2 | 2016-08-04 | 2016-08-05 | 1 |
| 7 | 3 | 1 | 2016-08-04 | 2016-08-04 | 1 |
Shipper | ShipperID | ShipperName |
|---|
|
| 1 | shipper1 |
| 2 | shipper2 |
| 3 | shipper3 |
| 4 | shipper4 |
Subjects | SubjectID | CategoryName |
|---|
|
| 1 | category1 |
| 2 | category2 |
| 3 | category3 |
| 4 | category4 |
| 5 | category5 |
Supplier | SupplierID | CompanyName | ContactLastName | ContactFirstName | Phone |
|---|
|
| 1 | supplier1 | company1 | company1 | 1111111111 |
| 2 | supplier2 | company2 | company2 | 2222222222 |
| 3 | supplier3 | company3 | company3 | 3333333333 |
| 4 | supplier4 | company4 | | 4444444444 |
type your code