6.00 Database Software
Capstone Activity
Student Directions
Directions:
Part I--Type the
following database. Save
the file as TV.
|
|
PROGRAM NETWORK
DAY TIME AM/PM
CLASSIFICATION
Days of our Lives NBC M-F
01:00 PM
Soap Opera
GeneralHospital
ABC M-F
03:00 PM Soap
Opera
Young & Restless CBS M-F
12:30 PM Soap
Opera
Boston Public FOX M
08:00 PM
Drama
Everybody Loves CBS M
09:00 PM
Comedy
Raymond
Judging Amy CBS TU
10:00 PM
Drama
24 FOX TU
09:00 PM
Drama
Pyramid CBS M
- F 10:00 AM
Game
Dr. Phil ABC M
- F 10:00 AM
Talk
Bernie Mac FOX W
08:00 PM
Comedy
West Wing NBC W
09:00 PM
Drama
Law and Order NBC W
10:00 PM
Drama
The Today Show NBC
M - F 07:00 AM
Morning/News
CBS Evening News CBS
M - F 6:30 PM
News
The Price Is Right CBS
M - F
11:00 AM
Game
ER NBC
THUR 10:00 PM
Drama
Oprah ABC
M - F
4:00 PM
Talk
Inside Edition ABC
M - F
7:00 PM
News Magazine
The Practice ABC
S
10:00 PM
Drama
The Dead Zone USA
S 10:00
PM Drama
The Wonderful ABC
S
7:00 PM
Family
World of Disney
Regis & Kelly ABC
M - F
9:00 AM
Talk
Directions:
Part II--Use your
database program and the files called TV and TVSHORT (or DB1, Table 1 for
Access) to complete the following:
1.
Read the Scenario.
2.
Use the database file to
respond to the questions below.
3.
When asked to “describe
the steps you took to find your answer,” use appropriate database terms.
For example, “Searched
the average income field for all records greater than 14000.”
|
|
Directions: Use your database program and the file
called dnba.wdb.
1.
Read the Scenario.
2.
Use the database file to respond to the questions below.
3.
When asked to “describe the steps you took to find your answer,” use
Scenario
Your
class is studying TV programs. Use the database TV
that you saved in Part I to find this information.
_____________ 1.
How many records are in this database?
_____________ 2.
How many fields are in this database?
_____________ 3.
How many programs are classified as dramas?
Explanation: Use proper database terms to describe the
steps you took to find your answer:
_____________ 4.
Of the programs that are classified as news, how many are shown in the
morning?
Explanation: Use proper database terms to describe the
steps you took to find your answer.
_____________ 5.
What program comes on the earliest in the morning?
_____________ 6.
How many programs begin no earlier than 3:00 p.m. and end no later than
7:00 p.m. M-F?
_____________ 7.
What drama airs on FOX at 9:00 p.m. on Tuesdays?
_____________ 8.
How many shows air only on Wednesdays?
_____________ 9.
How many shows begin no earlier
than 8:00 p.m. and end no later than 10:00 p.m.?
_____________ 10.
Name the shows that air on M – F beginning no earlier than 4:00 and
ending no later than 9:00 p.m. that are classified as dramas.
_____________ 11.
If you change the connector term in Question 10 from “and” to “or”
before dramas, how many programs do you have?
_____________ 12.
Create a report with the following fields: PROGRAM,
NETWORK, and CLASSIFICATION. Sort by Classification in
descending order. Filter by Network equal to NBC. How
many records are in your report?
Close TV. Open TVSHORT or
DB1, Table 1.
13. Add the following field after
Classification: Viewer. For
each program listed, put Yes or No
depending on whether or not you watch the program.
14. Add a new record to the
database. Type your favorite TV program and fill in the
information in the remaining fields. If your favorite TV
program is already in the database, type your next favorite, etc.
15. Type your name under the last
record.
16. Print the file. Make
sure to print field and record labels.
