Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

dbms conceptual modeling, Lecture notes of Database Management Systems (DBMS)

A database management system (DBMS) is system software for creating and managing databases. The DBMS provides users and programmers with a systematic way to create, retrieve, update and manage data

Typology: Lecture notes

2018/2019

Uploaded on 05/20/2019

anton-wishwa-sandaruwan
anton-wishwa-sandaruwan 🇱🇰

2 documents

1 / 12

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Conceptual Modelling
using ER model- Day 1
CS105:DATABASE MANAGEMENT SYSTEMS
ISURA NIRMAL |ISURA.N@ NSBM.LK| SCHO O L OF COMPUTI NG
pf3
pf4
pf5
pf8
pf9
pfa

Partial preview of the text

Download dbms conceptual modeling and more Lecture notes Database Management Systems (DBMS) in PDF only on Docsity!

Conceptual Modelling

using ER model- Day 1

CS105:DATABASE MANAGE ME NT SYSTE MS

ISURA NIRMAL |ISURA.N@ NSBM.LK| SCHOOL OF COMPUTING

Entity Relationship Model

Entity Relationship(ER) Model is a conceptual data model which can

be used in designing a database.

The three main constructs of the ER model are,

◦ Entities ◦ Attributes ◦ Relationships

ER Model is an Illustration. So we need a Modelling Notation

◦ Standard Symbols to use ◦ Chen Notation

What is a “Entity”?

An entity can be a real-world object, either animate or inanimate,

that can be easily identifiable.

As an example, in a school database, students, teachers, classes, and

courses offered can be considered as entities.

First letter of each word in the entity name is uppercase

E.g., Student, Teacher, Class, Course

Normally an entity is named using a “ noun ‟ or “ noun phrase ‟

What are the entities in Library?

Types of Entities

Strong (Regular) Entity

◦ An entity that exists independently of other entity types

Weak Entity

◦ An entity types whose existence depends on some other entity ◦ This is depended on the scenario (interaction with other entities) ◦ I.e :- A call cannot exist without phone (phone number)

Represented by using a rectangle

Types of Attributes

Simple attribute / Single-value attribute An attribute that cannot be broken down into smaller components Composite attribute An attribute that can be broken down into component parts Derived attribute An attribute whose values can be calculated from related attribute values

Types of Attributes

Multi-value attribute An attribute that may take on more than one value for a given entity instance (I.e ;_ phone number) Key Attribute Uniquely identifiers individual instances of an entity type Can be single attribute or combination of attributes that uniquely identifies individual instances of an entity type

Some Examples

Some Examples