Questions 8-15 will all deal with the database described by the following set of
ID: 3734758 • Letter: Q
Question
Questions 8-15 will all deal with the database described by the following set of relation schemas and data dictionaries Tornado(Tornadold. EFScaleRating, Duration) Shark(Tagld, Species, ToothCount, Tornado) Victim(VictimId, FirstName, LastName, Shark) Tornado: Records shark-infested tornados (waterspouts, actually, but "Sharkspout" really doesn't have uch of a ring to it, now does it?) ornadold FScaleRating Rating on the Enhanced Fujita NUMBER(1)1-5 Domain All Attribute Name Description atatype ullable PK FK nique Id of the tornado HAR(8) 0 cale uration ow long the tornado lasted in NUMBER(3)1-999 0 nutes hark: Sharks picked up by tornados Attribute Name Description atatvpe omain ullable PKFK Serial number of tracking tagCHAR(12) All 0 0 mehow affixed to shark as it swirled around in a tornado- just go with it, people Species of shark How many teeth Tornado shark was in cies oothCount ornado ARCHAR2(100) All UMBER(4) HAR(8) 0 0 1-2000 All 0 0 0 0Explanation / Answer
8) c.EFScaleRating
First of all we need to know about the scalerating.So that we can keep that as check constraint to know the victims effected approximately .
9)d. All three tables would need to have references
10)a)2 because constraint specification is not allowed there
11)d) A primary key of char type
12) a)insert into shark values('ABCD1234WXYZ','TIGER','TORNADO1');
SHARK table contains 4 columns and in option only 3 values have been specified and
we need to specify the column names to insert data into specific columns
13) d)duration is not required
14) c)4 we need to use having instead of where
select species,sum(toothcount)
from shark
group by species
having sum(toothcount)>1000;
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.