Create entity relationship diagram with at least two tables and their

Create entity relationship diagram with at least two tables and their 

Create entity relationship diagram with at least two tables and their

 
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:

Create entity relationship diagram with at least two tables and their

 
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:

Create entity relationship diagram with at least two tables and their

DO YOU NEED HELP WITH THIS ASSIGNMENT ?


At LindasHelp.com , I can take care of all your academic needs including your individual & learning team papers & power points, your Accounting, Finance, Math and QNT labs, sheets, quizzes, discussion questions and Final exams. All the work I complete for you is guaranteed to be 100% original, plagiarism free, edited, APA formatted and just ready for you to add your name on it.

Leave a Reply

Your email address will not be published.

Scroll to Top