DATABASE DESIGN AND APPLICATIONS

 

This event recognizes FBLA members who demonstrate that they have acquired entry level skills for understanding database usage and development in business.

 

This event is composed of two (2) parts: an objective test and a school-site computer database applications test.  Participants are required to complete both parts to be eligible to win an award.

 

Participants should be well prepared in 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/reports.

 

In addition, on the objective test, participants will be tested on their knowledge of data definitions, terminology, query development/SQL, table relationships (include referential integrity), normalization of data, and advanced queries (joins and unions, subqueries).
 

 

ELIGIBILITY

 

Participants must have paid state and national dues postmarked by December 15 of the current school year.

 

District       Number of participants governed by local FBLA District policy.

 

State          Each district may be represented by participant(s) based on the Florida FBLA scaled quota system found in the Fact Finder.

 

National    See publication:  National Chapter Management Handbook—current edition.

 

REGULATIONS

 

District       Each district determines its own procedures for event registration.

 

State          When it has been determined that a student will represent the district at state competition, the student's local adviser must send the appropriate entry form to the state adviser by first-class mail.  The entry form and the required postmark deadline are included in the SLC registration packet.

 

National    See publication:  National Chapter Management Handbook—current edition.

 

• Participants must be selected in accordance with the regulations of the FBLA district and state chapters and the national association.

 

• Participants must not have entered this event at a previous National Leadership Conference or placed 1st or 2nd in this event at a previous State Leadership Conference.

 

• Participants failing to report on time may be disqualified.

 

• Participants must furnish their own No. 2 pencils and erasers.  No reference materials, electronic devices, or other items may be used during the written portion of this event.  Calculators are not allowed on the production portion of this event.

 

• Participants must adhere to the dress code established by the Board of Directors or they will not be permitted to participate in the competitive event.

 

SCHOOL SITE TESTING

The production test will be administered prior to the state conference. One hour will be allowed for the skills test at the school testing site.  Additional time will be allowed for general directions, equipment set up, and warm up.  Problems are weighted according to difficulty and may be completed in any order.  Word division manuals and dictionaries may be used as reference materials for the skills portion of the event. 

 

Documents produced for this event must be prepared by the FBLA competitors without help from the adviser or any other person. No reference materials may be used other than that provided or specifically allowed by the national association.

 

The district director (with the approval of the state adviser) will determine the central site location for the test.  The state adviser will provide the district directors with the dates.  An impartial party will be selected to administer the test.

 

JUDGING
 

Objective tests will be machine graded.  This test will be given at the State Leadership Conference and will constitute 15 percent of the final event score.

 

Judging of the skill test will be based on printed copy.  The documents will be evaluated by a panel of judges.  All decisions of the judges are final.  The production portion of this event will constitute 85 percent of the final event score.  Ties will be broken based on the scores associated with the production portion of this event.

 

AWARDS
 

District       The number of awards presented at the District Leadership Conference is determined by local FBLA District policy.

 

State          State awards for the top five places are presented at the State Leadership Conference.

 

National    The number of awards presented at the National Leadership Conference is determined by judges and/or number of contestants.