Capstone Project: Databases

Description

In this project, you will demonstrate the database-related knowledge and skills that you have recently learned. In this capstone project, you get to construct your own specific Airtable database.

Learning Outcomes

At the end of this project, you will be able to:

• Create a new relational database made up of three or more tables
• Design your database tables to house specific information for your application
• Add fields of specific data types
• Construct relationships (or links) between tables
• Input your own personal data into the database tables
• Use the Airtable system and its interface functionality

Assignment Tasks

1. If you haven't already, sign up for a free account Airtable account and be sure to read through the Guide to Airtable.

2. Create a new database (referred to as a "base" in Airtable) for a set of information that is of interest to you. For example, you could create a database for your co-ed soccer team keeping track of each players stats. Or, a database for a collection of favorite superhero action figures, Or, a log of the different dogs you walk as part of your side job as a dog walker. These are just a few off-the-cuff ideas.

3. If you are still stumped as to what you might create as your database, be sure to take a look at the extensive list of templates and find one that would be applicable and valuable to you. You may also create a new base from scratch if you have an idea for something altogether new.

4. Minimally your database should have the following features/functionalities:

   • 3 or more tables
   • Each table should have at least 3 or more fields
   • Use at least 2 different field types in each table
   • At least one relationship (link) between two of your tables
   • At least 20 records cumulative across all of your tables

Grading Criteria

This capstone project is worth 50 points or 5% of your overall grade. Your submission will be evaluated based on the following criteria:

• Key Features/Functionalities: 20 pts
• Overall Design (proper use of tables, fields and relationships): 15 pts
• Creativity (Wow Factor): 15 pts

Submitting Your Work