Sign In
Not register? Register Now!
You are here: HomeCourseworkIT & Computer Science
Pages:
2 pages/≈550 words
Sources:
3 Sources
Level:
APA
Subject:
IT & Computer Science
Type:
Coursework
Language:
English (U.S.)
Document:
MS Word
Date:
Total cost:
$ 12.96
Topic:

Types Of Relationships That In Cardinality Coursework (Coursework Sample)

Instructions:

In database jargon, cardinality refers to the number of associations that can exist between two record types. Identify the three types of relationships that deal with cardinality and explain each one.

source..
Content:

TYPES OF RELATIONSHIPS THAT IN CARDINALITY
NAME OF STUDENT
TUTOR’S NAME
COURSE TITLE
INSTITUTION’S NAME
DATE
Cardinality
Also known as the degree of relationship, is the number of instances that an entity A can be associated with another entity B. There is a maximum and minimum cardinality in any relationship. An unspecified cardinality is shown as N. Cardinality limits are mainly derived from external constraints or organisational policies.
There are three main kinds of cardinality:
1 One-to-one (1:1)
2 One-to-many (1:M)
3 Many-to-many (M:N) and not (M:M)
One-to-one (1:1)
59367966088300This is a relationship where an entity’s occurrence relates to a single occurrence in another. This is a rare relationship though it still exists. For example, a driver in a company is allocated a vehicle. Only a single driver can drive a single at a time.
In this case where Entity1 is the driver and Entity2 being the company vehicle.
One-to-many (1:M)
This relationship involves the occurrence of a single entity relating to many occurrences in another entity. An example would be where many employees are able to work in a single department. This is a one (department) to many (employees) relationship between department and employee.
4776722879000
In this case where Entity1 is the department and Entity2 being employee.
Many-to-many (M:N)
This is a relationship that has many specified on both cardinalities and are very common. Many occurrences of an entity similarly relates to many occurrences for another entity and vise versa.
20447044450000An example is where a student can take several courses, on the other...
Get the Whole Paper!
Not exactly what you need?
Do you need a custom essay? Order right now:

Other Topics:

  • Factors In A Business Indicate The Need For Simulation
    Description: What is monte carlo simulation? Where does the name come from? What does it consist of? What is the difference between simulation and modeling? ...
    5 pages/≈1375 words| 6 Sources | APA | IT & Computer Science | Coursework |
  • Bridging versus routing
    Description: Bridging versus routing IT & Computer Science Coursework...
    4 pages/≈1100 words| 3 Sources | APA | IT & Computer Science | Coursework |
  • Annotated Bibliography on Cybersecurity and data protection
    Description: Annotated Bibliography on Cybersecurity and data protection IT & Computer Science Coursework...
    4 pages/≈1100 words| 6 Sources | APA | IT & Computer Science | Coursework |
Need a Custom Essay Written?
First time 15% Discount!