database assignment 1.docx - ICT285 Databases Assignment 1 1 a InstructorName AND Specialty(INSTUCTOR b ClassName Description>60(CLASS c ClassName=

database assignment 1.docx - ICT285 Databases Assignment 1...

This preview shows page 1 - 5 out of 14 pages.

ICT285 Databases Assignment 1
Image of page 1
1 a. InstructorName AND Specialty (INSTUCTOR) b. ClassName, Description>60 (CLASS) c. ClassName= ‘Aqua Deep’ OR ClassName= ‘Aqua Fit’(CLASS) – T1 T1 * T1.ClassName = SESSION.ClassName SESSION ->; T2 INSTRUCTER * INSTRUCTOR.InstructorName = T2.InstructorName T2 ->; T3 PROJECT InstructorName (T3) d. VenueName – ‘Studio 5’ ->; T1 T1 * T1.VenueName = SESSION.VenueName SESSION ->; T2 T2 * T2.SessionID = PARTICIPANT.SessionID PARTICIPANT->;T3 T3 * T3.MemberID = MEMBER.MemberID MEMBER ->; T4 T4 * T4.ClassName = CLASS.ClassName CLASS ->;T5 DayAndTime = ‘19/9/2019’ (T5) ->; T6 MemberName AND ClassName (T6) e. Capacity= >30 (VENUE) ->; T1 T1 * T1.VenueName = SESSION.VenueName SESSION ->; T2 T2 * T2.SessionID = PARTICIPANT.SessionID PARTICIPANT->;T3 T3 * T3.MemberID = MEMBER.MemberID MEMBER ->; T4 T4 * T4.ClassName = CLASS.ClassName CLASS ->;T5 MemberName(T5)
Image of page 2
f. DayAndTime = ‘19/9/2019’ (SESSION) ->; T1 T1 * T1.SessionID = PARTICIPANT.SessionID PARTICIPANT->;T2 T2 * T2.MemberID = MEMBER.MemberID MEMBER ->; T3 SessionID AND DayAndTime AND NumberOfPlaces AND ClassName AND VenueName AND InstructorName AND MemberName g. VenueName – ‘Studio 1’ AND ‘Studio 2’ (Venue) ->; T1 T1 * T1.VenueName = SESSION.VenueName SESSION ->; T2 T2 * T2.InstructorName = INSTRUCTOR.InstructorName INSTRUCTOR ->; T3 InstructorName (T3) h. T1 * T1.VenueName = SESSION.VenueName SESSION ->; T2 T2 * T2.SessionID = PARTICIPANT.SessionID PARTICIPANT->;T3 T3 * T3.MemberID = MEMBER.MemberID MEMBER ->; T4 T4 * T4.ClassName = CLASS.ClassName CLASS ->;T5 SuitableFor = ‘Over 60S’ or VenueName = ‘Warm Water Pool’ (T5) ->; T6 MemberName (T6) i. CLASS * CLASS.ClassName = SESSION.ClassName SESSION ->; T1 T2 * T2.SessionID = PARTICIPANT.SessionID PARTICIPANT->;T2 T3 * T3.MemberID = MEMBER.MemberID MEMBER ->; T3 ClassName = ‘Zumba’ ->; T4 T3 MINUS T4 ->; T5 MemberName (T5)
Image of page 3
j.
Image of page 4
Image of page 5

You've reached the end of your free preview.

Want to read all 14 pages?

  • One '14
  • Relational model, Candidate key, Database normalization

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes