How to Draw Entity Relationship Diagrams using MS PowerPoint - PowerPoint PPT Presentation

1 / 10
About This Presentation
Title:

How to Draw Entity Relationship Diagrams using MS PowerPoint

Description:

How to Draw Entity Relationship Diagrams using MS PowerPoint Richard Holowczak Computer Information Systems Zicklin School of Business Baruch College, CUNY – PowerPoint PPT presentation

Number of Views:201
Avg rating:3.0/5.0
Slides: 11
Provided by: RichardH77
Category:

less

Transcript and Presenter's Notes

Title: How to Draw Entity Relationship Diagrams using MS PowerPoint


1
How to Draw Entity Relationship Diagrams using MS
PowerPoint
  • Richard Holowczak
  • Computer Information Systems
  • Zicklin School of Business
  • Baruch College, CUNY
  • Richard_Holowczak_at_baruch.cuny.edu

2
Step 1 Create a blank presentation Step 2
Insert a new, completely blank slide as below
3
Step 3 If you do not see the drawing tools on
the tool bar, make certain they are
displayed View -gt Toolbars -gt Drawing This
toolbar is usually at the Bottom of the screen
4
Model Salon Core Business Creation Date/Time
August 30, 2002 801 PM Modified Date/Time
September 9, 2002 345 PM Last Modified by R.
Holowczak
12 pt. font Gray background
Step 4 Create a legend on the diagram Use the
Text Box drawing tool Include what the ER model
represents, when it was Created and last modified
and who modified the diagram
5
Model Salon Core Business Creation Date/Time
August 30, 2002 801 PM Modified Date/Time
September 9, 2002 345 PM Last Modified by R.
Holowczak
  • Step 5 Create an entity
  • Use the text box tool
  • Format the box with a solid border
  • Make the Entity name Bold
  • Use the space bar to center
  • Make dashes to indicate the attributes
  • Put (id) next to the identifier(s)
  • Customer
  • CustomerID (id)
  • FirstName
  • LastName
  • CustPhone
  • Street
  • City
  • State
  • Zip

14 pt. font size and 2 pt. sized black border
6
Model Salon Core Business Creation Date/Time
August 30, 2002 801 PM Modified Date/Time
September 9, 2002 345 PM Last Modified by R.
Holowczak
Step 6 Once you have one nice entity, just copy
and paste it to make more
  • SalonService
  • ServiceID (id)
  • ServiceName
  • ServiceDuration
  • ServicePrice
  • ServiceRendered
  • LineItemNumber (id)
  • ServiceExtendedPrice

Note Use a double border to indicate
Id-dependent entities
  • Appointment
  • AppointmentID (id)
  • AppointmentDate
  • AppointmentTime
  • Employee
  • EmployeeID (id)
  • FirstName
  • LastName
  • PayRate
  • Customer
  • CustomerID (id)
  • FirstName
  • LastName
  • CustPhone
  • Street
  • City
  • State
  • Zip
  • Payment
  • PaymentID (id)
  • PaymentDate
  • PaymentAmount
  • PaymentMethod
  • ReferenceNumber

7
Model Salon Core Business Creation Date/Time
August 30, 2002 801 PM Modified Date/Time
September 9, 2002 345 PM Last Modified by R.
Holowczak
Step 7 Add relationships Use the line drawing
tools in 4 parts Dashed line (optional) Solid
Line (mandatory) Crows foot (Many) two small
lines Group these and copy/paste to make
more Dont forget to add relationship
comments/titles
dashed line, 2pt. weight
solid line, 2pt. weight
  • Customer
  • CustomerID (id)
  • FirstName
  • LastName
  • CustPhone
  • Street
  • City
  • State
  • Zip

Two small solid lines
a payment submitted by
  • Payment
  • PaymentID (id)
  • PaymentDate
  • PaymentAmount
  • PaymentMethod
  • ReferenceNumber

Hint Try and make all relationships go in the
same direction
paying
8
Collection of pre-made relationships
One to many Optional to Mandatory
One to One Optional to Mandatory
Many to Many Optional to Mandatory
9
Model Salon Core Business Creation Date/Time
August 30, 2002 801 PM Modified Date/Time
September 9, 2002 345 PM Last Modified by R.
Holowczak
Step 8 Copy and paste relationships Make certain
the relationships make sense!
  • SalonService
  • ServiceID (id)
  • ServiceName
  • ServiceDuration
  • ServicePrice

a rendering of
  • ServiceRendered
  • LineItemNumber (id)
  • ServiceExtendedPrice

a service rendered as
a specific service rendered during
rendered by
a reservation to provide
rendering
  • Appointment
  • AppointmentID (id)
  • AppointmentDate
  • AppointmentTime
  • Employee
  • EmployeeID (id)
  • FirstName
  • LastName
  • PayRate

a reservation for
  • Customer
  • CustomerID (id)
  • FirstName
  • LastName
  • CustPhone
  • Street
  • City
  • State
  • Zip

making
Example ONE Customer May Be making MANY
Appointments ONE Appointment Must Be a
reservation for ONE Customer
10
Conclusion
  • Once youve completed one, youll never have to
    do it again - just copy and paste ?
Write a Comment
User Comments (0)
About PowerShow.com