Database schema below shows the relations involved in Maju Holdings system. PARTICIPANTS EVENTS ATTENDANCE STAFFS LOCATIONS...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Database schema below shows the relations involved in Maju Holdings system. PARTICIPANTS EVENTS ATTENDANCE STAFFS LOCATIONS TASKS (PARTID, PARTNAME, PARTPHONE, PARTEMAIL, PARTADDRESS, PARTJOB) (EVENTID, EVENTNAME, EVENTBUDGET, EVENTHEME) (ATTID, ATTDATE, EVENTID, PARTID) (STAFFID, STAFFNAME, STAFFADDRESS, STAFFPHONE, STAFFEMAIL, STAFFPOSITION, STAFFSALARY) (LOCID, LOCNAME, LOCSIZEAREA, LOCADDRESS) (STAFFID, EVENTID, LOCID, LEADERID, TASKDESCRIPTION, TASKDATE) Each year, Maju Holdings will organize few events for public to attend and gain new knowledge. Each event is led by a staff. There are a lot of other staffs who will be given different tasks to handle the event. The event can be held at many different locations depending on the availability of the location. The attendance for the participants is recorded for future use by the company. The default date format is DD-Mon-YYYY. 2. Retrieve these data with SQL and Relational Algebra. a) List the name of the leaders and event name that they have managed. (3 marks) Database schema below shows the relations involved in Maju Holdings system. PARTICIPANTS EVENTS ATTENDANCE STAFFS LOCATIONS TASKS (PARTID, PARTNAME, PARTPHONE, PARTEMAIL, PARTADDRESS, PARTJOB) (EVENTID, EVENTNAME, EVENTBUDGET, EVENTHEME) (ATTID, ATTDATE, EVENTID, PARTID) (STAFFID, STAFFNAME, STAFFADDRESS, STAFFPHONE, STAFFEMAIL, STAFFPOSITION, STAFFSALARY) (LOCID, LOCNAME, LOCSIZEAREA, LOCADDRESS) (STAFFID, EVENTID, LOCID, LEADERID, TASKDESCRIPTION, TASKDATE) Each year, Maju Holdings will organize few events for public to attend and gain new knowledge. Each event is led by a staff. There are a lot of other staffs who will be given different tasks to handle the event. The event can be held at many different locations depending on the availability of the location. The attendance for the participants is recorded for future use by the company. The default date format is DD-Mon-YYYY. 2. Retrieve these data with SQL and Relational Algebra. a) List the name of the leaders and event name that they have managed. (3 marks)
Expert Answer:
Related Book For
Database System Concepts
ISBN: 9780078022159
7th Edition
Authors: Abraham Silberschatz, Henry F. Korth, S. Sudarshan
Posted Date:
Students also viewed these databases questions
-
NorthBound Tours (NBT) offers educational holiday tours to locations that are significant in terms of the Northern Territorys environmental, historical or cultural heritage. The company has now been...
-
NorthBound Tours (NBT) offers educational holiday tours to locations that are significant in terms of the Northern Territorys environmental, historical or cultural heritage. The company has now been...
-
describe Jarir bookstore by providing the followings: - A brief introduction regarding the history of this brand and its main activity? - Describe how and why the brand's activity has evolved through...
-
In current business publications or on the Federal Reserve Web site (www.federalreserve.gov), find the press release from the most recent meeting of the FOMC. What is the targeted federal funds rate?...
-
The Montreal Company is an electronics business with eight product lines. Income data for one of the products (XT-107) for June 2015 are: Dorval Ltd., an instruments company, has a problem with its...
-
The John Gore Organization owns and operates the Charles Playhouse, a theater in Boston, Massachusetts. Evelyn Castillo has diabetes, a disability under the Americans with Disabilities Act (ADA)....
-
Bad Debts'Aging Puckett, Inc. includes the following account among its trade receivables. Age the balance and specify any items that apparently require particular attention atyear-end. Alstott Co....
-
Mary, Shannon, and Anika each invested $9,000, $25,000, and $18,000, respectively, into a business. a. Calculate their investment ratio reduced to the lowest terms. 0 : 0 : 0
-
HT Tool Co is considering the purchase of a new CNC machine. This project is not expected to change sales, but should save the firm in labor costs. The labor savings is expected to be $46,000 (before...
-
What is Par Value??
-
Your company uses stock-to-sales ratios for planning end-of-the-month and beginning-of-the-month inventory levels. If you've forecasted sales for the month of February to be $240,000 and you are...
-
Discuss (1) why estimated overhead is used, (2) how the estimated overhead rate is calculated, and (3) how the allocation base is determined?
-
Complete the bank reconciliation below by making the appropriate selections. Assume that all deposits, checks, and other withdrawals have been recorded in your check register. Balance per your check...
-
Joohee sells 100 shares of Acme, Inc. on November 1, 2021 for $20,000. Her basis in the shares was $15,000. On November 17th, Joohee repurchased 50 shares of Acme, Inc. How much of the gain from...
-
A clinical trial was conducted to test the effectiveness of the drug zopiclone for treating insomnia in older subjects. Before treatment with zopiclone, 16 subjects had a mean wake time of 102.8 min....
-
On October 1, 2014, the Dow Jones Industrial Average (DJIA) opened at 17,042 points. During that day it lost 237 points. On October 2 it lost 4 points. On October 3 it gained 209 points. Deter-mine...
-
Consider the relations r 1 (A, B, C), r 2 (C, D, E), and r 3 (E, F), with primary keys A, C, and E, respectively. Assume that r 1 has 1000 tuples, r 2 has 1500 tuples, and r 3 has 750 tuples....
-
Construct a B+-tree for the following set of key values: (2, 3, 5, 7, 11, 17, 19, 23, 29, 31) Assume that the tree is initially empty and values are added in ascending order. Construct B+-trees for...
-
An existence bitmap has a bit for each record position, with the bit set to 1 if the record exists, and 0 if there is no record at that position (for example, if the record were deleted). Show how to...
-
Let \(\left\{X_{n}ight\}_{n=1}^{\infty}\) be a sequence of random variables such that for each \(n \in \mathbb{N}\), \(X_{n}\) has a \(\operatorname{GAmma}\left(\alpha_{n}, \beta_{n}ight)\)...
-
Let \(\left\{X_{n}ight\}_{n=1}^{\infty}\) be a sequence of random variables where \(X_{n}\) is an ExPo\(\operatorname{NENTIAL}\left(\theta+n^{-1}ight)\) random variable for all \(n \in \mathbb{N}\)...
-
Let \(\left\{X_{n}ight\}_{n=1}^{\infty}\) be a sequence of random variables where for each \(n \in \mathbb{N}, X_{n}\) has an BERNoulli \(\left[\frac{1}{2}+(n+2)^{-1}ight]\) distribution, and let...
Study smarter with the SolutionInn App