Question Two

The following Employee table records the hours an employee spends working for a

department each week in SQLite:

CREATE TABLE Employee $($

PPSN INTEGER not null PRIMARY KEY,

name TEXT$(20)$ not null,

age INTEGER not null,

salary INTEGER not null,

;

a$)$ Write a valid SQL statement to add an employee into the Employee table.

$(9$ Marks$)$

b$)$ Identify three issues with the assigned data types declared in relation to the

sample case provided below.

H$12345,$ John Kelly, $23,30000\}$

$(6$ Marks$)$

c$)$ Identify the correct data types for storing of the variables in the table.

H$12345,$ John Kelly, $23,30000\}$

$(3$ Marks$)$

d$)$ Provide the SQLite code to delete the table.

$(4$ Marks$)$

e$)$ Identify one issue with the original assigned data types declared in the table

Employee in relation to the proposed wish of the company to prepare an average

wages calculation.

$(3$ Marks$)$

$($Total $25$ marks$)$