MCA World :: Computer Application ::
Questions :  Answers : Solutions of TMA & Project Assignment  of  MCA courses of IGNOU, NIT & Other Universities.

::: Entity Types & Relationship



Home • Introduction to Software • Data Structures • System Engineering • Database Management System • Discrete Mathematics • Numerical & Statistical Computing • Software Engineering • Operation Research • Accounting & Finance • Computer Architecture • Operating Systems • Intelligent Systems • Relational Database • Obejct Oiented Systems

Entity Types & Relationship

Up • RDBMS VS OODBMS • Data Independence in DBMS • Data Redundancy • Functional Dependency • Entity Types & Relationship

Main Chapters

Home
Introduction to Software
Data Structures
System Engineering
Database Management System
Discrete Mathematics
Numerical & Statistical Computing
Software Engineering
Operation Research
Accounting & Finance
Computer Architecture
Operating Systems
Intelligent Systems
Relational Database
Obejct Oiented Systems

Entity Types & Relationship

 Problems Discussed in this chapter

 Question 5:  Describe the rules for deriving relations that represent strong entity types, weak entity types, one-to-one binary relationship types, one-to-many relationship types, multi-valued attributes, and super class / subclass relationships.?

  Answer 5:    Strong Entity: objects  are represented by their attributes and, as objects are  inter distinguishable, a subset of these attributes forms a primary key for uniquely identified an instance of an entity. Entity types that have primary keys are called strong entities.

Weak Entity: instance of weak entity sets associated with the same instance of the strong entity must be distinguishable from each other by a subset of  the attributes of the weak entity. This subset of the attributes is called discriminator.

One- to – one binary relationship: the one to one relationships between entity sets indicates that for each entity in either set there is at most one entity in the second set that is associated with it.

One- to – many binary relationship: one to many relationship between entity sets indicates that for an occurrence of the entity, there could be zero, one or more entities from the other entity set.

Up ]

 

 

 
 


Home • Introduction to Software • Data Structures • System Engineering • Database Management System • Discrete Mathematics • Numerical & Statistical Computing • Software Engineering • Operation Research • Accounting & Finance • Computer Architecture • Operating Systems • Intelligent Systems • Relational Database • Obejct Oiented Systems



This is complete MCA study materials containing question, solutions, answers, programming, scripts, TMA, Project assignment solutions for aspiring MCA or BCA student. This website may be useful for all in general and IGNOU student in particulars. Disclaimer : Execution and correctness of programs/answers may be established by the users himself and the mcaworld.net shall not held responsible for any damage/loss caused due to the use of code over this site.



Dear Visitor, If you are not able to find what you have been looking for on this site, please do try your search once again with different combination of words in the following Google Tool Bar, Specially designed to provide enhanced search option. Thank you.
Google

Webmaster Bipin Bihari Pandey, An IT Expert of DotNet Technology, MCA from IGNOU
bipin9830@rediffmail.com or bipin9830@yahoo.com