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.
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.
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 email@example.com. 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.
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.
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.
We welcome questions and feedback about these course materials. For a prompt response, please email Kevin English directly at firstname.lastname@example.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)