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...
-
You are the senior auditor with JPT Chartered Professional Accountants. You have been involved with the audit of Clean Energy Supply (CES) since JPT was appointed auditors in 2014. CES provides...
-
On August 3, 2013, the date of incorporation, Quinn Company accepts separate subscriptions for 1,000 shares of $100 par preferred stock at $104 per share and 9,000 shares of no-par, no-stated-value...
-
Compute the median sales for all three toys.
-
The Protek Company is a large manufacturer and distributor of electronic components. Because of some successful new products marketed to manufacturers of personal computers, the firm has recently...
-
How do external factors, such as economic conditions or industry trends, influence organizational commitment, and how should organizations adapt to these influences ?
-
The water face of the guide banks, is protected by (A) One men stone pitching (B) Two man stone pitching (C) Three man stone pitching (D) Four man stone pitching
-
6. You have implemented a butterfly spread whereby the strategy will make money if the stock ends up between $44 and $56 (8 months from now). The stock currently trades at $48, its historical...
-
Alpha Manufacturing has embarked on a post-audit review for one of their underperforming projects. The project required the firm to purchase specialised machinery 2 years ago that cost $152415. The...
-
What is the value of zero-coupon bond with a par value of $1,000 and a yield to maturity of 5.43%? The bond has 3 years to maturity. SET YOUR CALCULATOR TO 4 DECIMAL PLACES THEN ROUND YOUR ANSWER TO...
-
The net sales for the season were $ 4 7 , 5 0 0 . The cost of goods sold was $ 2 1 , 0 0 0 and operating expenses were $ 7 , 8 0 0 . What is the net profit percentage? ( Round to the nearest tenth...
-
Beagle Beauties engages in the development, manufacture, and sale of a line of cosmetics designed to make your dog look glamorous. Below you will find selected information necessary to compute some...
-
What is the number of cable links required for mesh topology if you have 8 stations? a. 8 O b. 64 O . 16 O d. 22
-
Determine two different Hamilton circuits in each of the following graphs. A B F G
-
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...
-
Random samples are taken from two normal populations with \(\sigma_{1}=9.6\) and \(\sigma_{2}=13.2\) to test the null hypothesis \(\mu_{1}-\mu_{2}=41.2\) against the alternative hypothesis...
-
With reference to part (a) of Exercise 8.33, how would you pair and then randomize for a paired test? Data From Exercise 8.33 8.33 How would you randomize, for a two sample test, in each of the...
-
How would you randomize, for a two sample test, in each of the following cases? (a) Forty combustion engines are available for a speed test and you want to compare a modified exhaust valve with the...
Study smarter with the SolutionInn App