fame data dictionary

Using tables from the FAME data dictionary created and added, develop the following:

• Entity relationship diagram. Use Visio (or another data modeling tool).
• Enhanced Entity Relationship Model. Use Visio (or another data modeling tool).
• Logical Database Design. Use Visio (or another data modeling tool).
• Create a FAME Data Dictionary and provide the following information for each field/data element:
  • field name,definition/description, data type, format, allowable values, whether the field is required or optional, whether the field is indexed and the type of index, whether the field is a primary key, whether the field is a foreign key and the table that is referenced by the foreign key field.
• Physical Database Design, use MS Access and establish relationships between tables.