ERP Diagram- please check before bidding

profilejuicypredatore

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

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

How do I normalize a database: https://support.microsoft.com/EN-US/help/283878 

  • Posted: 2 years ago
  • Due: 
  • Budget: $20
Answers 2

Purchase the answer to view it

blurred-text

Purchase the answer to view it

blurred-text
    • As the final step to your proposed database, submit your Project Plan. This document should communicate how you intend to complete the project. Include timelines and resources required.