Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A company hires temporary helpers to help organising events. For each helper, the hours worked on each event and duty (planner or coordinator or

A company hires temporary helpers to help organising events. For each helper, the hours worked on each event Requirements Transform the conceptual schema to a set of relational schemas. Assume, that superset method

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.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Management Accounting Information for Decision-Making and Strategy Execution

Authors: Anthony A. Atkinson, Robert S. Kaplan, Ella Mae Matsumura, S. Mark Young

6th Edition

137024975, 978-0137024971

More Books

Students also viewed these Databases questions

Question

Why are positive stereotypes harmful?

Answered: 1 week ago

Question

What is benchmarking, and why is it used?

Answered: 1 week ago