Database Fundamentals graphic organizerStudent Activity

Student NamePeriod Date

Database Fundamentals

Page 1 of 57

Guided Practice: Search an Online Database Teacher-Demonstration

Student NamePeriod Date

Guided Practice: Searchan Online Database

Directions: You will search an online database of airlines. Go to and search for 5 round-trip flights to 5 different destinations. Answer the questions at the end of the activity when you have completed the search.

  1. Flight One

Flight # / Airline
DepartureCity / ArrivalCity
Departure Time / Arrival Time
Length of Flight / Date Leaving
# of Stopovers / Cost of Trip
  1. Flight Two

Flight # / Airline
DepartureCity / ArrivalCity
Departure Time / Arrival Time
Length of Flight / Date Leaving
# of Stopovers / Cost of Trip
  1. Flight Three

Flight # / Airline
DepartureCity / ArrivalCity
Departure Time / Arrival Time
Length of Flight / Date Leaving
# of Stopovers / Cost of Trip
  1. Flight Four

Flight # / Airline
DepartureCity / ArrivalCity
Departure Time / Arrival Time
Length of Flight / Date Leaving
# of Stopovers / Cost of Trip
  1. Flight Five

Flight # / Airline
DepartureCity / ArrivalCity
Departure Time / Arrival Time
Length of Flight / Date Leaving
# of Stopovers / Cost of Trip

Page 1 of 57

DatabaseActivity 3

Student NamePeriod Period

Questions:

  1. What are the field names?
  1. What is the name of the database?
  1. How many entries were recorded in your search?
  1. How many records were searched?

Page 1 of 57

Data Types and Field Properties graphic organizerStudent Activity

Student NamePeriod Date

Page 1 of 57

Review of Database TablesStudent Activity

Student NamePeriod Date


Review of Database Tables

Part I Directions: Match the letters above with their definition below.

Page 1 of 57

Review of Database TablesStudent Activity

Student NamePeriod Date

  1. Field______
  2. Record______
  3. Entry______

Page 1 of 57

Review of Database TablesStudent Activity

Student NamePeriod Date

Part II Directions: Answer the questions below using the above diagram.

Page 1 of 57

Review of Database TablesStudent Activity

Student NamePeriod Date

  1. Number of entries ______
  2. Number of records______
  3. Number of fields______

Page 1 of 57

Review of Database TablesStudent Activity

Student NamePeriod Date

Part III Directions: Identify the correct data type for each item using the list below

•Text / •Number / •Date/Time / •Yes/No
•Currency / •Memo / •Lookup Wizard
  1. 123-45-6789 (social security number)______
  2. John______
  3. $257.98______
  4. 12587 (employee ID number)______
  5. Paid/Not Paid______
  6. This item needs to be reordered. It
    is one of our best selling items.______
  7. Series of choices (low, medium, high)______
  8. December 15, 2006______
  9. (555) 555-5555 (phone number)______
  10. Pets Allowed/Pets Not Allowed______
  11. Age of students______
  12. Cost of trip______
  13. Date of Purchase______

Part IV Directions: Place the parts of a database in order from the smallest unit to the largest unit. (1 being the smallest, 5 being the largest)

•Field / •Character / •Entry / •Record

Page 1 of 57

Review of Database TablesStudent Activity

Student NamePeriod Date

1.

2.

3.

4.

5.

Page 1 of 57

Review of Database TablesStudent Activity

Student NamePeriod Date

Part V: Match the definition to the correct term.

  1. Field
/
  1. Is also a true/false field. Will contain a checkbox for yes no. Default is No.

  1. Entry
/
  1. Monetary values

  1. Record
/
  1. Creates fields that automatically enter a unique number when a record is added

  1. Text
/
  1. Includes words and/or numbers not used in calculations

  1. Number
/
  1. This format is applied to a field that will be sorted chronologically

  1. Input Mask
/
  1. Data and formulas keyed in a field

  1. Yes/No
/
  1. An efficient means of storing and retrieving data and printing reports from the stored data

  1. Currency
/
  1. One item of information in a record. Represented by a column

  1. Lookup Field
/
  1. A group of related fields of information

  1. Memo
/
  1. A format often applied to dates and times

  1. Database
/
  1. Like text, but max of 64,000 characters

  1. AutoNumber
