Data Modeling 1

profilejun184
unit_1_ip_-_template.docx

{Enter Your Name Here}

My selected topic is: _____________________________________________.

Entity List & Descriptions

Entity Name

Description / Special Notes

Unique Identifier

Relationships

Relationship Type

Entity #1

Entity #2

Description / Justification

one-to-one (1:1)

{why is this an example of a 1:1 and not a 1:M or M:N?}

one-to-many (1:M)

{why is this an example of a 1:M and not a 1:1 or M:N?}

many-to-many (M:N)

{why is this an example of a M:N and not a 1:1 or 1:1?}

Entity Relationship Diagram (ERD)

{Insert your ERD here}

Sample Data

· Highlight Unique Identifiers in Yellow

· Note: Format the table so that all rows and columns are visible.

· Delete un-needed columns and rows.

· Add more columns/rows as needed. Just make sure all columns are visible in the white space.

{Entity #1}

{Entity #2}

{Entity #3}

{Entity #4}

{Entity #5}

{Entity #6}

{Entity #7}

{Entity #8}

Page 1 of 12