Fds in relationships and teaches relationship, Database Management System

FDs in Relationships:

 Enrols Relationship: None as it is many to many

Teaches Relationship: Course code → Instructor

Instructor → Course code

The next question is:  How do we recognize the functional dependence in a database model?

Functional dependencies occur from the nature of the actual world that the database models. Often A and B are facts about an entity where A may be some identifier for the entity and B some characteristic. Functional dependencies cannot be automatically determined by studying one or more cases of a database. They can be determined only by a careful study of the actual world and a clear understanding of what every attribute means.

 There are no thumb rules for determining FDs.

Functional dependence is an vital concept and a large body of formal theory has been developed about it.

 

Posted Date: 3/7/2013 1:54:10 AM | Location : United States







Related Discussions:- Fds in relationships and teaches relationship, Assignment Help, Ask Question on Fds in relationships and teaches relationship, Get Answer, Expert's Help, Fds in relationships and teaches relationship Discussions

Write discussion on Fds in relationships and teaches relationship
Your posts are moderated
Related Questions
Operator Precedence The basic operators used in SQL are * /   - + Operators of the similar priority are evaluated From Left to right Parentheses are used to force priorit

Which data manipulation command combines the records from one or more tables ? JOIN data manipulation command combines the records from one or more tables.

Explain mechanism of nested queries? SQL gives a mechanism for nesting subqueries. A subquery is a select from where expression that is nested within one more query. A common u

The result of the UNION operation between R1 and R2 is a relation that includes? The result of the operation between R1 and R2 includes all the tuples of R1 and R2 which have c

What is the purpose of tables, private synonyms and public synonyms? If there are multiple objects of similar name on an Oracle database, that order are they accessed in? The r

What is known as heap file organization? In the heap file organization, any record can be placed anywhere in the file where there is space for the record. There is no ordering

Now that she understands more about the benefits of databases, the play-scheme manager would like to extend the play-scheme database to include data for schools and instructors as

Normal 0 false false false EN-IN X-NONE X-NONE

Question 1 Discuss on transmission impairments Question 2 What is framing? Question 3 Write a note on 10Base2 10Base- T Question 4 Explain the rev

Explain briefly concurrent task by taking an example. Concurrent Task- The concurrent occurrence of more than one event is called concurrent task. Operating systems can handl