Formula Society of Automotive Engineers

1
Formula Society of Automotive Engineers

• Omer Shalev, Ameet Salvi, Jon Thysell, Alex
  Brooks, Jyot Bawa, Michael Joyce, Jaime Mullins

2
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

3
Database Entities

• Member
• Job
• Skill
• Logbook
• Trial
• Car
• Component
• Contribution
• Sponsor

• Material
• Metal
• Reusable
• Plastic
• Rubber
• Other
• Supplier
• Part
• Custom
• Stock

4
Simplified EER Diagram
SPID
(1,N)
contact
Skill
donate
(0,N)
Sponsors
SID
(0,N)
level
(0,N)
has
contacts
(0,N)
Student Members
(1,N)
SUID
PID
order
donates
Parts
Suppliers
quantity
builds
build
has
(0,N)
d,t
(0,N)
supply
(1,1)
Inventory
creates
custom
stock
(0,N)
MID
IID
(1,N)
Made by
Materials
has
tools
Logbook
quantity
other
Made for
conduct
o,t
reusable
plastics
year
rubber
test
metal
support
Car
Trials
CID
Date time
Contributions
5
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

6
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.

7
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.

8
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 FSAEs annual budget.

9
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
Project ScheduleGroup 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