1 / 26

Automatic Drink Mixer Design Review

Automatic Drink Mixer Design Review. Ryan Bowen Jake Czapeczka Ken Smith Jr. Team Members:. Agenda. Overview of System Review of Components Plumbing (Physical Components) Circuitry Database System Software Interface Discussion. System Overview. Normal Operation System Setup

cora
Download Presentation

Automatic Drink Mixer Design Review

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. Automatic Drink Mixer Design Review Ryan Bowen Jake Czapeczka Ken Smith Jr. Team Members:

  2. Agenda • Overview of System • Review of Components • Plumbing (Physical Components) • Circuitry • Database System • Software Interface • Discussion

  3. System Overview • Normal Operation • System Setup • Drink Selection • Liquid Dispensing

  4. System Overview • Abnormal Operation • Bottle Replacement • Manual System Halt • Software System Halt

  5. Plumbing • Tubing/Fittings • Solenoid Valves / Air Relief Valves • Air Pressure System • Physical Layout • Cabinet

  6. Plumbing – Tubing/Fittings • Tubing Type • Plastic and flexible • Tubing Sizing • Flow rate • Length of tubing • Compression Fittings • Nicely interfaces with solenoid valves

  7. Plumbing – Valves • Solenoid Valves • 12 DC 0.25A • Operating Range 0 – 40 psi • Normally Closed • Air Relief Valves • Removes air from line • Need to be oriented at an apex

  8. Plumbing – Air Pressure System • Air Compressor • Max Pressure – 135 psi • Volume – 1.5 gallon tank • Automatic pressure maintenance • Pressurized Bottles • Air input, liquid output lines • Rubber stopper

  9. Plumbing – Physical Layout • A – Solenoid Valve 1 • B – Solenoid Valve 2 • C – Air Relief Valve • D – Bottle with Rubber Stopper • E – Check Value • F – Air Compressor • 1 – Multiple F-E Connections • 2 – Normalized Filling Chamber • 3 – Pressurized Liquid • 5 – Liquor Dispenser

  10. Plumbing - Cabinet

  11. Circuitry • Parallel Port • PAL Chip • Darlington Circuit • Next State Logic • Java-based Hardware Drivers

  12. Circuitry – Parallel Port • Parallel Port Pin out • Line Control (Bits 0 – 4 ) • Solenoid Control (Bits 5,6) • System Pause (Bit 7)

  13. Circuitry – PAL Chip • System calls for 64 solenoid valves to be controlled by 7 bits. • PAL chips allow for full selection programming • Global reset can be include in PAL • PAL also can fake internal clock

  14. Circuitry – Darlington Circuit • Solenoid valves require more voltage and current than normal TTL • Darlington circuit – consists of pair of BJT transistors • Able to drive large load • 5V TTL compatible

  15. Circuitry – Next State Logic

  16. Circuitry – Drivers

  17. Database System • Database Manager – PostgreSQL • Scheme - UML Diagram • Database Drivers (JDBD and Custom) • Add/Delete/Modify as Triggers

  18. Database – PostgreSQL • PostgreSQL - Database Manager • Freely Available • Cross-Platform Capable • Object-Oriented Database • PGAdmin – Database Utility • Graphically manage database • Shell provided to execute SQL queries

  19. Database – UML Diagram FK – Foreign KeyPK – Primary Key Bold – Required

  20. Database – JDBC Driver • JDBC – Java driver package • Library of function calls specific to the database manager (PostgreSQL) • These function calls allow for connections, queries, and updates to the database • Required in the CLASSPATH

  21. Database – Custom Drivers • Custom Java-based Database Drivers • Database Controller • Establishes connection to database • Queries the database • Drink Controller • Retrieves and stores data that involve drinks including their recipes and ingredients • Cabinet Controller • Retrieves and stores data that is involve with the physical components (Bottles used, Quantity, etc)

  22. Database - Triggers • Triggers • SQL code sequences • Stored within the Database Manager • Executed locally to the Database Manager • Possible Trigger Implementation • Adding/Deleting/Updating data where constraints exist • Example – Adding an ingredient for a drink

  23. Software - GUI • Main Frame – application foundation • Bottle Pane • Top10 & Recent Recipes • Search Pane • Browse Pane • Custom Pane

  24. Software – GUI • Bottle Pane • Progress Bars for Fluid Levels • Bottle Status Database Driven • Top 10 Drinks • Polls Database for Top 10 drinks • 10 Most Recent Recipes • Polls Database for last 10 unique drinks made

  25. Software - GUI • Search Pane • Searches database drink names like string in a text field. • Browse Pane • Search database drink names based on its ingredients • Custom Pane • Create your own drink by adding ingredients and their quantities.

  26. Questions and Comments

More Related