support@unifiedpapers.com

What is an ER Diagram

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


 

. .

.

The post What is an ER Diagram appeared first on Unified Papers.

"Get 15% discount on your first 3 orders with us"
Use the following coupon
FIRST15

Order Now

Hi there! Click one of our representatives below and we will get back to you as soon as possible.

Chat with us on WhatsApp