answer the question no 2. please answer as early within 1 hour.

the lecture time and classroom, the enrollment cap. and the instructor. There must be at least one instructor fo each section. The instructor of a section of a particular course must be a professor (tenured or not, it doesn matter) who may or may not be affiliated with the department that lists the course. Draw an ER diagram to capture the situation described above. Make sure you capture as many integrity constrain as possible and explicitly mention those that cannot be captured by the ER diagram (if any). Make sure that you E/R diagrams are clear and unambiguous (e.g., your bold lines look unmistakably bold, your arrowheads loo unmistakably like arrowheads, etc.). You will not receive the benefit of the doubt in the presence of ambiguity. Q2 (15 marks): Consider the following table Insurance No. Contract No. HRS. Employee Name Hotel No. Location 5001 CO211E 15 Osman H01 Dhaka 5003 CO211E 19 Sohel Rajshahi 5007 CO211F 22 Farhana Chittagong 5009 CO211F 15 Maliha H01 Cox's Bazar Describe, and illustrate the process of normalization up to 3NF. State and make assumptions, if any