User Account

All Pages

Create query by using either query designer or query wizard

Assignment Help Database Management System
Reference no: EM131584954

Assignment: Lab Overview

Scenario/Summary

Part A: You have been asked to create a database model using MS Visio Database Model Diagram Template. The purpose of this Lab is to provide experience designing, with limited instructions, a simple database based on a list of data requirements and associated business rules.

Upon completing this Lab, you will be able to

• create a new Visio file for database design; and

• using the data requirements and the business rules provided, develop a conceptual model (ERD), including attribute data types and required field lengths.

Part B: The Lab begins with a simple example of query development using Access; then, evolves to more complex queries which the student should perform after completing the first exercise. Create a query using the wizard with query-design view or with SQL statements. The Northwind (NWind) database will be used again in this Lab.

Upon completing this lab, you should be able to

• create a query by following lab instruction;
• create a query by using either Query Designer or Query Wizard;
• create a query by using SQL statements; and
• interpret the results of queries.

Deliverables

Part A: YourNameLab4A.vsdx (Visio Diagram)

Part B: YourName_Lab4B_Finital.accdb (Access Database)

Required Software

Microsoft Office: Word 2013, Visio 2013, and Access 2013

Options for accessing the software:

1. Use a personal copy on your PC. You can request a copy of Microsoft Office 2013 via the Student Software Store icon on the Course Resources Page. Microsoft Office is located on the Students tab and all other Microsoft products, such as Visio and Access, are located on the DreamSparks tab.

2. If you are a MAC user, click to read the MAC User Information.

3. DeVry virtual lab environment to access all Microsoft Office software. For additional information about the virtual lab and how to save files, the Lab icon on the Course Resources page.

Lab Steps

STEP 1: Complete the Week 4a and 4b Labs

Download and complete the Lab Instructions.

• To begin the Lab download the Lab starter file.

https://www.dropbox.com/s/c5x9543dknbcz3w/Attachments.rar?dl=0

Reference no: EM131584954

Questions Cloud

Identify audience and the reason for the presentation : You will summarize the software components here, pointing out major components or differences in major components - Internet Connectivity and Web Services
What were the most radical aspects of longs plan : What were the most radical aspects of Long's plan? Did any of his ideas become reality? Upon whose law did Long base his ideas?
What is the journal entry to record raw materials used : Bunnell Corporation is a manufacturer that uses job-order costing, On January 1, What is the journal entry to record raw materials used in production
Create unique hypothetical weighted average cost of capital : Create a unique hypothetical weighted average cost of capital and rate of return. Recommend whether or not the company should expand, and defend your position.
Create query by using either query designer or query wizard : create a query by using either Query Designer or Query Wizard; Create a query by using SQL statements; and interpret the results of queries.
Write out the ten fibonacci numbers : Find a formula for the sum of the first n odd-index Fibonacci numbers (F1, F3, etc.).
Possess upon completion of the training : Describe the purpose of the training-be sure to describe the skills that basic users should possess upon completion of the training.
Why does each crime-fighting official make the claim : A person is murdered at twilight near the outskirts of a town of population 5,000, in view of several witnesses. The dastardly murderer has been described.
List the form and database design : List the form and database design problems with this design. Hint: Draw on your knowledge of good user interface and database design concepts and practices.

Reviews

Write a Review

Database Management System Questions & Answers

  Write the first line fo the definition for a poodle class

Design a class and a program that creates an object of the class and prompts the user to enter the name, type, and age of his or her pet.

  What are four pieces that make up key performance indicator

What are the four pieces that make up a Key Performance Indicator (KPI)? Provide an example of a KPI based on the AdventureWorks database.

  Determine the steps in development of an effective entity

Determine the steps in the development of an effective Entity Relationship Model (ERM) Diagram and determine the possible iterative steps / factors that one must consider in this process with consideration of the HR core functions and responsibili..

  Use a two-dimensional array to accumulate the number

Create a form containing labels with each of the questions and a group of radio buttons for each question with the following responses: Always, Usually, Sometimes, Seldom, Never.

  Write a query to display the patron id and full name

Use the Ch08_Fact database shown in Figure P8.44. For problems with very large results sets, only the first several rows of output are shown in the following.

  Draw the relationships between the tables

Draw the relationships between the tables. Assume that a DEPARTMENT does not need to have an EMPLOYEE, but that every EMPLOYEE is assigned to a DEPARTMENT.

  Completing transaction using sql

Write down the complete transaction using SQL.

  How organizations can use data warehouses and data marts

Write a one- to two-page (250-500 word) paper that discusses the differences between data warehouses and data marts. Also, discuss how organizations can use data warehouses and data marts to acquire data.

  Generate scatter plot of age vs charges in database

Use ggplot2 to generate a scatter plot of age vs. charges in the heart attack dataset. Create a 5 by 5 matrix with a sequence of 1 to 5 for the diagonal

  Draw the appropriate physical data flow diagram

Prepare a table of entities and activities -  Draw the corresponding context diagram and draw the appropriate physical data flow diagram (DFD).

  Use an entity relationship diagram to define the structure

Use an entity relationship diagram to define the structure of the system.

  How would you define a relational database

How would you define a relational database? What is "normalization" and why do we normalize DBs

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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