ISM 641 Database Design & Management ERD Creation & Entities Discussion

Prior to beginning work on this interactive assignment, read Chapter 4 of your textbook and the Fundamentals of Relational Database Design (Links to an external site.), Entity Relationship Diagram (Links to an external site.), Ten Common Database Design Mistakes (Links to an external site.), and 10 Best Practices in Database Schema Design (Links to an external site.) online resources, and review any relevant information in this weeks lecture.

Carefully review the instructions for the Week Six Database Design Project assignment including the ISM641 Database Design Project: Business Rules document downloadthat includes the entities and attributes information. This will become part of your final assignment in the course.

Analyze the user needs as laid out in the Business Rules document download. Access your Virtual Lab and use Visio to create an entity-relationship diagram (ERD) from the entities and attributes listed for the ConstructCo Database Project. Your ERD must include the following.

Identify all entities and attributes
Define all relationships between entities (including proper relation semantics)
Select the appropriate data types for each of the attributes
Identify your primary keys

Once you have created your Visio, save it as a PDF and download to your computer from Practice Labs. Attach your ERD PDF to your initial post. In your written initial post explain the process you have selected in order to build the ERD and any challenges you might have experienced. List any tips that might be helpful to anyone planning to build an ERD. Discuss how you selected the different data types for your attributes and what considerations to take into account when selecting data types. Describe how you selected your primary keys for each of the tables and whether other attributes could have been selected as primary keys. Finally, review the benefits of using a database-agnostic tool like MS Visio versus the ERD building tools already available with most Relational Database Management System (RDBMS).

Guided Response: Review several of your colleagues posts, and respond to at least two of your peers by 11:59 p.m. on Day 7 of the week. You are encouraged to post your required replies earlier in the week to promote more meaningful interactive discourse in this interactive assignment.

For your response you will take on the role of a data modeler or database architect (refer to Defining the Role of the Data Architect (Links to an external site.)). Carefully examine your colleagues ERD and determine whether all required entities and related attributes have been identified. Analyze the strengths and weaknesses presented in the ERD and explain at least one limitation including any missing entities or attributes. Suggest alterations to the diagram that might correct or mitigate the limitation(s) found. (Once you have completed your required responses, review your instructor and peer feedback and make changes to your ERD based on these. You will be including the revised ERD in your final Database Design Project.)

Our Service Charter

1. Professional & Expert Writers: Writers Hero only hires the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.

2. Top Quality Papers: Our customers are always guaranteed papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.

3. Plagiarism-Free Papers: All papers provided by Writers Hero are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.

4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. Writers Hero is known for timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.

5. Affordable Prices: Our prices are fairly structured to fit all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses.

6. 24/7 Customer Support: At Writers Hero, we have put in place a team of experts who answer all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.