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.