Register

Homework Help Question and Answers

Submit a new Query

Recent Homework Help Question & Answers


Question 37294

posted 1 years ago

A tuple in Tutor may be:
('t1', 'Jackson', `Jenny', 's101', 'Steve', 'Adams', 'sub101', 'Physics', '2019-01-11',
[3] (25%) Consider the following relation Tutor (which stands for tutoringassiqnments):
Tutor(TutorId, TLName, TFName, StudentId, SLName, SFName, Subjectīd,SubjectName, StartDate, Level).

View answer

Question 37293

posted 1 years ago

(25%) List the candidate keys and the highest normal forms for the following(2)relations.
[a] R(A,B,C,D) {C->AD}
[b] R(A,B,C,D) {C->A, A->BD}
[c] R(A,B,C,D) {C->A, A->C, AC->B, B->D, D->B}
[d] R(A,B,C,D) {С->А, А->, АС->BD}
[e] R(A,B,C,D) {C->B, BD->AC}

View answer

Question 37295

posted 1 years ago

meaning that the tutor with id 't1' and name 'Jenny Jackson is assigned as the tutorfor the student with id 's101' and name 'Steve Adams' on the subject 'Physics' (withthe subject id 'sub101') starting on 2019-01-11 at Level 4.

View answer

Question 37427

posted 1 years ago

(2) List the names of the swimmers who has the same last name as their primary care takers.

View answer

Question 37433

posted 1 years ago

(8) List the swimmers (names and their number of participated events) who have participated in two or more '100M' events (events with '100M' in their titles) in the following format. Note the order of the result is in descending of the counts of 100Mevent participations.
Turn in CSCI4333_<<Section #>>_H6_<<Your name>>_<<Your StudentID>>.sql.txt and submit your homework through Blackboard. It must be done in text format executable by the TA using the source command.

View answer

Question 37426

posted 1 years ago

(1) List the names, phones and join times of all swimmers joining in the years of2014 to 2017.

View answer

Question 37429

posted 1 years ago

(4) List the names of the swimmers who have participated in both event #1 and event #9.

View answer

Question 37430

posted 1 years ago

(5) List the names of swimmers who have participated in meet #1 but not meet#3.

View answer

Question 37431

posted 1 years ago

(6) List the numbers of events on distances. Assume that the event title uses the format of "<distance>M <style>", e.g. "50M Butterfly". Note the order of the result is in ascending distance.

View answer

Question 37432

posted 1 years ago

(7) List the names of all swimmers and their number of wins (the number of times with the word Winner in the result in an event) in the following format.

View answer

Questions not Found

Most popular subject

Thermodynamics

Essay/Summary

Mechanics

Complex Analysis

Engineering Economics

Calculus

Modern Physics

General Chemistry

Strength Of Materials

Fluid Mechanics

x