Categories
Study Questions

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

This page is having a slideshow that uses Javascript. Your browser either doesn't support Javascript or you have it turned off. To see this page as it is meant to appear please use a Javascript enabled browser.

Jessy
Jessy
Just a bit off from the syllabus rubric, but I can add to the slides on my own. Thank you anyway.
Alvin
Alvin
To the writer, THANK YOU, a million times over, this is very impressive! Thank you to the support team for making a hiccup not turn into a disaster!
Milly.P
Milly.P
There was consistent communication from the start, and it was obvious the writer thoroughly reviewed the information provided. Thank you.
Ivy.G
Ivy.G
Excellent work all the time! love my writer also. Don't know if I'm supposed to do this but I just need to say this writer does excellent work!
Emily.s
Emily.s
The writer followed my instruction thoroughly and did a great job. The quality of the paper is more than I expected. Thank you.
Justus N
Justus N
You people have been really patient with me as I created mechanical engineering content. It’s not an easy topic to handle, yet I can say that I worked with a skilled specialist. My writer took time to understand my ideas but it was mostly my fault. Just share more details.
Kelly H
Kelly H
When I received a paper revision from my new college professor, I was desperate as I didn’t know what to do. If not for Academized, I would be doomed. They know how to fix things for you and explain what was wrong as they fix it.
Paul D
Paul D
You're the best, I'll be using your services again soon! Thank you Thank you Thank you!
Mark P.
Mark P.
I asked my writer to help me compose a personal essay about charity work that I do at the local church. It is not easy for me to express myself in words, which is why I needed some privacy and a good person who would appreciate my thoughts and ideas.

error: Content is protected !!
Open chat
1
Do You Need Assignment Help? Lets Chat!
StudyPoo Inc.
Get Help Instantly direct from an Expert.

Talk through Live Chat right now!