Give the SQL query and attach the output of the workbench after creating the table. Use the desc command to show the structure. a) Table Name: EmployeeAttributeData TypeConstraintFirst NameVarchar(15)Not NullLast NameVarchar(15)Not NullSSN NumberChar(9)Primary KeyBirthdayDateAddressVarchar(50)SexChar(1)Sex in (M, F, m, f)

Write the SQL query to create the given table and attach the output of the workbench after creating…

Answered: Give the SQL query and attach the…

Give the SQL query and attach the output of the workbench after creating the table. Use the desc command to show the structure.

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

Related questions

Q: Write the SQL command to add column MIDTERM GRADE to a table called STUDENT table

A: SQL (Structured Query Language) : Structured Query Language is known as SQL. You can use SQL to…

Q: Task 4: Create a view named PROPERTY_OWNERS. It consists of the property ID, office number, square…

A: Answer is given below .

Q: Write the T-SQL scripts for the following tasks: Write a query to select the employees whose…

A: Please refer to the following step for the complete solution of the problem above.

Q: B5. Write a SQL command to perform the following operations by using this schema: BOOKS(BooklID.…

A: SQL command to ⦁ create the table BOOKS⦁ insert a new row in the BOOKS table⦁ Update the value of…

Q: Write a stored procedure that accepts two parameters: A starting date The number of the consecutive…

A: The required stored procedure statement is given in the next step.

Q: The given SQL creates a Song table and inserts some songs. The SELECT statement selects all songs.…

A: SQL stands for Structured Query Language.

Q: Using the software.subscription table, pull all columns for subscriptions that have been cancelled.…

A: For the given database, if the user wants to select all the columns by giving the condition that the…

Q: You need to return all travel data from the TRAVELS table for the CAR_ID which has a plate number…

A: Here, you need to join both the tables with same car_id whose car_plate is BB-883-***

Q: Create a new table, named Senior Teaching Staff, using the existing teacher table as your source.…

A: Structured query language is a programming language for storing and processing information in a…

Q: Submit just the SQL to:Return CompanyName (customers table), and only phone number that represents…

A: The answer is

Q: The Employee database contains a page displaying summary information, including EMPNO, ENAME, JOB,…

A: We need to read the EMP table for the given fields and display the result as per the given…

Q: Write a query to create a report that displays the count of the number of tables in the SQ library.…

A: The question is to write SQL statement for the given query.

Q: plz help with the following: Change the following commands to oracle commands line meaning that…

A: Below are the commands for Oracle. I executed them successfully CREATE TABLE book(Num NUMBER NOT…

Q: True/False 11. The product of two tables is the table created by combining every row in the first…

A: 11.The product of two tables is the table created by combining every row in the first table with…

Q: Q2/ The difference between the results of executing the following two SQL commands: delete from…

A: Answer to the given question: delete from Employee: will delete all the tuples from the Employee…

Q: You need to create the Store Sales database using the scripts under the Course Resources. Using the…

A: Solution: SQL Query to create Customer Table CREATE TABLE "CUSTOMER" ( "NAME"…

Q: In the same text file you created in step 2, add SQL commands to insert the sample records (given…

A: Here is the query : INSERT INTO Doctor VALUES (5040, ‘ Sam Rathod ’ , ‘ 1234567890 ’ , null , ‘…

Q: Write a SQL command to perform the following operations by using this schema BOOKS(BookID, Book…

A: CREATE TABLE BOOKS(BookID int,Book_Name varchar(100),Author varchar(50),Publisher varchar(50),ISBN…

Q: Create a Trigger in SQL that updates an existing View when a new entire is made to the Doctors…

A: Here is the explanation regarding the SQL trigger:

Q: Use the following code to Write the SQL command to change the price code for all Action movies to…

A: SQL (Structured Query Language) is a standard programming language for managing and manipulating…

Q: Use appropriate datatype and size for creating a table "BOOKS" ii. Insert a new row in the BOOKS…

A: Write a SQL command to perform the following operations by using this schema: Use appropriate…

Q: The given SQL creates a Song table and inserts three songs. Write three UPDATE statements to make…

A: Solution - (Note: all data used in this solution is dummy.) Song table at starting - Task 1:…

Q: Please write a view to list staff’s names, salary, ages, and their supervisors’ names, salary, and…

A: To list staff members and their supervisors meeting the given criteria, you can create a SQL view…

Q: CREATE OR REPLACE VIEW view_name AS SELECT column1, column2, ... FROM table_name WHERE condition; in…

A: Given: CREATE OR REPLACE VIEW view_name ASSELECT column1, column2, ...FROM table_nameWHERE…

Q: In this module, it is assumed that students already have JLDB installed so they need to run…

A: Introduction SQL: Relational databases are managed and manipulated using a programming language…

Q: The given SQL creates a Movie table and inserts some movies. The SELECT statement selects all…

A: Answer

Q: Using AdventureWorks database and the Production schema write a common table expression that returns…

A: This can be solved using SQL query which queries the table and produce required output.

Q: eference table 6-28. Include both SQL commands and results/answers in your answers. In the NONCAT…

A: SOLUTION - (1) Query - UPDATE NONCATSET PRICE = (PRICE * 1.05)WHERE CATEGORY='BRD'; This query is…

Q: 4. Display a list of all book titles and the percentage of markup for each book. The percentage of…

A: SQL commands:- Structured Query Language is what it stands for. When using a database to carry out…

Q: Do a SQL query using their data format to see who hasn't attended any classes there. Please avoid…

A: SQL command The SQL query to list every student's ID who hasn't attended a university course may be…

Q: Create an anonymous block to drop a student from a class. Save the block in a file called…

A: Here we use the DELETE statement to delete the record from the table. So, for a given class and…

Q: Please written by computer source Create a table with two columns. Name the table First Initial _…

A: Here i have user SQL Server 2012 for creating the sql scripts, tables and views Below is the SQL…

Q: Write a SQL command please Write a query that displays the last name in uppercase letters and…

A: This query can be solved using different SQL functions. Here is the answer with explanation.

Q: d) Write SQL query to insert the entry ("Shaun", "Paul", "Football", 4) in the table…

A: It is possible to write the INSERT INTO statement in two ways: Specify both the column names and…

Q: te two different forms of the INSERT command to add a student with a student ID of 65798 and last…

A: Here for it note, we can only solve three subparts in one question. There are two types of…

Q: Produce a list of all customer names in which the first letter of the first and last names is in…

A: The answer to the following question is given below:

Q: I am stuck on a question. Please assist with writing this code: Create a trigger for the EMPLOYEES…

A: Answer in step 2

Q: Data File for this Question: Chinook_Sqlite.sqlite Complete the Python code below by filling in the…

A: This code retrieves the column names of the Album table in the Chinook_Sqlite.sqlite database using…

Q: To obtain the structure of an Oracle table, the command to use is: a) STRUCTURE [TableName]. b)…

A: Dear Student, DESCRIBE is used in Oracle to obtain the structure. STRUCTURE , DESCRIBE STRUCTURE,…

Q: B5. Write a SQL command to perform the following operations by using this schema: BOOKS(BookID. Book…

A: 1) CREATE TABLE BOOKS( BookID int, Book_Name varchar(255), Author varchar(255), Publisher…

Q: Write the validation rule to enter a number greater than 1000 and less than or equal to 2000?

A: Write the validation rule to enter a number greater than 1000 and less than or equal to 2000

Q: write the code to create a database and contract table using SQLite

A: To create a database just need to call this method openOrCreateDatabase with your database name and…

Question

100%

Give the SQL query and attach the output of the workbench after creating the table. Use the desc command to show the structure.

a) Table Name: Employee
Attribute
Data Type
Constraint
First Name
Varchar(15)
Not Null
Last Name
Varchar(15)
Not Null
SSN Number
Char(9)
Primary Key
Birthday
Date
Address
Varchar(50)
Sex
Char(1)
Sex in (M, F, m, f)

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Requirement:

VIEW

Answer:

VIEW

Workbench Screenshot:

VIEW

Output Screenshot:

VIEW

Step by step

Solved in 4 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

The given SQL creates a Song table and inserts some songs. The first SELECT statement selects songs released after 1992. The second SELECT statement selects the release year for song with ID 800. Create a third query that combines the two existing queries. The first SELECT should be the outer query, and the second SELECT should be the subquery. The ORDER BY clause should appear after the subquery. Run your solution and verify the new query returns a result table with five rows, all with release years after 1992. CREATE TABLE Song (ID INT,Title VARCHAR(60),Artist VARCHAR(60),ReleaseYear INT,Genre VARCHAR(20),PRIMARY KEY (ID)); INSERT INTO Song VALUES(100, 'Hey Jude', 'Beatles', 1968, 'pop rock'),(200, 'You Belong With Me', 'Taylor Swift', 2008, 'country pop'),(300, 'You\'re Still the One', 'Shania Twain', 1998, 'country pop'),(400, 'Need You Now', 'Lady Antebellum', 2011, 'country pop'),(500, 'You\'ve Lost That Lovin\' Feeling', 'The Righteous Brothers', 1964, 'R&B'),(600, 'That\'s…
Task 3: The InstantRide Finance team wants to collect the price and discount information with the driver names for each travel in the system. You need to return the TRAVEL_ID, DRIVER_FIRST_NAME, DRIVER_LAST_NAME, TRAVEL_PRICE, and TRAVEL_DISCOUNT information from the TRAVELS and DRIVERS tables combined over DRIVER_ID field with the ON keyword. Task: Calculate each user's price and discount information. (SQL Database Test)
Practice Question 1. Assume that the Users table has a plenty of records but only three colums: UserID, FirstName and LastName. Write the following: a) Write an SQL query to show the top 5 records of the Users table. (in order to test it populate your table with more than 5 records) in the PHP file and to display the result in well-readable format (table preffered) in the browser using parameters. b) Write a SQL query in the PHP file that will print details of all users excluding those with the FirstName “Will” and “Michael” from the Users table and to display the result in well-readable format (table preffered) in the browser using parameters. Hint: you can either write all your code in the same file or use two different files
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
a. Write a query to get all unique first names that start with the letter W from the student table. Output the names in all upper case. Sort the results in ascending order. Write a query to get the first 3 characters of all last names that start with an T from the student table and sort them in descending order.
In a .txt file (using Notepad), write SQL commands to create the tables. Name this .txt file as Lastname_Med_DB.txt (being Lastname is your lastname).
6.7 LAB - Create Vehicle and EventVehicle tables The California DMV's completed table diagram is presented in the zyBook. The following is a portion of the table di Vehicle VehicleID TypeCode R YearNumber R MakeCode R ModelName R PlateID R VehicleEvent StateCode R -restrict- • VehicleID RegistrationDate -restrict- • EventNumber
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;
Q1. Please write a query statement from emp table to display employee's empno, ename, length of ename, number of 'S',and number of 'L'. SQL> SELECT empno AS "EmpNo", ename AS "Emp Name", ... AS "Name Length", .... AS "# Of S", .... AS "# Of L"FROM emp; [IMAGE below] Material to answer the question above: Material: https://drive.google.com/file/d/14OwWDIybjAIeuHCO7McupV08gJs9nB-8/view?usp=sharing https://drive.google.com/file/d/1npRH8JoJ6GYBzPU3iNjLXluvCyhr2tMu/view?usp=sharing
7. Rewrite the following SELECT statement. In the rewrite change the join operator style on the Facility and Employee tables to a Type I nested queries. SELECT DISTINCT eventrequest.eventno, dateheld, status, estcost FROM eventrequest, employee, facility, eventplan WHERE eventplan.workdate BETWEEN '2018-10 -01' AND '2018-12-31' AND eventplan.empno = employee.empno AND eventrequest.facno = facility.facno AND facname = 'Basketball arena' AND empname = AND eventrequest.eventno = 'Mary Manager' eventplan.eventno;
You have a table named student having attributes student_name, id, batch, contact. Write a SQL query to display the names of all students in alphabetically increasing order.
Hello! I was given those tables(no data) and I am supossed to write sql code for the following. But I looks like I have a syntax error or there is something I have wrote wrong. (see images) (1) Create a trigger “insert_inventory” on table “Inventory”. The trigger is fired after a row is inserted in table “Inventory”. After a row is inserted in table “inventory”, the “itemid”, the insertion time, and the action is inserted in table “Inventory_history”. The action is set to ‘add an item’. The oldprice is set to null. Test your trigger by inserting a row into Inventory and displaying the contents of Inventory_history. (3) Create a trigger “change_price” on table “Inventory”. The trigger is fired before a change is made to the “Inventory” table. Before the price of an item is changed, the “itemid”, the item’s old price, the action, and the time of change are inserted into the table “Inventory_history”. The action is set to “price change”. Test your trigger by updating a row in Inventory…