1. Given the following table, create a view named "names" to contain the first and lastnames for all employees.Employee (ID, first_name, last_name, position)ID123first name last_namePaskierNicolasRachadLayla73. Delete the view "names"TakiBioret2. Modify the previous view to select only the first and last names of employees with theposition "Project Manager."positionProject ManagerComputer EngineerHR

Database views can be valuable tools for organizing and extracting specific information from complex…

1. Given the following table, create a view named "names" to contain the first and last names for all employees. Employee (ID, first_name, last_name, position) ID 1 2 3 www first name last_name Paskier Taki Bioret Nicolas Rachad Layla position Project Manager Computer Engineer HR 2. Modify the previous view to select only the first and last names of employees with the position "Project Manager." 3. Delete the view "names"

1. Given the following table, create a view named "names" to contain the first and last names for all employees. Employee (ID, first_name, last_name, position) ID 1 2 3 www first name last_name Paskier Taki Bioret Nicolas Rachad Layla position Project Manager Computer Engineer HR 2. Modify the previous view to select only the first and last names of employees with the position "Project Manager." 3. Delete the view "names"

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

Which of the following are constraints that can be used with the create table command? Select one: a. references, alias, check b. null, primary key, view of c. primary key, not null, unique d. primary key, default, between
Question 8 Which of the following keywords is used to specify the foreign key after the table is already created? SPECIFY a. Ob. ALTER TABLE SETUP OC. Oa SET
The clause is used to list the attributes desired in the result of a query. Select one: O a. Distinct O b. Where O . Select O d. From
Which view is used to filter and look at the data in a table, without changing the structure of the file? O Report Data Dashboard O Model
Use SQL to complete the following exercises. Provide SQL screenshots of the resutls of both questions. 1. Create a table named REP. The table has the same structure as the SALES_REP table shown in Figure 3-15 except the LAST_NAME column should use the VARCHAR data type and the COMMISSION and RATE columns should use the NUMERIC data type. Execute the command to describe the layout and characteristics of the REP table. 2. Add the following row to the REP table: rep ID: 35, first name: Fred; last name: Kiser; address: 427 Billings Dr.; city: Cody; state: WY; postal: 82414; cell phone: 307-555-6309; commission: 0.00; and rate: 0.05. Display the contents of the REP table.
Given the Bank database that contains the following tables (primary keys are underlined and foreign keys are preceded with #):Agency(agencyNumber, agencyName, city, assets)Client (clientNumber, firstName, lastName, clientCity)Account(accountNumber, #agencyNumber, #clientNumber, balance)Loan(loanNumber, #agencyNumber, #clientNumber, amount ) 3) Create a view named ‘ClientDetails’ to hold all the details of clients who are residing in ‘Salalah’ and who have an account with a balance more than 10,000
The Driver Relationship team wants to work with the active drivers using a VIEW constructed on the DRIVERS table. By creating the VIEW the team wants to eliminate extra work to keep both tables up-to-date. Create a VIEW for the drivers that has at least one travel in InstantStay. Task Create the ACTIVE_DRIVERS VIEW for working with active drivers.
Question 1: Assume that you are going to create a spreadsheet template for the monthly supply order. Use Ms Excel to create the worksheets according to the following requirements. Open a new work book. Rename Sheet1 tab to “Suppliers”. This worksheet should include three tables (one for each supplier) Consisting of the Items and Price. Rename Sheet2 tab to “Flower Stalks Gallery”. This worksheet should include Flower Types (default values: Rose, Carnation, and Statice), Blue Stalks (default values: N/A for Rose and Carnation, 0 for Statice), Pink Stalks (default values: 0 for Rose, Carnation, and Statice), Purple Stalks (default values: N/A for Rose, and 0 for Carnations and Statice), Red Stalks (default values: 0 for Rose and Carnation, and N/A for Statice), White Stalks (default values: 0 for Rose, Carnation, and Statice), and Yellow Stalks (default values: N/A for Rose, and 0 for Carnation and Statice). Rename Sheet3 tab to “Gifts Accessories Supply”. This worksheet should…
What is a view??
1. Given the following table, create a view named "names" to contain the first and last names for all employees. Employee (ID, first_name, last_name, position) ID 1 2 3 first name last_name Paskier Taki Bioret Nicolas Rachad Layla position Project Manager Computer Engineer HR 2. Modify the previous view to select only the first and last names of employees with the position "Project Manager." 3. Delete the view "names"
A view is updatable when it is derived from joining two base tables on the _________ command
1. Use Design view to create a new table. Add AccountType as the first field name, with data type Short Text and field size 10. Ensure AccountType is set as the primary key. Save the table and name it AccountTypes. Add three records: Platinum, Silver, and Gold. Close the table.2.Open the Customers table in Design view. Set the PhoneNumber and AccountType fields to Required. Save the table. Close the table.3.Open the Loans table in Design view. Establish a validation rule for the InterestRate field that requires the value to be greater than or equal to 2.5 but less than or equal to 10. Create validation text for the InterestRate: Value must be between 2.5 and 10 (no period). Save the table. Change the InterestRate in the first record to 2. The validation text appears. Press ESC to restore the original value. Close the Loans table.4.Open the Customers table in Design view. Add a phone number input mask for the PhoneNumber field, storing the symbols with the data.5.Change the Data Type of…