Assignments 9 & 10 -- The Big Lab -- Create A Database
This lab is the big lab. You will work with your team of 3 to 5 people to create a database designed for establishing Voting integrity in a general election

Background: The Board of Elections is concerned with voter manipulation through a variety of channels including social media, web broadcasting and printed media. They have tasked you their database experts to come up with a way to not only securely store the voter data, but link that data to metadata that can be used to determine the extent of exterior influence on voters during the election.

Your solution will be a "Vote From Home" solution that incorporates metadata from the voters interface device (which can be anything from a computer to a hand-held device) to help validate the voter.

Your team will break this problem down so that each person on the team has their own part to design. Even though the part design is done by a team member the parts must fit together as a whole. One team member must be responsible for the core functionality (the gathering and storing of the votes) and the other team members will use that data to make their parts of the database function.

While you do not technically have to make your database run in a live environment, I strongly suggest you use a solution you can download for free, build your tables and queries in and run them. This is really the only way to see if your design works.

Your team will present your solution on week 11 where you will also have the opportunity to see the other teams solutions. I will rank them. While it is possible for everyone to get a high score (even an A) the best solution gets the best score.
Assignment Submission Criteria
While your assignment will not be evaluated as stringently as it would if this were an English class, it is expected that you will make an effort to use capitalization, sentence structure and punctuation appropriately.
There are 3 sets of items to turn in for this assignment and a presentation:
  1. A database design with a section from each team member clearly marked with who did what -- what I am looking for is an ERD style design, but I am open to alternatives as long as I can understand the design from your work. You should include screen shots of your ERD(s).
  2. A non-trivial query designed to run on your section of the database (1 per team member). This query is intended to show off your skill so make it good. You should include screen shots of your queries.
  3. A database with tables containing sample data -- it does not have to be lots of records just enough so I can get an idea of how your design works and I can manually step through your query. You should include screen shots of your tables and data.


Return to Assignment Index