Lab 2-1 Part 2 (see link for part 1)

https://www.chegg.com/homework-help/questions-and-answers/lab-2-1-part-1-one-sl-inte-s-first-priorities-identify-areas-success-well-areas-potential--q84512506

Now that youve identified the data you need for your analysis, complete a data request form.

3. In the description field, identify the tables that youd like to analyze, along with the time periods (e.g., past month, past year, etc.).

4. Select a frequency. In this case, this is a One-off request.

5. Enter a request date (today) and a required date (one week from today).

6. Choose a format (spreadsheet).

7. Indicate what the information will be used for in the appropriate box (internal analysis).

8. Take a screenshot (label it 2-1A)

EXHIBIT 2-1A Customer_Table 1..1 1..1 FGI_Product Product_Code : PK Product_Description Product_Sale_Price Sales_Subset Sales_Order_ID :PK Sales_Order_Date Sales_Employee_ID:FK 0..* Customer_ID:FK Product_Code:FK Sales_Order_Quantity_Sold Product_Sale_Price 0..* Customer_ID :PK Business_Name Customer_Address Customer_City Customer_St Customer_Zip Example Standard Data Request Form: Requestor Name: Requestor Contact Number: Requestor Email Address: Please provide a description of the information needed (indicate which tables and which fields you require): What will the information be used for? One-Off Annually Termly Other: Spreadsheet Word Document Text File Other: Frequency (circle one) Format you wish the data to be delivered in (circle one): Request Date: Required Date: Intended Audience: Customer (if not requestor): EXHIBIT 2-1A Customer_Table 1..1 1..1 FGI_Product Product_Code : PK Product_Description Product_Sale_Price Sales_Subset Sales_Order_ID :PK Sales_Order_Date Sales_Employee_ID:FK 0..* Customer_ID:FK Product_Code:FK Sales_Order_Quantity_Sold Product_Sale_Price 0..* Customer_ID :PK Business_Name Customer_Address Customer_City Customer_St Customer_Zip Example Standard Data Request Form: Requestor Name: Requestor Contact Number: Requestor Email Address: Please provide a description of the information needed (indicate which tables and which fields you require): What will the information be used for? One-Off Annually Termly Other: Spreadsheet Word Document Text File Other: Frequency (circle one) Format you wish the data to be delivered in (circle one): Request Date: Required Date: Intended Audience: Customer (if not requestor)