A company hires temporary helpers to help organising events. For each helper, the hours worked on...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A company hires temporary helpers to help organising events. For each helper, the hours worked on each event and duty (planner or coordinator or crew) performed must be recorded. At the end of the event, a helper will be paid for the total hours worked for the event(s). Helper helper-no ID name address phone location start-date Requirements A) Has I Payslip ref-no ID amount payment-date 0.1 hours duty 1.1 Work Included in 1.. 0..1 For helper-no PromotionEvent location ID1 start-date ID1 end-date A OutdoorEvent TicketdEvent fee permit-no Transform the conceptual schema to a set of relational schemas. Assume, that superset method must be used to implement a generalization (if any). You are not allowed to add the Requirements Transform the conceptual schema to a set of relational schemas. Assume, that superset method must be used to implement a generalization (if any). You are not allowed to add the attribute(s) not listed in the conceptual schema to the primary key and candidate keys or modify attribute(s) in the conceptual schema. A) B) C) Based on the relational schemas, provide SQL statements to create the tables. You must choose an appropriate date type and length for each column. You must also include appropriate check constraints and foreign key constraints to ensure data integrity. University of Wollongong School of Computing and Information Technology Page 1 of 4 CSIT115 Data Management and Security To prepare for possible changes in the near future, the store owner requests a set of ALTER Table statements to alter the table structure without dropping and re-creating the tables. The changes are stated below. - When a helper is deleted, the related "child records" will be deleted. Add a column called claim to the Payslip table to indicate the transport claim paid to the helper. The default value is 0. Add a column called payment_type to the Payslip table. The possible values are: 'Cheque', 'Mobile payment' or 'Online banking'. The column cannot accept NULL value. A company hires temporary helpers to help organising events. For each helper, the hours worked on each event and duty (planner or coordinator or crew) performed must be recorded. At the end of the event, a helper will be paid for the total hours worked for the event(s). Helper helper-no ID name address phone location start-date Requirements A) Has I Payslip ref-no ID amount payment-date 0.1 hours duty 1.1 Work Included in 1.. 0..1 For helper-no PromotionEvent location ID1 start-date ID1 end-date A OutdoorEvent TicketdEvent fee permit-no Transform the conceptual schema to a set of relational schemas. Assume, that superset method must be used to implement a generalization (if any). You are not allowed to add the Requirements Transform the conceptual schema to a set of relational schemas. Assume, that superset method must be used to implement a generalization (if any). You are not allowed to add the attribute(s) not listed in the conceptual schema to the primary key and candidate keys or modify attribute(s) in the conceptual schema. A) B) C) Based on the relational schemas, provide SQL statements to create the tables. You must choose an appropriate date type and length for each column. You must also include appropriate check constraints and foreign key constraints to ensure data integrity. University of Wollongong School of Computing and Information Technology Page 1 of 4 CSIT115 Data Management and Security To prepare for possible changes in the near future, the store owner requests a set of ALTER Table statements to alter the table structure without dropping and re-creating the tables. The changes are stated below. - When a helper is deleted, the related "child records" will be deleted. Add a column called claim to the Payslip table to indicate the transport claim paid to the helper. The default value is 0. Add a column called payment_type to the Payslip table. The possible values are: 'Cheque', 'Mobile payment' or 'Online banking'. The column cannot accept NULL value.
Expert Answer:
Answer rating: 100% (QA)
In order to transform the conceptual schema to a set of relational schemas we need to create tables that represent the entities and relationships shown in the conceptual schema and normalize these rel... View the full answer
Related Book For
Management Accounting Information for Decision-Making and Strategy Execution
ISBN: 978-0137024971
6th Edition
Authors: Anthony A. Atkinson, Robert S. Kaplan, Ella Mae Matsumura, S. Mark Young
Posted Date:
Students also viewed these databases questions
-
What strategies can leaders employ to foster a culture of ethical integrity within organizations, integrating principles of ethical leadership theory and transformational leadership approaches ?
-
2. (a) Use Dijkstra's algorithm to find the shortest path from node A to all other nodes in the network in Fig. 3. Show all intermediate steps. State two properties of Dijkstra's algorithm and show...
-
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...
-
Lucy, a 57-year-old widow, lost her husband in 2021. He was an active participant in the Federal Employees' Retirement System (FERS), and his FERS contributions totaled $27,000 at the time of his...
-
In the method of separation of variables (Section 4.2) for two-dimensional, steady-state conduction, the separation constant 2 in Equations 4.6 and 4.7 must be a positive constant. Show that a...
-
Sexton Corp. has projected the following sales for the coming year: Sales in the year following this one are projected to be 15 percent greater in each quarter. a. Calculate payments to suppliers...
-
With reference to Exercise 4.5, find an expression for the distribution function \(F(x)\) of the random variable. Data From Exercise 4.5 k 4.5 Given that f(x): = is a probability distribution for 2x...
-
Ceebros Builders is expanding very fast and is expected to grow at a rate of 25 percent for the next four years. The company recently paid a dividend of $3.60 but is not expected to pay any dividends...
-
Please comment on the differences in risk between the two companies as reflected in their respective required rates of return and weighted average cost of capital. Explain why they are different and...
-
Provide the missing information. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marked wrong.) Item Case 1...
-
Balance Sheet The account balances of Zenith Travel Service for the year ended August 31, 20Y4, are listed below. Fees earned $918,145 Office expense 211,175 Miscellaneous expense 18,365 Wages...
-
Find the binomial probabilities in Problems 3-10. \(n=6, X=6, p=0.50\)
-
Refer to the following tree diagram for a two-stage experiment. Find the probabilities in Problems 7-12. (Round your answers in Problems 11 and 12 to the nearest hundredth.) \(P(\bar{E})\) A B E E E...
-
Find the binomial probabilities in Problems 3-10. \(n=12, X=6, p=0.65\)
-
Two cards are drawn in succession from a deck of 52 cards (without replacement). Let \(D_{1}=\{\) diamond is drawn on the first draw\} and \(D_{2}=\) \{diamond is drawn on the second draw\}. Find the...
-
Suppose you are given two urns, numbered Urn I and Urn II. Contents of Urn I: 5 red, 6 blue, and 10 green marbles Contents of Urn II: 30 red, 20 blue, and 10 green marbles The probability of...
-
13. The most universally understood way of expressing emotion is through... C. hand gestures d. tone of voice a. Body posture b. Facial expressions 14. Which of the following faces shows expression...
-
Jax Incorporated reports the following data for its only product. The company had no beginning finished goods inventory and it uses absorption costing. $ 57.30 per unit $ 10.30 per unit $ 7.80 per...
-
Asahi USA, Inc., based in Denver, Colorado, is a subsidiary of a Japanese company manufacturing specialty tools. Asahi USA employs a standard cost system. Following are the standards per unit of one...
-
What is benchmarking, and why is it used?
-
One of the most widely accepted and longest held beliefs is the controllability principle, which says that organization units and people should be held accountable only for things that they can...
-
The following equity accounts are in the ledger of Eudaley Group at December 31, 2025. Instructions Prepare the equity section of the statement of financial position at December 31, 2025. Share...
-
The equity section of Atrio Ltd. showed the following: share premium 6,101, share capitalordinary 925, share capitalpreference 58, retained earnings 7,420, and treasury shares 2,828. (All amounts are...
-
Travis Mordica asks, Since share dividends dont change anything, why declare them? What is your answer to Travis?
Study smarter with the SolutionInn App