write the psuedo code for the following

CREATE DATABASE healthy$\_$habits;

USE healthy$\_$habits;

$--$ Table for storing administrator information

CREATE TABLE Administrator $($

AdminID INT AUTO$\_$INCREMENT PRIMARY KEY, $--$ Unique identifier for each administrator, automatically incremented

Password VARCHAR$(255)$ NOT NULL $--$ Password of the administrator, not nullable

$)$;

$--$ Table for Pharmacist

CREATE TABLE Pharmacist $($

ID INT PRIMARY KEY,

Name VARCHAR$(255)$

$)$;

$--$ Table for Doctor

CREATE TABLE Doctor $($

ID INT PRIMARY KEY,

Name VARCHAR$(255)$

$)$;

$--$ Table for storing update information

CREATE TABLE UpdateTable $($

UpdateId INT AUTO$\_$INCREMENT PRIMARY KEY, $--$ Unique identifier for each update, automatically incremented

UpdateDescription VARCHAR$(255),--$ Description of the update

UpdateDate DATE, $--$ Date of the update

UpdateStatus BIT $--$ Status of the update

$)$;

$--$ Table for storing issue information

CREATE TABLE IssueTable $($

IssueId INT AUTO$\_$INCREMENT PRIMARY KEY, $--$ Unique identifier for each issue, automatically incremented

IssueDate DATE, $--$ Date of the issue

IssueType VARCHAR$(255),--$ Type of the issue

IssueMessage TEXT $--$ Message or description of the issue

$)$;

$--$ Table for storing user information

CREATE TABLE UserTable $($

UserId INT AUTO$\_$INCREMENT PRIMARY KEY, $--$ Unique identifier for each user, automatically incremented

UserName VARCHAR$(255),--$ Username of the user

UserPassword VARCHAR$(255),--$ Password of the user

UserWeight DOUBLE $--$ Weight of the user

$)$;

$--$ Table for storing activity information

CREATE TABLE Activities $($

ActId INT AUTO$\_$INCREMENT PRIMARY KEY, $--$ Unique identifier for each activity, automatically incremented

ActName VARCHAR$(255),--$ Name of the activity

ActDescription TEXT, $--$ Description of the activity

ActCategory VARCHAR$(255),--$ Category of the activity

ActDate DATE, $--$ Date of the activity

ActDuration FLOAT, $--$ Duration of the activity

ActIntensity FLOAT, $--$ Intensity of the activity

ActNotes TEXT $--$ Additional notes for the activity

$)$;

$--$ Table for storing habit information

CREATE TABLE Habit $($

HabitId INT AUTO$\_$INCREMENT PRIMARY KEY, $--$ Unique identifier for each habit, automatically incremented

HabitName VARCHAR$(255),--$ Name of the habit

HabitDescription TEXT, $--$ Description of the habit

HabitCategory VARCHAR$(255),--$ Category of the habit

HabitStartDate DATE, $--$ Start date of the habit

HabitEndDate DATE, $--$ End date of the habit

HabitFrequency FLOAT, $--$ Frequency of the habit

HabitTarget DOUBLE $--$ Target or goal for the habit

$)$;

$--$ Table for storing goal information

CREATE TABLE Goal $($

GoalID INT AUTO$\_$INCREMENT PRIMARY KEY, $--$ Unique identifier for each goal, automatically incremented

GoalName VARCHAR$(255),--$ Name of the goal

GoalDescription TEXT, $--$ Description of the goal

GoalCategory VARCHAR$(255),--$ Category of the goal

GoalStatus VARCHAR$(255),--$ Status of the goal

GoalStartDate DATE, $--$ Start date of the goal

GoalEndDate DATE $--$ End date of the goal

$)$;

Select $*$ from Doctor;