/
  1. Allows you to create a finite set of choices for that field’s entry values

Page 1 of 57

Guided Practice: Create a Database: ComputersTeacher Demonstration

Student Name: Period: Date:

Guided Practice: Create a Database: Computers

Directions: In this activity, you will follow along with your teacher to create a database and complete the following tasks:

Page 1 of 57

Guided Practice: Create a Database: ComputersTeacher Demonstration

Student Name: Period: Date:

•Plan the structure

•Enter data

•Add records

•Delete records

Page 1 of 57

Guided Practice: Create a Database: ComputersTeacher Demonstration

Student Name: Period: Date:

  1. The first step is to plan the structure. You will be creating a computer inventory database. For each item, you have the name of the manufacturer, the serial number, the room location, and the ID number of the student to which it is assigned. Based on this information and the data below, how many fields are needed in the database?

Notes:

  1. What are appropriate field names?

Compaq / 12345 / 214 / 5
Dell / 54321 / 110 / 6
Dell / 98765 / 310 / 9
Packard Bell / 45678 / 214 / 3
Compaq / 34567 / 110 / 4
Compaq / 95425 / 111 / 8
Gateway / 55557 / 109 / 8
Dell / 90864 / 222 / 12
Dell / 123674 / 214 / 15
Gateway / 87093 / 119 / 27
Hewlett Packard / 83765 / 111 / 22
  1. In addition to assigning field names, the caption field property allows the user to enter more user-friendly column headings that will be visible when the database is viewed or printed.

Use the caption field property for each field name to assign user-friendly column headings

  1. The next step is to determine the format and size of each field

Notes:

  1. Name the database according to teacher directions and enter the data

Notes:

  1. Edit the database to add the following records:

Hewlett Packard / 88334 / 109 / 25
Compaq / 22990 / 211 / 26
Dell / 34419 / 110 / 27
Gateway / 22334455 / 214 / 28

Notes:

  1. Edit the database to delete the following 2 records:
  2. Compaq with Serial Number 34567
  3. Dell with Serial Number 123674

Notes:

Page 1 of 57

Guided Practice: Database Management: Anti-VirusTeacher Demonstration

Student NamePeriod Date

Independent Practice: Create a Database: Scavenger Hunt

Directions: In this activity, you willwork independently to create a database based on information you gather from your classmates.

  • You will need to determine field names and captions, data types, and field properties by reading the questions below.
  • Once you have determined the fields, you will survey your classmates as assigned by your teacher.
  • You will then create a database to record your results.

Survey Questions:

  1. What is your first and last name?
  2. Do you have blue eyes?
  3. What is your favorite sport?
  4. Do you have your driver’s license?
  5. Are you a Senior, Junior, Sophomore or Freshman?
  6. What is your favorite music group or band?
  7. What is your favorite food?
  8. What is your favorite color?
  9. Are you left-handed or right-handed?
  10. How old are you?


Guided Practice: Database Management: Anti-Virus

Directions: In this activity, you will follow along with your teacherto complete the following tasks as you create a database of antivirus software:

•Plan a database structure
•Determine data types and field properties
•Enter data
•Use AutoNumber / •Add captions
•Add a field
•Delete a field
•Print a table

Page 1 of 57

Guided Practice: Database Management: Anti-VirusTeacher Demonstration

Student NamePeriod Date

Step 1: Determine the structure of the database and field properties. Item 3 has been completed for you as an example.

Field Name / Data Type / Caption / Field Property / Scale / Decimal Places
NA / NA / NA
Memo / NA / NA
NA / NA
Rating / Number / Decimal / 2 / 2
NA / NA
NA / NA

Step 2: Name the database and enter the data

Popular AntiVirus Software Titles / Price / Rating
.Mac 2.5 Retail / $76.99 / 4.78
PC-Cillin 2003 / $26.99 / 4.2
Norton AntiVirus 2002 Professional Upgrade / $39.54 / 4.17
Bullguard AntiVirus Firewall / $39.99 / 4
Norton Personal Firewall 2005 / $42.50 / 4
Stomp Spy Ware X-terminator / $22.79 / 3.83
eTrust EZ AntiVirus 2005 / $24.99 / 3.8
Zone Alarm Internet Security Suite / $59.99 / 3.6
PC-Cillin Internet Security 2005 / $39.99 / 3.55
Webroot Spy Sweeper Internet Essentials Suite / $54.99 / 3.67
McAfee AntiVirus Suite / $39.99 / 4.25
Ad-Aware / $59.99 / 4

