Define all relationships between entities

Assignment Help Computer Engineering

Reference no: EM133526862

Assignment: ERD Creation

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

Carefully review the instructions for the Week Six Database Design Project assignment including the ISM641 Database Design Project: Business Rules document Download ISM641 Database Design Project: Business Rules documentthat 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 Business Rules document. 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.

1) Identify all entities and attributes
2) Define all relationships between entities (including proper relation semantics)
3) Select the appropriate data types for each of the attributes
4) 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).

Reference no: EM133526862

Questions Cloud

About childs understanding of death : Explain what a social worker could say to Dev's mother to educate her about a child's understanding of death.

Prepare a report about one product : Prepare a report about one product or service containing information that could be used for a marketing plan. You can choose a product

Which roux-en-y bariatric surgery can cause weight loss : Discuss the steps involved in using this glucose to produce energy. For each step, describe its location and oxygen requirements and name the substances produce

How can using privacy controls help preserve your privacy : Why would Google combine information from separate accounts across its services and sites have privacy implications for its users

Define all relationships between entities : ISM 641- Define all relationships between entities (including proper relation semantics). Select the appropriate data types for each of the attributes.

Why health care providers might discomfort discusing sexual : why health care providers might discomfort discusing sexual health issues, particularly in older populations. maybe lack of training?

Introduced to an examination of the affordable care act : In our readings for this part of the week, we are introduced to an examination of the Affordable Care Act (sometimes referred to as "Obamacare").

What are the implications for nursing education, practice : List at least three (3) interesting facts you learned from the article. What are the implications for nursing education, practice, and research?

Climate change and environmental degradation : Determine the impact of below mentioned external factors on business profitability: Climate change and environmental degradation Emerging technologies

User Account

All Pages