dbTalk Databases Forums  

Would anyone know how to do this

comp.database.ms-access comp.database.ms-access


Discuss Would anyone know how to do this in the comp.database.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
tlwillia
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.