Step 3: Add a field and its data to the database.

Compatibility / Size
MAC / 64 MB
W93 / 264 MB
MAC / 264 MB
MAC / 264 MB
XP / 1 G
XP / 1 G
W95 / 264 MB
W98 / 264 MB
W95 / 64 MB
XP / 1 G
XP / 1 G
XP / 264 MB

Step 4: Delete a field.

Notes:

Page 1 of 57

Independent Practice: Create a Database: SurveyStudent Activity

Student NamePeriod Date

Independent Practice: Create a Database: Survey

Directions: In this activity, you will work independently to create a database of survey information as you complete the following tasks:

Page 1 of 57

Independent Practice: Create a Database: SurveyStudent Activity

Student NamePeriod Date

•Plan a database structure

•Determine data types and field properties

•Enter data

•Use AutoNumber

•Add a field

•Delete a field

•Print a table

Page 1 of 57

Independent Practice: Create a Database: SurveyStudent Activity

Student NamePeriod Date

Step 1: Plan the database structure. Use the table below to plan the field names and structure of the database based on the information in Step 2.

Field Name

/ Caption / Data Type / Field Size

Step 2: Enter the data

Number / Age / Income / Gender / Number of Children
1 / 34 / $25,000.00 / M / 2
2 / 45 / $100,000.00 / M / 3
3 / 88 / $50,000.00 / M / 1
4 / 25 / $26,000.00 / F / 1
5 / 21 / $39,000.00 / M / 0
6 / 58 / $57,000.00 / F / 3
7 / 45 / $37,000.00 / M / 3
8 / 46 / $90,000.00 / M / 0
9 / 40 / $58,000.00 / F / 2
10 / 36 / $60,000.00 / M / 2
11 / 36 / $72,000.00 / F / 2
12 / 66 / $22,000.00 / M / 2

Step 3: Add a field. Add the field Marital Status and enter the data in order as listed.

Marital Status
S
S
S
M
M
S
M
M
S
S
M
S

Follow teacher directions for printing, completing the final step of this activity (deletion of a field), andsubmitting your work. Ask your teacher which field to delete.

Page 1 of 57

Guided Practice: Create a Database: MusicFunTeacher Demonstration

Student NamePeriod Date

Guided Practice: Create a Database: MusicFun

Directions: In this activity, you will follow along with your teacher to create a database and complete the following tasks:

Page 1 of 57

Guided Practice: Create a Database: MusicFunTeacher Demonstration

Student NamePeriod Date

•Add fields

•Rearrange fields

•Add entries

•Apply field formats:

  • Date with Input Mask
  • AutoNumber (review)
  • Lookup
  • Yes/No

Page 1 of 57

Guided Practice: Create a Database: MusicFunTeacher Demonstration

Student NamePeriod Date

1.Create the database structure as indicated in the table below.

Field / Caption / Type / Size / Format / Description
Artist / Artist / Text / 25 / NA / Name of the artist or group
CD / Album Title / Text / 100 / NA / NA
Release / Release Date / Date/Time / Format as Short Date (Use Input Mask) / Original release date

Notes:

  1. Enter the records in the table below. When keying the date, enter a zero before any single digit numbers, such as 04/03/2008.

Artist / CD Title / Release Date
U2 / How to Dismantle an Atomic Bomb / 11/23/2004
Green Day / American Idiot / 9/21/2004
Ray Charles / Genius Loves Company / 8/31/2004
John Legend / Get Lifted / 12/28/2004
Alicia Keys / Maximum Alicia Keys / 12/14/2004
Brooks and Dunn / Red Dirt Road / 7/15/2003
Prince / Purple Rain / 10/25/1990
Doobie Brothers / Minute by Minute / 2/22/2002
Maroon 5 / Songs About Jane / 6/25/2002
Kelly Clarkson / Breakaway / 11/30/2005
Rolling Stones / It’s Only Rock and Roll / 7/26/1974
Rolling Stones / Made in the Shade / 4/5/1975
Rolling Stones / Beggar’s Banquet / 8/27/1968
U2 / War / 5/15/1983
U2 / Achtung, Baby / 11/19/1991

