BIS245 Course Discussions Week 3

$6.50

BIS245 Course Discussions Week 3
Conceptual ERD models information gathered from business requirements…

SKU: BIS 245 Requirements Analysis Conceptual Design  Categories: , Tags: , , ,

Description

BIS245 Course Discussions Week 3

BIS245 Course Discussions Week 3

Requirements Analysis and Conceptual Design

Week 3 All Students Posts – 62 Pages 

  • Describe some typical pairs of entities that you think might be common in business, and describe their relationships, whether many-to-many, one-to-many, many-to-one, or one-to-one. Explain why you think that a particular relationship applies to that pair of entities.
  • Why do you think organizing data into tables and relationships is a good way to design a database? How do related tables improve the accuracy of data in a database?

Physical ERD represents the actual design blueprint of a relational database. It represents how data should be structured and related in a specific DBMS so it is important to consider the convention and restriction of the DBMS you use when you are designing a physical ERD. This means that an accurate use of data type is needed for entity columns and the use of reserved words has to be avoided in naming entities and columns. Besides, database designers may also add primary keys, foreign keys and constraints to the design…