0

    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.

    a. First row contains column headings.

    b. In a new table.

    c. Make no changes to any of the fields.

    d. Make the “Team Name” field your primary key.

    e. Save the table as Teams.

    f. 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:

    a. Complete the table using names and information for 10 players.

    b. 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:

    a. 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:

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

    b. Enforce Referential Integrity is selected.

    c. Cascade Update Related Fields is selected.

    d. 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.

                                                                                                                                      Order Now