Microsoft Office Tutorials and References
In Depth Information
ASSIGNMENT 1: CREATING THE DATABASE DESIGN
Keep in mind that some students have joined more than one intramural team in different sports.
When John needs to schedule games or tournaments, he uses a large wall calendar to record the name of the
sport, the names of the teams, and the time of day and venue where the event will occur. When the event is
over,Johnrecordstheendingtimeandputsagoldstarnexttothewinningteam
s name on the same calendar.
Once a good database is designed and implemented, John can envision plenty of information he can
glean from the system. For example, John often has wanted a list of all students who have not had a medical
exam. You suggest that a query will answer that question. In addition, the team captains constantly ask for an
updated list of their team members and their phone numbers. This list often must be printed immediately
before a game because students join and quit intramural teams frequently. You suggest that a parameter
query could be effective in this situation; the captain could enter his team
s color and get a current listing of
team members.
John is curious to know how long each game lasts, because he has received some comments about long
games. He would also like to know how many students are on each team. Again, you realize that the answers
to both questions could be captured by queries. John would also like to be able to add students to teams and
remove them from teams. You tell John that a form and subform could be used for additions, and that a
delete query would be appropriate to remove a student from a team.
Finally, you suggest creating a report that displays the amount of time each referee has worked in
intramural games. John can use this information to thank the refs by giving them awards, gifts, or pay.
ASSIGNMENT 1: CREATING THE DATABASE DESIGN
In this assignment, you will design your database tables using a word-processing program. Pay close attention
to the tables
logic and structure. Do not start developing your Access code in Assignment 2 before getting
feedback from your instructor on Assignment 1. Keep in mind that you will need to examine the requirements
in Assignment 2 to design your fields and tables properly. It is good programming practice to look at the
required outputs before beginning your design. When designing the database, observe the following guidelines:
￿
First, determine the tables you will need by listing the name of each table and the fields it
should contain. Avoid data redundancy. Do not create a field if it can be created by a
calculated
field
in a query.
￿
You will need a transaction table. Although no money is changing hands in this system, events
are occurring, and they are considered transactions. Avoid duplicating data.
￿
Consider using a logical field to note whether each student has had a medical exam.
￿
Document your tables using the table feature of your word processor. Your tables should
resemble the format shown in Figure 3-1.
￿
You must mark the appropriate key field(s) by entering an asterisk (*) next to the field name.
Keep in mind that some tables might need a compound primary key to uniquely identify a
record within a table.
￿
Print the database design.
Table Name
Field Name
Data Type (text, numeric, currency, etc.)
FIGURE 3-1
Table design
NOTE
Have your design approved before beginning Assignment 2; otherwise, you may need to redo Assignment 2.
Search JabSto ::




Custom Search