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: ER Diagram of system implemented in tool such as Sqlyog & Draw.io (Available online). Create all tables with 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. System must perform all operations such as searching of particular data, insert of new record, delete, and update.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

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:

ER Diagram of system implemented in tool such as Sqlyog & Draw.io (Available online).
Create all tables with 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.
System must perform all operations such as searching of particular data, insert of new record, delete, and update.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 6 steps with 6 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions