Q1. CSUEB is a university. Its database includes a Student Table and a Student Major table. Each Student can declare at most two majors. Describe how this rule can be enforced in a Include in your description the type of SQL statement to be used, the tables involved, and whether the rule is checked before inserting records into a table or after they are inserted. n enterprise database. Student Table StudentMajor Table StudentNo StudentName StudentNo MajoriD Alice Bob 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