Question: 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
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
Get step-by-step solutions from verified subject matter experts
