Question: Create the following Workers (PK = E_Id) and Premium (PK = Ref_Id) tables with the create table command. Create and insert the data with the

Create the following Workers (PK = E_Id) and Premium (PK = Ref_Id) tables with the "create table" command. Create and insert the data with the "insert" command. The two tables are related via E_id. note Null fields are marked with "*"

Create the following Workers (PK = E_Id) and Premium (PK = Ref_Id)sql

Table name:premium Ref_id" | E_ld premium_date premium_amount 1 2 01-02-13 5000 2 3 04-02-13 3000 3 1 01-03-13 4000 4 01-01-13 4500 5 7 01-05-13 3500 1 2. 3 Tablo ad: iler Table name:workers E_id Name Surname Salary Work start date departmant John Abraham 10000 01-01-13 12.00.00 AM accounting Michael Clarke 8000 01-01-13 12.00.00 AM insurance Roy Thomas 7000 01-02-13 12.00.00 AM accounting Tom 6000 01-02-13 12.00.00 AM insurance Jerry Pinto 01-02-13 12.00.00 AM Philip Mathew 7500 01-01-13 12.00.00 AM additional service Tom 123 6500 01-01-13 12.00.00 AM additional sevice Jerry Lname% 6000 01-02-13 12.00.00 AM 4 Jose 5 6500 insurance 6 7 8 insurance

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!