Suppose a company would like to design a data warehouse to facilitate the analys
ID: 3598666 • Letter: S
Question
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). Do the following three parts.
Design a data warehouse using a Star schema to facilitate effective registration and online analytical processing of such data. Then, design the above data warehouse using a snowflake schema. Then, design the above data warehouse using a fact constellation schema.
Explanation / Answer
#include
#include
#include
#include "Container.h"
#include "Pet.h"
#include "Checkup.h"
using namespace std;
// forward declarations
void flush();
void branching(char);
void helper(char);
void add_pet(string, string);
Pet* search_pet(string, string);
void remove_pet(string, string);
void clean_up(Pet*);
void print_all(Container*);
void remove_all();
Container* list = NULL; // global list
int main()
{
_CrtSetDbgFlag(_CRTDBG_ALLOC_MEM_DF | _CRTDBG_LEAK_CHECK_DF); // Use to check for memory leaks in VS
char ch = 'i';
do {
// Q6: Implement cin / cout for the lines below without modifying the functionality (5 points)
// (change all printf statements to cout and read the next char using cin)
printf("Please enter your selection ");
printf(" a: add a new pet to the list ");
printf(" c: add a new checkup for a pet ");
printf(" r: remove a pet from the list ");
printf(" p: print all pets on the list ");
printf(" q: quit ");
ch = getchar();
// End Q6
flush();
branching(ch);
} while (ch != 'q');
remove_all();
list = NULL;
return 0;
}
void flush()
{
int c;
do c = getchar(); while (c != ' ' && c != EOF);
}
void branching(char c)
{
switch (c) {
case 'a':
case 'c':
case 'r':
case 'p':
helper(c);
break;
case 'q':
break;
default:
printf(" Invalid input! ");
}
}
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.