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
Describe the difference between a one-to-many and a many-to-many relationship. Which logical data structures comprise one-to-many and which comprise many-to-many relationship?

Explain I command in QBE ? I : It is the command in QBE that is used to insert tuple (s) into the database

Oracle Fusion Middleware: Key Skills: Consulting,Architect, Oracle Fusion Middleware,ECM, UCM, Stellent,Identity Management, SOA Suites, BPEL, ESB,OAM,OIM,J2ee, Java, Livelink

What are the DBMS languages? Briefly explain? Data Definition language (DDL):A database schema is specified through a set of definitions expressed through a special language

In this practical assignment, we will run through a complete database application development cycle, starting with the schema design, from an initial data import to database applic

Having clause This clause is used for producing conditions on grouped information. Example: Find maximum salary and department number of those departments where maxim

1) Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pict

Explain natural join? Natural Join - Similar as equi-join except in which the join attributes (having similar names) are not involved in the resulting relation. Only one sets

4. Describe three ways to handle missing field values

A database for the Service and Maintenance (SM) section of a Computer sales and service Company has to be developed. SM gives after sales service to customers. SM branch has a numb