Database Design & Application

Category: Production & Objective Test
Type: Individual

Overview

Two (2) parts: a production test administered and proctored at a designated school-site prior to the NLC and a 60-minute objective test administered onsite at NLC.

Production Test Competencies: Multiple Table Database Design; Table Creation, Inserting Data into Tables; Table SQL Statements; Creation of Forms/Reports

Objective Test Competencies: Data Definitions/Terminologies; Query Development; Table Relationships; Form Development; Reports and Forms


Guidelines

Production & Objective Test Guidelines
Production Test Guidelines
  • Documents produced for this event must be prepared by the competitor without help from the adviser or any other person.
  • Administration of the production test is determined by the state chair/adviser.
  • No calculators are allowed to be used on the production test.
  • The production score will constitute 85% of the final event score.
  • The production test score will be used to break a tie.
  • Tests must be uploaded online by 11:59 p.m. Eastern Time on the third Friday in May.
Objective Test Guidelines
  • No materials may be brought to the testing site.
  • No calculators may be brought into the testing site; calculators will be provided.
  • Electronic devices must be turned off and out of sight.
  • Bring a writing instrument.
General Guidelines

The general event guidelines below are applicable to all national competitive events. Please review and follow these guidelines when competing at the national level. When competing at the state level, check the state guidelines since they may differ.

Eligibility

  • Dues: Competitors must have paid FBLA national and state dues by 11:59 p.m. Eastern Time on March 1 of the current school year.
  • NLC Registration: Participants must be registered for the NLC and pay the national conference registration fee in order to participate in competitive events.
  • Deadlines: The state chair, or designee, must register each state competitor on the official online entry forms by 11:59 p.m. Eastern Time on the second Friday in May.
  • Each state may submit four (4) entries in all events except LifeSmarts, Virtual Business Finance Challenge, and Virtual Business Management Challenge.
  • Each competitor can only compete in one (1) individual/ team event and one (1) chapter event.
  • Each competitor must compete in all parts of an event for award eligibility.
  • A team shall consist of two or three members. Exceptions are Parliamentary Procedure which must be a team of four or five members, and LifeSmarts which must be a team of two members.

Repeat Competitors

Competitors are not permitted to compete in an event more than once at the NLC unless one of the following circumstances applies:

  • Modified Events: A competitor may compete in the same event when the event is modified. Note, if the only modification is a name change, competitors may not compete in the renamed event.
  • Team Events: One (1) competitor of the team may have competed in the same event at one (1) previous NLC; however, they may not compete more than twice in the event at the national level.
  • Chapter Events: Competitors may compete in a chapter event more than once (American Enterprise Project, Community Service Project, and Partnership with Business Project).
  • Individual Entry: A competitor who competed as an individual entry in a team event at the national level may compete in the same event a second time as part of a team, but not a second time as an individual.
  • Parliamentary Procedure: Two (2) competitors of the team may have competed in this event at a previous NLC; however, they may not compete more than twice at the national level.
  • Pilot Event: Competition in a pilot event does not disqualify a competitor from competing in the same event if it becomes an official competitive event. The participant may compete in another event as well as a pilot event.

Breaking Ties

  • Objective Tests: Ties are broken by comparing the correct number of answers to the last 10 questions on the exam. If a tie remains, the competitor who completed the test in a shorter amount of time will place higher. If this does not break the tie, answers to the last 20 questions will be reviewed and determine the winner.
  • Objective and Production Tests: The production test scores will be used to break a tie.
  • Objective Tests and Performances: The objective test score will be used to break a tie based on the tie-breaking criteria of objective tests.
  • Reports/Projects and Performances: The report/project scores will be used to break a tie.
  • Performances: Judges must break ties and all judges’ decisions are final.

