Transcript Group 6 Presentation

Formula Society of
Automotive
Engineers
Omer Shalev, Ameet Salvi, Jon Thysell, Alex Brooks, Jyot Bawa, Michael Joyce, Jaime Mullins
10/21/2005
Group 6 IEOR 115
1
Background
 Student-group building competitive small
formula-style racecars
 Annual competition in Pontiac, Michigan
 Restricted budget of $25,000
 Private and public sponsorships
 Roughly 50 members
 Predominantly mechanical and electrical engineering
students
 Two faculty advisors
 Off-site studio in Richmond
10/21/2005
Group 6 IEOR 115
2
Database Entities









• Material
 Metal
 Reusable
 Plastic
 Rubber
 Other
• Supplier
• Part
 Custom
 Stock
Member
Job
Skill
Logbook
Trial
Car
Component
Contribution
Sponsor
10/21/2005
Group 6 IEOR 115
3
Simplified EER Diagram
Skill
contact
SPID
(1,N)
(0,N)
donate
(0,N)
level
has
(0,N)
PID
(0,N)
contacts
Student
Members
(1,N)
SUID
order
Parts
builds
has
d,t
custom
supply
Inventory
stock
(0,N)
(1,N)
IID
Logbook
(1,1)
creates
MID
Materials
has
conduct
(0,N)
(0,N)
Made
by
donates
Suppliers
quantity
build
Sponsors
SID
tools
quantity
other
Made
for
reusable
o,t
plastics
year
rubber
test
Trials
10/21/2005
Car
Date
time
support
Group 6 IEOR 115
metal
Contributions
CID
4
Summary
 Members
 The group consists of student members that
perform a variety of functions from fabricating
parts and conducting trial runs to contacting
contributing donors. SID numbers are stored
along with the various skills, tasks and
responsibilities associated with each member
10/21/2005
Group 6 IEOR 115
5
Summary
 Parts
 The car consists of custom parts produced by
students for a specific car and stock items
purchased from suppliers.
 Parts are organized in an inventory
warehouse along with materials used during
the course of the project. FSAE specifically
requested that the completed database
contain detailed and flexible inventory
management features for the annual report.
10/21/2005
Group 6 IEOR 115
6
Summary
 Car
 A car undergoes a series of
experimental trials and
consists of several different
systems supported by
individual members.
 Although a new car is
constructed, it may include
parts and sponsor
contributions from previous
years.
10/21/2005
Group 6 IEOR 115
7
Summary
 Donors
 Donors contribute annually in a variety of
ways to assist FSAE. Contact information and
donations must be stored in order to credit the
private and public sponsors that support
FSAE’s annual budget.
10/21/2005
Group 6 IEOR 115
8
Additional Requirements
 Commentary fields are essential in order to
capture specific instances
 Substantive Queries
 Design Forms
 Final Report Submission for Annual Competition
 Parts (custom and stock)
 Suppliers
 Costs
10/21/2005
Group 6 IEOR 115
9
Project Schedule
Group Deadlines
 Revised EER Diagram – Deadline 10/25
 5 Queries in English – Deadline 11/15
 Executive Summary – Deadline 11/19
 Tables and relationships in Access – Deadline 11/16
 SQL with implementation – Deadline 11/18
 Final Presentation w/Access – Deadline 12/8
 Final Report – Deadline 12/12
10/21/2005
Group 6 IEOR 115
10