project -Database in Access
| CarID | TagNumber | Make | Model | CarYear | CategoryID | Picture | Condition | Available |
|---|---|---|---|---|---|---|---|---|
| 1 | 4 | BMW | 2008 BMW 7 Series | 2008 | Good | true | ||
| 2 | 5 | Honda | 2013 Honda Civic Si | 2013 | Good | true | ||
| 3 | 16 | Lexus | 2015 Lexus IS 250 AWD | 2015 | Good | true | ||
| 4 | 47 | Subaru | 2013 Subaru Legacy 2.5i Premium | 2013 | Good | true | ||
| 5 | 87 | Mitsubish | 2014 Mitsubishi Lancer ES | 2014 | Good | true |
| CategoryID | Category | Daily | Weekly | Monthly |
|---|
| CustomerID | DrvLicNumber | FullName | Address | City | State | ZIPCode | Occupation | Note |
|---|---|---|---|---|---|---|---|---|
| 1 | E8574 | jane | jane@gmail.com | tori | toronto | 2536-412 | Self-employed | on progress |
| 2 | R5841 | Michel | Michel@gmail.com | cran | Hurugay | 456-225 | Students | on progress |
| 3 | Y5485 | Edward | edward@gmail.com | hamna | crane | 4721-635 | Employed | on prograss |
| 4 | S7542 | Ford | ford@gmail.com | Nairobi | Kenya | 5285-6352 | Companies | Given |
| 5 | A8574 | Carol | carol@gmail.com | Texass | Texaas | 5414-6374 | Self-employed | Given |
| 6 | Q8502 | William | wiliam@gmail.com | Califonia | Califonia | 8596-6307 | Students | On progress |
| 7 | D5874 | Marian | marian@gmail.com | Tomaco | Tomaco | 5241-2002 | Employed | Given |
| 8 | T8714 | Moses | moses@gmail.com | Washington | Washington | 7458-9658 | Employed | On progress |
| 9 | U8595 | Ronny | ronny@gmail.com | Dinia | wenii | 5241-9685 | Students | On progress |
| 10 | L4114 | Ann | ann@gmail.com | Nigeria | Nigeria | 4752-7895 | Self-employed | Given |
| EmployeeID | EmployeeNumber | FirstName | LastName | Title | Notes |
|---|
| ID | AllFK |
|---|
| RentalOderID | EmployeeID | CustomerID | CarID | CarCondition | StartDate | EndDate | TotalDays | AmountPaid | OrderStatus | Notes |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Well returned |