Draw the ERD Diagram to create relational model corresponding to the described Scenario.

Intellectual Property (IP) in Malaysia is administered by Pejabat Cap Dagangan dan jsminhsk that are located at different branch all over Malaysia. Its objectives are also to establish strong and affective administration, strengthening intellectual property laws, and managing applicants that apply for the ownership of the IP, IP can be categorized into patent, copyright and trademark. Each of the IP categories has their unique attributes. As a database designer, you are required to design a database for IP management systems which need these requirements:

Each branch has a manager to manage the operations.

A branch has employees and contains information about employees - EmpID, Emp_Name, Emp_Email

A supervisor will supervise many employees.

One applicant can apply to many IPs.

An employee will handle many applications by the applicants.

Both the application and applicants basic details, such as ID, Date, email

Each employee is attached to a branch.

IP can be categorized into: Patent, Trademark and Copyright.

Requirements:

ER Diagram of system implemented in tool such asSqlyog& Draw.io (Available online).

Create all tableswith the attribute and appropriate data types presented in ERD.

INSERT data into tables(two ,three).

Also make sure to have the primary keys and foreign keys clearly defined.