Complete the following:

Part II: Using the the grade report below (which is not in our textbook) create an ERD for a database to store this information. Instructions

Follow the instructions below:

For all the problems use the Crow's foot notation. Do not create the Chen or UML diagrams, even if the author tells you to do so.Include connectivities (tick-marks and circles).You do not need to include verbs on your relationships. The exception is if there are two or more relationships between the same two tables.Include all the attributes described in the problem. Note that for some of these problems the author has intentionally left out most/all of the attributes. Do not make up non-key attributes.Your ERD should include the appropriate primary keys and foreign keys, even if the author omitted them. Create them if necessary. Keep it simple and straight forward. If you have a Product entity then an appropriate primary key would be Product_Number or Product_Id.Include solid or dashed lines for strong/weak relationships.Do not use multi-valued attributes or derived attributes.I only need the completed ERD in Crow's foot notation. You do not need to answer any of the author's questions, create lists, etc. When the author says to identify something you should include it in the ERD.Do not use any ternary relationships. Convert these into one to many relationships.Make sure you have no redundant data. See section 3-7 starting on p. 101 (12th edition).

Other NotesThe point level for this assignment has increased.This assignment may take you longer to complete than previous assignments. Don't wait until the last day.Do not complicate the problem by adding to it. Your imagination can lead you astray. Do not add non-key attributes or entities that are not explicitly in the problem. Note that this is very easy to do without thinking about it. The human mind likes to fill in the blanks.Don't forget that instances of entities (rows in tables) never show up on an ERD.The organization that the database is for is almost never an entity. Often times it is never stored in the database.Some information in the problems is irrelevant to the ERD. This is common in data modeling.

HW04a.png TABLE 4-4 Grade Report Relation Grade Report Instructor Instructor Name Location Grade StudentiD StudentName CampusAddress Major CourselD CourseTitle 168300458 Williams 168300458 Williams 543291073 Baker 543291073 Baker 543291073 Baker B 104 208 Brooks 208 Brooks 104 Phillips 104 Phillips 104 PhillipsAcctg IS 350 Database Mgt Codd IS IS Acctg IS 350 Database Mgt Codd Acctg Acct 201 Fund Acctg IS 465 Systems Analysis Parsons B317 B B 104 C H310 B A Miller Mkgt 300 Intro Mktg Bennett B 212 ere to search