Database Structure

Here is a full list of tables in the test database. All examples in the SQL tutorial works with the following tables:

AntiqueOwners Table

OwnerID OwnerLastName OwnerFirstName Address City State Country
1 Jones Bill   London   UK
2 Smith Bob   New York New York USA
5 Jenifer Lopes   Paris   France
15 Lawson Patricia   Los Angeles   USA
21 Akins Jane 77, Lincoln st. Kirkland Washington USA
50 Fowler Sam   Losantiville   USA

Antiques Table

SellerID BuyerID Item Price ItemID
1 50 Bed 350 3
1 21 Cabinet 400 66
1 15 Jewelry Box 200 7
2 15 Table 750 1
2 21 Coffee Table 375 4
2 21 Pottery 450 16
10 5 Boocase 260 55
15 2 Chair 370 21
15 50 Chair 325 21
21 50 Mirror 500 15
50 1 Desk 850 2
50 1 Plant Stand 250 22

EmployeeAddressTable Table

EmployeeIDNo SSN FirstName LastName Address City State BirthDate
10 512687458 Joe Smith 83 First Street Howard Ohio 10.05.1978
11 615374542 Jane WhiteHead 55 Oak st. London England 15.03.1965
152 758420012 Mary Scott 842 Vine Ave. Losantiville Ohio 21.12.1981
244 102254896 Sam Jones 33 Elm St. New York New York 31.12.1980
400 876512563 Sarah Ackerman 440 U.S. 110 Upton Michigan 15.08.1979

EmployeeStatisticsTable Table

EmployeeIDNo Salary Benefits Position
10 75 000,00 15 000,00 Manager
105 65 000,00 15 000,00 Manager
152 60 000,00 15 000,00 Manager
215 60 000,00 12 500,00 Manager
244 50 000,00 12 000,00 Staff
300 45 000,00 10 000,00 Staff
335 40 000,00 10 000,00 Staff
400 32 000,00 7 500,00 Entry-Level
441 28 000,00 7 500,00 Entry-Level

Orders Table

OwnerID ItemDesired
1 Table
2 Desk
15 Mirror
21 Chair
23 Window
55 Bookcase
64 Lamp
admin

admin

Leave a Reply

Your email address will not be published.