NCAA

PROJECT 1: NCAA DATABASE TOURNAMENT
 
OBJECTIVE
The purpose of this project is to demonstrate your understanding of the following course concepts:
 

1. Creating an Access database.
2. Managing a database.
3. Create and modify tables.
4. Modify field properties.
5. Defining table relationships.

 
PROJECT DESCRIPTION
For many years people have been following the NCAA tournament. Since there is a need to have this information readily accessible, we need to convert a previous paper-based system into a stored database. We will do this using an Access database. The first step in this conversion is dividing the information into different tables.
 
You will be creating a NEW database from scratch. This activity and all those associated with it are for you to go through creating a database and to review all tasks associated with doing so. Please take heed to do everything exactly as it is given including saving with the correct file names. Based on what you have learned in the lessons, you should have found out that even spelling has to be accurate in MS Access.
 
DIRECTIONS

1. Create a new MS Access database. Save it in to your computer or other destination using the following protocol: lastname_NCAA (for example, Henry_NCAA), (2) modify the database based on the instructions, (3) save your work, and (4) submit the completed file to your Assignments Folder in our CMST 100F Classroom.
2. Import the Teams.xlsx file as a new table to your database. (see attachment for Teams.xlsx file). The following site will also help you with the import process.

 

1. First row contains column headings.
2. In a new table.
3. Make no changes to any of the fields.
4. Make the “Team Name” field your primary key.
5. Save the table as Teams.
6. Close the table after you have correctly imported it.

 

3. Create a new table with the following fields;

 
FieldName                   FieldType         Format/Other Items
Conference                   Text                Primary Key
Team Name                   Text                Short Text
 

4. Save the table as Conferences.
5. Open the table in Datasheet view and enter the following information about the NCAA Conferences:

 
Conference
 
Team Name
 
ACC
 
Abilene Christian Wildcats
 
American
 
Air Force Falcons
 
American East
 
Alabama Crimson Tide
 
Atlantic 10
 
Arizona Wildcats
 
Atlantic Sun
 
Baylor Bears
 
Big 10
 
Buffalo Bulls
 
Big 12
 
Campbell Fighting Camels
 
Big East
 
Charleston Cougars
 
Big Sky
 
Duke Blue Devils
 
Big South
 
East Tennessee State Buccaneers
 
Big Ten
 
Eastern Washington Eagles
 
Big Twelve
 
Fairleigh Dickerson Knights
 
Big West
 
Florida Atlantic Owls
 
Colonial
 
Florida Gators
 
Conf USA
 
Florida State Seminoles
 
Horizon
 
Georgia State Panthers
 
Ivy League
 
Georgia Tech Yellow Jackets
 
MEAC
 
Colgate Raiders
 
Mid American
 
Gonzaga
 
Missouri Valley
 
Hofstra Pride
 
Mountain West
 
Houston Cougars
 
Northeast
 
Jacksonville Dolphins
 
Ohio Valley
 
Kansas State Wildcats
 
Pacific-12
 
LSU Tigers
 
Patriot League
 
Marquette
 
SEC
 
Maryland Terrapins
 
Sothern
 
Michigan State Spartans
 
Southern
 
Murray State Racers
 
Southland
 
Murray State Racers
 
Sun Belt
 
New Mexico State Aggies
 
WAC
 
Norfolk State Spartans
 
West Coast
 
North Carolina Tar Heels
 

6. Save and close the table.
7. Create a table with the following fields:

 
FieldName       FieldType                   Format/Other Items
 
LastName         Text                              Primary Key
Position            Lookup Wizard              Create w/ the following options
– Guard, Forward, Center (Hint: (HINT: Select “I will type the values that I want.” Click Next. Then type in the 3 options
Team Name      Text                              Size of 20
PPG                 Number                        Double
Rebounds         Number                        Double

8. Save the table as Players.

 

9. Open the table in Datasheet view and enter the following information for the Players Table using the example below:

 

1. Complete the table using names and information for 10 players.
2. Use at least five of the team names from the Teams Table.

 
LastName                    Position           TeamName                              PPG     Rebounds
Anthony Cowan Jr.        Guard               Maryland Terrapins                   15.6           3.7
 

10. Save and close the table.

 
RELATIONSHIPS

1. Click the Relationship button on the Database tools tab.
2. Add all three tables in the database, Teams, Conferences, and Players to the Relationships window.
3. Create a relationship between the Teams table and the Players table using the TeamName field. Make sure the following is true for this new relationship:

 

1. It is a One-to-Many relationship..

 

4. Create a relationship between the Teams table and the Conference table using the “Conference” field. Make sure the following is true for this new relationship:

 

1. It is a One-to-Many relationship .

 

1. Enforce Referential Integrity is selected.
2. Cascade Update Related Fields is selected.
3. Cascade Delete Related Records is selected.

 

5. Save the changes you made to the relationships for this database.
6. Close the Relationships Window.

 
SUBMISSION REQUIREMENTS
Please submit the following to your Assignments Folder:
 

1. The completed Access database file.
2. Submit a Project Reflection (see below):

 
PROJECT REFLECTION
Answer the following questions when you submit your assignments files.
 

1. What are some roadblocks that you encountered while completing this assignment?
2. What is the most important thing that you have learned from completing this assignment?

 
Please submit your Project Reflection as a Microsoft Word document or just copy and paste your answers in your Assignments Folder’s text box when you submit your assignment along with the rest of the required project files.