Please submit a single text file which contains the following: - Relational schemas for task 1 -
Fantastic news! We've Found the answer you've been seeking!
Question:
Please submit a single text file which contains the following:
- Relational schemas for task 1
- SQL statements to create the tables for task 1
- SQL statements to alter the tables for task 1
The SQL statements must be arranged in the correct sequence of execution so that the marker can execute them to create, alter the tables and modify the records.
For part c, it is under task 1 as well. part c carries forward from part b
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 Requirements A) location start-date B) Has Payslp ref-no ID amount payment-date 0.1 hours duty 1.1 Work Included in 0.1 For helper-no PromotionEvent location ID1 start-date ID1 end-date 4 OutdoorEvert TicketdEvent pemil-no fee 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. 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. 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 Requirements A) location start-date B) Has Payslp ref-no ID amount payment-date 0.1 hours duty 1.1 Work Included in 0.1 For helper-no PromotionEvent location ID1 start-date ID1 end-date 4 OutdoorEvert TicketdEvent pemil-no fee 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. 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.
Expert Answer:
Answer rating: 100% (QA)
Task 1 Relational schemas and SQL statements Helper helperno name ... View the full answer
Related Book For
Using Microsoft Excel and Access 2016 for Accounting
ISBN: 978-1337109048
5th edition
Authors: Glenn Owen
Posted Date:
Students also viewed these databases questions
-
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...
-
What strategies can leaders employ to foster a culture of ethical integrity within organizations, integrating principles of ethical leadership theory and transformational leadership approaches ?
-
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...
-
Accounting The Case: Patient Khaled is a 75-year-old man admitted to the hospital for a small bowel obstruction. His medical history includes hypertension. Khaled is on NPO. He has a nasogastric (NG)...
-
Figure 3-33 shows two vectors, A and B, whose magnitudes are A = 6.8 units and B = 5.5 units. Determine C if (a) C = A + B, (b) C = A - B, (c) C = B - A. Give the magnitude and direction for each.
-
Repeat Problem 8.3 considering G(s) = (s + 2)2. Data From Problem 8.3 Consider an open loop system having a transfer function \(G(s)=\) \((s+4)^{-1}\) and a sampler placed before \(G(s)\). Find its...
-
Use the recursion relation (6.22) to evaluate \(\int_{-1}^{1} x P_{n}(x) P_{m}(x) d x, n \leq\) \(m\). Data from 6.22 (n+1)Pn+1(x) = (2n+1)xPn(x) - nPn-1(x), n = 1,2,....
-
The Wallace Stationary Company purchases paper from the Seaboard Paper Company. Wallace produces stationary that require 1,415,000 sq. yards of stationary per year. The cost per order for the company...
-
In 2020, ConcordCorporation had accounting income of $234,000and taxable income of $185,400. The difference is due to the use of different depreciation methods for tax and accounting purposes. The...
-
In recent years, Kannada Company purchased three machines. Because of heavy turnover in the accounting department, a different accountant was in charge of selecting the depreciation method for each...
-
If the formula y = x is changed by adding two (shown in bold below), what effect would that change have on the function's values? f(x) = x+2
-
The Shirt Works sells a large variety of tee shirts and sweatshirts. Steve Hooper, the owner, is thinking of expanding his sales by hiring high school students, on a commission basis, to sell...
-
A, B, C and D allegedly rob a Town Bank, which is located in the city of Cape Town. Members of the South African Police Services (SAPS) are called to the scene of the crime, during which a shoot-out...
-
Ashley will be a bridesmaid next summer, and she purchased her dress online. The next time she turned on her computer, she was surprised to see special offers for matching accessories. This is an...
-
Asset 4 has E[R4] = 7.4% and SD = 21% meaning it is at least as risky as the other risky assets and has a lower expected return than any of the other risky assets. In other words, it appears to be a...
-
On December 1 of the current year, Rob Elliot invested $35,500 of his cash to form a proprietorship, GGE Enterprises. After all transactions have been entered into the accounting equation, the...
-
The vendor's identity is added to the ___________, once the vendor is chosen. Question 18 options: 1) purchase order transaction file 2) purchase master file 3) product inventory transaction file 4)...
-
Explain how two samples can have the same mean but different standard deviations. Draw a bar graph that shows the two samples, their means an standard deviations as error bars. T S
-
Create and edit tables for What SUP (use the Ch9-02 file) a. Create a new table for What SUP that includes fields BuyerID, BuyerName, and BuyerPhone. The first field (BuyerID) is a Number data type;...
-
Describe the PV function in Excel and its arguments.
-
What base amount is used for vertical analysis of a balance sheet?
-
4. In October, Renie Guimond discovered that her credit report at TransUnion Credit Information Co. incorrectly stated that she was married, used the name "Ruth Guimond," and had a credit card from...
-
When customers called the number provided, New Rapids Carpet Center, Inc., sent salespeople to visit them at home to sell them carpet that was not as advertisedit was not continuous filament nylon...
-
6. Thomas Waldock purchased a 1983 BMW 320i from Universal Motors, Inc. It was warranted "to be free of defects in materials or workmanship for a period of
Study smarter with the SolutionInn App