Draw an E-R diagram of the system below. (Make sure that your E-R diagram is based on your data model that is normalized to 3NF). Identify on your E- R diagram: primary keys, foreign keys, relationship types and their multiplicity. Note: MS Access generated E-R diagram will not be accepted for part (b) and will not receive any marks.

 

1 - SeminarDetails

Seminar ID (PK)

Title 

Start date 

End date 

Topic of the seminar 

Venue (FK)

 

2 - VenueDetails

Venue ID 

Venue name 

Street number

Street name 

City 

State 

Website address 

 

3 - SeminarAttendeeFormDetails

Form number (PK)

Title

First name 

Last name 

Address (FK)

E-mail address 

Seminar number 

Number of days attending 

Credit card number 

Expiry date 

 

4 - TraderShowExhibitionDetails

Trade show number (PK)

Seminar number (FK)

 

5 - TraderDetails 

Trader number (PK)

Title 

First name 

Last name 

Address (FK)

E-mail address 

 

6 - TraderShowParticipationFormDetails

From number (PK)

Title 

First name 

Last name 

Address (FK)

E-mail address 

Seminar number 

Number of days attending 

Credit card number 

Expiry date 

Products and services 

 

7 - SubjectMatterExpertDetails

Subject matter expert ID (PK)

First name 

Last name 

Address (FK)

E-mail address 

 

8 - PresenterDetails

Presenter number (PK)

First name 

Last name 

Address (FK)

E-mail address

Qualification 

 

9 - ReviewerDetails

Reviewer ID

Title 

First name 

Last name 

Address 

E-mail address 

 

 10 - StaffDetails

Staff ID (PK)

Title

First name 

Last name 

Address 

E-mail address 

Telephone number 

Branch number (FK)

 

11 - BranchDetails

Branch ID (PK)

Address (FK)

Telephone number

 

12 - ContactDetails 

Telephone number 

Branch number 

Staff number 

 

13 - InvoiceDetails

Invoice number (PK)

Seminar number (FK)

Trade show number 

Due date 

Amount 

Payee name 

Issuing staff 

 

14 - AttendeesPaymentDetails

Payment ID (PK)

Seminar number (FK)

Amount paid 

Date of payment 

Payment type 

 

15 - TraderPaymentDetails

Payment ID (PK)

Seminar number (FK)

Trader number 

Amount paid 

Date of payment 

Payment type 

 

16 - AttendeesReceiptDetails

Receipt number (PK)

Attendee number 

Date of payment

Amount paid 

Invoice number 

 

17 - TradersReceiptDetails 

Receipt number (PK)

Trader number

Date of payment 

Amount paid 

Invoice number 

 

18 - Author'sDetails 

Author Identifier (PK)

First name 

Last name 

 

19 - PublisherDetails

Publisher number (PK)

Publisher name 

Address 

E-mail address 

 

20 - BookDetails

Book Identifier (PK)

Price 

Title 

Author's name

Publisher name  

Answer rating: 100% (QA)

Draw an ER diagram of the system below Make sure that your ER diagram is based on your data model that is normalized to 3NF Identify on your E R diagram primary keys foreign keys relationship types an... View the full answer