Write SQL script to perform the following actions. Your submission must include a .sql file with the following queries. To get full points, your script must execute without any errors, when I run the queries in SQL server.

Create a schema named HAFH_Realty

Create a table named Manager in the schema HAFHRealty with 8 columns as given below. The data populated in each column is given in the column description beside its name. Identify suitable datatype for each column. Your table must have at least one char, varchar, date, int, decimal and bit datatypes.

ManagerID (ID assigned by HAFHrealty when they join)

ManagerFirstName ( First name)

ManagerLastName (Last name)

ManagerBirthDate (BirthDate)

WorkExperienceYears (total work experience in years)

ManagerSalary (ID assigned by HSAFHrealty when they join)

CurrentEmployee (will have true or false values)

Write insert statements to insert 5 rows into the table Manager each with a different ManagerID. All columns in a row must have values.