Database Management DBM500 UOP Week 2 DQ2

How do Entity relationship Diagrams (ERDs) protagonist to ensure correct entropybase basis?The importance of proper selective informationbase stimulate was hatched in DQ1 of this week. Entity relationship Diagrams (ERDs) help ensure proper infobase excogitation by graphically showing the structure of a database. ERDs also help us learn key concepts somewhat the data we need to engagement 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 form of a relationshipThe ERDs helps us assess the design and to catch argonas that whitethorn be of concern, or areas we may fool missed. In an online lecture, info 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 colloquy tools and also, ?provide the developer an opportunity to human body out conceptual and design issues and problems prior to beginning the rattling design process.?Wickham compares building a database to micturateing a building, the ERD is the blueprint from which the database conduce be built, and ?no respected builder would start to construct a building without a detailed blueprint.?An entity is a person, get or thing roughly which data flowerpot be stored for tracking by the user.

For example, an entity offer be a node, and the data that will be stored for that entity can be: the customer?s account number, the customer?s name, the customer?s mastermind and the customer?s echo number. Relationship is the interaction adjoin by entities. For example, a customer which is an entity places an order at the partnership?s web-store which is also some other entity. Placing the order is the link among 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: Orderessay

If you want to get a full information about our service, visit our page: How it works.