Answered step by step
Verified Expert Solution
Question
1 Approved Answer
From this form, please normalize UNF, 1NF, 2NF, 3NF. Then, after that make the ERD based on the normalization results Seminar Attendance Form EventCode: AB001
From this form, please normalize UNF, 1NF, 2NF, 3NF. Then, after that make the ERD based on the normalization results
Seminar Attendance Form EventCode: AB001 EventName: SQL For Data Science Date : 10 May 2017 SpeakerName : Albert SpeakerEmail: albert07@gmail.com Gender: Male Phone Number: +1 566 873 0992 Attendance No Studentld 1 2 3 4 5 AT001 AT002 AT003 AT004 AT005 Name Address Kennedy Chicago Phoenix New York Boston Las Vegas Jean Hellen Joe Dessy Email kennedy@gmail.com jean@gmail.com hellen@gmail.com joe@gmail.com Dessy@gmail.com Roomld: TY01 RoomName: ES1 Capacity: 500 people Certificate: Yes Phone +1 777 666 9082 +1 778 753 9824 +1 765 973 0084 +1 876 0885 9922 +1 873 8836 0853 Staff, SeatNumber 1 Gender Male Male 4 Female 9 Male Female 7 2 Joseph Alexandre
Step by Step Solution
There are 3 Steps involved in it
Step: 1
The given relation is 1NF because the relation doesnt have any multivalued or composite attribut...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started