Essay BIS 245 (BIS245)

DeVry University
Student Lab Activity
BIS245 Database Essentials for Business with Lab


A. Student Name: NEED HELP ? Contact


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.
 Company,
 supplier Id,
 zip or postal address,
 business phone and home phone job title,
 first name,
 last name,
 email address,
 web page,
 state or province,
 city,
 fax,
 address and attachments.



2. With the Customers table sorted in alphabetical order by city, what is the name of the first
customer to appear in the table? Boise, ID- Customer name: Xie, Ming Yang



3. Who are the customers located in the Tennessee?
 Raghav,
 Ludick,
 Amritansh,
 Andre



4. List the tables along with the primary key for each.
 Customers (customer ID),
 employee privileges (Employee ID),
 employees (Employee ID),
 invoices (Order ID),
 Inventory transactions (Transaction ID),
 inventory transaction types (ID),
 suppliers (ID),

unoconv_3456614784.docx Page 1 of 2