Categories
Uncategorized

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…

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 KeysForeign keysRelationshipsField 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/18244802You 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.htmVideo Tutorial Entity Relationship Diagram (ERD) Training Video:  https://www.youtube.com/watch?v=-fQ-bRllhXcVideo: How do I normalize a database: https://www.youtube.com/watch?v=xoTyrdT9SZIcleArticle:  https://support.microsoft.com/en-us/help/283878/description-of-the-database-normalization-basicsSample of a Diagram with many tables:
 
Are you looking for a similar assignment? Order now for an Amazing Discount! Use Discount Code “Newclient” for a 15% Discount!

Create Entity Relationship diagram with at least two tables and their attributes .

 

Leave a Reply

Your email address will not be published. Required fields are marked *