We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>

Looking For Something at vustudents.ning.com? Click Here to Search

www.bit.ly/vucodes

+ Link For Assignments, GDBs & Online Quizzes Solution

www.bit.ly/papersvu

+ Link For Past Papers, Solved MCQs, Short Notes & More


Dear Students! Share your Assignments / GDBs / Quizzes files as you receive in your LMS, So it can be discussed/solved timely. Add Discussion

How to Add New Discussion in Study Group ? Step By Step Guide Click Here.

Graded Discussion Board (GDB) of CS403 - Database Management Systems will be launched on 19th of February 2014 (19-Feb-2014) and will last for 48 hours only till (20-Feb-2014) 11:59 PM

GDB_FALL 2013 Dated: Feb 14, 14

Dear Students!

Please Note that GDB of CS403 will be launched on 19th of February 2014 (19-Feb-2014) and will last for 48 hours only.

The topic will be as follows:

Suppose there are two entities "building" and "apartment". The entity "apartment" is dependent entity and cannot exist independently and “building” is an independent entity. The "apartment" entity contains the primary key (building_name) of building entity to identify the apartment of that specific building. The "apartment" entity also has its own identifier, i.e. apartment_no but that identifier is not sufficient to identify the particular apartment, so in this case we used both keys building_name and apartment_no to identify the particular apartment.

 

You have studied different dependencies in the course. You are required to choose the appropriate dependency applicable in  the above scenario. Justify your answer with reasons.

Try to provide precise, to the point answer and avoid irrelevant details.

 

For any query: CS403@vu.edu.pk

--

Instructor CS403

+ How to Follow the New Added Discussions at Your Mail Address?

+ How to Join Subject Study Groups & Get Helping Material?

+ How to become Top Reputation, Angels, Intellectual, Featured Members & Moderators?

+ VU Students Reserves The Right to Delete Your Profile, If?


See Your Saved Posts Timeline

Views: 7359

.

+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)

+ Click Here to Search (Looking For something at vustudents.ning.com?)

+ Click Here To Join (Our facebook study Group)

Replies to This Discussion

Types of dependencies: So we could get idea about their functionalities

Trivial Functional Dependencies

trivial functional dependency occurs when you describe a functional dependency of an attribute on a collection of attributes that includes the original attribute. For example, “{A, B} -> B” is a trivial functional dependency, as is “{name, SSN} -> SSN”. This type of functional dependency is called trivial because it can be derived from common sense. It is obvious that if you already know the value of B, then the value of B can be uniquely determined by that knowledge.

Full Functional Dependencies

full functional dependency occurs when you already meet the requirements for a functional dependency and the set of attributes on the left side of the functional dependency statement cannot be reduced any farther. For example, “{SSN, age} -> name” is a functional dependency, but it is not a full functional dependency because you can remove age from the left side of the statement without impacting the dependency relationship.

Transitive Dependencies

Transitive dependencies occur when there is an indirect relationship that causes a functional dependency. For example, ”A -> C” is a transitive dependency when it is true only because both “A -> B” and “B -> C” are true.

Multivalued Dependencies

Multivalued dependencies occur when the presence of one or more rows in a table implies the presence of one or more other rows in that same table. For example, imagine a car company that manufactures many models of car, but always makes both red and blue colors of each model. If you have a table that contains the model name, color and year of each car the company manufactures, there is a multivalued dependency in that table. If there is a row for a certain model name and year in blue, there must also be a similar row corresponding to the red version of that same car.

Importance of Dependencies

Database dependencies are important to understand because they provide the basic building blocks used in database normalization. For example:

 

  • For a table to be in second normal form (2NF), there must be no case of a non-prime attribute in the table that is functionally dependent upon a subset of a candidate key.
  • For a table to be in third normal form (3NF), every non-prime attribute must have a non-transitive functional dependency on every candidate key.
  • For a table to be in Boyce-Codd Normal Form (BCNF), every functional dependency (other than trivial dependencies) must be on a super key.
  • For a table to be in fourth normal form (4NF), it must have no multivalued dependencies.

 

Type of Functional Dependence (FD)

A functional dependency is an association between two attributes of the same relational database table. One of the attributes is called the determinant and the other attribute is called the determined. For each value of the determinant there is associated one and only one value of the determined.


If A is the determinant and B is the determined then we say that A functionally determines B and graphically represent this as A -> B. The symbols A à B· can also be expressed as B is functionally determined by A.

