The purpose of this assignment is to assess your ability to model business problems in an E-R diagram and to analyze business problems and model the database solution using Entity relationship Diagrams.
Given the following information produce one Entity Relationship Diagram (ERD) based on the Chen model that can be implemented.
Make sure to include all appropriate entities (entities should be in all capital letters in rectangles), relationships (in diamonds), connectivities (either 1 or M), and cardinalities (in parentheses at each entity [ie., (I,N), (0, 1), etc.]. Also, I need for your diagrams to be done in either MS Word, SmaltDraw or Visio. Last, please explain all cardinalities and connectivities in English sentences. NOTE: there will be some 'optionalities ' or optional participation (see pages 119122 in the tat for details) in this diagram as well — which you will need to include with a circle next to the optional side of the entity relationship (ie., INVOICE is optional to CUSTOMER).
NOTE: Several of you have asked if you can turn in a Crow's foot model instead of Chen model for assignment 2-1. That is fine with me if you do that but if you turn in a Crow's foot model, you must also include the attributes in the ER diagram whereas these are not needed for the Chen model
NOTE: Please be sure to put all diagrams, etc int a Word document prior to submission
P.S. I have high-lighted the nouns that relate to or should be entities for this assignment.
Assignment Writing Help
Engineering Assignment Services
Do My Assignment Help
Write My Essay Services