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
Hot Backup: Some sites cannot terminate the database while creating a backup copy of the files. The cold backup is not a reliable option. So different kinds of backing up database

What are the three data anomalies that are similarly to take place as a result of data redundancy?  Can data redundancy be completely eliminated in database approach?  Why or why n

design a generalization specialization hierarchy for a motor vehicle sales company. the company sells motorcycles, passenger cars, vens and buses.

Using Literal Character String Example: To print IS A as one string with column name employee SELECT ENAME || ' IS A ' || JOB AS "EMPLOYEE" FROM EMP;


can you create a database for me in oracle/sql

Define Sequence A sequence is a set of integers 1, 2, 3 that are generated in order on demand. Sequences are regularly used in databases because lots of applications require ev

Vertical Fragmentation- Vertical fragmentation groups together only those attributes in a relation that are used jointly by various important transactions. A vertical fragment is d

What are the advantages of using a DBMS? The benefits of using a DBMS are a) Controlling redundancy b) Restricting unauthorized access c) Giving multiple user interfac

Explain hash file organization? Hash functions a) The distribution is uniform Hash functions assign each bucket the similar number of search -key values from the set of a