Suppose a company would like to design a data warehouse to facilitate the analysis of objects with RFID tags in an online analytical processing manner. Since recently, the Radio-Frequency Identification (RFID) is commonly used to trace object movement and perform inventory control. (An RFID reader can successfully read an RFID tag from a limited distance at any scheduled time.) The company registers huge amounts of RFID data in the format of (RFID, at location, time), and also has some information about the objects carrying the RFID tag, e.g., (RFID, product name, product category, producer, date produced, price).

a) Design a data warehouse using a Star schema to facilitate effective registration and online analytical processing of such data.

b) Design the above data warehouse using a snowflake schema.

c) Design the above data warehouse using a fact constellation schema