As you asking for the of the BE Computer Science and Engineering 5 Sem Subject DBMS of the Unit ER model the Notes are as follow

Introduction to ER Model

ER model is represents real world situations using concepts, which are commonly used by people.It allows defining a representation of the real world at logical level.ER model has no facilities to describe machine-related aspects.

In ER model the logical structure of data is captured by indicating the grouping of data into entities. The ER model also supports a top-down approach by which details can be given in successive stages.

Entity: An entity is something which is described in the database by storing its data, it may be a concrete entity a conceptual entity.

Entity set: An entity set is a collection of similar entities.

Attribute: An attribute describes a property associated with entities. Attribute will have a name and a value for each entity.

Domain:A domain defines a set of permitted values for a attribute


ER Model Concepts

Entities and Attributes
Entities are specific objects or things in the mini-world that are represented in the
database.

For example the EMPLOYEE John Smith, the Research DEPARTMENT, the ProductX

PROJECT.
Attributes are properties used to describe an entity.
For example an EMPLOYEE entity may have the attributes Name, SSN, Address, Sex, BirthDate .

A specific entity will have a value for each of itsattributes.

For example a specific employee entity may have Name='John Smith', SSN='123456789',
Address ='731, Fondren, Houston, TX', Sex='M', BirthDate='09-JAN-55‘

Each attribute has a value set (or data type) associated with it – e.g. integer, string,
subrange, enumerated type,

Rest of the Notes you may get from the below attachement that is Free to Download

Notes of the BE Computer Science and Engineering 5 Sem Subject DBMS of the Unit ER model VTU university

UNIT -2
Entity-Relationship Model
Introduction to ER Model
ER model is represents real world situations using concepts, which are commonly used
by people. It allows defining a representation of the real world at logical level.ER model
has no facilities to describe machine-related aspects.
In ER model the logical structure of data is captured by indicating the grouping of data
into entities. The ER model also supports a top-down approach by which details can be
given in successive stages.
Entity: An entity is something which is described in the database by storing its data, it
may be a concrete entity a conceptual entity.
Entity set: An entity set is a collection of similar entities.
Attribute: An attribute describes a property associated with entities. Attribute will have a
name and a value for each entity.
Domain: A domain defines a set of permitted values for a attribute

Example COMPANY Database
We need to create a database schema design based on the following (simplified)
requirements of the COMPANY Database:
The company is organized into DEPARTMENTs.
Each department has a name, number and an employee who manages the department.
We keep track of the start date of the department manager.
A department may have several locations.
Each department controls a number of
PROJECTs. Each project has a unique name, unique number and is located at a single
location.
We store each EMPLOYEE’s social security number, address, salary, sex, and birth date.
Each employee works for one department but may work on several projects.
All Syllabus All Syllabus vtu.allsyllabus.com
Page 4
We keep track of the number of hours per week that an employee currently works on
each project.
We also keep track of the direct supervisor of each employee.
Each employee may have a number of DEPENDENTs.
For each dependent, we keep track of their name, sex, birth date, and relationship to the
employee.
ER Model Concepts
Entities and Attributes
Entities are specific objects or things in the mini-world that are represented in the
database.
For example the EMPLOYEE John Smith, the Research DEPARTMENT, the ProductX
PROJECT.
Attributes are properties used to describe an entity.
For example an EMPLOYEE entity may have the attributes Name, SSN, Address, Sex,
BirthDate .
A specific entity will have a value for each of its attributes.
For example a specific employee entity may have Name='John Smith', SSN='123456789',
Address ='731, Fondren, Houston, TX', Sex='M', BirthDate='09-JAN-55‘
Each attribute has a value set (or data type) associated with it – e.g. integer, string,
subrange, enumerated type,

rest notes are given below in the pdf file

For any query you may contact to the VTU University the contact details are given below :

Contact details :
VTU University
Address: Jnana Sangama, VTU Main Road, Machhe, Belagavi, Karnataka 590018
Phone: 0831 249 8196

Attached Files

Notes of the BE Computer Science and Engineering 5 Sem Subject DBMS of the Unit ER model VTU uni.pdf (821.2 KB, 124 views)