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...

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 supervisor will supervise many employees.


• One applicant can apply to many IPs.


• An employee will handle many applications by the applicants.


• Each employee is attached to a branch.


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

Requirements:

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


2. Create all tables with the attribute and appropriate data types presented in ERD.


3. INSERT data into tables(two ,three).


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


5. System must perform all operations such as searching of particular data, insert of new record, delete, and update.