your textbook and the , , , and online resources, and review any relevant information

Hello, I need help again with this. Please review before accepting bid. Plagiarism will be checked, thanks. ====================================================================== Prior to beginning work on this interactive assignment, read Chapter 4 of your textbook and the , , , and online resources, and review any relevant information in this week’s lecture. Carefully review the instructions for the Week Six assignment including the that 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 . Access your 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. 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).