A grocery shop is using the following tables in their relational database:
TABLE Product id INTEGER name VARCHAR categoryId INTEGER REFERENCES ProductCategory(id) TABLE ProductCategory id INTEGER name VARCHAR TABLE ProductSale id INTEGER productId INTEGER REFERENCES Product(id) price DECIMAL date DATE
The company has decided to implement a data warehouse since their analytic queries have started causing issues by consuming most database resources.
As a first step, the company wants to create a star schema of the previous tables. Which tables should be present in the star schema?
(Select all acceptable answers.)