provide a diagram for the conceptual framework for the following statement of the problem''However, a major issue is the disorganization of transaction data related to the real estate market. Because every buyer and seller keeps their own records in the current environment, data is fragmented and makes it difficult to get a complete picture of the market. Furthermore, gathering information from market players, such as buyers, sellers, and estate brokers, is a difficult procedure, as there is no uniform format for data input. Accuracy in real estate transaction data is worsened by the incapacity to actively disclose such data absence of incentives for data sharing. This can be achieved by developing an incentive mechanism that incentivizes market participants to consistently report transaction data in a standardized format.''

Question 1According to recent data, how often do people find themselves ready to buy or sell real estate?1 point

One of the disadvantages of the market approach is that the data that is real and publicSelect one:TrueFalse

Draw a flowchart that will calculate the price of building a house. The price of the house is based on three things:The quality of the interiorThe lot sizeThe size of the houseThe realtor enters the number for each item, not the name. The clerk will not enter the numbers that they can’t control such as the prices. For example: everyone who buys a custom home pays $1000 for each 500 square feet of lot and $500 for each 100 square feet of house.Output the cost for one person buying a house. People may only buy one house.Trace the program 3 times: once for each type of home, make up your own data.Data Related to Quality and Size of HouseQuality of house Type of house Price per 500 sq. ft of lot Price per 100 sq. ft of house1 Custom Home $1000 $5002 Mid-quality $700 $4003 Economy $500 $300

Via a digital structure, buyers and sellers interact to trade money and assets.*1 pointPromotes saving habitsStable and systematic security pricesEconomic growthAvailability of funds

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: