I need VIEW, TRIGGER, TRANSACTION that might be helpful. (DATA can just be made up) (SQL Server)

You are provided partial representation of the database used by an online retailer to record data from shopping and related activities by visitors to its website. This includes: 1) 2) 3) Browsing activities related to the product pages, Shopping activity tracking the changes in the shopping carts, and Ordering: final order placed NOTES: Any attribute bolded is NOT NULL; otherwise NULL is allowed for the attribute Use the provided data model to answer the following questions ProdModel Guest PK PK,FK1 ID Visitor PK,FK1 UPC CODE Browser PK?ID specificationNum unitPrice MSRP ProdName Brand Category Subcategory datelntroduced ProdDescription LocationZ2ip Customer ProductPromotions FK1 previous UPC PK,FK1ID PK,FK1 UPC CODE PK PromolD BrowsingSession AcctNum email address datejoined PercentOff Soff promoCode datePromoStart datePromoEnd PK SessionlD ProductsBrowsed dateTimeBegin dateTimeEnd IPAdd Browser PK viewinglD FK1 UPC CODE FK2 SessioniD FK1 ID dateTimeStart dateTimeEnd FK3 previousPage shoppingCartitems PK,FK2 cartip Ordereditems PK,FK2 orderNumber PK,FK3 UPC CODE dateTimeAdded dateTimeR emoved quantity unitPrice activeCart UPC CODE PromolD FK1 viewinglD qtyOrdered FK3 FK3 discount$ Order shopping Cart PK orderNumber PK cartID dateTimeCartCreated dateTimeCartOrdered dateTimeCart Deleted dateTimePlaced deliveryMethod expectShipped deliveryAddress FK1 cartID shippingCharges$ tax totals FK2 AcctNum You are provided partial representation of the database used by an online retailer to record data from shopping and related activities by visitors to its website. This includes: 1) 2) 3) Browsing activities related to the product pages, Shopping activity tracking the changes in the shopping carts, and Ordering: final order placed NOTES: Any attribute bolded is NOT NULL; otherwise NULL is allowed for the attribute Use the provided data model to answer the following questions ProdModel Guest PK PK,FK1 ID Visitor PK,FK1 UPC CODE Browser PK?ID specificationNum unitPrice MSRP ProdName Brand Category Subcategory datelntroduced ProdDescription LocationZ2ip Customer ProductPromotions FK1 previous UPC PK,FK1ID PK,FK1 UPC CODE PK PromolD BrowsingSession AcctNum email address datejoined PercentOff Soff promoCode datePromoStart datePromoEnd PK SessionlD ProductsBrowsed dateTimeBegin dateTimeEnd IPAdd Browser PK viewinglD FK1 UPC CODE FK2 SessioniD FK1 ID dateTimeStart dateTimeEnd FK3 previousPage shoppingCartitems PK,FK2 cartip Ordereditems PK,FK2 orderNumber PK,FK3 UPC CODE dateTimeAdded dateTimeR emoved quantity unitPrice activeCart UPC CODE PromolD FK1 viewinglD qtyOrdered FK3 FK3 discount$ Order shopping Cart PK orderNumber PK cartID dateTimeCartCreated dateTimeCartOrdered dateTimeCart Deleted dateTimePlaced deliveryMethod expectShipped deliveryAddress FK1 cartID shippingCharges$ tax totals FK2 AcctNum