Question: Q2: A furniture store needs a database solution to support its sales process. The information to be stored includes sales transactions as items are purchased,
Q2: A furniture store needs a database solution to support its sales process. The information to be stored includes sales transactions as items are purchased, and customer information so the customer can be appropriately billed and the product delivered. Several sales transactions take place in a day and data about each transaction (typically price and information about 1 or 2 furniture items purchased need to be recorded. Sometimes data about a specific purchased would need to be retrieved to provide customer service. What kind of a database solution is relevant in this case? An operational database or an analytical one such as a data warehouse? Provide 3 reasons in support of your recommendation. Q3. ABC Inc. is a consulting company. Their database includes an Employee table about employees and a ProjectWork table which captures the number of hours an employee has worked on a project. Whenever an employee leaves a company the employee record is deleted from the employee table
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
