Please help me with the extra credit question

3. Is the relational data model in 2NF2 Whviwhy not? If not. convert to dotted line to indicate any 4. Is the relational data model in 3NF Why/why not? If not. convert to 3NF. Use solid underline to indicate primary key, dotted line to indicate any foreign keys. nm Question 8- Extra Credit (total 10 credits): A whole sale furniture provider wants you to help design a data mart for analysis of sales. The subjects of the data mart are as follows: Salesperson Attributes: SalespersonID, Years Experience, SalespersonName Product Attributes: ProductID, Category, Weight, and YearReleasedToMarket. Customer Attributes: CustomerlD, CustomerName, CustomerSize, and Location. Location is also a hierarchy over which they want to be able to aggregate data. Each Location has attributes LocationID, Averageincome, PopulationSize, and NumberOfRetailers. For any given customer, there is an arbitrary number of levels in the Location hierarchy. Period Attributes: DaylD, FullDate, WeekdayFlag, and LastDay of MonthFlag. The only fact that is to be recorded in the fact table is Dollar Sales. a) Design a typical schema to represent this Data Mart (5 credits) b) Is your design a star or a snowflake schema? (2 credits) c) Given the following data calculate how many rows do you expect to have in the fact table? There are approximately 50 salesperson, 200 customers, 500 products and 2 years of monthly data. (3 credits)