Purchase Solution

FDD Diagram

Not what you're looking for?

Ask Custom Question

Draw the FDD from the FD below

FD
1) Student must be signed up for at least one Course
i) Registration Code ->Course Name

2) Given student may have taken a given exam on a certain date, receiving a grade for it:
i) StudentRegistrationNumber + Course code + Date ->Mark

3) A Course will be taught be only one Lecturer
i) Course_code->employee number

4) A Course is presented in one or more classrooms, on prescribed days and times
Please help with the following problem.

i) Course + day + time -> classroom

5) Students are each assigned a lecturer as a Personal Tutor
i) Registration Code -> employee number

I derived these FD from the given attributes
The attributes are found in the attachment
Correct me if I am wrong
Please refer to this link on how to draw a FDD http://www.dsm.fordham.edu/~moniot/Classes/DatabaseSp04/FD-diagrams.html

Purchase this Solution

Solution Summary

This solution helps with a problem regarding FDD diagrams.

Solution Preview

FD
1) Student must be signed up for at least one Course
i) Registration_Code ->Course_code

2) Given student may have taken a given ...

Purchase this Solution


Free BrainMass Quizzes
Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.

Javscript Basics

Quiz on basics of javascript programming language.

Word 2010: Table of Contents

Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.