National Deadlines

  • State chair/adviser must register all competitors for NLC competitive events online by 11:59 p.m. Eastern Time on the second Friday in May.
  • All prejudged components (reports, websites, projects, statement of assurance) must be received by 11:59 p.m. Eastern Time on the second Friday in May.
  • All prejudged projects and reports must be submitted electronically.
  • All Statements of Assurance must be submitted online.
  • All production tests must be received at FBLA-PBL by 11:59 p.m. Eastern Time on the third Friday in May.
  • All production tests must be uploaded online.
  • State chair/adviser may make name changes only (no additional entries) by 11:59 p.m. Eastern Time on the first Friday in June. Competitor drops are the only changes allowed after this date and onsite.

National Awards

The number of competitors will determine the number of winners. The maximum number of winners for each competitive event is 10. Only one (1) award is given to the schools competing in chapter events (American Enterprise Project, Community Service Project, Local Chapter Annual Business Report, and Partnership with Business Project).

Additional Materials

Certain events may allow the use of additional materials. Please refer to event guidelines.

Americans with Disabilities Act (ADA)

FBLA‑PBL meets the criteria specified in the Americans with Disabilities Act for all participants who submit a special needs form.

Recording of Presentations

No unauthorized audio or video recording devices will be allowed in any competitive event. Participants in the performance events should be aware the national association reserves the right to record any performance for use in study or training materials.


Preparation

Sample Practice Materials

Format Guide

Competencies
Competency
Tasks
Data Definitions/Terminologies
1. Explain the principles of data analysis.
2. Evaluate and compare a variety of database programs for features and functions.
3. Determine when it is appropriate to use a database and identify the benefits derived.
4. Demonstrate correct use of database terminology.
5. Plan, design, and create a database file.
6. Construct database using appropriate inputting, formatting, and editing skills.
7. Set and modify field properties including limit field size, number formats, date/time formats, yes/no formats, validation rules, and input masks.
8. Distinguish between different field types.
9. Define and modify field names and data types.
10. Manipulate a database.
11. Import and export data into and from a database.
12. Save database objects as file types.
13. Use the Help feature of database software.
14. Compact and repair a database
15. Produce documents integrating word processing, database, spreadsheet, and presentation files
Query Development
1. Use the simple query wizard
2. Create a query in design view
3. Search, sort, index, merge, and manipulate database for specific information.
4. Filter data (sort, find specific records, and replace)
5. Create multi-table queries.
6. Design and create action queries (make-table, update, append, and delete).
7. Design and create advanced queries (setting top values, creating calculated field, creating function query, and creating parameter query).
8. Verify accuracy of output
Table Relationships
1. Define and create table relationships.
2. Use table wizard and design view to create a table.
3. Add records to tables.
4. Apply the default values, input masks, validation rules, validation text, required fields, and lookup fields to field properties in a table in design view.
5. Understand the difference between a one-to-one, one-to-many, and many-to-many relationships.
6. Enforce referential integrity.
7. Create and modify a multi-table select inquiry.
8. Save a table, query, and forms as a Web page.
9. Import/export linked tables
Form Development
1. Design, create, and modify basic forms in database.
2. Create a form with the form wizard.
3. Create a form based on a query.
4. Modify Format Properties.
5. Enter and delete records using a datasheet or form.
6. Use the control Toolbox to add controls, move a control, and resize a control.
7. View and print records in a form.
8. Use design view to disable the snap to grid feature, display the field list, move, move part of a paired control, align and space controls, add a label or image, and to edit an unbound control.
9. Create and modify a subform.
Reports and Forms
1. Design, create, save, and modify reports for data output.
2. Design, create, save, and modify reports for data output.
3. Enhance reports using formatting features and graphics.
4. Preview and print a report.
5. Modify and format report properties (font, style font size, color, and caption).
6. Use report sections.
7. Perform grouping and sorting to a report.
8. Create reports using all types of controls including Active X and calculated totals.
9. Use advanced report design to create a running summary, insert a date/time control, and use label wizard.

Alignment

NBEA Standards
  • Computation
  • Information Technology
Career Clusters
  • Business Management & Administration
  • Information Techology
  • S.T.E.M.

Eligibility

States may submit up to 4 entries.
Competitors must be registered for NLC and pay registration fee.
Competitors must pay dues by 11:59 p.m. Eastern on March 1.

Timeline

Test: 1 hour
Home-site Production Test: 1 hour