Create a list of possible entities for the speaker database


Discuss the below scenario in detail:

The scenario is that the Public Affairs Office at Highline University receives requests for speakers on particular topics. To be able to respond to such request, that office wants to build a database. In particular, it wants to keep track of topics, speakers, speeches, and organizations to which someone from Highline has spoken.

A. Make a list of possible entities for the Speaker database.

B. Create an IDEF1X E-R diagram showing only entities. Assume that there is an M:N relationship between SPEAKER and TOPIC.

C. For each relationship in your diagram, specify the relationship type, and the minimum and maximum cardinality on both parent and child. Name each relationship.

Solution Preview :

Prepared by a verified Expert
Database Management System: Create a list of possible entities for the speaker database
Reference No:- TGS01939418

Now Priced at $20 (50% Discount)

Recommended (96%)

Rated (4.8/5)