Data Modelling using the
Entity-Relationship
Model
PARTIALLY BASED ON CHAPTER 3 OF FUNDAMENTS OF DATABASE SYSTEMS BY
ELMASRI/NAVATHE – GO READ THIS CHAPTER AFTER FOR A FULLER COVERAGE
OF THIS TOPIC!
, Last time…
We took a first look at MySQL and writing some SQL queries for the first
time to
Create a database and a table
Insert records
Select records
Delete records
Alter records
Add and remove columns (fields) from a table
,But before we do anything
“practical” we need “preparation”
Requires
, So we need to
design our
database
properly before
we implement it!
A simplified diagram to
illustrate the main phases of
database design…
Entity-Relationship
Model
PARTIALLY BASED ON CHAPTER 3 OF FUNDAMENTS OF DATABASE SYSTEMS BY
ELMASRI/NAVATHE – GO READ THIS CHAPTER AFTER FOR A FULLER COVERAGE
OF THIS TOPIC!
, Last time…
We took a first look at MySQL and writing some SQL queries for the first
time to
Create a database and a table
Insert records
Select records
Delete records
Alter records
Add and remove columns (fields) from a table
,But before we do anything
“practical” we need “preparation”
Requires
, So we need to
design our
database
properly before
we implement it!
A simplified diagram to
illustrate the main phases of
database design…
