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.

Answer rating: 100% (QA)

Task 1 Relational schemas and SQL statements Helper helperno name ... View the full answer