CSC 390 - Special Topics: Web Programming

Dr. R. M. Siegfried

Assignment #15 - Normalizing a Small Database

Due Friday, May 15, 2015

Create a small database for student transcript that starts out with a table with the following fields:

• Student ID
• Student First Name
• Student Last Name
• Student's Local Phone Number
• For each course:
  • Department Code
  • Course Number
  • Section Number
  • Credits
  • Grade

The table (with first row) might look like this:

Stud id	First	Last	Local Phone	Dept Code	Course No	Section No	Credits	Grade
1234567	Robert	Siegfried	x4482	0144 0145	141 171	1 2	4 4	A- A

Populate the table (add fictional data of your own) and then get it into first normal form, second normal form and finally third normal form.

If a majority of the class has completed it before Monday's class, we will go over this in class; otherwise you will hnd it in on paper on Wednesday.

[Back to the Assignments.html]