explain 1.The serial number attribute in TeamClue is 1 if this is the rst clue (

Question

explain

1.The serial number attribute in TeamClue is 1 if this is the rst clue (delivered at the start gps position) for a team, 2 if it is the second clue for a team (delivered

at the place where they answered their rst clue: location gps for Clue), 3 if it is their third clue (delivered at the place where they answered their second clue).

2.In Clue, prompt is the text of the clue; for example In the library where genetically equivalent students might be manufactured, how many pains are

there?" Answering it would involve going to the Klohn Commons and counting the number of panes of glass. Maybe the answer is 42. Acceptable answers

might be "" or orty-two".

3.We will handle the derived attribute for last used" in the Clue table differently. Make an attribute for it.

Road Rally date. start gps end. stuck phone-hum AIN lean num pen me Team Chue Clue. Serial num Cluet date answer rom clue id /ocation gps L distance last use lme given longs ersion Person cellinum num highes

Explanation / Answer

Answer: -

1) Create table Road Rally .

CREATE TABLE dbo.Roadrally
(
Pk_roadrally_Id INT IDENTITY PRIMARY KEY,
Date Datetime,
strart gps VARCHAR(255),
end gps VARCHAR(255),
stackphashenum int,
);

2) Create Table Team details with Roadrally.

CREATE TABLE dbo.Team
(
Pk_team_Id INT PRIMARY KEY,
license plate VARCHAR(255),
number int,
timepenalty varchar(255),
disqualified varchar(255)
Fk_roadrally_Id INT UNIQUE FOREIGN KEY REFERENCES dbo.Team(Pk_team_Id)
);

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.