a. Consider the following relation Customer (CID, ACCOUNTNO, CNAME, ADDRESS, AGE) Write SQL for the following queries. i. Insert information of two customers in a table Customer. ii. Display name…

a. Consider the following relation Customer (CID, ACCOUNTNO, CNAME, ADDRESS, AGE) Write SQL for the following queries. i. Insert information of two customers in a table Customer. ii. Display name and accountno of Customers whose name end with "e" iii. Display the name and address of those customers who doesnot live in "Kathmandu". iv. Count the number of customers. v. Display CID and age of those Customers whose age lies between 16 and 50. [5] b. Consider a hospital system including Doctor (Did, dname, dspecialization, ddepartment), Nurse (nid, name, ndepartment) and patient (pid, pname, paddress) as entities. A doctor may treat many patients in the hospital. Nurse helps the doctor in treatment process. Draw the E-R model for above scenario assuming necessary constraints.