Unit 1 Lab 1

Satisfactory Essays
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

You May Also Find These Documents Helpful

  • Powerful Essays

    PT2520

    • 1263 Words
    • 7 Pages

    You will also submit eight screen shots of specific steps of the database for the project. These eight screen shots should each be a separate file. The filename of the screen shot will take the format of nnProject_XX_X, where nn is your initial and XX_X corresponds to the Step number in the section of Technical Steps of this lab. The following are the required screen shots for submission (Substitute your initials for nn):…

    • 1263 Words
    • 7 Pages
    Powerful Essays
  • Satisfactory Essays

    I think this relates to database development in a number of ways. One is how it starts, gathering information and finding the intent of the system. Next you must plan out how to set up the database, which is the vital information? What are the minor details? Then you set up your database fill in some test information insure it works properly and make needed adjustments. Finally you implement your database design where in it works properly you merely maintain and fix any errors.…

    • 317 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Ilab Instructions

    • 2258 Words
    • 10 Pages

    You will then open an existing Access database to explore database objects and to experiment with simple data manipulation using filters and sorts and to begin elementary work with relationships.…

    • 2258 Words
    • 10 Pages
    Satisfactory Essays
  • Satisfactory Essays

    3.06 Lab Worksheet

    • 364 Words
    • 2 Pages

    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
  • Satisfactory Essays

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

    • 782 Words
    • 4 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Unit 1 Lab 1

    • 432 Words
    • 2 Pages

    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
  • Satisfactory Essays

    moonstuff

    • 285 Words
    • 2 Pages

    Use the following data table to record data from the lab. You will need to do the following:…

    • 285 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    ddfdwqdewqrfqwrf

    • 1724 Words
    • 7 Pages

    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
  • Satisfactory Essays

    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
  • Good Essays

    Duration: 4 Hours After taking this course, the learner will be able to create databases and tables, and sort and retrieve data using SQL and MySQL.…

    • 944 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Stoichiometry Lab

    • 551 Words
    • 3 Pages

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

    • 551 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    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
  • Good Essays

    Netw202 week 1 lab report

    • 800 Words
    • 4 Pages

    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
  • Good Essays

    Journal4

    • 509 Words
    • 2 Pages

    Directions: Answer the following questions about your lab. Submit via Assignments in the Course Tools menu.…

    • 509 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    Network 209

    • 674 Words
    • 3 Pages

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

    • 674 Words
    • 3 Pages
    Satisfactory Essays