Product surveys are conducted in various countries each year, and the result are then published in websites, e.g., https://www.trustedbrands.asia/singapore/. The surveys cover customer perception on brands and their products which

are grouped into categories. Apply normalisation to design a database, given the data in the Product Score table:Product Score (brand, product, category, country, attribute, year Surveyed, score, award, judge, head Judge) Assume the following data requirements: The category of a product depends on the product itself, regardless of its brand, country or year surveyed. For example, the category of the product oven is household product. Each country has a list of attributes for each year it participates in surveys. The list for a country for a particular year is applied to all products surveyed in that country. The list may change over the years, and may have overlapping attributes with other countries. A product has participated in at least one survey. For each survey for the country and year, a score for each attribute in the list is recorded for each product. For each year that a country participates in a survey, two or more judges and a head judge help determine whether a brand of the product wins an award (gold, silver and bronze). A judge may be involved in multiple surveys for different countries and years. а)Formulate and list the functional and multi-valued dependencies. b) Draw a dependency graph and propose candidate key(s) for the table Product Score. c) Normalise the table to BCNF and 4NF by applying the BCNF approach. Show how you apply the steps to arrive at the tables and at each iteration, explain whether each derived table is already in BCNF and 4NF (if applicable). Indicate also whether each MVD is subsumed. d) Assemble your tables and constraints clearly.