Project
schoolanswers
data_dictionary_table_2.docxTABLE:
|
Data Item |
Value |
||||||||
|
Name |
Type |
Length |
Min |
Max |
Description |
Index |
PK |
FK |
References |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Example Below:
TABLE: Employee_T
|
Data Item |
Value |
||||||||
|
Name |
Type |
Length |
Min |
Max |
Description |
Index |
PK |
FK |
References |
|
EmpID |
Varchar |
5 |
|
|
Person ID |
|
Y |
Y |
Person(PersonID) |
|
DateHired |
Date |
|
|
|
Hire date of employee |
|
|
|
|
|
EmpType |
Varchar |
1 |
“N” |
“T” |
Subtype discriminator; values N, S, T. N=Nurse, S=Staff, T=Technician |
|
|
|
|
