Create the following tables in your database with the following schema: Table: Employee +- | Column Name | Type | | empId | name | supervisor | salary | int | varchar | | int | int +-- empId is the primary key column for this table. Each row of this table indicates the name and the ID of an employee in addition to their salary and the id of their manager. Table: Bonus | Column Name | Type | -----+ | empId | bonus | int | int +-- empId is the primary key column for this table. empId is a foreign key to empId from the Employee table. Each row of this table contains the id of an employee and their respectiv bonus. Add the following data to your tables: Input: Employee table: +-------+- ------+ | empId | name risor | salary | | 3 | 1 2 | Brad | John | 3 | Dan | 3 | Thomas | 3 | 4000 | 1000 | 2000 | 4000 | null | 4 +-

Create the following tables in your database with the following schema: Table: Employee +- | Column Name | Type | | empId | name | supervisor | salary | int | varchar | | int | int +-- empId is the primary key column for this table. Each row of this table indicates the name and the ID of an employee in addition to their salary and the id of their manager. Table: Bonus | Column Name | Type | -----+ | empId | bonus | int | int +-- empId is the primary key column for this table. empId is a foreign key to empId from the Employee table. Each row of this table contains the id of an employee and their respectiv bonus. Add the following data to your tables: Input: Employee table: +-------+- ------+ | empId | name risor | salary | | 3 | 1 2 | Brad | John | 3 | Dan | 3 | Thomas | 3 | 4000 | 1000 | 2000 | 4000 | null | 4 +-

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

Question #10.Write a query to retrieve invoice_number, invoice_date, and “Balance Due” from the invoices table.Balance Due can be calculated by subtracting payment and credit from the original invoicedamount. Make sure to only select rows with positive “Balance Due” and sort the results basedon Balance Due. Refer to the sample result screen below.
Task 19: List every table that you have created thus far. Display the TABLE_SCHEMA and TABLE_NAME columns. Task 20: List every column in the ITEM table and its associated data type.
I want to write the SQL to create the tables for the ERD attached, but I also want to add this to the tables: rental date, due date, and return date so that I can support overdue queries. I also want it so each table has primary keys and foreign keys. I want it so the tables have at least 4 rows of data. How can I do this? Thank you for your help as I learn more about SQL and table creation.
7. Determine the length of data stored in the ISBN field of the BOOKS table. Make sure eachdifferent length value is displayed only once (not once for each book). SQL commands
Create a view, using JOBS, DEPARTMENTS, and JOB_HISTORY tables that will include department name (not ID), job title (not jobID), start date, and end date for all rows in the JOB_HISTORY table Using your view, write a query that shows the number of rows (count) for each department. Write a query that uses your view from above to select the columns department name, job title, and end date for all rows where the department name includes the string “Sale” that is NOT case-sensitive. Use a function. i.e. SALE, SaLe, Sale, sAle, etc. should all match a row
QUESTION 8 Columns added to a table in transform data can be seen in the Data View? O True False
PLZ HELP WITH THE FOLLOWING QUESTION Using oralce sql or sql live Create a view named all_volunteer that gets details of all volunteers that assigned tasks in the organization. CREATE TABLE Packinglist( List_ID INT NOT NULL, Name VARCHAR(50), Description VARCHAR(100), PRIMARY KEY(List_ID)); CREATE TABLE Task( Task_Code INT NOT NULL, List_ID INT, Task_Description VARCHAR(100), Type VARCHAR(30), Status VARCHAR(20), PRIMARY KEY(Task_Code), FOREIGN KEY(List_ID) REFERENCES Packinglist(List_ID)); CREATE TABLE Volunteer( Vol_ID INT NOT NULL, Name VARCHAR(50), Telephone NUMBER, Address VARCHAR(100), PRIMARY KEY(Vol_ID)); CREATE TABLE Assignment( Vol_ID INT, Task_Code INT, Start_Time TIME, End_Time TIME, PRIMARY KEY(Vol_ID, Task_Code), FOREIGN KEY(Vol_ID) REFERENCES Volunteer(Vol_ID), FOREIGN KEY(Task_Code) REFERENCES Task(Task_Code)); CREATE TABLE Package( Pack_ID INT NOT NULL, Task_Code INT, Date DATE, Weight FLOAT, PRIMARY…
For SQL, Modify the following select statement. Convert the datatypes of all the columns to text. (Actually, sometimes this code will work as it is and the conversion of the datatypes is done automatically for you behind the scenes.)select date_1, date_1, date_1from sec1507_firstunionselect number_2, word_2, date_2from sec1507_second;
Insert at least three rows into your EMPLOYEE_xx table. Use the next value of the sequence you created , EMPL_SEQUENCE_xx as the value for the employee ID for every row inserted. You may choose values for the other columns Test your constraint on the rate column by trying to update a row in the EMPLOYEE_xx table with the value of 6 used for the Pay Rate (you choose the row). Drop your EMPLOYEE_xx table and make sure it HAS been purged from the recyclebin
Please match the keyword or operator from the list below to its correct SQL explanation and syntax in the table. Replace ? with a correct option from the following list: Right outer join, UNION, Left outer join, Cartesian product, Inner join, Full outer join Keyword/Operator Explanation Syntax ? Combine tables vertically SELECT * FROM <table 1> UNION SELECT * FROM <table 2>; ? Produces all possible combinations of rows from the two tables SELECT * FROM <table name 1>, <table name 2>; ? Only matching rows are returned SELECT * FROM <table name 1>, <table name 2> WHERE <join condition> <AND other conditions> <other CLAUSES>; SELECT * FROM <table name 1> INNER JOIN <table name 2> ON join-condition <other clauses>; ? Includes all rows from the left table and inserts NA for non-matching rows SELECT * FROM <table name 1> LEFT JOIN <table name 2> ON <join…
Add a foreign key constraint to the movie table: the column prod_id is the foreign key, referencing the column id from the production table (use sql) following is movie and production table