a. There are different organizations available for which we are interested to store the unique orgid...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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] 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]
Expert Answer:
Answer rating: 100% (QA)
Heres a breakdown of the tables Organization Attributes orgid Primary Key orgname domain Annual Fest ... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
The cost of a new computer is $4,000 and its expected useful life is 5 years. If the residual value is estimated at $400 and the company uses straight-line depreciation, how much depreciation expense...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Reynolds number is: i. a dimensionless quantity ii. inversely proportional to viscosity of liquid iii. directly proportional to velocity of liquid iv. used for quantifying the laminar or turbulent...
-
A family chosen at random has four children. (a) What is the probability that there are two boys and two girls? (b) What is the probability that there are three children of one gender and one of the...
-
Hannon Company has 1,600 pounds of raw materials in its December 31, 2011, ending inventory . Required production for January and February of 2012 are 4,000 and 5,500 units, respectively. Two pounds...
-
Prove that, under the equivalent martingale measure \(\mathbb{Q}_{n}\) of Section 2.3.4, the ratio \(f_{t} B_{t}\) is a martingale. Data From Section 2.3.4, The mathematics of arbitrage relies on...
-
Calculating Ending Inventory and Cost of Goods Sold Under FIFO, LIFO, and Average Cost Hamilton Company uses a periodic inventory system. At the end of the annual accounting period, December 31,...
-
The hybrid state of the Xe and shape of the XeF4 molecule are: 1. (a) sp and tetrahedral 2. (c) sp d and square planar (b) spd and tetrahedral (d) sp d and see saw Which of the following relation is...
-
John Fuji (birthdate June 6, 1981) moved from California to Washington in December 2018. His earnings and income tax withholding for 2019 for his job as a manager at a Washington apple-processing...
-
A corporation is considering a capital project for the coming year. Source of Capital Proportion Aftertax cost __________________________________________________ Longterm debt .40 10 % Preferred...
-
Write a Java program to implement a stack data structure and demonstrate its usage with push, pop, and peek operations.
-
Marigold Corp. is constructing a building. Construction began in 2025 and the building was completed 12/31/25. Marigold made payments to the construction company of $2994000 on 7/1, $6216000 on 9/1,...
-
Show a process and recommend a location for a coffee shop in one of uk's resident areas. The residential area has been divided into 4 blocks. Based on the following statement. The coffee shop should...
-
Write a client-server application where the client sends a request to the server, and the server responds accordingly. Implement error handling and ensure the application is scalable and robust.
-
Choose a grocery store of your choice that sells products and services for the daily needs of society. Answer the following questions linking to your chosen grocery store. (a) Describe how the chosen...
-
The City of West Hutchison is constructing a new road, which it estimates will cost $7.2 million. The city will finance the road with an expenditure-driven state construction grant of $1.2 million...
-
1. Advertising for eyeglasses _________ (increases/decreases) the price of eyeglasses because advertising promotes _________. 2. An advertisement that succeeds in getting consumers to try the product...
-
Which medium in the table to the right has the lowest cost per thousand (CPM)?
-
Suppose a manufacturer of exercise equipment sets a suggested price to the consumer of $395 for a particular piece of equipment to be competitive with similar equipment. The manufacturer sells its...
-
You may disagree with the estimates of market size given for the rows in the market-product grid in Figure. Estimate the market size, and give a brief justification for these market segments: (a)...
-
Craigs Car Detailing Service had the following accounts and account balances in the adjusted trial balance columns of its worksheet for the year ended 30 June 2019. Required (a) Record the required...
-
The accounts below are taken from the ledger of Bartel Music Consulting on 30 June 2019, the end of the current financial year. Required (a) Record the closing entries that affected the accounts. (b)...
-
The following unadjusted trial balance was taken from the ledger of Mirandas Management Services on 30 June 2019. Required (a) Prepare a 10column worksheet using the following additional information...
Study smarter with the SolutionInn App