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
A database for the Service and Maintenance (SM) section of a Computer sales and service Company has to be developed. SM gives after sales service to customers. SM branch has a numb

what is Mapping Constraints? with examples

Discuss the term- Design Optimization  We have seen various ways of representing the objects.The fundamental design model uses analysis model as the framework for implementati

What is DML compiler? DML Compiler: Translates DML statements in a query language within low level instructions understandable through the query evaluation engine. Attempts to

The traffic data mgmt. systems infrastructure plan describes the software, hardware, data network, and other elements that will support the TDMS. The infrastructure plan is based o

Task Partitioning, Sequencing and Project Planning The tasks required for the service might be broadly partitioned into: 0.      Set up database tables and account file

Explain the term- Data Flows Data Flows: A data flow connects output of an object or process to input of another process or object. It represents an in-between data value wit

Create centralized relational database using bottom up method.   (a) Recognize a single un-normalized relation for the above scenario.          (b) Recognize the primary key for

Define the Two Phase Locking Protocol This is a protocol that is used to make sure serializability of transactions. This protocol needs that every transaction issue lock and u

Can your organization scan large format documents? Yes, large format scanning used for such entities as city plans and blueprints is available. We selected scanners with the ab