Normalize the following form into UNF 1NF, 2NF and 3NF. Show primary keys and foreignkeys for all the normalized tables (from 3NF).Employee Task Record FormEmployeelD: 587Employee Name: SmithDepartment ID: D1DeparmentName : ITTask IDTask NameDurationSupervisor ID | Supervisor Name Emp_TaskJoin_DateDesigningDrawingReportingT170hrsS1Khalfan12/12/2019T256hrsS2Fatma01/10/2020T360hrsS3Haitham11/11/2020

We have given a table and we need to normalize the given table into 1NF, 2NF, and 3NF. Then we need…

Normalize the following form into UNF 1NF, 2NF and 3NF. Show primary keys and foreign keys for all the normalized tables (from 3NF). Employee Task Record Form EmployeelD : 587 Employee Name: Smith Department ID: D1 DeparmentName : IT Supervisor ID Supervisor Name Emp TaskJoin Date si S2 Task ID Task Name Duration Designing Drawing Reporting T1 70hrs Khalfan 12/12/2019 T2 56hrs Fatma 01/10/2020 T3 60hrs S3 Haitham 11/11/2020

Normalize the following form into UNF 1NF, 2NF and 3NF. Show primary keys and foreign keys for all the normalized tables (from 3NF). Employee Task Record Form EmployeelD : 587 Employee Name: Smith Department ID: D1 DeparmentName : IT Supervisor ID Supervisor Name Emp TaskJoin Date si S2 Task ID Task Name Duration Designing Drawing Reporting T1 70hrs Khalfan 12/12/2019 T2 56hrs Fatma 01/10/2020 T3 60hrs S3 Haitham 11/11/2020

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

1. a) Create a table bank_master Column Name Datatype Varchar2(4) Varchar2(30) Varchar2(30) Number (7) b) Insert the records using the following table values Constraint accountno Not Null name address amount accountno name Address amount 101 Mohamed Burka 9000 102 Nasser Nizwa 8000 103 Khamiz Sohar 8200 104 Murshid Burka 7800 106 Mustasim Sohar 9500 a) Create a table bank_details Column Name Datatype Varchar2(4) number(4) date Constraint Recurrent_acno Not Null ac_no Transaction_date Fixed_deposit Number(8) b) Insert the records using the following table values Recurrent_acno | ac_no Transaction_date Fixed_deposit С101 101 12.05.2002 10000 C102 102 13.01.2020 80000 C103 103 14.02.2021 50000 C101 104 13.05.2020 40000 C102 105 15.06.2019 null
Question 18 The query in the figure below:. BRANCH SALESPERSON 1 Dr ID Br_Name Em ID TITLE FIRST LAST Gender DOB PASSWORD Dr ID SALART Field Br Name Table BRANCH TILE SALESPERSON First Last SALESPERSON, SALARY SALESPERSON SALESPERSON Sort Show Criteria RTa" DE A. The First, Last, and SALARY for all salespersons who did not work in a Riffa branch will be listed The Br Name, TITLE, First, Last, and SALARY for all salespersons who live in Manama will be listed The Br Name, TITLE, First, Last, and SALARY for all salespersons Mwill be listed The Br Name, TITLE, First Last, and SALARY for all salespersons who worked in a Riffa branch will be listed
Table: Employee EmpID 1 2 3 4 DeptID D01 D02 Name D03 Ronny Table: Department Kith John Anny Age HR 32 50 34 29 DeptName ADMIN Testing Deptal D D01 D03 D01 D02 Retrieve the Department names and the count of employees work in each Department, but only for department name with more than 2 employees work.
JUST THE ONE IN RED PLEASE. THANK YOU SIR
In our dataset, each job has a predefined salary range. Expand on the previous query and explore this salary range per customer. The query should display the attributes as problem 1 but also include the name of their position, and salary ranges for each employee. Finally, add a column that calculates the difference between each employee’s current salary and the base (minimum) salary for their job. Renamed this last calculated field as “Pay_above_minimum”.
Using the Henry Books database, increase the price of book “The Fall” by 10%. You will insert 2 snips for this question.
Normalise the table to 3rd Normal Form.
The DEPARTMENTS table has the following data: DEPARTMENT ID DEPARTMENT NAME MANAGER ID LOCATION_ID 10 Administration 200 1700 20 Marketing 201 1800 50 Shipping 124 1500 60 IT 103 1400 80 Sales 149 2500 What will be the value in the first row of the result set when the following query is executed? SELECT manager_id FROM departments ORDER BY location_id; O a. 201 O b. 149 O c. 103 O d. 200
List the names of all Staff members who hold a faculty position and have a salary of $45,000 or less. Show their names as their first name, followed by a space, and then their last name but sort the list alphabetically by last name and then first name. Hint: Check out the Position column in the Staff table. All staff members who do not hold a faculty position will get a bonus this year equal to 5% of their salary. List the names, current salary, and bonus amount for each Staff member (non-faculty) who is due a bonus. Show your list in order with the person receiving the highest bonus first.
Given the table PRODUCT(ProductID, ProductName, ProductClass, ProductWeight, ProductStyle, ProductColor, ProductPrice). Note: ProductWeight and ProductPrice are numeric fields, and the other attributes are character fields, i.e., store text. Write a SQL query to display the product class whose average price is at least 50
DATABASE
Create a new table maned “Hiking” that includes TripID, NumPersons from Reservation table and Trip Type, Trip Name columns from Trip table where Trip type is “Hiking” .