Threesuns

Email the Instructor

Contact

All Semesters

Semesters

All Courses

Courses

2010Spring

01.11.10 - 05.09.10

Database Design (Online)

CSYS2643

Online
12:00 AM - 12:00 AM

Preliminary Table List

Lab03

Objective: To create a preliminary table list for a database

pastdue

Submit Your Solution

Lab03

Requirements

All tables are identified20 pts
Each table is given an accurate description20 pts
All fields are ideal fields20 pts
Tables are ideal tables20 pts
Fields are assigned to tables correctly20 pts
Total100 pts

Instructions

Review your preliminary field list and from it see what subjects you can infer from it. Compare this list with the previous list of subjects you created in lab01 and resolve items that appear on both lists, items that represent the same subject but have different names, and then combine the remaining items together into a single list.

Once your preliminary table list is to this stage improve it by refining your table names, compose a description for each table, assign the appropriate fields to each table, and indicate the table's type.

Next improve your field list for each of your tables. Make sure each field has a good name and determine whether the field complies with the Elements of the Ideal Field.

Finally, resolve any duplicate field names, determine whether each table complies with the Elements of the Ideal Table, and establish subset tables as needed.

For this lab submit a document containing your table list with assigned fields, descriptions, and table types.