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
Explain different categories of failures that occur in Oracle database? Categories of Failures - In Oracle database subsequent types of failures can occurred: Statement Failu

List the table modification commands in SQL? A) Deletion B) Updates C) Insertion D) Update of a view

What is the difference between link and reference? The fundamental difference between links and references is that links are symmetrical on the other hand references refer only

i want notes on this topic

FitAll Ltd is a company that manufactures clothes. Its processes are manual and there are stand-alone Information Systems that aid to manage them. The Information Systems were purc

What is relationship instance ? Relationship Instance - A relationship is a relation between two or more entities. An instance of relationship set is a set of relationships.

What is nested relational model? The nested relational model is an extension of relational model in which domains might be either atomic or relation valued.

Project Description: I would like to get a database of a website which has clients email name and phone number. If you are able to get information from a website, by entering

Define deadlock prevention. Deadlock prevention is a set of methods for ensuring that at least one of the four essential conditions like mutual exclusion, hold and wait, no pre

Question: (a) What do you meant by content management and briefly describe four major components of a Content Management System? (b) Explain key benefits of a Content Manage