ISQS 4349

File and Database Design Report See below for refresher on field sizes

The following is an outline of the report you should provide:

Cover Page

Table of Contents

Logical DB Design which includes an E-R diagram, Contents of each table, primary keys and secondary or foreign keys. The tables should be listed as relations (filename(fld1,fld2,.fldn). Relations should be in 3NF and list all of the attributes.

Physical File and Database Design which includes database organization, list of fields and their attributes. It also includes an estimation of the storage requirements and why specific storage media were chosen. A discussion on archiving and backup/recovery is also appropriate.

Summary

You may use the form for specifications as shown in the text book for all of the files, including access methods, organization, suggested storage media, etc.

Remember your programming classes when determining your record length.

The field sizes are as follows:

integer………2 bytes of storage

long integer….4 bytes of storage

float…………use 8 bytes of storage

double float…use 8 bytes of storage

character…….use 1 byte per character.