Scribd
Upload
93 views9 pages

Database Data Models Overview

The document discusses different data models including the entity-relationship model and relational model. The entity-relationship model uses entities and their attributes to model real-world scenarios. Relationships define associations between entities which can have cardinalities like one-to-one, one-to-many, etc. The relational model, which is most popular, stores data in tables called relations. Relations can be normalized and contain atomic values with each row and column having unique and domain-consistent values respectively.

Uploaded by

ahmed
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
93 views9 pages

Database Data Models Overview

The document discusses different data models including the entity-relationship model and relational model. The entity-relationship model uses entities and their attributes to model real-world scenarios. Relationships define associations between entities which can have cardinalities like one-to-one, one-to-many, etc. The relational model, which is most popular, stores data in tables called relations. Relations can be normalized and contain atomic values with each row and column having unique and domain-consistent values respectively.

Uploaded by

ahmed
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
You are on page 1/ 9

Introduction to Database

UCT – Mogadishu, Somalia


3-Data Models

 Data models define how the logical structure of a


database is modelled.
 Data Models are fundamental entities to introduce
abstraction in a DBMS.
 Data models define how data is connected to each
other and how they are processed and stored inside
the system.
3-Data Models

 Entity-Relationship Model
 Entity-Relationship (ER) Model is based on the notion of
real-world entities and relationships among them. While
formulating real-world scenario into the database
model, the ER Model creates entity set, relationship set,
general attributes, and constraints.
3-Data Models

 ER Model is best used for the conceptual design of a


database. ER Model is based on:
 Entities and their attributes.
 Relationships among entities.
 Entity
 An entity in an ER Model is a real-world entity having
properties called attributes. Every attribute is defined by its set
of values called domain.
For example, in a school database, a student is considered as an
entity. Student has various attributes like name, age, class, etc.
3-Data Models
3-Data Models

 Relationship
 The logical association among entities is called relationship.
Relationships are mapped with entities in various ways.
 Mapping
 Mapping cardinalities define the number of association
between two entities
3-Data Models

 Mapping cardinalities:
 one to one
 one to many
 many to one
 many to many
3-Data Models
 Relational Model
 The most popular data model in DBMS is the Relational
Model. It is more scientific a model than others.
Column

Attributes SID SNAME SAGE SCLASS SSECTION


1101 Farah 14 9 A

Tuple 1102 Jama 15 9 B


1103 Qowdhan 14 10 B
1104 Warsame 14 9 A
1105 Bootaan 15 10 A

Table (Relation)
3-Data Models

 The main highlights of this model are:


 Data is stored in tables called relations.
 Relations can be normalized.
 In normalized relations, values saved are atomic values.
 Each row in a relation contains a unique value.
 Each column in a relation contains values from a same
domain.

You might also like