PROJECT 1: NCAA DATABASE TOURNAMENT

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.

PROJECT DIRECTIONS

Step 1:

Create a new MS Access database.

1. 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.
4. Submit the completed file to your Assignments Folder in our CMST 100F Classroom.

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

Step 3:

Create a new table with the following fields:

FieldName FieldType Format/Other Items

Conference Text Primary Key

Team Name Text Short Text

Step 4:

Save the table as Conferences.

Step 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

Step 6:

Save and close the table.

Step 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

Step 8:

Save the table as Players.

Step 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

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

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

Note 1: 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.

Project Grade Weight

• Points: This project is worth 400 points or 40% of your total grade for the course.
• Grade Reductions: You will lose points for issues such as: not following directions, not submitting your work on time, and failure to include all required elements. Each omission will result in a partial point deduction.

Project 1 Due Date

• Hard Due Date: End of Week 2
• Laste Penalty: You can submit this assignment until the LAST DAY OF WEEK 2. The Assignments Folder will then be closed and you will not be able to physically submit the assignment for a grade. Exceptions may be allowed, on a case-by-case basis, for life situations (military deployment, medical illness, death in the family, etc.). In all cases, timely notification of a “life situation” is critical to the approval of any extensions.

Technical Difficulties in Submitting Your Work

• Submit Early: Please do not wait until the last minute to submit your assignment. Give yourself at least a 5-hour window to account for any technical difficulties that might arise. If you experience technical difficulties beyond your control that do not allow you to successfully complete the assignment, immediately follow the steps below:
  • Step 1: Contact the UMGC Help Center. Inform them of the problem you are having. Get a problem ticket number from them to document the situation.
  • Step 2: E-mail me ASAP and include a description of the problem you are having and your problem ticket number from the Help Center so I can investigate the situation.
  • Step 3: E-mail the assignment to my e-mail address. The date and time your e-mail is received will help provide a timestamp of your work.

Archive Your Assignment

• CYA: Please make sure you keep a copy of your project stored on your computer. Technical difficulties do happen–you may need to resubmit your assignment for a number of reasons. It is always a good policy to CYA (Copy Your Assignment).

Verify Your Assignment Has Been Posted

• Make Sure Your Project Was Submitted: It is your responsibility to make sure you have posted your assignment CORRECTLY! Once you have posted your assignment, immediately attempt to view it, just to make sure your post was accepted by LEO, that it is formatted correctly, and you have posted the correct file. You should also receive an Assignment Submission Verification via e-mail (If you do not, that may be a cause for concern)
  

  Rubric Name: old_Access Project 1 Grading Rubric

  Print

  Tabes		Very Good	Good	Needs Work	No Submission	Criterion Score
  Creating and Importing Tables	ALL Requirements for creating and importing the tables are successfully met: NCAA database created and saved correctly (Lastname_NCAA) “Teams” file imported correctly “Players” table created with 5 fields: LastName, Position, Team, PPG, Rebounds Data for “players” entered correctly in datasheet view (used data for 10 players) Field type and other formatting properly entered for Players Table Conferences table created with 3 fields: Conf., Total Teams, Tournament Teams Data for “conferences” entered correctly in datasheet view Field type and other formatting properly entered for Conferences Table	ONE Requirements for creating and importing the tables are NOT met: NCAA database created and saved correctly (Lastname_NCAA) “Teams” file imported correctly “Players” table created with 5 fields: LastName, Position, Team, PPG, Rebounds Data for “players” entered correctly in datasheet view (used data for 10 players) Field type and other formatting properly entered for Players Table Conferences table created with 3 fields: Conf., Total Teams, Tournament Teams Data for “conferences” entered correctly in datasheet view Field type and other formatting properly entered for Conferences Table	TWO Requirements for creating and importing the tables are NOT met: NCAA database created and saved correctly (Lastname_NCAA) “Teams” file imported correctly “Players” table created with 5 fields: LastName, Position, Team, PPG, Rebounds Data for “players” entered correctly in datasheet view (used data for 10 players) Field type and other formatting properly entered for Players Table Conferences table created with 3 fields: Conf., Total Teams, Tournament Teams Data for “conferences” entered correctly in datasheet view Field type and other formatting properly entered for Conferences Table	MORE than TWO Requirements for creating and importing the tables are NOT met: NCAA database created and saved correctly (Lastname_NCAA) “Teams” file imported correctly “Players” table created with 5 fields: LastName, Position, Team, PPG, Rebounds Data for “players” entered correctly in datasheet view (used data for 10 players) Field type and other formatting properly entered for Players Table Conferences table created with 3 fields: Conf., Total Teams, Tournament Teams Data for “conferences” entered correctly in datasheet view Field type and other formatting properly entered for Conferences Table	NONE of the requirements for creating and importing the tables are met: NCAA database created and saved correctly (Lastname_NCAA) “Teams” file imported correctly “Players” table created with 5 fields: LastName, Position, Team, PPG, Rebounds Data for “players” entered correctly in datasheet view (used data for 10 players) Field type and other formatting properly entered for Players Table Conferences table created with 3 fields: Conf., Total Teams, Tournament Teams Data for “conferences” entered correctly in datasheet view Field type and other formatting properly entered for Conferences Table	/ 200

  Relationships		Very Good	Good	Needs Work	No Submission	Criterion Score
  Creating Table Relationships	ALL Requirements for creating the relationships are successfully met:ALL three tables added to relationships window: Teams, Players and Conferences Relationship between Players & Teams tables created w/Team – TeamName field It is a One-to-Many relationship Relationship between Conferences & Teams tables created w/ Conference field 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	ONE Requirement of creating the relationships NOT met:ALL three tables added to relationships window: Teams, Players and Conferences Relationship between Players & Teams tables created w/Team – TeamName field It is a One-to-Many relationship Relationship between Conferences & Teams tables created w/ Conference field 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	TWO Requirements of creating the relationships NOT met:ALL three tables added to relationships window: Teams, Players and Conferences Relationship between Players & Teams tables created w/Team – TeamName field It is a One-to-Many relationship Relationship between Conferences & Teams tables created w/ Conference field 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	MORE than TWO Requirements of creating the relationships NOT met:ALL three tables added to relationships window: Teams, Players and Conferences Relationship between Players & Teams tables created w/Team – TeamName field It is a One-to-Many relationship Relationship between Conferences & Teams tables created w/ Conference field 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	NONE of the requirements for creating the relationships are met:ALL three tables added to relationships window: Teams, Players and Conferences Relationship between Players & Teams tables created w/Team – TeamName field It is a One-to-Many relationship Relationship between Conferences & Teams tables created w/ Conference field 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 / 50