Transcript ER Diagram Master • How to use this template

ER Diagram Master
• How to use this template
– The following 3 pages have the objects
necessary to create ER diagrams for your
database design
– Copy the objects to a new presentation,
changing the generic field names to your field
names.
– The last page has a completed example.
20 pt
ER Diagram Title
Table Name
UniqueIdentifier
Field1
Field2
Table Name
UniqueIdentifier
Field1
Field2
Field3
Field4
Field5
Field6
relationship of
Table Name
UniqueIdentifier
Field1
Field2
Field3
Field4
Field5
Field6
Field7
Field8
Field9
Field10
Table Name
UniqueIdentifier
Field1
Field2
Field3
Field4
Field5
Field6
Field7
Field9
Field10
Field11
Field12
Field13
Field14
Field15
Field16
16 pt
ER Diagram Title
Table Name
UniqueIdentifier
Field1
Field2
Table Name
UniqueIdentifier
Field1
Field2
Field3
Field4
Field5
Field6
Table Name
UniqueIdentifier
Field1
Field2
Field3
Field4
Field5
Field6
Field7
Field8
Field9
Field10
relationship of
Table Name
UniqueIdentifier
Field1
Field2
Field3
Field4
Field5
Field6
Field7
Field9
Field10
Field11
Field12
Field13
Field14
Field15
Field16
12 pt
ER Diagram Title
Table Name
UniqueIdentifier
Field1
Field2
Table Name
UniqueIdentifier
Field1
Field2
Field3
Field4
Field5
Field6
Table Name
UniqueIdentifier
Field1
Field2
Field3
Field4
Field5
Field6
Field7
Field8
Field9
Field10
relationship of
Table Name
UniqueIdentifier
Field1
Field2
Field3
Field4
Field5
Field6
Field7
Field9
Field10
Field11
Field12
Field13
Field14
Field15
Field16
12 pt
Order Database
Customer
CustomerID
FirstName
LastName
Address1
Address2
City
State
Zip
Order
OrderID
CustomerID
OrderDate
SalesRepID
Product
ProductID
ProductNum
ProductName
ProductPrice
OrderDetail
OrderID
ProductID
Quantity
Discount