Create entity relationship diagram from excel

Create Entity Relationship Diagram With At Least Two Tables And Their Attributes

Create and submit an ER Diagram with at least two tables and their attributes. Your diagram should include:

Table Names (for each entity)
Attributes (first name, last name, city, etc.)
Primary Keys
Foreign keys
Relationships
Field types (text, currency, numeric, date)
Your tables should be should be normalized (first, second and third normal forms)

You can use the attached form or upload your tables in Excel or create and link them in an Access database file.

For information on how to use Word to create and ERD, go to: https://vimeo.com/18244802

You can upload your tables in Excel, Word or create and link them in an Access database file. If you use another tool please create a PDF file of the results.

Resources for Building ER Diagrams and Normalization:

What is an ER Diagram: http://databases.about.com/od/specificproducts/l/blentity-relationship-diagrams.htm

Video Tutorial Entity Relationship Diagram (ERD) Training Video: https://www.youtube.com/watch?v=-fQ-bRllhXc

Video: How do I normalize a database: https://www.youtube.com/watch?v=xoTyrdT9SZIcle

Article: https://support.microsoft.com/en-us/help/283878/description-of-the-database-normalization-basics

Sample of a Diagram with many tables:

ER Diagram

Assignment:

Create and submit an ER Diagram with at least two tables (one for each table of your proposed database).

Your diagrams should exhibit;

· Some amount of normalization (first, second and third normal forms)

· Primary and Foreign keys are identified

· Type of field (text, currency, numeric) and field length is included

Does not meet expectations

Meets expectations

Exceeds expectations

Conceptual Data Modeling

Did you correctly identify the entities in the case based on the Project Charter?

Did not identify entities correctly

Identified regular entity types

Identified and listed all entity types and listed all data elements

Did you correctly identify

the relationships in the case?

Did not identify relationships

Identified regular relationships

Identified all relationships with proper notation

Did you correctly identify

the keys of the entity types?

Did not identify any keys

Identified primary or foreign keys

Identified both primary and foreign keys.

Did the student correctly identify

the attributes of the entity types?

Did not identify attributes

Identified regular attributes

Identified regular attributes

as text, currency, numeric or other types and field length for text

Logical Database Design

Did you correctly map the

E-R diagram constructs into the logical database design?

Missed Entity Types mapping to

tables.

Missed Attributes mapping to table columns

Missed foreign keys for 1or more

relationships

 Entity types mapped as tables,

 Some relationships mapped properly (foreign keys or separate tables),

 Some primary and foreign keys designed properly



Entity types mapped as tables,

 All relationships mapped properly (foreign keys or separate tables),

 All primary and foreign keys designed properly

Normalization

Are the tables in 3rd Normal Form?

Few tables 3NF

Most tables in 3NF

All tables 3NF