2 5 Consider the following relation OFFERING currently used by the Registrar's Office at WMU: OFFERING (CRN, CourselD, Title, Date Time, Classroom, Semester, Year. CrHrs, Description) where CRN is a unique course offering number (e.g., 45876) for a particular course, CourID is the course ID for a particular course (e.g., CIS4990), Description is the detailed course description, the remaining attributes are self-explanatory. Some instances of this relation are given below: CRN Court Title DateTime Classroom Sem/Year Cruirs Description 23876 CIS2640 Intro to computing TR 9:30 am Fried2100 Sum 1, 2010 Analyzing business data 23878 C1S2640 Intro to computing MW 2:30 pm Dusb3200 Sum II, 2010 Analyzing business data 23991 C184950 e-Commerce proj TR 11:00 am Sang3800 Fall, 2020 Web application for e-commerce 43112 C1S4990 Enterprise project TR 2:00 pm Schn2270 Fall, 2020 Enterprise project development 3 8 3 3 3 1 4 7 Answer the following questions: (Please label your answer to avoid confusions) 1) Based on the current relation design OFFERING, a) what is its primary key? b) What is its current normal form? (2 point) a) the primary key for the current design: b) the current normal form is because: 2) Given the current relation design, give one example to highlight "Deletion Anomaly" (i.e., unintentional data loss) (2 point) 0 MARALD