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
CREATE TABLE prodtrans ( pno number (4) ptype char (1) CHECK (ptype in ('I','R','S')), qty number (5) FOREIGN KEY pno REFERENCES product (pno) ON DELETE CASCADE);

Report writing help on database mgmt Project Description: Use of Harvard referencing, critical analysis is required. Skills required: Academic Writing, Technical Writin

ALTER TABLE Command : This command is used for variation of existing structure of the table in the given situation: When a new column is to be added to the table structure.

What is relationship instance ? Relationship Instance - A relationship is a relation between two or more entities. An instance of relationship set is a set of relationships.

What are the disadvantages of file processing system? The drawbacks of file processing systems are a) Data redundancy and inconsistency b) Complexity in accessing data

What is Candidate Key Super Key or Candidate Key: It is such an attribute of a table that can uniquely recognize a row in a table. Generally they have unique values and can n

Define value set? Value set: It is a set of values. You do not always need a user to enter junk free text within all the fields. Therefore, Oracle Apps uses value set to valida

compare the features of oracle RDBMS with MySQL and Microsoft SQL server

Define the term Domain. For each n every attribute there is a set of permitted values known as the domain of that attribute.

Define Timestamp ordering Ans In timestamp-based method, a serial order is made among the concurrent transaction by assigning to every transaction a unique nondecreasing number