EdwardHernandez_Lab1C_Questions

EdwardHernandez_Lab1C_Questions - DeVry University Student...

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: Edward Hernandez 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. a. SupplierID b. SupplierCompanyName c. SupplierContactName d. SupplierContactTitle e. SupplierAddress f. SupplierCity g. SupplierRegion h. SupplierPostalCode i. SupplierCountry j. SupplierPhone k. SupplierFax l. SupplierHomePage 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.
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.

Page1 / 2

EdwardHernandez_Lab1C_Questions - DeVry University Student...

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