A partial functional dependency is a functional dependency where the determinant consists of key attributes, but not the entire primary key, and the determined consist~ of non-key attributes.

A transitive functional dependency is a functional dependency where the determinant consists of non-key attributes and the determined also consists of non-key attributes.

A Boyce-Codd functional dependency is a functional dependency where the determinant consists of non-key attributes and the determined consists of key attributes.

Trivial functional dependency: A trivial functional dependency is a functional dependency of an attribute on a superset of itself.

For example: {Employee ID, Employee Address} à {Employee Address} is trivial, here {Employee Address} is a subset of {Employee ID, Employee Address}.

Transitive dependency
 
 

In Database Management System, a transitive dependency is a functional dependency which holds by virtue of transitivity. A transitive dependency can occur only in a relation that has three or more attributes. Let A, B, and C designate three distinct attributes (or distinct collections of attributes) in the relation. Suppose all three of the following conditions hold:
A → B
It is not the case that B → A
B → C

Then the functional dependency A → C (which follows from 1 and 3 by the axiom of transitivity) is a transitive dependency.


In database terminology, a partial functional dependency occurs when the value in a non-key attribute of a table is dependent on the value of some part of the table's primary key (but not all of it).

X depends on Y??

Sorry I couldn't understand.

yeah.. I confused.. Now right..

can anyone please tell me in short that which one is suitable...!!

Dear Students Don’t wait for solution post your problems here and discuss ... after discussion a perfect solution will come in a result. So, Start it now, replies here give your comments according to your knowledge and understandings....

RSS

Latest Activity

+ M.Tariq Malik replied to + M.Tariq Malik's discussion SOC101 Assignment No 01 Fall 2019 Solution & Discussion Due Date: 21-11-2019 in the group SOC101 Introduction to Sociology
1 minute ago
Profile IconRida Jaffery, Waqar Aslam, mubashar hussain and 15 more joined Virtual University of Pakistan
1 minute ago
+ M.Tariq Malik replied to MIT's discussion cs604 Quize#1 fall semester 2019 in the group CS604 Operating Systems
2 minutes ago
+ M.Tariq Malik replied to MIT's discussion cs604 Quize#1 fall semester 2019 in the group CS604 Operating Systems
2 minutes ago
+ M.Tariq Malik replied to MIT's discussion cs604 Quize#1 fall semester 2019 in the group CS604 Operating Systems
2 minutes ago
+ M.Tariq Malik liked MIT's discussion cs604 Quize#1 fall semester 2019
3 minutes ago
+ M.Tariq Malik replied to مخلص's discussion Samsung Galaxy S11 Leaked Camera Features
4 minutes ago
+ M.Tariq Malik liked مخلص's discussion Samsung Galaxy S11 Leaked Camera Features
4 minutes ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion ECO401 Economics GDB Fall 2019 Solution & Discussion in the group ECO401 Economics
4 minutes ago
+ M.Tariq Malik replied to +¢αяєℓєѕѕ gιяℓ's discussion MCM301 - Communication skills Assignment No.1 Due Date Nov 27, 2019 in the group MCM301 Communication skills
6 minutes ago
+ M.Tariq Malik liked +¢αяєℓєѕѕ gιяℓ's discussion MCM301 - Communication skills Assignment No.1 Due Date Nov 27, 2019
8 minutes ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion MGT603 Strategic Management Assignment No 01 Fall 2019 Solution & Discussion in the group MGT603 Strategic Management
9 minutes ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion MGT603 Strategic Management Assignment No 01 Fall 2019 Solution & Discussion in the group MGT603 Strategic Management
9 minutes ago
+ M.Tariq Malik liked UMER UMER's discussion What is Love?
11 minutes ago
+ M.Tariq Malik liked Abdul Majid Jamil's discussion for assignment of zoogy on topic wildlife counting
11 minutes ago
Abdul Majid Jamil posted a discussion
12 minutes ago
+ ! ! ! ! ! ! BaDd TamEeZ updated their profile
13 minutes ago
+ NurAl Ain + updated their profile
13 minutes ago
Abdul Majid Jamil posted a status
"i am the student of m.phill zoology ...m happy to fined that place ...i need some help"
13 minutes ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion ENG201 Business and Technical English Writing Assignment No 01 Fall 2019 Solution & Discussion in the group ENG201 Business and Technical English Writing
14 minutes ago

© 2019   Created by + M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service