Create a new visio file for database design

Reference no: EM13779545

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 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.

Reference no: EM13779545

Questions Cloud

Conglomerates and market domination : The purpose of this discussion is to understand the role of corporations in the modern world, and evaluating ethical aspects of corporate market domination. Prepare and post a response to the following prompts:

Applying theory: environmental issues : The goal of this assignment is to apply an ethical theory to a real-world situation. You will examine an environmental issue, and apply one of the ethical theories to understand how human interactions with the natural environment raise ethical con..

Assignment on network security : the selection of a virtual private network (VPN) for a midsize network.You shall actually identify the hardware and software needed to meet the network security and users requirements.

To what extent is valentine committing a political blunder : What advice can you offer Parker about his approach to empowerment? To what extent is Valentine committing a political blunder in telling her boss that he is a yo-yo delegator

Create a new visio file for database design : Create a query by following lab instruction and create a query by using either Query Designer or Query Wizard;

Drawing storyboards and wireframes : Drawing such as storyboards and wireframes can be drawn by hand or software and embedded in the document or submitted as a separate file.

Write a paper about every day by sven birkerts : Write a paper about "Every Day" by Sven Birkerts. This text can be considered creative nonfiction for several reasons. For one, the voice of the author draws me to the story.

How should ivan and courtney have handled the situation : How should Ivan and Courtney have handled the situation, To what extent do you think Maya's behavior is justifiable

Case that raises major ethical issues : Watch the movie The Corporation and select a case that raises major ethical issues. If you were absent Wednesday, the movie is available on

User Account

All Pages