Use Microsoft Visio to create the forms for the program.Screenshots of them required,also screenshots of the coding.1. Analysis, Design and Implement a database system for given scenario. 2. Record...

Use Microsoft Visio to create the forms for the program.Screenshots of them required,also screenshots of the coding.1. Analysis, Design and Implement a database system for given scenario.
2. Record entry in table: each table at least 15 records.
3. Formulate SQL queries to produce following report (make sure that you have data in your database): a. List of all specialists  b. List of all specialist according to specialization area (e.g. ENT, Orthopedic, Cardiology, Endocrinology, Gastroenterology, Neurology, Urology, Paediatrics, Rheumatology etc.)  c. Count no of patients visited center in each day  d. View patients checked by particular specialist e. List of patients visited a center at specific time period (day, week, one month, six months or years)  f. List of room booked by doctors g. List of available room for booking h. List of specialist those who are greater than 50 years old i. Statistics of male and female specialist j. Particular’s specialist daily income :  i. List of card and cash payment ii. Calculate the total money (card and cash) iii. Calculate the total cash payment only k. List of specialist those who has not pay the room charge