Skip to main content

What is an-entity & it's type in DBMS? explain with proper Diagram - Computer science fundamentals tutorial


 Entity set & it's types

PDF version of this post also available. to download the click the link is given at the end of this post.  
1.What is entity?
Ans/- An entity can be a real word object either animated or inanimate that can be easily identifiable. An entity in a database is represented as a set of attributes. Each entity has a different  sets of values for some set of attributes and this is how entity seems to be distinct from other entities.  In relational model, an entity is represented as a row, tuple or a record.

2.What is Entity set?
Ans/- An entity set is a group of similar kind of entities. It may contain entities with attributes sharing similar values. Entities are represents by their properties which also called attributes.
Type of entity: -Entities  are two types. there are  a) weak entity b) strong entity. now we explain these entities with example and also their difference between them. 
Weak entity: - A weak entity is a type of entity which doesn’t have its key attribute. It can be identified uniquely by considering by consisting primary key of another entity. It represented by double rectangular box. Weak relation represent by double diamond box. 

Strong entity: - A strong entity is a type of entity which has its key attribute for that strong entity said need not to have participation.

Difference between strong and weak entity: -

click here for PDF version  of  this post 
PDF of  What is an entity & its type in DBMS

 To know about Cardinality & its type in details visit my blog site given below
https://programminglanguagepoint.blogspot.com/2020/06/what-is-cardinality-or-binary.html


Labels:

Comments

Post a Comment

please subscribe my blog and let me suggest how I improve this site

Popular posts from this blog

type casting in C. - computer science fundamentals tutorial

Typecasting in C Typecasting is also known as "forced conversion". It refers to changing variable one data type to another data type.          Typecasting in can be certified into following two types: - 1) Implicit type casting. 2) Explicit type casting. Implicit type casting : - It is also known as "Automatic type conversion". It is done by compiler on its own without any external trigger from user. Generally takes place when in an expression more than one data type is present in such condition. Type conversion take places to avoid data lose. Example : - #include<stdio.h> main() {   char y = 'a';   int b = y; printf("%c",y); printf("%d",b); } Explicit Type casting : - This process also called 'Type casting' and it is user defined . Here the user can type cast the result to make it of particular data type. Example : - #include<stdio.h> main() { int m...
2 comments
Read more

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...
6 comments
Read more

Solve-write C program to find grade of student by using nested else-if statement

C program to find grade of student by using nested else-if statement Problem Description This program take input as your number then show your grade. Problem Solution 1. enter your marks as input. 2. then check your marks with 'If' block's condition. if it satisfied then show your grade as output. 3. if it not satisfied then it checks with all else-if block's condition repeatedly. 4. print the grade according to your given marks as input and exit. Program codes:-   #include<stdio.h> main() { int n; printf("\n enter the marks:"); scanf("%d",&n); if(n>89) printf("O"); else if(n>79) printf("E"); else if(n>69) printf("A"); else if(n>59) printf("B"); else if(n>49) printf("C"); else if(n>39) printf("D"); else printf("F"); } Program explanation:- 1. enter your marks. for example we take 70 . ...
Post a Comment
Read more