Determine the strong and weak entity, Database Management System

Determine the Strong and Weak Entity

Based on the method of foreign key, there might be arise a situation when we have to relate an entity having a primary key of its own and an entity not having a primary key of its own. In such a case, the entity having its own primary key is known as a strong entity and the entity not having its own primary key is known as a weak entity. Whenever we need to relate a strong and a weak entity together, the ERD would alter just a little.

Say, for instance, we have a statement "A Student lives in a Home." STUDENT is obviously a strong entity having a primary key Roll. But HOME might not have a unique primary key, as its only attribute Address may be shared by a lot of homes (what if it is a housing estate?). HOME is a weak entity in this case.

 

Posted Date: 7/26/2013 6:21:52 AM | Location : United States







Related Discussions:- Determine the strong and weak entity, Assignment Help, Ask Question on Determine the strong and weak entity, Get Answer, Expert's Help, Determine the strong and weak entity Discussions

Write discussion on Determine the strong and weak entity
Your posts are moderated
Related Questions
Consider a typical sales invoice that would include the following information. Design a single table to hold all of the information required to store an invoice including this info

Representing complex relationship among data A database may contain varieties of data interrelated to each other in numerous ways. A DBMS must have the capability to represent

what is attribute is attribute inheritance in dbms?

What does data dictionary is a special file contains ? The data dictionary is a special file contain The name of all fields in all files.The width of all fields in all files an

Create student database and retrieve course name taught by king? STUDENT (name, student#, class, major) COURSE (course name, course#, credit hours, department) SECTION (secti

explain exhausitively the problems associated with er diagrams with ellustrations

A video rental company has several branches. The data held on each branch is the branch address made up of street, city, state, and zip code, and the telephone number. Ea

What is storage manager? A storage manager is a program module that gives the interface among the low level data keeps in a database and the application programs and queries su

PHYSICAL DBMS ARCHITECTURE  The physical architecture defines the software components used to process and enter data, and how these software components are related and interc

Use a Set operator to create a list of academics who have written or co-written less than 5 papers and also have greater than 3 interests. List their academic number in the output.