Home > Link, Microsoft SQL Server, MSBI, Optimization, Query, Script, SQL Mentalist, SQL PraRup, SQL Query, SQL Server, Technology,, Vishal Pawar > BISQL – Laymen to SQL Developer # 22 – Entity-Relationship Model #1 – Introduction, Conceptual Data model for Database Design

BISQL – Laymen to SQL Developer # 22 – Entity-Relationship Model #1 – Introduction, Conceptual Data model for Database Design

Hi Folks,

This post is part of Series Database Management Systems

Currently running topic for this series is listed as below :

Series of Database Management Systems

>>Chapter 1 : DBMS [Database Management Systems]

>>Chapter 2 : Database Core Concepts and  Applications

>>Chapter 3 : Record Storage and Primary File Organization

>>Chapter 4 : Index Structures of Files

>>Chapter 5 : Entity-Relationship Model <You are Here>

Continuing from my previous post on this series.

We are going to Cover the Following Points in this article

  • Introduction
  • Conceptual Data model for Database Design

Introduction

Entity-relationship model is used to represent objects in the real world and the relationship among these objects, which represents the overall logical structure of a database. We have also seen that the data model that is independent of both the DBMS software and the hardware is the conceptual model. ER model is a high-level conceptual model developed by Chen in 1976 to facilitate database design. The ER model is extremely useful in mapping the meaning and interaction of real world enterprises onto a conceptual schema. The main usage is in the design of the database.

Definition:

Entity Relationship Model is generally referred to as ER Model. As the name indicates it is the representation of the features and relationships that exits between two entities and their relations

Relations:

Consider a relation called PART of degree 5. The five domains are sets of values representing, respectively, part numbers, part names, part weights, part colors, and locations in which parts are stores. The ‘part color’ domain, for example, is the set of all valid part colors.

As the figure illustrates, it is convenient to represent a relation as a table. Each row of the table represents one n-tuple [or simply one tuple] of the relation. The number of tuples in a relation is called the cardinality of the relation; e.g., the cardinality of the PART relation is four.

Relations of degree one are said to be unary; similarly relations of degree two are binary.

Part Relation:

P#

PNAME

COLOUR

WEIGHT

CITY

P1

Nut

Red

12

London

P2

Bolt

Green

17

Parts

P3

Screw

Blue

17

Rome

P4

Screw

Red

14

London

Conceptual Data model for Database Design

clip_image002

Figure Phase of database design (Simplified)

The first step in database design is requirement collection and analysis. During this step database designers interview clients to get their requirements. Without getting the exact requirement from the client it would become very difficult to design a good ER diagram. It is useful to specify functional requirements of the application. Data flow diagrams are used to specify functional requirements.

The next step in the application development is to create a conceptual schema for the database. The conceptual schema is one that describes the data type, relationship and constrains. This step is called conceptual database design.

This concept does not include any implementation details as well as storage details. It is usually easier to understand and can also be used to communicate with non-technical users.

After conceptual schema has been designed, the next step in database design is the actual implementation of the database, using a commercial DBMS like oracle, MS access etc. This step is called logical database design.

Finally the last step is the physical database design phase. During this, the internal storage structure and file organization for the database are specified.

Hope you will like Series of Database Management Systems series !

If you have not yet subscribe this Blog , Please subscribe it from “follow me” tab !

So that you will be updated @ real time and all updated knowledge in your mail daily for free without any RSS subscription OR news reading !!

Happy Learning and Sharing !!

For More information related to BI World visit our all Mentalist networks Blog

SQL Server Mentalist … SQL Learning Blog

Business Intelligence Mentalist … Business Intelligence World

Microsoft Mentalist … MVC,ASP.NET, WCF & LinQ

MSBI Mentalist … MS BI and SQL Server

NMUG Bloggers …Navi Mumbai User Group Blog

Architectural Shack … Architectural implementation and design patterns

DBA Mentalist …Advance SQL Server Blog

MVC Mentalist … MVC Learning Blog

Link Mentalist … Daily Best link @ your email

Infographics Mentalist … Image worth explaining thousand Words

Hadoop Mentalist … Blog on Big Data

BI Tools Analysis … BI Tools

Connect With me on

| Facebook |Twitter | LinkedIn| Google+ | Word Press | RSS | About Me |

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: