The following is a list of the final tables and columns for the SkyWrite database, including linking columns. An asterisk (*) denotes a key column.
Employee
Column name |
Data type |
*EmployeeID |
INTEGER |
EmployeeFirstName |
TEXT 25 |
EmployeeLastName |
TEXT 25 |
EmployeeAddress |
TEXT 40 |
EmployeeCity |
TEXT 25 |
EmployeeState |
TEXT 2 |
EmployeeZip |
TEXT 10 |
EmployeeAreaCode |
TEXT 3 |
EmployeePhone |
TEXT 8 |
Customer
Column name |
Data type |
*CustomerID |
INTEGER |
CustomerFirstName |
TEXT 25 |
CustomerLastName |
TEXT 25 |
CustomerCompany |
TEXT 30 |
CustomerAddress1 |
TEXT 40 |
CustomerAddress2 |
TEXT 40 |
CustomerCity |
TEXT 25 |
CustomerState |
TEXT 2 |
CustomerZip |
TEXT 10 |
CustomerAreaCode |
TEXT 3 |
CustomerAreaCode |
TEXT 8 |
Flights
Column name |
Data Type |
*FlightID |
INTEGER |
*EmployeeID |
INTEGER |
*CustomerID |
INTEGER |
FlightDate |
DATE |
Slogan |
TEXT 30 |
Letters |
INTEGER |
Price |
CURRENCY |
TotalCharge |
CURRENCY |
Place |
NOTE |
Congratulations! Your design is now complete. In the next lesson you will learn how to implement the SkyWrite database design in R:BASE.