-Write SQL script to perform the following actions. Your submission must include a .sql file with the following queries. 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. Identify the null and not null columns in the table. Your table must have at least one null column.

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 HAFHrealty when they join)

ManagerBonus (some employees may not have a bonus)

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.

-Write insert statements to insert 3 rows into the table Manager each with a different ManagerID. Include null values in the null columns for these three rows.