Create an ERD to represent the conference database. Your ERD should include the following information:

1. The name and columns of each table.
2. An indication of primary and foreign keys in each table.
3. The relationships between tables, including ordinality.

You may use whatever notation you prefer, so long as each of the above requirements is clear.

Your ERD can be scans or pictures of legibly written diagrams or digital diagrams. It should be a pdf, PNG, or JPEG file

1. An attendee should have a full name, a mailing address, and email address, a date of birth, and an associated university. Attendees may have up to one associated institution. GBS tickets are sent via mail, so the mailing address is mandatory.
2. Each institution should have a name and a country.
3. Attendees are allowed to submit publications for exhibition. Publications are submitted by one or more associated attendees, and each attendee can submit any number of publications for exhibition.
4. A publication should have a title, author(s), a publication journal, a publication date, and a summary. A publication can be submitted only if it is published by attendees; that is, all authors must be attendees, and it must have a publication journal and date.
5. Attendees may vote for the viewers choice award for best publication. Each attendee may submit any number of votes for the award, but cannot vote for the same publication more than once.