shows a basic ERD for an event's database. As shown, there are 4 entities: a. Event:...

  

Transcribed Image Text:

shows a basic ERD for an event's database. As shown, there are 4 entities: a. Event: shows the event, for example a conference on new database trends. b. Location: shows the location of an event can take place, for example SJ convention center in downtown San Jose or online (through zoom) or both. c. d. EventParticipants: shows a person as a participant of the event. For example, John Smith can attend the DB conference as keynote speaker (role) or a regular attendee. Pay attention to the relationships between the entities. All relationships have been identified as one to many (1:M) with one mandatory and many as optional. 2. Use SQL to design the following database. PK eventID name start Time end Time date Person: shows a person who would potentially attend the event. For example, John Smith. Event eventDescription FK participant FK location D EventParticipant HPK participanti role FK person 3. Create the tables with proper PK and FK Location HPK locationID location Description name address Person HPK personi firstName lastName 4. Populate the database with at least 3 entries for each category. (Use SQL to insert records). You will have to insert PK first before you can add a foreign key. 5. Make the following queries and display the results: a. All events that start at the same date (make sure you add two events with the same date in steps 3 and 4). b. All the participants as a keynote speak (set the role in EventParticipant table as keynote speaker). Set at least two participants as keynote speaker in steps 3 and 4. 6. Submit your SQL code, your database/table entries and print out of the query results. shows a basic ERD for an event's database. As shown, there are 4 entities: a. Event: shows the event, for example a conference on new database trends. b. Location: shows the location of an event can take place, for example SJ convention center in downtown San Jose or online (through zoom) or both. c. d. EventParticipants: shows a person as a participant of the event. For example, John Smith can attend the DB conference as keynote speaker (role) or a regular attendee. Pay attention to the relationships between the entities. All relationships have been identified as one to many (1:M) with one mandatory and many as optional. 2. Use SQL to design the following database. PK eventID name start Time end Time date Person: shows a person who would potentially attend the event. For example, John Smith. Event eventDescription FK participant FK location D EventParticipant HPK participanti role FK person 3. Create the tables with proper PK and FK Location HPK locationID location Description name address Person HPK personi firstName lastName 4. Populate the database with at least 3 entries for each category. (Use SQL to insert records). You will have to insert PK first before you can add a foreign key. 5. Make the following queries and display the results: a. All events that start at the same date (make sure you add two events with the same date in steps 3 and 4). b. All the participants as a keynote speak (set the role in EventParticipant table as keynote speaker). Set at least two participants as keynote speaker in steps 3 and 4. 6. Submit your SQL code, your database/table entries and print out of the query results.

Answer rating: 100% (QA)

It looks like youre being asked to create a database schema based on the provided EntityRelationship Diagram ERD populate the tables with some data and then run a couple of specific SQL queries Step 3 ... View the full answer