DATABASES For all database problems on this and the following page use the table
ID: 3582057 • Letter: D
Question
DATABASES For all database problems on this and the following page use the tables shown here: Day Names and Solar. Table Solar represents the performance of my new roof-top photovoltaic power system, installed in late March, 2016, where the Daily KWH field shows the number of kilowatt- hours produced by the system on each day. Solar is indexed on the Calendar Day field. Sola Day Names Fu Filte Day Name Full View Filter Z calendar Day Day of week Daily KwH weather Day Code Day Strin TU 12 system on at 3:45pm 3/29/2016 Sunday SU WE 3/30/2016 66 Sunny Monday MO TH 152 3/31/2016 Late clouds Tuesday 4/1/2016 FR Rainy Wednesday SA 17 Rainy 4/2/2016 4/3/2016 TH Thursda Snow, then sunny Mo o 4/4/2016 Frid Snow (6 inches) FR 4/5/2016 TU 3 sunny, snow melting SA Saturday 4/6/2016 Sunny early, then overcast TH 15 Rainy 4/7/2016 Record: 6 of 7 LD No Filter Search FR 32 4/8/2016 Sunny early, then overcast SA 9/2016 Sunny early, then overcast Num Lock 10/2016 4/11/2016 MO 12 Rainy 4/12/2016 Rainy until 1:00pm, then sunny 10 Points Examine the tables 4/13/2016 WE Sunny closely TH 75 Sunny 4/14/2016 4/15/2016 FR 74 Sunny SA 76 Sunny 4/16/2016 A. Does table Day Names have an su 4/17/2016 Sunny Mo 67 index? NO 4/18/2016 Sunny, some clouds TU 4/19/2016 Cloudy early, then sunn 63 WE 78 Sunny /20/2016 B. What is the most appropriate 21/2016 Sunny 4/22/2016 Rainy and cloudy, some sun FR numeric subtype of the Daily KWH SA 4/23/2016 Cloudy early, then sunny 62 field? BYTE 4/24/2016 SU Sunny 4/25/2016 Mo Overcast, some clearing 4/26/2016 TU 10 Rainy C. What is the minimum possible field WE 4/27/2016 Sunny width of the Day of Week field? 2 Record: I 9 of 30 No Filter Search Num Lock E How many records are in the SolarExplanation / Answer
A. Yes,The table DayNames has an index as there are no duplicate values . Day Code and Day Name have unique values. So the table must be indexed.
C. The minumum possible field width of day of week is 2 as all values have minimum two charaters to represent this field.
H. Many to One relationship is there between Day of week of table Solar and Day Code of table Day Names.
Many Day of Week values in Solar table have only one code in Day Code field of Day Names table.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.