Database Management DBM500 UOP Week 2 DQ2

How do Entity relationship Diagrams (ERDs) service of process to ensure puritanical infobase rootage?The importance of proper selective informationbase introduction was hatched in DQ1 of this week. Entity consanguinity Diagrams (ERDs) help ensure proper informationbase target by graphically showing the structure of a database. ERDs also help us learn key concepts or so the data we need to utilise or manipulate. For example, ERDs indicate:1. data relationships such as One-to-Many, Many-to-Many, Ambiguities2. what data needs to be stored3. the grade of a relationshipThe ERDs helps us respect the design and to picture argonas that whitethorn be of concern, or areas we whitethorn befool missed. In an online lecture, entropy Modeling with Entity Relationship Diagrams by Frances Wickham from the Medical University of South Carolina (http://www.srnr.arizona.edu/rnr/rnr417/erdiagrams3/erdiagrams.htm)Wickham indicates that data models such as ERDs are used as discourse tools and also, ?provide the developer an opportunity to mannequin out conceptual and design issues and problems prior to beginning the in truth design process.?Wickham compares building a database to micturateing a building, the ERD is the blueprint from which the database hold be built, and ?no honourable builder would start to cook up a building without a detailed blueprint.?An entity is a person, keep apart or thing about which data erect be stored for tracking by the user.

For example, an entity dope be a customer, and the data that will be stored for that entity can be: the customer?s account number, the customer?s name, the customer?s shroud and the customer?s address number. Relationship is the interaction meet by entities. For example, a customer which is an entity places an order at the participation?s web-store which is also some other entity. Placing the order is the link amongst the both entities, thus the relationshipOnce the database tables have been created for the database it is then important to understand how the entities... If you exigency to get a full essay, order it on our website: Ordercustompaper.com

If you want to get a full essay, visit our page: write my paper