Transcript Chapter 7 Practice 1- Presenting the Group Project

Any Sports League
A Sample Presentation
Depicting the
Requirements of Your
Group Project
The Assignment



A (maximum) 10 minute presentation to the
class. Class time, however, may limit the
presentations to three groups (drawn by lot).
Describe the physical problem and database
design (the tables and relationships) that will
be used to implement the system.
Illustrate the type of information to be
obtained from the system and the means of
obtaining that information.
Describe the System and
Its Relationships

Our system is intended to track the teams,
players, and coaches in an intramural sports
(soccer) league. There is a:
–
–
One-to-many relationship between teams and
players; one team can have many players, but a
specific player is associated with one team.
One-to-many-relationship between teams and
coaches; one team can have many coaches, but a
specific coach is associated with one team.
The Design
TeamID is a foreign key in
both the Players table and
the Coaches table
Information from the Database
Query: Which players
are on the Comets?
Solution: Search the
Teams table for the
Comets, then take the
TeamID to the Players
table to list all players
with that TeamID.
Information from the Database
Query: What color uniform
does Jodi McPherson
need for Saturday?
Solution: Search the
Players table to determine
Jodi’s TeamID, then go to
the Teams table to find the
team colors
Information from the Database
Query: What is the phone
number of Natalie
Anderson’s coach?
Solution: Search the
Players table for Natalie,
get her TeamID, then
search the Coaches table
to locate the coach(es)
with that TeamID to get the
phone number(s).
A Contract Between You
and Your Professor



Your presentation becomes a contract between
you and your professor with respect to the
database design. Additional requirements will
be specified later.
The completed system must be able to add,
edit, or delete any object through a form
The completed system must be capable of
creating your sample queries which in turn
reflect any changes to the data
Delivering the Presentation




Use PowerPoint to make the presentation as
polished as possible.
All members of the group are to be in front of
the room during the presentation.
Maintain eye contact, speak in sufficient
volume, etc.
Handouts of the printed relationships diagram
are required for the class