Upload your final project code and your presentation. Upload all of your code in one large text file that has the .sql extension. Be sure to identify each section of code so that the reader will know what it does. All code must run successfully on the reader's computer. Also create a brief presentation (show and tell) using the Chrome browser Media Core add in. Using Mediacore (a Chrome add in), put together and show a demonstration of your database and queries. Mediacore uses the speaker on your computer to capture your words, and also captures your screen. Instructions on how to use Mediacore are provided below:
Mediacore Capture Instructions
Note: All of the videos you saw in the class were made using Mediacore within the Chrome Browser. An alternative to using Mediacore is to just create a PowerPoint presentation that explains the purpose of your database, shows the EER diagram, and shows the results of a few significant queries that you select to show.
Upload your completed database code (each section identified), and Mediacore presentation or PowerPoint presentation to Canvas.
You may provide a PowerPoint presentation as an alternative.
As a reminder, content requirements for the final project are provided below.
EER diagram showing your tables and relationships.
A database with a minimum of four tables that are populated with data and properly related. Each table must be in 3rd Normal Form. Submit the code to create the database, create the tables, and to populate the tables with data. Be sure the code used to design and create all runs properly. I will use it generate the database and tables. It must work correctly. Note that you only need to minimally populate each table; just enough for the database to provide meaningful results.
Two of the tables will have many-to-many relationships and thus will need a linking table to connect/relate them. Be sure the code used to perform the queries, views, and procedures all runs properly. I will use it generate the results. All must work correctly.
Write and submit all code to create four queries that provide meaningful information. Two of the four queries must perform calculations.
Be sure to identify each section of code so that the reader will know what it does.
In addition to submitting the code, also submit a Media Core presentation of less than 10 minutes in duration. Use this presentation to demonstrate your database. You may substitute a PowerPoint presentation in lieu of the Mediacore presentation. Be sure to explain the purpose of your database and show the EER, the tables, and the results of significant queries.
