he following relationships are used to keep an after-school calendar of events for students in a school. An example of this database is given below. The database can be much larger and can contain much more information than these given features, but just use the following data sets for this question. SchoolEvents database Student (student ID, name, surname, address, telephone) Activity (event_name, capacity, equipment, fee, instructorID) Location (place_name, equipment) Calendar (event_name, day, start_time, end_time, place) Registration (studentID, event_name) Instructor (trainer ID, name, surname, address, telephone, salary) Student student ID name surname address phone 123 Ali Ozturk Barbaros Cad 0 533 466 77 88 345 Ayse Kaya Tesvikiye Mah 0 505 222 33 44 Activity activity_name capacity equipment fee Music 3 piano 100 Bale 15 wooden floor 50
The following relationships are used to keep an after-school calendar of events for students in a school. An example of this
SchoolEvents database
Student (student ID, name, surname, address, telephone)
Activity (event_name, capacity, equipment, fee, instructorID)
Location (place_name, equipment)
Calendar (event_name, day, start_time, end_time, place)
Registration (studentID, event_name)
Instructor (trainer ID, name, surname, address, telephone, salary)
Student
student ID name surname address phone
123 Ali Ozturk Barbaros Cad 0 533 466 77 88
345 Ayse Kaya Tesvikiye Mah 0 505 222 33 44
Activity
activity_name capacity equipment fee
Music 3 piano 100
Bale 15 wooden floor 50
Location
place_name equipment
Hall 1 piano
Hall 2 mat
Room 1 wooden floor
Calendar
event_name day start time end time place instructorID
Music Wednesday 15.30 16.30 Hall 1 111
Ballet Monday 16.30 18.00 Room 1 333
Record
studentID event_name
123 Music
345 Ballet
123 Ballet
Instructor
egitmenID name surname address phone salary
111 Pinar Efe Nispetiye Cad 0 533 463 37 88 3000
333 Aysen Yilmaz Etiler Mah 0 505 222 11 44 5000
Relational Algebra Questions:
a) List the name, surname and telephone number of the students registered in the activities of the instructor named Pinar.
b) Find activities for which no event plan has been made yet.
c) List the activities that have not been planned according to the required equipment.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images