Page 1 of 57

Independent Practice: Create a Database: B&BStudent Activity

Student NamePeriod Date

  1. Add a new field named MusicianID. Use Auto-Number and set this field as a primary key.

Notes:

  1. Add another new field named Genre.
  2. Format the field as a Lookup and use the Lookup Wizard (or similar command relative to software) to create a drop-down list of genre options.
  3. Enter the following values for the drop-down list:
  4. Classical
  5. Country
  6. Pop
  7. R & B
  8. Reggae
  9. Rock

Notes:

  1. Use the drop-down box just completed toselect the correct genre for each of the artists.

Artist / Genre / Artist / Genre
1. / Alicia Keys / Pop / 6. / Kelly Clarkson / Pop
2. / Brooks and Dunn / Country / 7. / Maroon 5 / Rock
3. / Doobie Brothers / Rock / 8. / Prince / R&B
4. / Green Day / Rock / 9. / Ray Charles / R&B
5. / John Legend / R&B / 10. / Rolling Stones / Rock
11. / U2 / Rock
  1. Rearrange the fields:
  2. Move MusicianID to the first field in the table.
  3. Make Genre the 2nd field

Notes:

  1. Add the following entries.

Genre / CD Title / Artist / Release Date
Classical / Phantom of the Opera / Andrew Lloyd Weber / 11/23/2004
R & B / The Essential Stevie Ray Vaughan and Double Trouble / Stevie Ray Vaughan / 10/01/2002
Reggae / Legend (The Definitive Remasters) / Bob Marley / 5/21/2002
Country / Who Am I? / Jessica Andrews / 2/27/2001
R & B / Best of Bonnie Raitt (US) / Bonnie Raitt / 9/30/2003
Classical / Requiem / Wolfgang Amadeus Mozart / NA
Classical / Crimson Tide Soundtrack / Hans Zimmer / 5/16/1995
Country / Here for the Party / Gretchen Wilson / 5/11/2004
Country / Greatest Hits / Shania Twain / 11/9/2004
R & B / Confessions / Usher / 10/5/2004
Pop / Under the Table and Dreaming / Dave Matthews Band / 8/24/2004
  1. Create a yes/no field. Add a new field to the database named Under25. The caption should be Under 25?

Artist / Under 25?
Alicia Keys / Y
Kelly Clarkson / Y
Usher / Y
  1. Format the field as yes/no
  2. Click the box for each artist that is under the age of 25.

Notes:

Independent Practice: Create a Database: BB

Directions: In this activity, you will work independently to create a database and complete the following tasks:

Page 1 of 57

Independent Practice: Create a Database: B&BStudent Activity

Student NamePeriod Date

•Add fields

•Rearrange fields

•Add entries

•Format data types and field properties:

  • Date with Input Mask
  • AutoNumber (review)
  • LookUp
  • Yes/No

Page 1 of 57

Independent Practice: Create a Database: B&BStudent Activity

Student NamePeriod Date

Part I

  1. Open a new database and save it as B&B (or as instructed by your teacher). You will create a database for the Bed and Breakfast Association. Name the database table HistoricInns.
  2. Plan the database structure. Determine the appropriate field names, types, and sizes according to the information in number 3 (on the next page) and write your answers in the spaces provided in the table below. The first one has been completed for you.

Name / Caption / Data Type/ Field Property / Format/Comments
Field 1 / Inn / Memo / Field size = 50
Field 2
Field 3
Field 4
Field 5
Field 6
  1. Enter the data using the table below.

