Draw the dependency diagram for the relation, Database Management System

Assignment Help:

Consider the subsequent relation

Professor (Pfcode, dept, head, time)

It is assumed that

(i) A professor can work in much more than one dept.

(ii) The time he spends in every dept is given.

(iii) Every dept has only one head

Draw the dependency diagram for the above relation by recognizing the dependencies.

Ans:

Dependency Diagram

Related Discussions:- Draw the dependency diagram for the relation

Explain the concept of modeling with objects, Explain the concept of Modeli...

Explain the concept of Modeling With Objects A model is a conceptual representation of a specification, design or system from a particular point of view. A modelling language

I want a professional with strong it background, I want a professional with...

I want a professional with strong IT background who provide me timely assignments Project Description: I want a professional who can do my assignments for my major i.e. Infor

What are the components of storage manager, What are the components of stor...

What are the components of storage manager? The storage manager components include a) Authorization and integrity manager b) Transaction manager c) Buffer manager d

Distributed database, distributed quey processing

distributed quey processing

A step-wise distributed database design methodology, A step-wise distribute...

A step-wise distributed database design methodology Following is a step-wise methodology for distributed database design. (1) Examine the nature of distribution. Find out wh

Heuristics, Benefits of using heuristics

Benefits of using heuristics

Define an abstraction, Define an abstraction by which relationships are tre...

Define an abstraction by which relationships are treated as higher level entities Ans: Aggregation. It is an abstraction by which relationships are treated as higher level

Explain the use of constraints in functional model, Explain the use of cons...

Explain the use of constraints in functional model with suitable example. A constraint shows relationship between two objects at same time, or among various values of the sam

Differentiate between natural join and outer join, Differentiate between na...

Differentiate between natural join and outer join? Natural join is a binary operator which is written as (R * S) where as R and S are relations. The output of the natural join

What is the concurrency identification, Concurrency Identification Whi...

Concurrency Identification While designing analysis, model we map real world model into our analytical model. Real life objects are simultaneous in nature, but all the design

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages