Describe three components of a data dictionary.
1) One component of a data directory is the topology of the database, which describes what each field and table in the database will do. It also includes a short description of each field or table.
2) Another component of a data dictionary is the data type of each field. This makes it easier to create the database because then only the correct data type can be input into the fields, for example, setting a name to text, else somebody could put numbers into it.
Bold=over lined
EMPLOYEE(EmployeeID, Surname, Forename, DateOfBirth, AddressLine1, AddressLine2, Town, Postcode, ContactNumber, DepartmentID, QualificationID, DateHired)
DEPARTMENT TABLE(DepartmentID, DepartmentDescription)
QUALIFICATIONS TABLE(QualificationID, QualificationDescription)
Field name Data type
Oder completed? Text
Total cost of order Currency (real number)
No comments:
Post a Comment