BIS 245 LAB need done within 2 hours

DeVry University

Student Lab Activity

BIS245 Database Essentials for Business with Lab

A. Student Name:

B. Lab 1 Part C Questions:

1. Entities in the conceptual model eventually are converted to tables in the database, and the attributes convert to the fields within the tables. Given this information, list the attributes (fields) found in the supplier table.

2. With the Customers table sorted in alphabetical order by city, what is the name of the first customer to appear in the table?

3. Who are the customers located in the Tennessee?

4. List the tables along with the primary key for each.

5. List the tables related to the Orders table.

6. Open query Inventory on Hold by double clicking that query. What data is in this query (give the column names)? What is the Quantity on Hold for Northwind Dried Plums?

Version 1.0 Page 1 of 9

4/9/2009 Lab Activity MDD WBG310-A1

Copyright © 2015 by DeVry Educational Development Corporation.

All rights reserved. No part of this work may be reproduced or used in any form or by any means – graphic, electronic, or mechanical, including photocopying, recording, Web distribution or information storage and retrieval systems – without the prior consent of DeVry Educational Development Corporation.

Lab Activity BSBA BIS245A-1.docx Page 1 of 1