b. For the Business Intelligence suggested in your answer to part a, suggest TWO transactions where Sea Forest may have obtained the relevant data to generate such information. Also state what relevant data were obtained in EACH transaction. (8 marks)

As SeaForest's network for farmer customers grows, the company sets up a relational database to replace the existing spreadsheet record of the farmer's information and the sales transactions. This change allows Sea Forest to address the emerging issues about their "Quality of Data" as the amount of data grows. In class, you were introduced to 6 dimensions of the Quality of Data: a. Suggest TWO such potential Quality of Data dimensions that are likely to be violated by using a spreadsheet to manage a large amount of transactional data. Justify your suggestions with a brief explanation and a specific example. Note that your suggestions must be related to the nature of spreadsheets for this specific purpose. (9 marks) b. For each of the two violations given in your answer to part a, explain how the use of a relational database instead of a spreadsheet can avoid such violations. Support each explanation with a specific example of relational database design (eg. How the data is organised to minimise the specific violation). Note that your answer must be about how relational databases may address the short-comings of spreadsheets for managing large amounts of data, rather than the properties of relational databases that are not related to such short-comings. (6 marks) Copy and paste the following answer template onto the answer field. Fill in your answer accordingly. a. Dimension 1: Justification: Example: Dimension 2: Justification: < > Example:

Which of the following categories of information is NOT provided in the Teca dataset?1 pointInformation on when the transaction took placeInformation about customersInformation about products being soldInformation about the store where sales took placeNone of these

Question 9Which of the following data sources are classified as structured data sources? Select all that apply.1 pointEnterprise Resource Planning (ERP) systemLog filesMessagesRelational databases

Question 2Which of the following could be elements of a data ecosystem? Select all that apply1 pointManaging dataGaining insightsSharing dataProducing data

Question 10Fill in the blank: An agriculture company collects data from an outside commodity market database and internal files containing information about livestock. This work occurs during the _____ phase of the data life cycle.1 pointmanageanalyzecaptureplanCoursera Honor