databases project and need the explanation and answer to help me learn.
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.
Save it in to your computer or other destination using the following protocol: lastname_NCAA (for example; Henry_NCAA).
Modify the database based on the instructions.
Save your work.
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.
First row contains column headings.
In a new table.
Make no changes to any of the fields.
Make the “Team Name” field your primary key.
Save the table as Teams.
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
Click the Relationship button on the Database tools tab.
Add all three tables in the database, Teams, Conferences, and Players to the Relationships window.
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..
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.
Save the changes you made to the relationships for this database.
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 2 Grading Rubric
Print
Table Very Good Good Needs Work No Submission Criterion Score
Create Table ALL Requirements for creating the table are successfully met:
“Student List” table created with 8 fields: Student ID, LastName, FirstName, Address, City, State, ZipCode, FirstSemesterAttended
Data for “student list” entered correctly in datasheet view
Field type and other formatting properly entered for Student List Table
Column widths are modified as necessary
ONE Requirement for creating the table NOT met:
“Student List” table created with 8 fields: Student ID, LastName, FirstName, Address, City, State, ZipCode, FirstSemesterAttended
Data for “student list” entered correctly in datasheet view
Field type and other formatting properly entered for Student List Table
Column widths are modified as necessary
TWO Requirements for creating the table NOT met:
“Student List” table created with 8 fields: Student ID, LastName, FirstName, Address, City, State, ZipCode, FirstSemesterAttended
Data for “student list” entered correctly in datasheet view
Field type and other formatting properly entered for Student List Table
Column widths are modified as necessary
MORE than TWO Requirements for creating the table NOT met:
“Student List” table created with 8 fields: Student ID, LastName, FirstName, Address, City, State, ZipCode, FirstSemesterAttended
Data for “student list” entered correctly in datasheet view
Field type and other formatting properly entered for Student List Table
Column widths are modified as necessary
NONE of the requirements for creating the table met:
“Student List” table created with 8 fields: Student ID, LastName, FirstName, Address, City, State, ZipCode, FirstSemesterAttended
Data for “student list” entered correctly in datasheet view
Field type and other formatting properly entered for Student List Table
Column widths are modified as necessary
/ 40
Form Very Good Good Needs Work No Submission Criterion Score
Create Form ALL Requirements for creating the form are successfully met:
Form correctly created w/8 fields: Student ID, LastName, FirstName, Address, City, State, ZipCode, FirstSemesterAttended
Form created with tabular or columnar layout, using any style
Form includes label at top w/ “Students” in Garamond size 26 font & centered
Form includes label at bottom w/Name in Garamond font size 14 & centered
2 New records created
ONE Requirement for completing the form NOT met:
Form correctly created w/8 fields: Student ID, LastName, FirstName, Address, City, State, ZipCode, FirstSemesterAttended
Form created with tabular or columnar layout, using any style
Form includes label at top w/ “Students” in Garamond size 26 font & centered
Form includes label at bottom w/Name in Garamond font size 14 & centered
2 New records created
TWO Requirements for completing the form NOT met:
Form correctly created w/8 fields: Student ID, LastName, FirstName, Address, City, State, ZipCode, FirstSemesterAttended
Form created with tabular or columnar layout, using any style
Form includes label at top w/ “Students” in Garamond size 26 font & centered
Form includes label at bottom w/Name in Garamond font size 14 & centered
2 New records created
MORE than TWO Requirements for completing the form NOT met:
Form correctly created w/8 fields: Student ID, LastName, FirstName, Address, City, State, ZipCode, FirstSemesterAttended
Form created with tabular or columnar layout, using any style
Form includes label at top w/ “Students” in Garamond size 26 font & centered
Form includes label at bottom w/Name in Garamond font size 14 & centered
2 New records created
NONE of the requirements for competing the form are met:
Form correctly created w/8 fields: Student ID, LastName, FirstName, Address, City, State, ZipCode, FirstSemesterAttended
Form created with tabular or columnar layout, using any style
Form includes label at top w/ “Students” in Garamond size 26 font & centered
Form includes label at bottom w/Name in Garamond font size 14 & centered
2 New records created
/ 120
Report Very Good Good Needs Work No Submission Criterion Score
Create Report ALL Requirements for creating the report are successfully met:
Report correctly created w/ Student List table: Student ID, LastName, FirstName, Address, City, State, ZipCode, FirstSemesterAttended
Report created w/grouping by First Semester Attended, Layout: Stepped, Orientation: Landscape , Title the report: Student Report
Adjust column widths in Design View as necessary
Labels & Textboxes resized to allow for all information to be visible
ONE Requirement for creating the report NOT met:
Report correctly created w/ Student List table: Student ID, LastName, FirstName, Address, City, State, ZipCode, FirstSemesterAttended
Report created w/grouping by First Semester Attended, Layout: Stepped, Orientation: Landscape , Title the report: Student Report
Adjust column widths in Design View as necessary
Labels & Textboxes resized to allow for all information to be visible
TWO Requirements for creating the report NOT met:
Report correctly created w/ Student List table: Student ID, LastName, FirstName, Address, City, State, ZipCode, FirstSemesterAttended
Report created w/grouping by First Semester Attended, Layout: Stepped, Orientation: Landscape , Title the report: Student Report
Adjust column widths in Design View as necessary
Labels & Textboxes resized to allow for all information to be visible
MORE than TWO requirements for creating the report NOT met:
Report correctly created w/ Student List table: Student ID, LastName, FirstName, Address, City, State, ZipCode, FirstSemesterAttended
Report created w/grouping by First Semester Attended, Layout: Stepped, Orientation: Landscape , Title the report: Student Report
Adjust column widths in Design View as necessary
Labels & Textboxes resized to allow for all information to be visible
NONE of the requirements for creating the report are Met:
Report correctly created w/ Student List table: Student ID, LastName, FirstName, Address, City, State, ZipCode, FirstSemesterAttended
Report created w/grouping by First Semester Attended, Layout: Stepped, Orientation: Landscape , Title the report: Student Report
Adjust column widths in Design View as necessary
Labels & Textboxes resized to allow for all information to be visible
/ 120
Query Very Good Good Needs Work No Submission Criterion Score
Create and run Query ALL Requirements for creating the query are successfully met:
A query is created from the Student List Table
Appropriate fields and criteria are used to show students who first attended in the Fall of ’08.
The query is run and saved as “qry_Fall08”
ONE Requirement for creating the query NOT met:
A query is created from the Student List Table
Appropriate fields and criteria are used to show students who first attended in the Fall of ’08.
The query is run and saved as “qry_Fall08”
TWO Requirements for creating the query NOT met:
A query is created from the Student List Table
Appropriate fields and criteria are used to show students who first attended in the Fall of ’08.
The query is run and saved as “qry_Fall08”
MORE than TWO Requirements for creating the query NOT met:
A query is created from the Student List Table
Appropriate fields and criteria are used to show students who first attended in the Fall of ’08.
The query is run and saved as “qry_Fall08”
NONE of the requirements for creating the query are met:
A query is created from the Student List Table
Appropriate fields and criteria are used to show students who first attended in the Fall of ’08.
The query is run and saved as “qry_Fall08”
Requirements: Assembly Language