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

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

Use Tuple Relational Calculus (TRC) to answer the samequeries

(a) List the names, phones and join times of all swimmers joining CLYSTMS after 1/1/2015 LNameFName Phone l joinTime Khan Bil

This 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 join times of all swimmers joining CLYSTMS after 1/1/2015 LNameFName Phone l joinTime Khan Billy 832-116-2992 1 2015-12-12 | Khan | Nina 832-116-29921 2016-05-12 I Johnson1 Philipl713-222-1010 1 2015-05-15 I (b) List the names of the swimmers who have Azalea Khan as the primary main caretaker I LName FName I | Khan Bobby Khan Billy I (c) List the names and emails of all other caretakers (not including the main caretaker) of Bobby Khan I LName FName Email Khan I JosephI the JKhan@gmail.com I Khan I Jim theJKhan2@gmail.com I % 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 join times of all swimmers joining CLYSTMS after 1/1/2015 LNameFName Phone l joinTime Khan Billy 832-116-2992 1 2015-12-12 | Khan | Nina 832-116-29921 2016-05-12 I Johnson1 Philipl713-222-1010 1 2015-05-15 I (b) List the names of the swimmers who have Azalea Khan as the primary main caretaker I LName FName I | Khan Bobby Khan Billy I (c) List the names and emails of all other caretakers (not including the main caretaker) of Bobby Khan I LName FName Email Khan I JosephI the JKhan@gmail.com I Khan I Jim theJKhan2@gmail.com I
% 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 *