Case Description

In Chapter $4,$ you created the relational schema for the FAME

system, and in Chapter $5$ you implemented that schema with

a relational database management system without giving full

consideration to the details of physical database design. In

Chapters $5$ and $6,$ you used this database for various forms of

manipulation of data. Your next step is to create an improved

detailed specification that will allow you to implement a carefully

designed version of the database. Specifically, you need to

identify and document choices regarding the properties of each

data element in the database, using information from the case

descriptions and the options available to you in the DBMS that

you have chosen for implementation $($or that has been selected

for you by your instructor$).$

Project Questions

$8-88.$ Do you see any justifiable opportunities to denormalize

the tables? If so$,$ provide appropriate justification

and create a new denormalized schema. Do you need

to update your EER diagram based on these decisions?

Why or why not?

$8-89.$ Create a data dictionary similar to the metadata table

shown in Table $1-1$ in Chapter $1$ to document your

choices. For each table in the relational schema you

developed earlier and using the solution you developed

in the context of Chapter $5,$ 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.

$8-90.$ Create a comprehensive physical data model for the

relational schema you developed in Chapter $4($and

potentially modified in $8-88$ above$),$ clearly indicating

data types, primary keys, and foreign keys.

$8-91.$ Create a strategy for reviewing your deliverables generated

so far with the appropriate stakeholders. Which

stakeholders should you meet with? What information

would you bring to this meeting? Would you conduct

the reviews separately or together? Who do you think

should sign off on your logical and physical schemas

before you move to the next phase of the project?