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

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

+ Iuuoɔǝut + posted discussions
11 minutes ago
+ Iuuoɔǝut + replied to ٹمبکٹو's discussion محبّت اور دل - عشق مجازی
14 minutes ago
+ Iuuoɔǝut + replied to + "J ɨ y ą ⋆'s discussion Mohabat
18 minutes ago
+ Iuuoɔǝut + replied to + "J ɨ y ą ⋆'s discussion Hona chahy tha.......
20 minutes ago
+ ! ! ! ! ! MySterIouS replied to ٹمبکٹو's discussion محبّت اور دل - عشق مجازی
45 minutes ago
+ "J ɨ y ą ⋆ replied to + M.Tariq Malik's discussion CS402 Assignment No 01 Fall 2019 Solution & Discussion Due Date: 15-11-2019 in the group CS402 Theory of Automata
1 hour ago
+ "J ɨ y ą ⋆ joined + M.Tariq Malik's group
1 hour ago
+ "J ɨ y ą ⋆ posted discussions
1 hour ago
+ "J ɨ y ą ⋆ liked + ! ! ! ! ! ! BLaiRe ! !+'s blog post ***NooR E KeyAnAT******HaPpy BiRtH DaY
1 hour ago
+ "J ɨ y ą ⋆ liked +¢αяєℓєѕѕ gιяℓ's blog post Now No One Can Break me.........!
1 hour ago
+ "J ɨ y ą ⋆ liked + ! ! ! ! ! ! maho+++'s blog post muhabat k nam pegham
1 hour ago
+ "J ɨ y ą ⋆ liked + ! ! ! ! ! ! ! Ayesha +++'s blog post some suggestions of Hazrat Muhammad (PBUH)
1 hour ago
+ "J ɨ y ą ⋆ liked + ! ! ! ! ! ! maho+++'s blog post Muhammad Mustafa Aye Bahar Andar Bahar Aaye
1 hour ago
+ "J ɨ y ą ⋆ liked + ! ! ! ! ! MySterIouS's blog post + Beginning +
1 hour ago
+ "J ɨ y ą ⋆ liked + ! ! ! ! ! MySterIouS's blog post + Attitude +
1 hour ago
+ "J ɨ y ą ⋆ liked Annu's discussion Please share solution for assig # 01 of wdu 602 fall 2019
1 hour ago
+ "J ɨ y ą ⋆ replied to +¢αяєℓєѕѕ gιяℓ's discussion Mera tu Mohabbat se aitbar.............:-P
1 hour ago
+ "J ɨ y ą ⋆ replied to ٹمبکٹو's discussion محبّت اور دل - عشق مجازی
1 hour ago
+ "J ɨ y ą ⋆ liked +¢αяєℓєѕѕ gιяℓ's discussion Mera tu Mohabbat se aitbar.............:-P
1 hour ago
+ "J ɨ y ą ⋆ liked + M.Tariq Malik's discussion Everyone Freelancer Must Watch it - Most important video for Every fiver user
1 hour ago

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

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