Access Assignment

vk4queen
DatabaseAssignmentAnswerSheet.docx

BA 325 Database Assignment Answer Key

Name:

Before you do anything fill out your name on the assignment and save your file as BA325 Firstname Lastname (use your actual name).

The table has all of the questions from the Superstore Assignment. Fill in your answers to the questions in the corresponding cell in the Answer column. Below the table there is a spot for the Screen Clippings from both the Intro Assignment, and the Superstore Assignment.

After you have filled out all of the answers and Screen Clippings submit the file to the Assignments folder in D2L.

Q Number

Question

Answer

Q1

How many Fields/Rows/Individual Values are found in the Order Info tab?

Q2

How many Fields/Rows/Individual Values are found in the Customer tab?

Q3

How many Fields/Rows/Individual Values are found in the Employee tab?

Q4

How many Fields/Rows/Individual Values are found in the Order tab?

Q5

How many Fields/Rows/Individual Values are found in the OrderLine ID tab?

Q6

How many Fields/Rows/Individual Values are found in the Product tab?

Q7

Are there more or less Individual Values in the Order Info tab, when compared to the total Individual Values found in the Customer/Employee/Order/OrderLine ID/Product tabs? How many more/less?

Q8

What Fields are in Columns AB and AC? What are the values in AB317 and AC317 once you have retrieved the Product Data?

Q9

What Fields are in Columns K and N? What are the values in K951 and N951 once you have retrieved the Order Data?

Q10

What Fields are in Columns E and F? What are the values in E317 and F317 once you have retrieved the Employee Data?

Q11

What Fields are in Columns B and C? What are the values in B951 and C951 once you have retrieved the Customer Data?

Q12

How many Fields/Rows are found in the Customer Table? What is the full Record for Record 256?

Q13

How many Fields/Rows are found in the Employee Table? What is the full Record for Record 2?

Q14

How many Fields/Rows are found in the Order Table? What is the full Record for Record 512?

Q15

How many Fields/Rows are found in the OrderLine ID Table? What is the full Record for Record 4096?

Q16

How many Fields/Rows are found in the Product Table? What is the full Record for Record 128?

Q17

Bonus Question 1: Are databases are an efficient way of storing large amounts of data?

Q18

Bonus Question 2: How many different tables were there in the Superstore database?

Screen Clippings:

Intro Assignment

Screen Clipping 1:

Screen Clipping 2:

Screen Clipping 3:

Screen Clipping 4:

Screen Clipping 5:

Screen Clipping 6:

Superstore Assignment

Screen Clipping 1:

Screen Clipping 2:

Screen Clipping 3:

Screen Clipping 4:

Access:

Excel:

Screen Clipping 5:

Access:

Excel:

Screen Clipping 6:

Access:

Excel:

Screen Clipping 7:

Access:

Excel:

Finn 2019 1

Based on Superstore data from Tableau