Preview

Unit 1 Lab 1

Satisfactory Essays
Open Document
Open Document
422 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Unit 1 Lab 1
Unit 1 Lab 1.1 – Explore the AdventureWorks Database Using the SQL Server Management Studio

Learning Objectives and Outcomes
Identify major relational database management systems (RDBMS).
Identify main characteristics of relational databases.

In this lab activity, you will explore a relational database in SQL Server 2008 Express. You should complete Lab 1.1: Explore the AdventureWorks database using the SQL Server Management Studio from the lab manual. At the end you should submit a document with screen-shot in Step 13.

Required Setup and Tools
See Lab Manual for Database Concepts for details on required setup and tools for this lab.

Recommended Procedures
See Lab Manual for Database Concepts for details on recommended procedures.

Deliverables
See Lab Manual for Database Concepts for details on deliverables.

Unit 1 Lab 1.2 – Define Major Topics for a Database
Learning Objectives and Outcomes
Identify some indications of where a database could be useful.
Define a statement of work for a given scenario.

In this lab activity, you will identify major topics to define a database. You should complete Lab 1.2: Define Major Topics for a Database from the lab manual. You should submit a document by completing the table in step 2.

Required Setup and Tools
See Lab Manual for Database Concepts for details on required setup and tools for this lab.

Recommended Procedures
See Lab Manual for Database Concepts for details on recommended procedures.

Deliverables
See Lab Manual for Database Concepts for details on deliverables.

Unit 1 Lab 1.3 – Create a Statement of Work
Learning Objectives and Outcomes
Define a statement of work for a given scenario.

In this lab activity, you will draft a statement of work (SOW). You should complete Lab 1.3: Create a Statement of Work from the lab manual. You should submit a document by completing the table in Steps 2 and 3.

Required Setup and Tools
See Lab Manual for Database Concepts for details on required setup and tools for
Continue Reading
View Writing Issues

