product surveys are conducted in various countries each year and the r
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.
*The amount will be in form of wallet points that you can redeem to pay upto 10% of the price for any assignment. **Use of solution provided by us for unfair practice like cheating will result in action from our end which may include permanent termination of the defaulter’s account.Disclaimer:The website contains certain images which are not owned by the company/ website. Such images are used for indicative purposes only and is a third-party content. All credits go to its rightful owner including its copyright owner. It is also clarified that the use of any photograph on the website including the use of any photograph of any educational institute/ university is not intended to suggest any association, relationship, or sponsorship whatsoever between the company and the said educational institute/ university. Any such use is for representative purposes only and all intellectual property rights belong to the respective owners.