Devry Acct 244 Lab1 Questions
A. Student Name: Heather Barton
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 in the supplier table include ID, Company, Last Name, First Name, Email Address, Job Title, Business Phone, Home Phone, Mobile Phone, Fax Number, Address, City, State/Province, Zip/Postal Code, Country/Region, Web Page, and Notes.
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 on the table when you sort the cities in alphabetical order.
3. Who are the Customers located in the Tennessee?
Amritansh Raghav and Andre Ludick are the only two customers located in Tennessee.
4. List the tables along with the primary key for each.
Customers – ID
Employee Privileges – Employee ID, Privilege ID
Employees – ID
Inventory Transaction Types – ID
Inventory Transactions – Transaction ID
Invoices – Invoice ID
Order Details – ID
Order Details Status – Status ID
Orders – Order ID
Orders Status – Status ID
Order Tax Status – ID
Privileges – Privilege ID
Products- ID
Purchase Order Details – ID
Purchase Order Status – Status ID
Purchase Orders – Purchase Order ID
Shippers – ID
Suppliers - ID
5. List the tables “related” to the Orders table.
The Orders table is related to the Customers, Shippers, Orders Status, Orders Tax Status, Order Details, Invoices, Inventory Transactions, and Employees tables.
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?
The data in the Inventory on Hold query includes the Product ID and the Quantity On Hold. There are 20
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 in the supplier table include ID, Company, Last Name, First Name, Email Address, Job Title, Business Phone, Home Phone, Mobile Phone, Fax Number, Address, City, State/Province, Zip/Postal Code, Country/Region, Web Page, and Notes.
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 on the table when you sort the cities in alphabetical order.
3. Who are the Customers located in the Tennessee?
Amritansh Raghav and Andre Ludick are the only two customers located in Tennessee.
4. List the tables along with the primary key for each.
Customers – ID
Employee Privileges – Employee ID, Privilege ID
Employees – ID
Inventory Transaction Types – ID
Inventory Transactions – Transaction ID
Invoices – Invoice ID
Order Details – ID
Order Details Status – Status ID
Orders – Order ID
Orders Status – Status ID
Order Tax Status – ID
Privileges – Privilege ID
Products- ID
Purchase Order Details – ID
Purchase Order Status – Status ID
Purchase Orders – Purchase Order ID
Shippers – ID
Suppliers - ID
5. List the tables “related” to the Orders table.
The Orders table is related to the Customers, Shippers, Orders Status, Orders Tax Status, Order Details, Invoices, Inventory Transactions, and Employees tables.
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?
The data in the Inventory on Hold query includes the Product ID and the Quantity On Hold. There are 20