Normalization & Relationships
Look at the attachment for more details on the assignment. In the word document, you need to be very detailed if it’s going to be more than three pages or less, please let me know. Entity-relationship diagrams (ERDs) can be found in many styles. In this assignment, you will be building upon a provided ERD. Even within the style of the diagram provided, there are different options for representing relationships. You may choose any style to use, but you must be consistent within your diagram. If you would like to view different styles of diagrams, you can look at this variety of examples. Download this ERD, and save it to your computer in a folder where you save your assignments for this course. You will expand the provided diagram to include additional entities and relationships. As you will see, the diagram contains a general set of entities that might be used for employees of any type of organization. As you plan the expansion of your diagram, it is important to identify the type of organization or a specific organization that you are now designing the database for. You will add entities that relate to the existing ones in the diagram. Remember, each entity becomes a table when you build your database in your database management system. The provided diagram called Start_U3.drawio includes four entities, as follows: Department Product/Service Employee Customer You must decide what organization your diagram is for and then determine what two new entities must be added to your diagram to fit the needs of your organization.