Example of weak entity, Database Management System

Consider the entity type dependent related to employee entity, which is used to keep track of the dependents of every employee. The attributes of dependents are: name, sex, birth date and relationship. Every employee entity is said to own the dependent entities that are related to it. Though, please note that the 'dependent' entity does not be of its own, it is dependent on the Employee entity. We can also say that in case an employee leaves the organisation all dependents related to him/her also leave along with. Therefore, the 'dependent' entity has no significance without the entity 'employee'. Therefore, it is a weak entity.

Posted Date: 3/6/2013 6:13:24 AM | Location : United States







Related Discussions:- Example of weak entity, Assignment Help, Ask Question on Example of weak entity, Get Answer, Expert's Help, Example of weak entity Discussions

Write discussion on Example of weak entity
Your posts are moderated
Related Questions
What is schema

Find the names of all Albums that have more than 30 tracks. Result: (name: varchar(255))

Consider the following database schema: STAFF(StaffNo, fName, lName, Position, sex, dob, branchNo) BRANCH(BranchNo, Street, City) Assume the following for the above database

Write short notes on Schema diagram. A database schema along with primary key and foreign key dependencies can be depicted pictorially by schema diagram. Every relation appears

what should be included in this???

Discuss the term- Design Optimization  We have seen various ways of representing the objects.The fundamental design model uses analysis model as the framework for implementati

what is attribute is attribute inheritance in dbms?

Use inheritance as an implementation technique when you are going to use inheritance as an implementation technique, you can achieve same goal in a safer way by making one cla

What is a candidate key? Minimal super keys are known as candidate keys.

Many-to-many : Entities in A and B are related with any number of entities from each other. Example: Taught_by Relationship among course and faculty. One faculty member ca