Q1: A furniture store needs a database solution to support its sales and marketi

Question

Q1: A furniture store needs a database solution to support its sales and marketing analysis. Their sales and marketing department needs to look at quarterly sales data to identify top selling products and how they vary by location and across customer demographics. The sales manager typically needs such reports once or twice every quarter and the report is based on all transactions in the previous quarter which is typically in the millions. Discuss if a data warehouse would/ would not be appropriate solution for this scenarlo. Provide 3 reasons in support of your recommendation Q2. CSUEB is a university. Their database includes a Student table and an Advisor table. Whenever an Advisor leaves the university the Advisor record is deleted from the Advisor table. The database should then reflect that any students who were being advised by that advisor now do not have an advisor by including a Null value for advisor in the student records. Describe how this scenario can be implemented in an enterprise database. Advisor Table AdvisorNo AdvisorName AdvPhoneNo Student Table Alice Bob 602-555-5555 StudentNo StudentName AdvisorNo 408-555-555s 1 Felix Bruno Q3: XYZ Inc. is an Insurance company. Their customer service desk receives calls from customers regarding claims. Most customers do not remember their InsurancelD numbers so the customer service y search for the Insurance ID number based on CustomerName and DateofBirth

Explanation / Answer

Solution:

The first question is done as per Chegg guidelines, please repost others.

I hope this helps if you find any problem. Please comment below. Don't forget to give a thumbs up if you liked it. :)

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.