Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

a. There are different organizations available for which we are interested to store the unique orgid along with orgname and domain. Each organization is

image text in transcribed

a. There are different organizations available for which we are interested to store the unique orgid along with orgname and domain. Each organization is conducting one annual fest (unique festid, festname, budget and theme) in each session. Many people are coming to the annual fest. Each person has unique prid along with prname, age and contact(s). The people can be categorized as either Employee (with salary) or Student (with cgpa) or Staff (with working hours). Employees are managing Students. Similarly, Staffs are managing Students. Each annual fest contains many events (identified by unique evid along with evname and category). The students are participating in one or more events. Similarly, many students are participating in an event. There are different students treated as event managers for different events. Each event contains different rewards. Each reward has a rewardname and prize. Each reward can be identified by rewardname once the event is known. Draw the entity-relationship diagram for the above system. Make necessary assumption. [3 marks] b. Convert the above ER diagram into relational schemas and specify primary and foreign keys. [2 Marks]

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Heres a breakdown of the tables Organization Attributes orgid Primary Key orgname domain Annual Fest ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Marketing

Authors: Roger Kerin, Steven Hartley, William Rudelius

16th Edition

1264218753, 978-1264218752

More Books

Students also viewed these Accounting questions

Question

What is an access control list?

Answered: 1 week ago