You May Also Find These Documents Helpful

  • Good Essays

    Huffman Trucking Service Request Sr-Ht-003 Essay Example
    • 820 Words
    • 4 Pages

    Huffman Trucking Service Request Sr-Ht-003 Essay Example

    In Change Request 3 we were to link the tables and to create tables for the Fleet Truck Maintenance database with ten records of test data. By putting these ten records of test data, the database can be tested to see if possible “bugs” or if anything is missing in the data system. Another thing we used in the testing and development of this database is use of an entity relationship . Entity Relationship Diagrams are a major data modeling tool and will help organize the data in your project into entities and define the relationships between the entities. This process has proved to enable the analyst to produce a good…

    • 820 Words
    • 4 Pages
    Good Essays
    Read More
  • Good Essays

    Cis/336 Ilab 5 of 7 - Sql Course
    • 1559 Words
    • 7 Pages

    Cis/336 Ilab 5 of 7 - Sql Course

    This lab will utilize a set of tables found in the script file (LeeBooks.sql) found in the Doc Sharing area of the website. If you have not yet downloaded this file from Doc Sharing then do so now. Once you have downloaded the script file, import and run the script in SQL*Plus.…

    • 1559 Words
    • 7 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    IT 240 Latest Version Set (A) Week 6 Assignment Work Group Scenarios
    • 694 Words
    • 4 Pages

    IT 240 Latest Version Set (A) Week 6 Assignment Work Group Scenarios

    Name your Access database file using Lab3_, your first initial, and your last name (e.g., Lab3_JSmith.accdb). Create and save your Access database file. When you are done, submit your database to the Course Project Dropbox.…

    • 694 Words
    • 4 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    DBM 380 Week 4 Individual Paper Normalization of the ERD
    • 644 Words
    • 4 Pages

    DBM 380 Week 4 Individual Paper Normalization of the ERD

    Reflect on the textbook readings. Using the search strings listed in the Electronic Reserve Readings for Week one search for additional information on database systems. What information would your provide to an organization or your employer on why database systems should be used?…

    • 644 Words
    • 4 Pages
    Satisfactory Essays
    Read More
  • Powerful Essays

    PT2520
    • 1263 Words
    • 7 Pages

    PT2520

    Upon completion of the project, you will submit a MS Word document with the answers to the three questions integrated within the project at key points. Questions 1 & 2 are located at the end of Step 11 and Question 3 at the end of Step 12 of the Technical Steps section of this lab. This MS Word document will be named nn_Projectanswers.doc where “nn” will be changed to your initials.…

    • 1263 Words
    • 7 Pages
    Powerful Essays
    Read More
  • Satisfactory Essays

    PartOneFlameTest1 CreateandcompleteadatatableforPartOneofthelabItshouldinclude
    • 328 Words
    • 2 Pages

    PartOneFlameTest1 CreateandcompleteadatatableforPartOneofthelabItshouldinclude

    1. Create and complete a data table for Part One of the lab. It should include the name of…

    • 328 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Good Essays

    Stoichiometry Lab
    • 551 Words
    • 3 Pages

    Stoichiometry Lab

    Before beginning, set up a data table similar to the Data Table: Experiment Results in the Lab…

    • 551 Words
    • 3 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    3.06 Lab Worksheet
    • 364 Words
    • 2 Pages

    3.06 Lab Worksheet

    Insert completed data tables for each part of the lab. Be sure that the data tables are organized and include units when necessary.…

    • 364 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Good Essays

    CMGT 400 Week 1 DQs
    • 676 Words
    • 3 Pages

    CMGT 400 Week 1 DQs

    The project for CIS336 is designed to touch all aspects of the fundamental concepts of database design and logical data modeling covered during the class. The project is team centered and each team will be responsible for designing, developing, and demonstrating the functionality of a database created based on a defined set of business specifications. At the end of the session, each project team will submit the database designed by the team and demonstrate the database's ability to deliver the required information as outlined in the project specifications. All aspects of the project will be ...…

    • 676 Words
    • 3 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    Chemical Reaction and Equilibrium
    • 782 Words
    • 4 Pages

    Chemical Reaction and Equilibrium

    Insert data tables for each part of the lab (Part I, Part II, and Part III).…

    • 782 Words
    • 4 Pages
    Satisfactory Essays
    Read More
  • Good Essays

    Netw202 week 1 lab report
    • 800 Words
    • 4 Pages

    Netw202 week 1 lab report

    1. Make sure that you understand the objective of the lab(s) and the requirements for successfully performing them.…

    • 800 Words
    • 4 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    Unit 1 Lab 1
    • 432 Words
    • 2 Pages

    Unit 1 Lab 1

    This project will develop and deliver a new way of knowing the status of software owned by Grandfield College for machines used by faculty and staff. The database that will be created will track the location of the software that Grandfield College owns. The new database will display a number of software which the school owns, where they are located, who uses the software, and what are the versions of the software owned by the school. Also, despite the version or the software, all versions and software will have (need to have) a “site” license. This database will be developed to enable additional products to be added to it over a period of time and be easy to maintain.…

    • 432 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Powerful Essays

    ddfdwqdewqrfqwrf
    • 1724 Words
    • 7 Pages

    ddfdwqdewqrfqwrf

    Each lab in this manual requires that you answer questions, take screen shots, and perform other activities that you will document in a worksheet named for the lab, such as Lab12_worksheet.docx. It is recommended that you use a USB flash drive to store your worksheets, so you can submit them to your instructor for review. As you perform the exercises in each lab, open the appropriate worksheet file, fill in the required information, and save the file to your flash drive.…

    • 1724 Words
    • 7 Pages
    Powerful Essays
    Read More
  • Better Essays

    Riordan Manufacturing Database Plan
    • 3100 Words
    • 13 Pages

    Riordan Manufacturing Database Plan

    Normalization of the database: This is a critical step for making the database. Normalization will help create table structures as well…

    • 3100 Words
    • 13 Pages
    Better Essays
    Read More
  • Satisfactory Essays

    LAB 1 Umeamara Introduction
    • 655 Words
    • 16 Pages

    LAB 1 Umeamara Introduction

    In order for data to be easily analyzed it must first be entered into a computer data base. Create a…

    • 655 Words
    • 16 Pages
    Satisfactory Essays
    Read More

Related Topics