Contact

•

Resume

•

LinkedIn Logo
Autobase Logo
  • Auto Dealer Database
  • Overview: Team Project For an Auto Dealership Database
  • Developed ERD for my team's Final Project for CNIT 392 (Enterprise Database Management) at Purdue.
First ERD Design
  • Meeting Requirements
  • We met with Your Choice Autos and were given pdfs they fill out when purchasing and selling cars. We began by first designing a database around those documents and additional information they wanted to track. We settled on 14 tables to track this information which we modeled in Oracle SQL Developer
Revised ERD Design
  • Revising the ERD
  • Your Choice Autos is a small chain of dealerships in the Chicago area. A large database would be overly complicated for their needs. Our previous design was more expandable, allowing for the storing of tax information associated with different states and counties, which was determined to be unnecessary, as was tracking of references and insurance. Payment and Layaway plans were always short term, lasting no more than a few months. Tracking all this information would cost employee time with no commensurate gain, so the tables were removed. This revision was better suited to the scope of the project and the business needs than our original design. With this database the dealership could easily track salesman performance, differences between purchase and sale prices and mileage, and overall inventory.
Click to Show Less Content Click to Show More Content
Vampire Game Logo
  • Unreal Engine Game
  • Overview: Team Project For An Interdisciplinary Game Development Class at Purdue
  • Lead a team of four students in the development of a video game for CGT 455 (Video Game Development) at Purdue from initial design to a single playable level featuring all of our initial planned mechanics.
Starting Area of Vampire Game
  • Managing a Team of Equals
  • This was the first project I'd done at Purdue where each teammember was capable and willing to contribute. To facilitate this I was able to set up Subversion on my home desktop and enable version control for the whole team to work on the project together at the same time. This saved us at the end of the project when a teammate added an endless loop to our code just before our presentation. We were able to roll back to a previous version and our presentation went off without a hitch. This project also was an opportunity for me to practice project management. We were a team of equals, so rather than control our direction and assign tasks, I lead discussion on what we needed to work on and let team members choose what tasks they wanted to work on and I took on the task they didn't want. I set our goals for each week based on those choices and pushed people to stay on track.