Project Assignment for Tuesday, April 4^th

MUST be printed to be accepted for grading

MUST be attached to a project cover sheet to be accepted for grading

The logical model of the database is concerned with the metadata of the database. For each entity class in your preliminary design (the list of entities or objects you developed previously) you will have a record type. Each of your record types will have several data item types that represent the attributes of your entity. Some of these data item types may be data aggregates or group attributes. Therefore, a record is a named collection of related data items and/or data aggregates. This information is stored in a data dictionary. There will be an entry for each data item and each data aggregate. Each entry will consist of the name of the data item or aggregate as well as a detailed description of the item or aggregate. The description of the aggregate would include its components. The descriptions includes its data type and any synonyms that it may be known by.

Your assignment is to create the data dictionary for your project. It might be helpful to store the data dictionary in an excel spreadsheet with one column for the name and one for the description. The advantage of this would be that it could be alphabetized for easy reference later and for later additions. (Using a spreadsheet is a suggestion, not a requirement).

Note that in creating this dictionary you should refer to

• the original project description
• your input and output report designs
• your list of entities
• your E/R diagram or Semantic Object Model

If you notice omissions or errors, this would be a good time to modify your design.