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 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: 7348

.

+ 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+ replied to 彡JK彡 ❤️'s discussion ............ A public service message...........
6 minutes ago
Ishaal Saifi posted a discussion
11 minutes ago
+ "αяsαℓ " Ќąƶµяɨ •" left a comment for asim ur rehman
21 minutes ago
+ "αяsαℓ " Ќąƶµяɨ •" left a comment for MALIK G
22 minutes ago
+ "αяsαℓ " Ќąƶµяɨ •" left a comment for IBS
23 minutes ago
+ Iuuoɔǝut+ posted discussions
47 minutes ago
+ Iuuoɔǝut+ replied to + Iuuoɔǝut+'s discussion How Can You Get Secured of Being Banned On Ning
47 minutes ago
Asmat replied to + M.Tariq Malik's discussion VU Students Reserves The Right to Delete Any Profile On the Site
52 minutes ago
+ Adeeena replied to + Adeeena's discussion Vitamins For Skin You Should Never Miss: p
59 minutes ago
+ Adeeena replied to + Adeeena's discussion Vitamins For Skin You Should Never Miss: p
1 hour ago
Whispering Soul liked Whispering Soul's discussion شاہی جوڑے کی رکشہ میں آمد
1 hour ago
Whispering Soul posted a discussion
1 hour ago
+ "αяsαℓ " Ќąƶµяɨ •" replied to 彡JK彡 ❤️'s discussion ............ A public service message...........
1 hour ago
+ "αяsαℓ " Ќąƶµяɨ •" liked 彡JK彡 ❤️'s discussion ............ A public service message...........
1 hour ago
+ "αяsαℓ " Ќąƶµяɨ •" left a comment for waseem khan
1 hour ago
+ "αяsαℓ " Ќąƶµяɨ •" left a comment for + ! Agha RoShaaan Khan
1 hour ago
+ "αяsαℓ " Ќąƶµяɨ •" left a comment for Ƨ.ℳƧℂƧ
1 hour ago
+ "αяsαℓ " Ќąƶµяɨ •" left a comment for stylo
1 hour ago
+ "αяsαℓ " Ќąƶµяɨ •" replied to + "αяsαℓ " Ќąƶµяɨ •"'s discussion 2019 Noble Prize Winners
1 hour ago
+ "αяsαℓ " Ќąƶµяɨ •" replied to + "αяsαℓ " Ќąƶµяɨ •"'s discussion Me, Mom and Bachy howey paisy
1 hour ago

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

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