Create the Relational Model for the Flubber database based on your ER Diagram, meeting all the same requirements. This should be syntactically correct to test in a MySQL database.

 

Transcribed Image Text:

1. Create an Entity-Relationship Diagram with the following requirements. (25 points) A. There are Professors (ie users) with the changeable attributes Professor_Name, Field, College, PhD_Date B. There are Flubs with the unchangeable attributes Content, Purpose, Moment, Inventor (which is the creating Professor) C. There are Bounces where a Professor can share another Professor's Flub D. Add ID attributes as necessary E. Content is only text of a fixed length for version 1.0 but should be expandable later F. Professors can have/be Colleagues G. A Flub can get Citations by other Professors 1. Create an Entity-Relationship Diagram with the following requirements. (25 points) A. There are Professors (ie users) with the changeable attributes Professor_Name, Field, College, PhD_Date B. There are Flubs with the unchangeable attributes Content, Purpose, Moment, Inventor (which is the creating Professor) C. There are Bounces where a Professor can share another Professor's Flub D. Add ID attributes as necessary E. Content is only text of a fixed length for version 1.0 but should be expandable later F. Professors can have/be Colleagues G. A Flub can get Citations by other Professors

Answer rating: 100% (QA)

a picture of ER Diagram of given Relational data Model Now find the syntax ... View the full answer