Hi everyone I am new to this forum hopefully someone can shed some light on this vague scenario for a test to get an interview for a company. I dont know for what to do at all stuck please could someone help it would mean alot thank you:
Scenario: A report is required to summarise a week's sales in a supermarket. A log is kept of sold items against time. Each item belongs to one or more categories. The report must give totals by category as well as by item.
Briefly describe what steps you could go through to produce the report. Are there multiple solutions to the problem? Identify the pros and cons of each.
1. Log Table [item, time] 5 million records (item against time stamp, item not unique)
2. Mapping Table [item, cat_id] 1500 records (many to many)
3. Category Table [cat_id, cat_label] 300 records cat_id is primary key
4. Item Table [item, item_label] 1000 records item is primary key
Example Results for given time period:
Bakery 235 Buns 120 Loaves 85 Cakes 30Dairy 168 Milk 103 Butter 65