CourseSession Enrollment ses ID: NUMBER(6) ses date: DATE Course % part ID: NUMB

Question

CourseSession Enrollment ses ID: NUMBER(6) ses date: DATE Course % part ID: NUMBER(6)(FK) has, ses ID NUMBER(6) (F relates to enroll_attending: CHAR(1) offered throughcourse number: VARCHAR(5) based orn ses time: VARCHAR10) ses roomNumber: VARCHAR(S) ses enrollmentNumber. NUMBER(3) course number: VARCHAR(5) (FK) course-name VARCHAR(50) course description: VARCHAR(650) course capacity: NUMBER(3) enrolls with / isfor Participant part ID: NUMBER(6) VolunteeringTime part fName: VARCHAR(100) part IName: VARCHAR(100) part address: VARCHAR(200) part_city: VARCHAR(100) part zipcode: NUMBER(5) part _phone: VARCHAR(20) part_ email: VARCHAR(50) (AK1.1) part_dateOYBirth: DATE part ID NUMBER)(FK) volTime arrivalTime: DATE volTime_leaveTime: DATE volTime date: DATE volunteers and captures times in / recordings volunteering time from volTime durationinMinutes: NUMBER(3) BikeType gets bike through gives bike to btype_ID: NUMBER(4) btype name: VARCHAR(20) Bike bike serialNumber: NUMBER(6) bike_name: VARCHAR(40) GiveAway categohizes/ categorized in giveaway ID: NUMBER(6) giveaway _date: DATE part ID: NUMBER(6) (FK) bike serialNumber: NUMBER(6) (FK) is given away through gives away bike brand: VARCHAR(50) bike sizelninches: NUMBER(2) bike condition: VARCHAR(20) bike volunteerTimelnHrReq: NUMBER(4) bike comment: VARCHAR(350) btype _ID: NUMBER (FK)

Explanation / Answer

Select Participant.part_ID,part_lName,giveaway_date from Participant left inner join GiveAway on Participant.part_ID = GiveAway.part_ID ;

left inner join is used as it will display all participants even though there is no matching giveaway date.

Do ask if any doubt. Please upvote.

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.