Answered step by step
Verified Expert Solution
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 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...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started