Menu
support@nursinghomework.org
+1 714-215-3097

(Solved) : Use Tuple Relational Calculus Trc Answer Queries Er Diagram Q35614219

Use Tuple Relational Calculus (TRC) to answer the samequeries

(a) List the names, phones and current level id of all swimmers with current level id >3. LNameEName Phone currentLeveild I Kthis is the ER diagram

% FR Assistant- [CLYSTMS-sol (1)] File Edit View Insert Mode Window Help LevelHistory -for-. .. ·..-Other caretaker-,-.. ..

(a) List the names, phones and current level id of all swimmers with current level id >3. LNameEName Phone currentLeveild I Khan Bobby 832-116-2992I I Johnson I Clara 713-222-1010I (b) List the names and level’s names of the swimmers with the last name ‘Khan’. I LName FName I level I Khan Bobby Yellow I I Khan Billy BlueI Khan Nina BlueI (c) List the swimmer names who have participated in the event ’50M Butterfly’ of the meet ‘UHCL Open’. I LName IFName Khan I Billy Khan I Nina I I Johnson | Philip % FR Assistant- [CLYSTMS-sol (1)] File Edit View Insert Mode Window Help LevelHistory -for-. .. “·..-Other caretaker-,-.. .. FName by- RescindTime Phone EMai JoinTime …-…-Main caretakerPhone Comment on. Level V Task in–Comment NumV FName Result Phone V TaskList of on Penaity PenaltyAmt of Event Meet tt etid Title Date StartTime EndTime State ZipCode Show transcribed image text (a) List the names, phones and current level id of all swimmers with current level id >3. LNameEName Phone currentLeveild I Khan Bobby 832-116-2992I I Johnson I Clara 713-222-1010I (b) List the names and level’s names of the swimmers with the last name ‘Khan’. I LName FName I level I Khan Bobby Yellow I I Khan Billy BlueI Khan Nina BlueI (c) List the swimmer names who have participated in the event ’50M Butterfly’ of the meet ‘UHCL Open’. I LName IFName Khan I Billy Khan I Nina I I Johnson | Philip
% FR Assistant- [CLYSTMS-sol (1)] File Edit View Insert Mode Window Help LevelHistory -for-. .. “·..-Other caretaker-,-.. .. FName by- RescindTime Phone EMai JoinTime …-…-Main caretakerPhone Comment on. Level V Task in–Comment NumV FName Result Phone V TaskList of on Penaity PenaltyAmt of Event Meet tt etid Title Date StartTime EndTime State ZipCode

Leave a Reply

Your email address will not be published. Required fields are marked *