Historic Inn / No. Rooms Available / Children under 10 allowed / Located in the city / SmallTown or Mountain Community / Full Breakfast
WhiteGate Inn and Cottage (1889) / 6 / Yes / Yes / Mountain / Yes
Inn on Montford (1900) / 5 / No / Yes / Mountain / Yes
SecretGarden (1904) / 3 / No / No / Town / Yes
Abbington Green / 8 / Yes / Yes / Mountain / Yes
Albermarle Inn / 11 / No / Yes / Mountain / Yes
A Bed of Roses / 5 / No / Yes / Mountain / Yes
Biltmore Village Inn / 6 / No / Yes / Mountain / Yes
Blake House Inn / 6 / Yes / Yes / Mountain / Yes
Carolina Bed & Breakfast / 7 / Yes / Yes / Mountain / Yes
Cedar Crest Victorian Inn / 12 / No / Yes / Mountain / Yes
Chestnut Street Inn / 8 / Yes / Yes / Mountain / Yes
Colby House / 5 / Yes / Yes / Mountain / Yes
Dry Ridge Inn / 8 / Yes / Yes / Mountain / Yes
The Hawk & Ivy / 4 / Yes / No / Town / Yes
Inn on Main Street / 7 / No / No / Town / Yes
The Lion and The Rose / 5 / Yes / Yes / Mountain / Yes
North Lodge on Oakland / 6 / Yes / Yes / Mountain / Yes
Owl's Nest Inn at Engadine / 7 / No / No / Town / Yes
  1. Add a new field so guests will know if pets are allowed. Inns allowing pets include the following:

Page 1 of 57

Independent Practice: Create a Database: B&BStudent Activity

Student NamePeriod Date

  • Abbington Green
  • Biltmore Village Inn
  • Blake House Inn
  • Carolina Bed & Breakfast
  • Owl’s Nest Inn at Engadine

Page 1 of 57

Independent Practice: Create a Database: B&BStudent Activity

Student NamePeriod Date

Part II: Answer the following questions:

  1. What is the default value of a Yes/No field?
  2. How many records are in the database?
  3. How many fields are in the database?
  4. What advice would you give someone about assigning field names?
  1. How could this database be used on the Internet?
  1. How would Internet users benefit from this list if posted on the Internet?
  1. How would the owners of the B & Bs benefit from this list if posted on the Internet?
  1. What other fields might be useful?
  2. What are two ways to toggle the yes/no field when entering data?
  1. Save and submit according to teacher instructions.

Page 1 of 57

Determining Sort OrderStudent Activity

Student NamePeriod Date

Determining Sort Order

Directions for Part I: Place an Ain the Order column for each scenario that is an example of ascending order or aD if the scenario is of descending order

Order / Scenario
  1. The class should line up from the shortest student to the tallest for the vault contest.

  1. The library books were shelved in alphabetical order by author’s first name.

  1. The most expensive items were listed first.

  1. The family reunion photograph shows the babies in the front row and the great-grandparents in the last row.

  1. The cities with the most snow days were listed first.

  1. The first grade teacher’s mailboxes were assigned before the fifth grade teacher’s.

  1. Bus 13 left the parking lot first, Bus 37 was second and Bus 73 left last.

  1. The oldest student was allowed to go first in the lunch line, while the youngest was last to get his tray.

  1. The mountains were listed on the board. The ones with the highest elevation were listed first while the ones with the lowest elevation were listed last.

  1. The cities with the least snow days were listed first.

Page 1 of 57

Determining Sort OrderStudent Activity

Student NamePeriod Date

Directions for Part II: Study each list below and determine the sort order. Write A for ascending and D for descending.

Page 1 of 57

Determining Sort OrderStudent Activity

Student NamePeriod Date

Page 1 of 57

Determining Sort OrderStudent Activity

Student NamePeriod Date

Order / Scenario / Order / Scenario
1). a). a full tank of gas
b). ¼ tank of gas
c). running on empty / 2). a). a can of coke
b). a 16 oz. bottle of coke
c). a 2 liter bottle of coke
3). a). a penny
b). a nickel
c). a dime / 4). a). Seniors
b). Juniors
c). Freshmen
5). a). 1923
b). 1945
c). 1990 / 6). a). 04/15/2006
b). 07/04/2006
c). 09/25/2006
7). a). David
b). Christine
c). Becky / 8). a). Rock
b). Pop
c). Classical
9). a). 150
b). 110
c). 90 / 10).a). Abbington Green
b). Dry Ridge Inn
c). SecretGarden

Page 1 of 57

Determining Sort OrderStudent Activity

Student NamePeriod Date

Page 1 of 57

Understanding OperatorsStudent Activity

Student NamePeriod Date

Understanding Operators

Understanding mathematical operators is necessary when conducting database searches and sorts and applying filters and queries. When instructed to locate information in a databasewith phrases such as shorter than, taller than, older than etc, you will need to translate the phrase into words that the database understands.