Convert the psuedo code below to C

$$

o $1.$ Start

o $2.$ Create a new database named "Healthy Habits"

o $2\mathrm{.}1.$ "CREATE DATABASE $`$Healthy Habits$`$;$"$

o $3.$ Switch to using the "Healthy Habits" database

o $3\mathrm{.}1.$ "USE $`$Healthy Habits$`$;$"$

o $4.$ Create tables within the "Healthy Habits" database

o $4\mathrm{.}1.$ Create the "Administrator" table

o $4\mathrm{.}1\mathrm{.}1.$ "CREATE TABLE Administrator $($

o AdminID INT AUTO$\_$INCREMENT PRIMARY KEY,

o Password VARCHAR$(255)$ NOT NULL

o $)$;$"$

o $4\mathrm{.}2.$ Create the "Pharmacist" table

o $4\mathrm{.}2\mathrm{.}1.$ "CREATE TABLE Pharmacist $($

o ID INT PRIMARY KEY,

o Name VARCHAR$(255)$

o $)$;$"$

o $4\mathrm{.}3.$ Create the "Doctor" table

o $4\mathrm{.}3\mathrm{.}1.$ "CREATE TABLE Doctor $($

o ID INT PRIMARY KEY,

o Name VARCHAR$(255)$

o $)$;$"$

o $4\mathrm{.}4.$ Create the "UpdateTable" table

o $4\mathrm{.}4\mathrm{.}1.$ "CREATE TABLE UpdateTable $($

o UpdateID INT AUTO$\_$INCREMENT PRIMARY KEY,

o UpdateDescription VARCHAR$(255),$

o UpdateDate DATE,

o UpdateStatus BIT

o $)$;$"$

o $4\mathrm{.}5.$ Create the "IssueTable" table

o $4\mathrm{.}5\mathrm{.}1.$ "CREATE TABLE IssueTable $($

o IssueID INT AUTO$\_$INCREMENT PRIMARY KEY,

o IssueDate DATE,

o IssueType VARCHAR$(255),$

o IssueMessage TEXT

o $)$;$"$

o $4\mathrm{.}6.$ Create the "UserTable" table

o $4\mathrm{.}6\mathrm{.}1.$ "CREATE TABLE UserTable $($

o UserID INT AUTO$\_$INCREMENT PRIMARY KEY,

o UserName VARCHAR$(255),$

o UserPassword VARCHAR$(255),$

o UserWeight DOUBLE

o $)$;$"$

o $4\mathrm{.}7.$ Create the "Activities" table

o $4\mathrm{.}7\mathrm{.}1.$ "CREATE TABLE Activities $($

o ActID INT AUTO$\_$INCREMENT PRIMARY KEY,

o ActName VARCHAR$(255),$

o ActDescription TEXT,

o ActCategory VARCHAR$(255),$

o ActDate DATE,

o ActDuration FLOAT,

o ActIntensity FLOAT,

o ActNotes TEXT

o $)$;$"$

o $4\mathrm{.}8.$ Create the "Habit" table

o $4\mathrm{.}8\mathrm{.}1.$ "CREATE TABLE Habit $($

o HabitID INT AUTO$\_$INCREMENT PRIMARY KEY,

o HabitName VARCHAR$(255),$

o HabitDescription TEXT,

o HabitCategory VARCHAR$(255),$

o HabitStartDate DATE,

o HabitEndDate DATE,

o HabitFrequency FLOAT,

o HabitTarget DOUBLE

o $)$;$"$

o $4\mathrm{.}9.$ Create the "Goal" table

o $4\mathrm{.}9\mathrm{.}1.$ "CREATE TABLE Goal $($

o GoalID INT AUTO$\_$INCREMENT PRIMARY KEY,

o GoalName VARCHAR$(255),$

o GoalDescription TEXT,

o GoalCategory VARCHAR$(255),$

o GoalStatus VARCHAR$(255),$

o GoalStartDate DATE,

o GoalEndDate DATE