Would anyone know how to do this -
07-17-2003
, 03:03 PM
Given the business requirements bellow for the current-term enrollment
at a large university:
· An instructor may teach none, one, or more courses in a given
term
· An instructor must direct the research of a least one student
· A course may have none, one, or two prerequisites
· A course may exist even if no students are currently enrolled
· All courses are taught by only one instructor
· The average enrollment in a course is 15 students
· A student must select at least one course per term
List the obvious FDs from the given requirements
At what level of normalization is the database implemented as a single
table with no repeating columns? Justify your answers
Given an example of this database in 3NF |