what is binary relationship? explain with example - Computer science fundamentals tutorial

Cardinality/Binary relationship

Cardinality/Binary relationship defines the numerical attributes of the relationship between two entities or entity sets.
Types of Cardinality/ Binary relationship
Cardinality/ Binary relationship are four types. now discuss all types of Binary relation ship.

One to one relationship : -

When a single instance of an entity is associated with a single instance of another entity then it is called one to one relationship.

For example : - a person has only one passport and a passport is given to one person.

One to many relationship : -

When a single instance of an entity is associated with more than one instance of another entity then it is called one to many relationship.

For example: -

One customer can placed many orders but an order can’t be placed by many customers.

Many to One relationship: -

When more than one instance of an entity is associated with single instance of another entity then it is called many to one relationship.

For example: -

Many students can study in a single college but a student in many colleges at same time.

Many to many relationship: -

When more than one instance is associated with more than instance of another entity then it is called many to many relationship.

For example: -

More than one employee assigned to many project and many project can be assigned to many employee.

Comments

Solve-write C program to find biggest number from three number by using nested if statement

C program to find biggest number from three number by using nested if statement Problem Description This program takes the 3 numbers and finds the biggest among all. Problem Solution 1. Take the three numbers as input. 2. Check the first number if it greater than other two. 3. Repeat the step 2 for other two numbers. 4. Print the number which is greater among all and exit. Program codes:- here the program of finding biggest of three number run this in your Linux, DEV C++,turbo c++ #include<stdio.h> main() { int num1,num2,num3,big; ...

Important MCQ of RDBMS( Relational database management system)-FCST

Important MCQ of RDBMS 1. A RDBMS consists a collection of ? a. Tables b. Fields c. Records d. Keys ANS/- a. table 2. The term attribute refers to a ___________ of a table a. Record b. Tuple c. Column d. Key ans/- c. Column 3. In relational model, the row of table is known to be ? a. Relation b. Entity field c. Tuple d. Attribute ans/- C. Tuple 4. . Address field of a person should not be part of primary key, since it is likely to ? a. Dependent b. Too long c. Changed d. Not changed ans/- c. Changed 5. The relational model is concerned with ? a. Data structure and Data integrity b. Data Manipulation c. Both a and b d. None of these ans/- c. Both a and b 6. Which is the false statement from the following ? a. A veiw is a named derived table b. A name relation is variable c. A veiw is a named reation and is virtual d. None of these ans/- d. None of these 7. The union of primary key...

Short notes on database schema & database independence- computer science fundamentals tutorial

Database Schema & Data Independence PDF version of this post also available. to download the click the link given at the end of this post. Database Schema : - A database schema is the skeleton structure that represents the logical view of the entire database. It defines how the data is organized and how relat ion among them are associated. Database schema formulates all the constrains that are to be applied on the data. A database schema defines its entities and the relationship among them. It contains descriptive details of the database which can be described by means of schema diagram. A database schema can be divided into two categories. I. Physical database schema : - this schema contain to the actual storage of data and its form of storage like files, indices etc. It defines how the data will be stored in a secondary storage. ...

Fundamentals of computer science tutorial (FCST)

Search This Blog