Illustrate the cardinality of relationship, Database Management System

Cardinality of Relationship

One-to-One

Only one entity of the first set is linked to only one entity of the second set. E.g. A teacher teaches a student. Only one teacher is teaching only one learner.

One-to-Many

Only one entity of the first set is related to many entities of the second set. E.g. A teacher teaches learners.

Many-to-One

Multiple entities of the first set are related to many entities of the second set. E.g. Teachers teach a learner.

Many-to-Many

Multiple entities of the first set are related to multiple entities of the second set. E.g. Teachers teach learners

 

Posted Date: 7/26/2013 5:57:55 AM | Location : United States







Related Discussions:- Illustrate the cardinality of relationship, Assignment Help, Ask Question on Illustrate the cardinality of relationship, Get Answer, Expert's Help, Illustrate the cardinality of relationship Discussions

Write discussion on Illustrate the cardinality of relationship
Your posts are moderated
Related Questions
Define the Traditional System Analysis and Design Traditional System Analysis and Design (SAD) have three basic life cycle models. A typical software lifecycle consists of the

what is attribute is attribute inheritance in dbms?

Q.   Explain  data aggregatio n and discuss different design constraints. Sol. Aggregation   One limitation of the E-R model is that it cannot express relationships amon

Define weak and strong entity sets? Weak entity set: entity set that do not have key attribute of their own are known as weak entity sets. Strong entity set: Entity set that

Insulation between conceptual and physical structures It can be defined as: 1. The Database Administrator should be capable to vary the storage structures without affectin

Consider the following relational schema: Doctor(DName,Reg_no) Patient(Pname, Disease) Assigned_To (Pname,Dname) Give expression in both Tuple calculus and Domain calculus for

What are views? Explain how views are different from tables? A view in SQL terminology is a one table in which is derived from other tables. These other tables could be base t

Process to find the non-concurrent objects Once we find out non-concurrent (mutually exclusive) objects, we can fold all objects together in one thread of process or control. O

Define data conversion? Helpful to load data into temporary staging tables. Then can write SQL code to do much of data processing. SQL code is simpler and faster to write than

Explain what is DDL? DDL - Data Definition Language: statements used to define the database structure or schema. Some examples: CREATE - to create objects in the database ALT