Tuesday, September 25, 2012

Part 4.1 Conceptual Data Modeling

4. Data Modeling

4.1 Conceptual Data Modeling
      4.1.1 Introduction to Conceptual Data Model
      4.1.2 Stages in Conceptual Modeling
      4.1.3 Components of a Conceptual Data Model
      4.1.4 ER Modeling Basic Concepts
      4.1.5 Enhanced ER Modeling
      4.1.6 Guidelines for ER Modeling
4: 4.1 Conceptual Data Model
Conceptual Data Model
A conceptual schema or conceptual data model is a map of concepts and their relationships. This describes the semantics of an organization and represents a series of assertions about its nature. Specifically, it describes the things of significance to an organization (entity classes), about which it is inclined to collect information, and characteristics of (attributes) and associations between pairs of those things of significance (relationships).
A conceptual data model identifies the highest-level relationships between the different entities.
Features of conceptual data model include:
Includes the important entities and the relationships among them.
No attribute is specified.
No primary key is specified.
4.1.2 Stages in Conceptual Modeling

Main stages in conceptual modeling are as follows:

--  Identification of requirements (done in previous lesson)
--  Designing of solutions
--  Evaluation of solutions
4.1.3 Components of a Conceptual Data Model
  
4.1.4 ER Modeling Basic Concepts
ER Model

The ER model is a conceptual model
Describes data as entities, relationships and attributes
No standard notation for displaying ER diagrams
(We will choose one among several alternatives for this presentation)
Entity
An entity is a “thing” in the real world with an independent existence
An entity may be an object with a physical existence
For example, person, car, house
An entity may be an object with a conceptual existence
For example, company, job, university-course

 
4.1.5 Enhanced ER Modeling
  
Enhanced ER Model, Includes all the modeling concepts of the ER model

In addition, it includes the following concepts:

  • Subclass & super-class
  • Specialization & generalization
  • Category
  • Attribute & relationship inheritance
Subclass & Super-class


  • In many cases an entity type has numerous sub-groupings of its entities that are meaningful and need to be represented explicitly because of their significance to the database application. Each of these sub-groupings are called subclass.
  • The entity type on which these subclasses are formed is called super-class
  • The relationship between a super-class and any one of its subclasses is called a super-class/subclass, a class/subclass or an IS-A (or IS-AN) relationship, e.g., a SECRETARY IS-AN EMPLOYEE
  • A member entity of a subclass represents the same real-world entity as some member of the super-class, but in a distinct specific role
Specialization (Top to Bottom Approach)


Specialization is the process of defining a set of subclasses of an entity type


In addition, it allows us to do the following:
  •  Establish additional specific attributes with each subclasses
  •  Establish additional specific relationship types between each subclass and other entity types or other subclasses
Generalization (Bottom to Top Approach)


Generalization refers to the process of defining a generalized entity type from the given entity types


Generalization process can be viewed as being functionally the inverse of the specialization process   
 


  A specialization lattice with multiple inheritance for a UNIVERSITY database.





23 Comments:

At 3/27/2019 , Blogger sandeep saxena said...

The information is good. I preview this type of good blog only. Good job.
Html5 Training in Chennai
Html5 Training Course
Html5 Training in Velachery
DOT NET Training in Chennai
.Net course in chennai
C C++ Training in Chennai
LoadRunner Training in Chennai
Html5 Training in Chennai

 
At 4/03/2019 , Blogger cynthiawilliams said...

Thanks for posting this info, I found it very interesting and informative.
RPA Training in Chennai
Robotics Process Automation Training in Chennai
Blue Prism Training in Chennai
UiPath Training in Chennai
Data Science Course in Chennai
RPA Training in Anna Nagar
RPA Training in Chennai
RPA course in Chennai

 
At 4/16/2019 , Blogger Sivanandhana Girish said...

I believe that your blog would help the readers by giving them a useful information. Waiting for more updates from this admin.

Spoken English Classes in Chennai
Best Spoken English Classes in Chennai
Spoken English Class in Chennai
Spoken English in Chennai
English Classes in Chennai

 
At 4/16/2019 , Blogger divya said...

Great info. The content you wrote is very interesting to read. This will loved by all age groups.
Angularjs Training in Chennai
Angularjs Course in Chennai
CCNA Training in Chennai
Salesforce Training in Chennai
Angular5 Training in Chennai
Angular6 Training in Chennai
Angular7 Training in Chennai
Angularjs Training in Chennai
Angularjs Course in Chennai

 
At 4/16/2019 , Blogger nikitha josh said...

I have gone through your blog, it was very much useful for me and because of your blog, and also I gained many unknown information, the way you have clearly explained is really fantastic. Kindly post more like this, Thank You.
best aviation academy in Chennai
best air hostess training institute in Chennai
airline management courses in Chennai
airport ground staff training in Chennai
Aviation Academy in Chennai
air hostess training in Chennai
airport management courses in Chennai
ground staff training in Chennai

 
At 5/21/2019 , Blogger Edward said...

