Background
A database is a software application that stores data in a form that can be easily searched. Banks, websites, governments, sports teams, hospitals, and many other companies and organizations use databases on a daily basis. The people in charge of maintaining these databases are known as database administrators. Skilled database administrators can make $100,000 a year or more in salary. For this project, students will use Microsoft Access to create a simple database of information about theme parks in the United States.
Introduction to Databases
Please watch the following video.
Database Vocabulary
For this class there are four important vocabulary terms related to databases. Please search for the definitions of the following terms and write them in your journal. Make sure all definitions relate to their usage in a database.
- Fields
- Records
- Queries
- SQL
Content Rubric
Your database should contain the following:
- NAME OF PARK field. [Short Text] [1 Point]
- CITY field. [Short Text] [1 Point]
- STATE field. [Short Text] [1 Point]
- DRIVING DISTANCE (Miles) field. [Number] [1 Point]
- ADULT ADMISSION field. [Currency] [1 Point]
- CHILD ADMISSION field. [Currency] [1 Point]
- MEAL PLAN COST field. [Currency] [1 Point]
- At least 20 records, no more than 5 in Florida. [10 Points]
- One SELECT QUERY that can sort by state. [10 Points]
- Bonus: Create an ACTION QUERY that can sort by DRIVING DISTANCE and ADULT ADMISSION. [+10 Points]
Query Help & Tutorials
Process Rubric
- File name is: lastname_firstname_themeparks [5 Points]
- File format is Microsoft Access (.accdb) [5 Points]
- Project is submitted to Focus by 05/25/2018 by 11:59PM [20 Points]
