1 / 10

Formula Society of Automotive Engineers

Formula Society of Automotive Engineers. Omer Shalev, Ameet Salvi, Jon Thysell, Alex Brooks, Jyot Bawa, Michael Joyce, Jaime Mullins. Background. Student-group building competitive small formula-style racecars Annual competition in Pontiac, Michigan Restricted budget of $25,000

cora
Download Presentation

Formula Society of Automotive Engineers

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Formula Society of Automotive Engineers Omer Shalev, Ameet Salvi, Jon Thysell, Alex Brooks, Jyot Bawa, Michael Joyce, Jaime Mullins Group 6 IEOR 115

  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 Group 6 IEOR 115

  3. Member Job Skill Logbook Trial Car Component Contribution Sponsor Material Metal Reusable Plastic Rubber Other Supplier Part Custom Stock Database Entities Group 6 IEOR 115

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

  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. Group 6 IEOR 115

  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. Group 6 IEOR 115

  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 FSAE’s annual budget. Group 6 IEOR 115

  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 Group 6 IEOR 115

  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 Group 6 IEOR 115

More Related