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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!