Database Design and Applications


Category: Computer Skill Test

Type: Individual

Grade Level: 9-12

Deadline/Testing: At School Testing: February 20 - March 15

Competitor Limit: 2 Entries per chapter

Event Guidelines

Objective Test (February 20-March 15)

  • Objective Test taken prior to SLC .
  • The top 15 scores based on the Objective Test will receive the prompts for the production component. The production component will need to be proctored and completed by the first day of the state conference.

Production Test (March 20-April 3)
• Test materials will be emailed to the chapter adviser prior to the designated testing dates.
• Participants will test on a computer at their local school on one of the designated testing dates.
• All students who entered the event from a school must test on the same date at the same time.
• Any appropriate software may be used.
• The event will be administered according to the guidelines provided in the testing packet by the proctor (a person other than the FBLA chapter adviser, such as the technology coordinator, guidance counselor, principal, or other faculty members).
• Thirty (30) minutes will be allowed for the application portion of the test at the school testing site. Additional time will be allowed for general directions. The proctor will start and stop all participants at the same time. (Exception: Time allowances may be made for equipment failure.)
• Voice recognition software may be used as an input method.
• Participants should be prepared to demonstrate the design of multiple table databases (selection of tables, fields and data types, ER diagrams, relationships), creation of tables and inserting data into tables, development of single table SQL statements, development of multiple table SQL statements, and creation of forms and reports.
• Participants will be notified when five (5) minutes and one (1) minute remaining.
• All proofreading and keying must stop when time is called by the proctor.
• Problems will be weighted according to difficulty and may be completed in any order.
• Participants must provide their own pens and pencils.
• No reference materials or calculators may be used.

Competency:

  • Multiple table database design
  • table creation, inserting data into tables
  • table SQL statements
  • creation of forms/reports

Eligibility:

Each chapter may enter two (2) FBLA members from Grades 9 through 12. Participants should have completed a computer course utilizing database software to solve business applications. Each participant must pay the SLC registration fee and attend the State Leadership Conference.

 

Judging

Judging will be based on accuracy of printed copy. Points will be deducted for errors. The documents will be evaluated by a panel of judges. All judges’ decisions are final.

Who Goes to Nationals?

The first-, second-, and third-place winners of this event will represent Nebraska in the Database Design and Applications event at the National Leadership Conference, provided they have not placed in the top 10 for this event at a previous National Leadership Conference.