hms doctors hms employee PK Employee_ID : varchar(255) e Name : varchar(255) e Address : varchar(255) hms patients PK Patient_ID: varchar(255) e Batch_No : varchar(255) PK O Name : varchar(255) Employee_ID: varchar(255) FK O Address : varchar(255) a DOB : date DOB : date hms attended_by e Contact : varchar(25) e Gender : varchar(10) # Salary : float(15,3) e Category : varchar(25) e Contact : varchar(25) FK a Patient_ID : varchar(255) Batch_No : varchar(255) FK e Gender : varchar(10) e Blood Group: varchar(5) O DOA : date hms departments FK O Dept_No : varchar(255) e Name : varchar(255) O Location : varchar(255) 2 Dept No : varchar(255) PK

Code for the following: Web application is written using the MVC (Model, View, Controller) architecture Web application is written using object-oriented PHP programming, including classes for: Database Connection & Information Products table model Products table DB Products table controller Categories table model Categories table DB Categories table controller Web application includes 3 user interface pages: Index/landing/navigation page Title: "Your Name Wk 3 GP" Page Header: Your Name Product Information Includes navigation links to all other pages Filename index.php Database Connection Status page Title: "Your Name Wk 3 GP" Page Header: Your Name Database Status Includes: Text display of the database name Text display of the database user ID Text display of the database password Text display of the status of the connection (successful or unsuccessful) Navigation link to the home page Filename db_conn_status.php Products page (and Product Add/Update page) Title: "Your Name Wk 3…

import sqlite3 from sqlite3 import Error # Creates connection to sqlite in-memory database def create_connection():     """     Create a connection to in-memory database     :return: Connection object     """     try:         conn = sqlite3.connect(":memory:")         return conn     except Error as e:         print(e)     # YOUR CODE HERE     # Use sqlite3.connect(":memory:") to create connection object     return conn # query to create the table table_sql = """ CREATE TABLE Horses (     id integer PRIMARY KEY NOT NULL,     name text,     breed text,     height real,     birthday text ); """ # query to insert data into the table ins_sql = """INSERT INTO Horses VALUES(1,'Babe','Quarter Horse',15.3,'2015-02-10'); """ # query to fetch all data from the table fetch_sql = """SELECT * FROM Horses;""" # creating db connection conn = create_connection() # fetching a cursor from the connection c = conn.cursor() # executing statement to create table c.execute(table_sql) # executing statement to…