Top Posters
Since Sunday
5
a
5
k
5
c
5
B
5
l
5
C
4
s
4
a
4
t
4
i
4
r
4
Home Q & A Board Science-Related Homework Help Computer Studies
New Topic  
青山 素子 青山 素子
wrote...
Go to Answer
Posts: 1332
Rep: 4 0
7 years ago
Consider the following relation, called StudentData. Assume that the data shown is a reliable basis for identifying the functional dependencies. Use the notation from the textbook to define this relation. Then identify all functional dependencies, again using the proper notation. Indicate the normal form of this relation and explain why it is in the normal form indicated. If it is not already in 3NF, perform any necessary normalization to put the relation into third normal form.

StudentID   Name   PhoneNbr   Major   Advisor
1001   Alice Long   555-1212   CIS   Smith
1002   Mark Williams   555-2948   Accounting   Jones
1003   Sam Miller   555-2999   Marketing   Baker
1004   Julia Davis   555-4309   CIS   Smith
1005   Latisha Markus   555-1212   CIS   Smith
1006   Forrest Gump   555-9595   Marketing   Baker
Textbook 
Object-Oriented System Analysis and Design

Object-Oriented System Analysis and Design


Edition: 1st
Authors:
Read 122 times
3 Replies
Replies
Answer verified by a subject expert
fierofiero
wrote...
#1
Top Poster
Posts: 1332
Rep: 8 0
7 years ago
Sign in or Sign up in seconds to unlock everything for free
More solutions for this book are available here
1
Computer nerd Nerd Face

Related Topics

青山 . Author
wrote...
#2
7 years ago
Loving it!
wrote...
#3
7 years ago
Don't forget to mark the topic solved Monkey
Computer nerd Nerd Face
New Topic      
Quick Reply
Explore
Post your homework questions and get free online help from our incredible volunteers
  1274 People Browsing
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Related Images
  
 2884
  
 827
  
 1076
Your Opinion
What's your favorite math subject?
Votes: 293
Previous poll results: Which 'study break' activity do you find most distracting?