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:

ER Diagram

Create entity relationship diagram with at least two tables and their

Calculate your order
Pages (275 words)
Standard price: $0.00
Client Reviews
4.9
Sitejabber
4.6
Trustpilot
4.8
Our Guarantees
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Money Back
If you're confident that a writer didn't follow your order details, ask for a refund.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00
Power up Your Academic Success with the
Team of Professionals. We’ve Got Your Back.
Power up Your Study Success with Experts We’ve Got Your Back.