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

  Find and display the total owed for all taxpayers

Exit the program (If the user choices 4, the program will exit. If the user chooses 1, 2 or 3, the program will do what the menu item says it will do, and then the menu will appear again.

  Explain how principles of database management are applied

Create a 4- to 6-slide Microsoft® PowerPoint® presentation in which you explain how the principles of database management and your recommendations were applied to the project.

  Find out the internal schema of the above database

Find out the internal schema of the above database

  Distinguish the role of databases and database management

Distinguish the role of databases and database management systems in the context of enterprise systems

  Create a database design specification

The Enhanced Entity Relationship Diagram (EERD) produced with a drawing or case tool. Your EERD must use a 'standard' notation style such as Crows Foot or Chen.

  Gathering information using cross indexed

Using data mining, it is possible to gather information which has been buried that can be manipulated and cross indexed which could be a valuable information gathering technique for entities.

  Planning & implementing a data warehouse project

ABC Industries is a diversified global organization that provides a variety of services, including financial and technical, and manufactures its own numerous products. Its manufacturing base is spread across the globe. ABC's production facilities ..

  What is normalization and explain why it is important

Write the SQL SELECT statement to display the average rent of the properties. What is normalization? Explain why it is important. List and describe the 4 components of a database system.

  Develop a table that identifies top threats to new customer

Develop a table that identifies the top threats to the new customer rewards program at Kudler Fine Foods in preparation for your final report. Include the likely vulnerabilities each threat might exploit.

  Which part of the rdbms takes care of the data dictionary

Name the sub-systems of a RDBMS. Which part of the RDBMS takes care of the data dictionary and How?

  Show all the lastnames from the customers table

Show all the LastNames from the Customers table and any associated OrdersIDs from the Orders Table.

  Analyze the fundamentals of pki

Analyze the fundamentals of PKI, and determine the primary ways in which its features and functions could benefit your organization and its information security department.

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