BIS245 Lab1 - Copy

BIS245 Lab1 - Copy - DeVry University Student Lab Activity...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
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. Supplier ID Company Name Contact Name Contact Title Address City Region Postal Code Country Phone Fax Home Page 2. With the Suppliers table sorted in alphabetical order by city, what is the name of the first supplier to appear in the table? Grandma Kelly’s Homestead 3. Who are the Suppliers located in the USA? Grandma Kelly’s Homestead Bigfoot Breweries New England Seafood Cannery New Orleans Cajun Delights 4. List the tables along with the primary key for each. Suppliers – SupplierID Products – ProducID Copyright © 2010 by DeVry Educational Development Corporation.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 09/01/2011 for the course BIS 245 taught by Professor Adrian during the Spring '11 term at DeVry Fremont.

Page1 / 2

BIS245 Lab1 - Copy - DeVry University Student Lab Activity...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online