Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
3 Cards in this Set
- Front
- Back
|
BIS 245 Week 1 Lab
|
BIS 245 Week 1 Lab 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.2. With the Customers table sorted in alphabetical order by city, what is the name of the first customer to appear in the table? 3. Who are the Customers located in the Tennessee? 4. List the tables along with the primary key for each. 5. List the tables “related” to the Orders table. 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?
|
|
|
BIS 245 Week 1 Lab
http://www.fres-courses.com/product/bis-245-week-1-lab |
BIS 245 Week 1 Lab 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.2. With the Customers table sorted in alphabetical order by city, what is the name of the first customer to appear in the table? 3. Who are the Customers located in the Tennessee? 4. List the tables along with the primary key for each. 5. List the tables “related” to the Orders table. 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?
|
|
|
BIS 245 Week 1 Lab
http://www.fres-courses.com/product/bis-245-week-1-lab |
BIS 245 Week 1 Lab 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.2. With the Customers table sorted in alphabetical order by city, what is the name of the first customer to appear in the table? 3. Who are the Customers located in the Tennessee? 4. List the tables along with the primary key for each. 5. List the tables “related” to the Orders table. 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?
|
