Relationship cardinality, Database Management System

Cardinality shows the number of instances of an entity associated with another entity participating in a relationship. Depend on the cardinality binary relationship can be further dividing into the following categories:

  • One-to-one: An entity in A is related with at most one entity in B, and an entity in B is associated with at most one entity in A.

 

Example: Relationship between university/college and principal

1656_Relationship Cardinality.png

One college only have at the most one principal and one principal can be assigned to only one college.

Likewise we can define the relationship among Vice Chancellor and university.

Posted Date: 3/6/2013 6:06:45 AM | Location : United States







Related Discussions:- Relationship cardinality, Assignment Help, Ask Question on Relationship cardinality, Get Answer, Expert's Help, Relationship cardinality Discussions

Write discussion on Relationship cardinality
Your posts are moderated
Related Questions
Using a labelled diagram explain the operation of the Data Warehouse, define the basic architectural components and outline the main functionalities. Briefly explain the role an op

Why DML is used for? DML is used to Manipulation and processing of database. DML is provided for manipulation & processing of database. (Data stored in the database is processed

An example of a weak entity is Staff because the availabilityID cannot be uniquely identified unless it is used in conjunction with the foreign key known as availabilityID in the A

Give an example of Operations from the functions of a bank. For creation of a saving account, you can write: bank::: create -savings-account (customer)->account. For oper

OBJECTIVES After going through this unit you should be capable to: Explain the File Based system and its limitations; Explain the structure of DBMS; Explain the

Explain Alternate key? Alternate Key - All the candidate keys except primary key are known as alternate keys.

Explain the systems development life cycle. This is the traditional method to develop, maintain, and replace information systems that contains the project identification and se

Retrieve the S&S In-Chapter Database (in Microsoft Access format) from the text's Web site (or create the tables in Table 4-5 in a relational DBMS product). Write queries to answer

ALTER TABLE Command : This command is used for variation of existing structure of the table in the given situation: When a new column is to be added to the table structure.

Question 1 Draw a Data Flow Diagram for a University scenario Question 2 Discuss the following with suitable examples Relational Algebra Operators Database Pla