One to many - relationship cardinality, Database Management System

Assignment Help:

One-to-many: An entity in A is related with any number of entities in B. An entity in B is related with at the most one entity in A.

Example: Relationship between faculty and department.

541_One to many - Relationship Cardinality.png

One department can take on any number of faculty members but a faculty member is assigned to only one department.

  • Many-to-one: An entity in A is related with at most one entity in B. An entity in B is related with any number in A.

147_One to many - Relationship Cardinality1.png

Example: Relationship between course and instructor. An instructor can teach several courses but a course can be taught only by one instructor. Please note this is an assumption


Related Discussions:- One to many - relationship cardinality

Enhanced entity relationship, what do you understand by enhanced entity-rel...

what do you understand by enhanced entity-relationship

What is an entity relationship model, What is an entity relationship model?...

What is an entity relationship model? The entity relationship model is a set of basic objects known as entities and relationship between those objects. An entity is a thing or

Distributed control and data sharing , Distributed Control and Data sharing...

Distributed Control and Data sharing: The geographical distribution of an organization can be showed in the distribution of the data; if a number of different sites are linked to e

View of data, how to submit answers softcopy

how to submit answers softcopy

Writing a pl/sql program, Problem 1. Create a PL/SQL program to insert ...

Problem 1. Create a PL/SQL program to insert data into student table and display the details of the student having Reg.No 1010 Writing a PL/SQL program to Insert data

Entity-relationship diagram, 1. Item based services will be charged fixed p...

1. Item based services will be charged fixed prices, and time-based will be charged variably depending on time. Such as per hour. Item-based: Fixed, pedicure, waxing, threading, fa

Increased overheads on update-data replication, Increased overheads on upda...

Increased overheads on update : On the drawbacks side, it will need the system to ensure that all replicas of a relation are consistent. This shows that all the replicas of the rel

Development of large scale distributed real systems, Question: (a) What...

Question: (a) What are the challenges in the development of Large Scale Distributed Real Systems? (b) What is backward engineering and forward engineering in a design packa

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd