Transcript Chapter 6 Practice 1 - Presenting the Group Project

The Computer Super Store
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 orders,
customers, and products in a Computer store.
There is a:
–
–
One-to-many relationship between customers and
orders; one customer can have many orders, but a
specific order is associated with one customer.
Many-to-many-relationship between orders and
products; this requires the creation of another table
that contains the primary key of both the Orders and
Products tables
The Design
Combination of OrderID and
ProductID is unique
Information from the Database
Query: What orders were
placed by John Smith?
Solution: Search the
Customers table to
determine John’s
CustomerID, then go to
the Orders table to find
all loans for that
CustomerID
Information from the Database
Query: Which products
appeared in order 1?
Solution: Search the
Order Details table for all
records for Order 1; take
the ProductID of those
records to the Products
table to learn product
names.
Information from the Database
Query: What is the
customer’s phone
number for Order 6?
Solution: Search the
Orders table for Order 6,
then take the CustomerID
to the Customers table to
obtain the phone number.
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