QUESTION 5 UiTM is planning to develop a volunteer management system for a better coordination and...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
QUESTION 5 UiTM is planning to develop a volunteer management system for a better coordination and reporting for the volunteerism activities. As a database designer, you are assigned to design the database system according to the following requirements: Any student or staff can be a volunteer. Each student or staff can fill only one entry form. The details are volunteer ID, register date and total hours of working. Volunteer can volunteer in more than one projects. Each assigned project will have details about start date, end date, hours, station and status. Each assigned project also will lead by one faculty. Each project will have their own project ID and project name such as trash clean up, money donation, animal shelter and others. Based on the given information: a) Construct an Entity Relationship Diagram (ERD) complete with all of the required tables, attributes and relationships using the Crow's Foot notation that reflects all of the given business rules. (16 marks) b) Identify TWO (2) relevant information that you can get from the ERD you construct in (a). Briefly explain your answer. (4 marks) QUESTION 5 UiTM is planning to develop a volunteer management system for a better coordination and reporting for the volunteerism activities. As a database designer, you are assigned to design the database system according to the following requirements: Any student or staff can be a volunteer. Each student or staff can fill only one entry form. The details are volunteer ID, register date and total hours of working. Volunteer can volunteer in more than one projects. Each assigned project will have details about start date, end date, hours, station and status. Each assigned project also will lead by one faculty. Each project will have their own project ID and project name such as trash clean up, money donation, animal shelter and others. Based on the given information: a) Construct an Entity Relationship Diagram (ERD) complete with all of the required tables, attributes and relationships using the Crow's Foot notation that reflects all of the given business rules. (16 marks) b) Identify TWO (2) relevant information that you can get from the ERD you construct in (a). Briefly explain your answer. (4 marks)
Expert Answer:
Related Book For
Quantitative Methods for Business
ISBN: 978-0324651751
11th Edition
Authors: David Anderson, Dennis Sweeney, Thomas Williams, Jeffrey cam
Posted Date:
Students also viewed these databases questions
-
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...
-
The following is a symbolic microprogram for an instruction in the computer defined in Sec. 7-3. a. Specify the operation performed when the instruction is executed. b. Convert the four...
-
Before agreeing to purchase a large order of polyethylene sheaths for a particular type of high-pressure oil-filled submarine power cable, a company wants to see conclusive evidence that the true...
-
What effect will an increase in the standard deviation of daily cash flows have on the return point in the Miller-Orr model? Why?
-
Name and describe some flexible-scheduling strate- gies. Why would a business use a flexible-scheduling strategy?
-
Temporarily Restricted el Assets. For several years, Baytown Rehabilitative Camp for Disabled Children (hereafter referred to as the camp) has applied for an operating grant from the Baytown Area...
-
what ways can organizations align their business strategies with sustainability and CSR goals, and how does this alignment impact stakeholder relationships and organizational reputation ?
-
Which of the following is a positive reason for learning chemistry? (a) Chemistry is relevant to daily life (b) Chemistry offers career opportunities (c) Chemistry studies interesting topics (d)...
-
Pass the Journal entries, for the following transactions on the dissolution of the firm of P and Q after various assets (other than cash) and outside liabilities have been transferred to Realisation...
-
Selected journal entries for Larkspur, Inc. are presented as follows. J1 Date Account Titles and Explanation Ref. Debit Credit May 5 Accounts Receivable 5,410 Service Revenue 5,410 (Billed for...
-
Student, Inc. had $330,000 in 2023 taxable income. Using the graduated rate table\ below,\ a. Calculate Student, Inc.s income tax liability.\ b. What is Student, Inc.s average tax rate?\ c. What is...
-
2. Solve the recurrence relations for D(n), the delay, and G(n), D(n) 3(1+ logn) D(1)=3 D(2n) = D(n) +3 G(n) = 3nlog2n+15n-6 G(1)=9 G(2n) 2G(n) + 6n+6
-
Website Profit You operate a gaming website, www.mudbeast.net, where users must pay a small fee to log on. When you charged $3 the demand was 1060 log-ons per month. When you lowered the price to...
-
1. A group of nursing students is discussing how their lives have changed since beginning nursing school. The student who understands the second step of holistic cognitive theory for stress reduction...
-
2. Three firms below have bought manufacturing systems with the specifications below to allow them offer products needed by their target market. Firm A Firm B Firm C Number of product types sold Few...
-
For each of the following reactions, express the equilibrium constant: a) H20 (I) H2 (g) + 02 (g) Ke = 1.0x107 b) Fe2 (g) 2F (g) Ke= 4.9 x 10-21 c) C (s) + O2 (g) d) H2 (g) + C2H4 (g) C2H6 (g) Ke =...
-
The average stock price for companies making up the S&P 500 is $30, and the standard deviation is $8.20 (BusinessWeek, Special Annual Issue, Spring 2003). Assume the stock prices are normally...
-
Colonial State College is considering building a new multipurpose athletic complex on campus. The complex would provide a new gymnasium for intercollegiate basketball games, expanded office space,...
-
Industrial Designs has been awarded a contract to design a label for a new wine produced by Lake View Winery. The company estimates that 150 hours will be required to complete the project. The firms...
-
True or False. Damping reduces the amplitude ratio for all values of the forcing frequency.
-
True or False. The steady-state solution can be assumed to be harmonic for small values of dry-friction force.
-
True or False. The unbalance in a rotating machine causes vibration.
Study smarter with the SolutionInn App