Skip to main content

Chapter 12 What is ERD and Types Explain in Details


CHAPTER 12

ERD

(ENTITY RELATIONSHIP DIAGRAM ) 

ER-Model :- ER- Model Stand for entity relationship model.

It is a graphical approach for designing a database, It’s database modelling technique that generated an abstract diagram of system data and that diagram is used in designing a relational database. It was developed by Peter Chen in 1976.

ERD:- ERD stands for Entity Relationship Diagram, The Diagram generated by ER-Model is known as ERD. ERD show the relationship of different entities stored in the database.



Customer

Name

Address

Shailesh

India / 23333

Chu So Shang

South Korea/ 33322

 

 

Product/ Item

Name

Price

Mouse

250/-

Keyword

750/-

 

ER Diagram explains the logical structure of database, at last an ERD is implemented as a database. It helps us to analyze data requirements systematically to produce a well design database. It is considered as a best practice to completed ER Modelling before implementing your database.

ER diagram are based on three basic concepts entities, attributes and relationship.

1.)    Entity :-An Entity is a real world object or concept about which your want to store information, An Entity can be place, person, object, or a concept etc. (as a Noun )

a.)    Persons :- Students, Employees, Patient..

b.)   Place :- Building, store..

c.)    Object :- Car, Bike, Product..

d.)   Concept :- Course (BCA, BBA, B-Tech, MBA..)

2.)    Attributes :- An attributes are the properties or characters of an entity, It describes an entity, it is represented using oval shape.

3.)    Relationship :- It specifies how entities are associated with each other. It is represented using diamond shape.



Important and uses of ERD:-

Database Design

Database debugging

Problem in requirement gathering

 

Entity Types :-

1.)    Strong Entity :- An Entity which does not depends on any other entity to exits is called Strong entity .

Ex:- Employees

2.)    Weak Entity :- An Entity Which depends on other entity to exist is called weak entity.

Ex :- Loan



Attribute Types :-  

a.)    Single value attributes

b.)   Multi-value attributes

c.)    Simple attributes

d.)   Composite attributes

e.)    Derived attributes

f.)     Key attributes


Comments

Popular posts from this blog

Assignment of ITA/ Information Technology and Application BCA- Technology369kk

Q1. What is  computer Explain basic computer architecture and Difference components.  2. Discuss the use of memory in computer system, Explain memory hierarchy  in details. 3. What is software? Explain difference types of software with explain. 4. Write short notes on the given:- (I) Internet. (II) LAN (Local area network ) (III) Search engine (IV) Web browser  Q 1.What is computer Explain basic computer architecture, Difference components of computer.   Computer :- Computer is defined as an electronic device that takes input data and instructions from the user and after processing them, it generates useful and desired output quickly.   A computer is designed to execute applications and provides a variety of solutions through integrated hardware and software components.                            It is fast and automatic device. It works with the help of programs and represents the d...

C++ and Java Practical All Questions Answers - BCA -Technology369kk

C++ and Java  In this post see most important questions for practical questions given by college all questions with answers . Guys I want to say that this is only for suggested post for your practical please request to you change same alphabets, words or anything  methods name and variables name because if you write all words same then this is copy paste for another peoples.  Used Topics:  Keywords, Variables, Condition Statements, Function , Array, Structure, Pointer.                           In OOPs, Class and Objects, Constructor, Poly morph, Encapsulation, Access Specifiers,                               Inheritance etc.  So, Without Time Lose Come to the Points, let's go start Now:        *************************************************************************  C++ 12 ...

Assignment of PMO (Principal of Management and Organization) - Technology369kk

 ** Assignment Of PMO ** Agenda: -  4 Questions discuss in this post. Question 1. Write a d etails note on selection why it Called. negative process.  Question 2. Write a details note on 'span of control. Question 3. Planning is an essential process, do you agree ? Discuss  Question 4. Write a note on management function. Q 1. Write a d etails note on selection why it called negative process.  Ans :-  Selection is the process of choosing the most suitable candidates out of the several candidates available.          Selection is a negative process because there may be more rejected then those selected in most of the candidates that is called selection is a negative process. → Selection process has the following steps:-  [ A .] Screening of applicants - Based on the screening of applicants only those candidates. It Called further process of selection. Who are found eligible for the job Standards of the the organization. [ B .] S...