Lab 1 Part C Essay

399 WordsJul 21, 20132 Pages
A. Student Name: Donna McKnight – D03553628 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. The attributes (fields) in the supplier table are: The company, customer last name, customer first name, e-mail address, job title, business phone, home phone, mobile phone, fax number, address, city and state/providence, zip/postal code, Country/Region, Web Page, Notes, attachments and drop down menu to add other data. 2. With the Customers table sorted in alphabetical order by city, what is the name of the first customer to appear in the table? Ming-Yang Xie is the first customer to appear in the table when the table is sorted in alphabetical order by city. 3. Who are the Customers located in the Tennessee? The customers located in Tennessee are Andre Ludick and Amritansh Raghav. 4. List the tables along with the primary key for each. Customers – primary key is customer ID Shippers – primary key is shipper ID Order Status – primary key is status ID Orders – primary key is the order ID Orders Tax Status – primary key is the tax status ID Order Details – primary key is the ID Invoices – primary key is the invoice ID Inventory Transactions – primary key is transaction ID Employees – primary key is employee ID Orders Detail Status – primary key is status ID Inventory transaction type – primary key is the ID Employee privileges - primary key is employee ID Products – primary key is ID Purchase Orders – primary key is purchase orders Privileges – primary key is privilege ID Purchase Order Details – primary key is ID Suppliers – primary key is the ID Purchase Order Status – primary key is status ID 5.

More about Lab 1 Part C Essay

Open Document