Thank you for the nice article here. Really nice and keep update to explore more tips and ideas.

Big Data Testing Services

 
At 6/07/2019 , Blogger Aparna said...

This post was very attractive and interesting. Currently, this content is very required for freshers. Kindly posting and sharing with us...
Oracle Training in Chennai
Oracle course in Chennai
Tableau Training in Chennai
Spark Training in Chennai
Excel Training in Chennai
Primavera Training in Chennai
Pega Training in Chennai
Unix Training in Chennai
Power BI Training in Chennai
Oracle DBA Training in Chennai

 
At 8/01/2019 , Blogger markson said...

Yet, I was certain that I at an option that is greater than what I had known every one of these years. After the a half year time frame, I was presently affirmed. data science course in pune

 
At 8/15/2019 , Blogger Unknown said...


I was blown out after viewing the article which you have shared over here. So I just wanted to express my opinion on Data Science, as this is best trending medium to promote or to circulate the updates, happenings, knowledge sharing.. Aspirants & professionals are keeping a close eye on Data science course in Mumbai to equip it as their primary skill.

 
At 8/27/2019 , Blogger digitaltucr said...


Attend The Digital Marketing Courses in Bangalore From ExcelR. Practical Digital Marketing Courses in Bangalore Sessions With Assured Placement Support From Experienced Faculty. ExcelR Offers The Digital Marketing Courses in Bangalore.
Digital Marketing training in Bangalore

 
At 9/05/2019 , Blogger Priyanka said...

Attend The Data Analytics Courses From ExcelR. Practical Data Analytics Courses Sessions With Assured Placement Support From Experienced Faculty. ExcelR Offers The Data Analytics Courses.
ExcelR Data Analytics Courses

 
At 9/07/2019 , Blogger ameer said...

Such a very useful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. I would like to state about something which creates curiosity in knowing more about it. It is a part of our daily routine life which we usually don`t notice in all the things which turns the dreams in to real experiences. Back from the ages, we have been growing and world is evolving at a pace lying on the shoulder of technology."institutes for data science in hyderabad" will be a great piece added to the term technology. Cheer for more ideas & innovation which are part of evolution.

 
At 9/07/2019 , Blogger seoexpert said...

Such a very useful article. I have learn some new information.thanks for sharing.
data scientist course in mumbai

 
At 9/10/2019 , Blogger ravali said...

Well, The information which you posted here is very helpful & it is very useful for the needy like me.., Wonderful information you posted here. Thank you so much for helping me out to find the Data science course in mumbai
Organisations and introducing reputed stalwarts in the industry dealing with data analyzing & assorting it in a structured and precise manner. Keep up the good work. Looking forward to view more from you.

 
At 9/11/2019 , Blogger ameer said...


Excelr is providing emerging & trending technology training, such as for data science, Machine learning, Artificial Intelligence, AWS, Tableau, Digital Marketing. Excelr is standing as a leader in providing quality training on top demanding technologies in 2019. Excelr`s versatile training is making a huge difference all across the globe. Enable ?business analytics? skills in you, and the trainers who were delivering training on these are industry stalwarts. Get certification on "
best institute for data science in hyderabad"
and get trained with Excelr.

 
At 9/12/2019 , Blogger ExcelR Solutions said...

Thanks for sharing your valuable information to us, it is very useful.
data science courses in bangalore with placement



 
At 9/22/2019 , Blogger Maneesha said...

I recently came across your article and have been reading along. I want to express my admiration of your writing skill and ability to make readers read from the beginning to the end. I would like to read newer posts and to share my thoughts with you.
data scientist course online

 
At 9/26/2019 , Blogger Manikanta said...

Nice Article...Very interesting to read this article. I have learn some new information.thanks for sharing.
Click here

 
At 10/04/2019 , Blogger data science course in mumbai said...

Such a very useful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article.
Click here

 
At 10/17/2019 , Blogger datasciencecourse said...

This post is very simple to read and appreciate without leaving any details out. Great work!
ExcelR Data Analytics courses

 
At 10/21/2019 , Blogger data science course in mumbai said...

Great post i must say and thanks for the information. Education is definitely a sticky subject. However, is still among the leading topics of our time. I appreciate your post and look forward to more.
ExcelR Business Analytics Course

 
At 10/22/2019 , Blogger Excelrsolutions said...

I am looking for and I love to post a comment that "The content of your post is awesome" Great work! excelr data science

 
At 10/22/2019 , Blogger Excelrsolutions said...

I am looking for and I love to post a comment that "The content of your post is awesome" Great work! excelr data science

 

Post a Comment

Subscribe to Post Comments [Atom]

<< Home