Database Design

The Database Design course introduces students to the basic concepts of database design and implementation. It covers all aspects of the database life cycle and systematically works through the procedure of collecting requirements, planning, modeling, and creating a database and a database application. Students move from a conceptual model to an entity-relationship model, which in turn translates into a relational database and a database application. Students hone the important skills required to classify information, identify relationships, and think logically.

For their culminating project, students get hands-on practice in a true-to-life database project they create for a client. They assess their client’s needs in a statement of requirements, and then they plan, model, design, and implement a relational database. As part of the project, they create, test, and document a database application that their client can use to run queries, input data using forms, and create reports. Students also examine career opportunities for database professionals and consider the education, experience, and skills needed to enter and succeed in database-related professions.

Students use Microsoft Access for all development of databases and database applications during the course. The course is written using Access 2013, but it can easily be adapted for use with Access 2007 or 2010.

This course is expected to take a total of 80 50-minute class periods.

Course Scope & Sequence

The Scope & Sequence lists the learning objectives for each lesson, providing you with an overview of what your students will learn during the course. You can use these learning objectives as a guide to determine how the course enables your students to reach the requisite goals set for them.

Download File type: .DOCX

Lesson Descriptions

The Lesson Descriptions document includes a brief overview of every lesson in the course. This is the narrative companion to the course Scope & Sequence document.

Download File Type: .DOCX

Course Support

If you have questions about this course, need a hand with a particular lesson, or just have a great idea to share, please contact the NAF Instructional Managers directly at curriculum@naf.org. We are available to support you in teaching the course while also gathering feedback to improve the NAF curriculum.

Culminating Project Overview

In every NAF course, students complete a culminating project and present it in the final lesson. Download the Project Overview to learn the details about the culminating project for this course and to find out what advance preparation the project entails.

Download File type: .DOCX

NAFTrack Certification Course Guide

NAFTrack Certification is a nationally recognized, standards-based set of tools developed by NAF to evaluate students' readiness for college and career. By completing all NAFTrack Certification requirements, students demonstrate mastery of academic skills and career-related knowledge. The requirements are as follows: for each of four NAF courses, students complete all coursework, pass the end-of-course exam, and fulfill culminating project responsibilities, as evidenced by uploading key pieces of work.

Download File type: .DOCX Resources

Correlations to the Common Core State Standards

This document identifies which of the ELA and Math Common Core State Standards are met by each lesson in the course. You can use these correlations as an aid to preparing your students for college and careers.

Download File type: .DOCX

We welcome questions and feedback about these course materials. For a prompt response, please email Kevin English directly at kenglish@naf.org.

The ZIP file below contains the current version of every file for this course. Be sure to download it before the start of each school year. If you just need a specific file or two, it's quicker to use the individual links listed on this page.

All Course Files (ZIP file)

Unit 4: IMPLEMENTING DATABASES AND DATABASE APPLICATIONS

Lesson 9: Creating a Relational Database

Lesson 10: Building a Database Application

Unit 5: PREPARING A DATABASE APPLICATION FOR DISSEMINATION

Lesson 11: Testing a Database Application

Lesson 12: Documenting a Database Application

Unit 6: CAREERS IN DATABASES AND COURSE CLOSURE

Lesson 13: Exploring Database Careers and Learning from Industry Experts

Lesson 14: Project Presentation and Course Closure

×
Access NAF's Curriculum
Please fill out the following fields to download your copy of this NAF resource:
By downloading this resource, you confirm that you have read and agree to the NAF Terms of Service and that you agree to the processing of your personal data by NAF as described in our Privacy Statement. We will not sell or share your email address with third parties.