Association of Information Technology Professionals
Region 3 Student Conference hosted by
Amarillo College
andOklahoma Panhandle State University

AITP Region 3 Student Conference

Building a Future in Information Technology

Database Design

Summary/Overview

The database design competition will allow teams of one or two students to utilize their analysis, design, and SQL coding skills and apply them to a real business problem within an approximate three hour time frame. Contestants will be presented with a problem statement and data for analysis and problem solving. The database design will consist of an Entity Relationship Diagram (ERD) and a relational schema, which will be turned in for scoring. From this, they will be required to design a working database solution and implement specified components of that database using SQL which will also be turned in for scoring. Students will use either MySQL or SQL Server in the contest. (NOTE: ER Assistant can be downloaded FREE at: http://er-assistant.software.informer.com/2.1/).

Team Size

Teams for this contest can consist of 1-2 Students. Each member can bring your own computer(BYOC).

Schedule

This contest will take place on Friday, October 21, 2016 from 4:00 ‐ 7:00 PM

Recommended Skills

Students should be knowledgeable with all of the following aspects:

Contests will use Course Management Software

www.coursesites.com

The AITP Region 3 Student Conference will use Coursesites Software, which is a free product from Blackboard. Each contest will have its’ own course with a login for each team. Any documents the team will need will be loaded under the Information folder for each contest. The students will submit their solutions under the Content folder.

Contest Page