Final Part A

Final Part A
Students’ Name
Professors’ Name
Institution affiliation

Question 1
Tables
•Client (client code, client name, email, phone, interest, organization code).
•Attendance list (attendance code, event code, client code).
•Invitation list (invitation code, client code, event code).
•Events (event code, event name)
•Organization (organization code, organization name, organization type).

Entity relationship diagram (ERD)
4448175105410Invitation list
Invitation code
Client code
Event code
0Invitation list
Invitation code
Client code
Event code

4448175106045952500106045Client list
Client code
Client name
Email
Phone
Interest
Organization code
0Client list
Client code
Client name
Email
Phone
Interest
Organization code

2419350298452419350192405043053003937000241935018224500952500106045
444817550165Event
Event code
Event name
0Event
Event code
Event name

430530060325002438400165100002419350603250024193501651000444754031750
2428875174625002438400603250024193501746250359092517462500
180975038100016478253810001809750381000
17145008001000345757527051000952500203835Organization affiliation
Organization code
Organization name
Organization type
0Organization affiliation
Organization code
Organization name
Organization type

3105150103506Attendance list
Attendance code
Event code
Client code
0Attendance list
Attendance code
Event code
Client code

31051501282…