Questions related to case study – FAME

Question 1 – Create a data dictionary, For each table in the relational schema developed earlier, 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.

Question 2 – Create the physical data model for the relational schema developed earlier, clearly indicating data types, primary keys, and foreign keys.

You can use the below document, to complete these two questions.