Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Using the descriptions of the attributes given in the figure, convert the ERD shown in Figure P6.2 into a dependency diagram that is in at
Using the descriptions of the attributes given in the figure, convert the ERD shown in Figure P6.2 into a dependency diagram that is in at least 3NF.
Presentation ERD for Problem 2 FIGURE P6.2 PRESENTATION REGISTRATION ATTENDEE PK Att Num PK,FK1 Pres Order PK,FK2 Att Num Att FName Att LName Att Status Pres Date Pres Room Pres Title Pres AuthorlD Pres FName Pres LName Reg Date Reg Date: The date the attendee registered. Att Num: System-generated number Att Fname: The first name of the attendee Att Lname: The last name ofthe attendee Att Status: Whethe o not the attendee has paid the registration fee Pres SessionNum: System generated number Pies Oid Number indicating the order of the presentations duing the Pies Date: The date that the presentation is scheduled to be given. Pies Room: The oom in which the presentation will be given. Pres Title: The tle of the piesentation. Pres AuthorlD: System-generated umber assigned to presentation authors. Pres Fname: The first name of the presentation author Pres Lname: The last name of the presentation author Presentation ERD for Problem 2 FIGURE P6.2 PRESENTATION REGISTRATION ATTENDEE PK Att Num PK,FK1 Pres Order PK,FK2 Att Num Att FName Att LName Att Status Pres Date Pres Room Pres Title Pres AuthorlD Pres FName Pres LName Reg Date Reg Date: The date the attendee registered. Att Num: System-generated number Att Fname: The first name of the attendee Att Lname: The last name ofthe attendee Att Status: Whethe o not the attendee has paid the registration fee Pres SessionNum: System generated number Pies Oid Number indicating the order of the presentations duing the Pies Date: The date that the presentation is scheduled to be given. Pies Room: The oom in which the presentation will be given. Pres Title: The tle of the piesentation. Pres AuthorlD: System-generated umber assigned to presentation authors. Pres Fname: The first name of the presentation author Pres Lname: The last name of the presentation authorStep by Step Solution
There are 3 Steps involved in it
Step: 1
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