Create a brief presentation show and tell

Assignment Help Database Management System
Reference no: EM131223893

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.

2476_Database.jpg

Reference no: EM131223893

Questions Cloud

Determine the pseudo-period : EEEN222 Assignment - Using an oscilloscope (settings: 200 μs/div, 1V/div), we got the waveforms of u(t) - Determine the pseudo-period T of u(t)
Discuss bounded rationality : Discuss how bias has blocked your ability to make a rational decision. In your answer, discuss the heuristic that you may have used and the bias associated with that heuristic. What could you have done to overcome the bias generated by the heurist..
Principal components of telecommunications networks : "What are the principal components of telecommunications networks and key networking technologies?" Let's begin by describing the features of a simple network
Gantt chart and clearly defined milestones : HI6007 Assessment - Business Research Report Proposal - brief literature review of the research topic and project plan using a Gantt Chart and clearly defined milestones and description of data collection and analysis methods
Create a brief presentation show and tell : 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.
Important factor contributing to motivation : "Why do you think making progress ranks as the most important factor contributing to motivation according to a recent study? How can managers provide a sense of progress for employees working on long-range projects that might not show results for ..
Impact of unemployment on work motivation : If many unemployed are spending around 2 hours/day looking for work as some research indicates, how would you evaluate the impact of unemployment on work motivation?
What role do these have on the way the business operates : What role do these have on the way the business operates? Do the company's actions seem to align to their vision and mission statements?
Evaluate the ongoing success of a winery : Establishes a system to evaluate the ongoing success of a winery that a operates a restaurant  and service as the marketplace and company dynamics evolve.

Reviews

Write a Review

Database Management System Questions & Answers

  How will your team c

What steps will your team take if you need to seize any digital evidence and What documentation processes will you follow to help support any potential legal proceedings?

  What type of entertainment events are the most popular

What type of entertainment events are the most popular? Has this always been the case or has there been a shift in recent years - Which area of venues used for organizing events is most popular in past 10 years?

  What does the resulting relation schema look like

Show the FDs in this resulting relation. Is it in 2NF Is it in 3NF? Why or why not? (State assumptions, if you make any.)

  Use three-sphere model for systems management

Use the three-sphere model for systems management and brainstorm issues related to the change based on the business, technology, and organization spheres.

  Create a use case based on relating functional requirements

Describe (in a one to two (1-2) page narrative) a use case, complete with typical and alternate courses, that documents the event of a bank customer withdrawing money from an ATM.

  Creates a user-defined database role named orderentry

Write a script that includes these statements coded as a transaction, What does it mean to commit a transaction

  Create a data structure for the screen in the diagram

Create a data structure for the screen in the diagram. This will have components from both data stores

  Design a flowchart for a program

Design a flowchart for a program that declares an array of 10 characters. Program should count and print number of times a special character, (your choice, let say ‘a') has been found in the array.

  Contestants in the heavyweight division

At the State Fair Pie Eating Contest all contestants in the heavyweight division must weigh within 30 pounds of 250 pounds. Write a program that asks for a contestant's weight and then says if the contestant is allowed in the contest.

  Create a database for use by the employees

The vegetable database: You have to create a database for use by the employees of vegetables.com, an online store which sells many different vegetables, including onions, tomatoes, carrots, potatoes, squash, eggplants and zuchini

  Indicate the normal form of the relation

For each of the following relations, indicate the normal form of the relation. Put each relation in the 3NF.

  Granting privileges to the new user

Issue an INSERT statement to insert a new record in new user session - Login to the Oracle server using SQL Developer and write and execute the SQL command needed to create a new user with a username and password of your choosing.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd