What should you create?

You need to create relationships to meet the reporting requirements of the customer service department. What should you create?A . an additional date table named ShipDate, a one-to-many relationship from Sales[sales_date_id] to Date[date_id], and a one-to-many relationship from Sales[sales_ship_date_id] to ShipDate[date_id]B . an additional date table named ShipDate, a many-to-many...

September 12, 2024 No Comments READ MORE +

What should you do next to meet the reporting requirements of the executives?

You merge data from Sales.Region, Region_Manager, Sales_Manager, and Manager into a single table named Region. What should you do next to meet the reporting requirements of the executives?A . Apply row-level security (RLS) to the Region table based on the sales manager username.B . Configure a bi-directional relationship between Region...

September 12, 2024 No Comments READ MORE +