Subject: Relational Database Program: MySQL Workbench Here is an example of what
ID: 3736809 • Letter: S
Question
Subject: Relational Database
Program: MySQL Workbench
Here is an example of what I need made from this:
For this assignment you will be designing and creating a database for Coastal Publishing. The publisher has been using a primitive method to keep track of Authors, their Agents, Books, and their Editors, so they have hired you to help create a database to hold the appropriate information. They have already contracted the creation of the following ER diagram that will serve their needs AuthorLastName BookGenre (O) AuthorName ) BookTtle BookPubishDate Authori AUTHOR Writes BOOK BookNumPages Represents Edits EditorFirstName AgentiD AGENT AgentPhone EditoriD EDITOR (EditorName) Mentor Mentoree ( AgentName) EditorLastName Mentors AgentLastName Part 1: EER Diagram Begin by using MySQL's Workbench to create the EER Diagram that corresponds to the ER Diagram above. Be sure to name your schema CoastalPublishing. Save the image of your EER Diagram for submission, and give it the name CostalPublishingEER.Explanation / Answer
There are some attributes you are missing here. I am not sure how much detailed information you want to store here but the attribute for each entities are quiet less.
For Course -> you can add course duration, credit poiint, If its a lab course or theory.
For class -> You can add the capacity, you can include venue as well along with date and time. Also I beleive a calss_id is also important here to establish a relationship between other attributes and class.
For section -> You can add capacity also if you not taking the capacity attribute in the class object.
For Student -> You can store their additional inforamtion like email ( its important for the communications ) also his/her phone number and other personal informations.
Also I beleive there might be a relationship directly between class and student. Its important we track the student and class relationship directly. Otherwise the design looks fine.
Do let me know if you need any other help....Please upvote :) ....Have a great day !!