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

.

+ 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

Referential Dependency:

This is the situation when the dependent entity has it own key for unique identification but the key used to show the reference with the parent entity is shown with the help of an attribute of the parent entity. Means to show the link of the parent entity with this entity there will be an attribute and a record in this entity will not exist without having a record in the parent entity

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.

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.


Full Functional Dependencies

A 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.

Transitive Dependency
Transitive dependency is one that carries over another attribute. Transitive dependency occurs when one non-key attribute determines another non-key attribute. For third normal form we concentrate on relations with one candidate key, and we eliminate transitive dependencies. Transitive dependencies cause insertion, deletion, and update anomalies.

Definition of Functional Dependency
If A and B are attributes or sets of attributes of relation R, we say that B is functionally dependent on A if each value of A in R has associated with it exactly one value of B in R. We write this as A B, read as “A functionally determines B” or “ A determines B”.

The Existence dependency:
This is the type of dependency which exists when one entity instance needs instance of another entity for its existence. As we have seen in case of employee of and organization and the projects associated with the employees there we see that employees are dependent on projects, it means that if no project is assigned to an employee it can not exist. In other words we can say that at a certain time an employee must be working on at least one project

Identifier Dependency: It means that the dependent entity incase of existence dependency does not have its own identifier and any external identifier is used to pick data for that entity. And to define a key in this entity the key of the parent entity is to be used in the key for this entity may be used as composite keys.

Yaar clear answer batao, which dependency and why.

plz tell me which dependency is best and why??

I think functional dependency is appropriate dependency  for the given scenario.

brillo is right its refereshional as well plus existence. read this carefully 

RSS

Latest Activity

zohaib joined + M.Tariq Malik's group
19 minutes ago
+Umar Amin+ liked +Umar Amin+'s discussion Happy Birthday to my sweet and lovely friend mmm
1 hour ago
+Umar Amin+ liked +Umar Amin+'s discussion Happy Birthday to my sweet and lovely friend mmm
1 hour ago
Mahi Malik is now friends with M Aqib, Makhdoom Shahrukh Jamil and IBS
2 hours ago
IBS replied to MIT's discussion Visual Programing (CS411) Assignment#01 Deadline Date = 18-11-2019 in the group CS411 Visual Programming
3 hours ago
Ammara replied to + M.Tariq Malik's discussion MTH501 Assignment No 01 Fall 2019 Solution & Discussion Due Date: 19-11-2019 in the group MTH501 Linear Algebra
3 hours ago
kiran ashraf replied to + M.Tariq Malik's discussion MGT611 Assignment No 01 Fall 2019 Solution & Discussion Due Date: 14-11-2019 in the group MGT611 Business & Labor Law
3 hours ago
kiran ashraf joined + M.Tariq Malik's group
3 hours ago
M IDREES replied to + M.Tariq Malik's discussion CS502 Fundamentals of Algorithms Assignment No 01 Fall 2019 Solution & Discussion in the group CS502 Fundamentals of Algorithms
3 hours ago
°`·("آفروز") aFFrOzE·´° replied to + M.Tariq Malik's discussion CS401 Assignment No 01 Fall 2019 Solution & Discussion in the group CS401 Computer Architecture and Assembly Language Programming
3 hours ago
Profile Icon°`·("آفروز") aFFrOzE·´°, Aamir Abbas and Rizwan Ali joined + M.Tariq Malik's group
3 hours ago
M IDREES replied to + M.Tariq Malik's discussion CS502 Fundamentals of Algorithms Assignment No 01 Fall 2019 Solution & Discussion in the group CS502 Fundamentals of Algorithms
3 hours ago
M IDREES replied to + M.Tariq Malik's discussion CS502 Fundamentals of Algorithms Assignment No 01 Fall 2019 Solution & Discussion in the group CS502 Fundamentals of Algorithms
3 hours ago
Ammara commented on + M.Tariq Malik's group MTH501 Linear Algebra
3 hours ago
Ammara joined + M.Tariq Malik's group
3 hours ago
+ Haxan updated their profile
4 hours ago
+ "αяsαℓ " Ќąƶµяɨ •" posted a discussion
4 hours ago
Fojjiii updated their profile
4 hours ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion ENG101 English Comprehension Online Quiz No 01 Fall 2019 Solution Discussion Last Date: 14-11-2019 in the group ENG101 English Comprehension
4 hours ago
Aamir Abbas replied to + M.Tariq Malik's discussion CS401 Assignment No 01 Fall 2019 Solution & Discussion in the group CS401 Computer Architecture and Assembly Language Programming
4 hours ago

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

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