Group 6 Presentation

Document Sample
Group 6 Presentation Powered By Docstoc
					              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
    Member                            • Material
    Job                                   Metal
    Skill                                 Reusable
                                           Plastic
    Logbook                               Rubber
    Trial                                 Other
    Car                               • Supplier
    Component                         • Part
    Contribution                          Custom
    Sponsor                               Stock



10/21/2005          Group 6 IEOR 115                   3
                 Simplified EER Diagram
                                                                                                                                                      SPID
                                    Skill                                   (1,N)
                                                               contact

                                                                                                     donate           (0,N)
                                                                                                                                       Sponsors
                                                 (0,N)                            SID
                                 level                                                                                                                (0,N)
                                            has
                                                         (0,N)                                       contacts
                                                                    Student
                                                                    Members                                     (1,N)
           PID                                                                                                                SUID
                                                                                                     order                                        donates

              Parts
                                                 quantity
                                                                                                                   Suppliers
   build                                                                 builds
                                     has
                 d,t                                                                                                      (0,N)
                                                                                                  (0,N)
                                                                                                                   supply                             (1,1)
                                         Inventory
   custom                                                                                  creates
                       stock
                                                                                                                        (0,N)
     Made                                                   IID                                         (1,N)                    MID
      by
                                           has
                                                                                                                 Materials
                                                                                              tools
           Logbook                                  quantity

                         Made                                                                 other
conduct                   for
                                                                                                                        o,t          reusable
                                                                                                  plastics
                                                                             year
                          test
                                                                                                                                       rubber
                                                                                                                 metal
     Trials                                                       Car                   support

                       Date                                                                                                   CID
 10/21/2005                                                                 Group 6 IEOR 115          Contributions                                         4
                       time
                      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

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:10
posted:3/26/2012
language:
pages:10
yaohongm yaohongm http://
About