Answered: Alter the PROPERTY table by changing…

Alter the PROPERTY table by changing the OWNER_NUM field to refer to the OWNER table. Retrieve the first and last names of the residents combined and converted to uppercase. > >

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

MS-ACCESS (. 1. Create a database COMPANY and create a new table EMPOLYEE and name it 2. Design a table EMPOLYEE so that it has all fields and the following properties FIELDS DATATYPE PROPERTIES EMPNO Number 4 EMPNAΜΕ Short Text 10 PHONE Number 8 PLACE Short Text 9. DOJ Date/Time 3. Set the field EMPNO as the primary key and save the table 4. Enter the following data into the table EMPLOYEE EMPNO ΕMPNAΜΕ PHONE PLACE DOJ 1111 ΑΗMED 98989898 | IBRI 12/06/2014 2222 SARA 99997777 | NIZWA 15/09/2018 3333 AMNA 90909090 | MUSCAT 14/06/2017 4444 NAHID 91919191 IBRI 02/08/2015 5. Design a table SPORTS so that it has all fields and the following properties FIELDS DATATYPE PROPERTIES EMPNO Number 4 SPORTS Short Text 10 YEARS Number 2 SCHOLARSHIP YES/NO AMOUNT CURRENCY 6. Set the field EMPNO as the primary key and save the table 7. Enter the following data into the table SPORTS EMPNO SPORTS YEARS SCHOLARSHIP AMOUNT 4444 FOOTBALL YES 50 3333 BASKETBALL NO 2222 FOOTBALL 1 NO 1111 CRICKET YES 50 8.…
Update table purchaseOrder, set column orderStateld equal to subquery a. (select column id from table orderstate where state equals "Payment sent") 3 Alter table supplierTransaction add column paymentDate as data type date, not null, default value of (CURRENT_DATE) (Note: the parenthesis MUST be included) Insert into table supplierTransaction, columns purchaseOrderId and total result set returned from query a. Select columns id and total from table purchaseOrder where column orderStateld is equal to subquery i. (select column id from table orderState where column state is equal to "Payment sent") Write Test Case 2 as a SQL join query to do the following a. Select supplierName from table supplier as Supplier b. Select purchaseOrderld from table supplierTransaction as “Purchase Order" c. Select description from table product as Product d. Select total from table purchaseOrder as “Product Total" e. Join tables şupplierTransaction, purchaseOrder, supplier, product f. Order by column…
Display the first 10 rows of the invoice number, 2 line numbers, 2 product SKUs, 2 product descriptions, and brand ID for the sales of “sealer” and “top-coat” related products of the same brand on the same invoice sorted by the invoice number. (See partial result below, it has only 2 rows) Hints: Assign two different alias to both the"lin" and "product" tables. Then do the joins treating them as 4 differnet tables.
The Colombia City office of StayWell indicated that there is a new tenant by the name of Yigit Yilmaz staying at the property with an ID of 13. You need to include this new resident in the RESIDENTS table.
Create a view named ITEM_INVOICE. It consists of the item ID, description, price, invoice number, invoice date, number ordered, and quoted price for all invoice lines currently on file.
Mark the Category field in the BOOK_PRICING table as not being used. Check to see if the field can still be used.
Country ISOCode3 Name PopDensity FJI Fiji 130 CHE LTU Switzerland 560 Lithuania 120 Complete the UPDATE statement to change 'Fiji' to 'North Macedonia' in the Country table. In the WHERE clause, identify the row to be changed using the PopDensity column. UPDATE Country SET WHERE Note: Your answers for SET and WHERE should include the column names followed by an equals sign and the corresponding value.
Which clause do you add to the following SELECT statement to limit the display to those categories that their total price is out of the range 5000 to 7000 (We also do not want to include 5000 and 7000 in the result)? SELECT catergoty_id, SUM(price) FROM products GROUP BY catergoty_id O a. HAVING SUM(price) 7000 O b. HAVING SUM(price) > 5000 and SUM(price) 7000 O d. WHERE SUM(price) > 5000 and SUM(price) < 7000
The InstantRide User Satisfaction team requires the average and maximum number of rides users have taken so far with InstantRide. In addition, they would like to know the total number of travels. However, they need these details with the corresponding column names Average, Maximum and Total by using the AVG, MAX and SUM functions. In order to accomplish this, you will first need to create a derived table from the TRAVELS table to pass the TRAVEL_ID count to the three mathematical functions.
I need help with an UPDATE statement that will change the CUST_EMAIL value to "unknown" for records in the CUSTOMERS table that have null values for the cust_email field
using the code below write a query to display the minimum balance, maximum balance, and average balance for memberships that have a rental CREATE TABLE MEMBERSHIP ( MEM_NUM NUMBER(8,0) PRIMARY KEY, MEM_FNAME VARCHAR2(30) NOT NULL, MEM_LNAME VARCHAR2(30) NOT NULL, MEM_STREET VARCHAR2(120), MEM_CITY VARCHAR2(50), MEM_STATE CHAR(2), MEM_ZIP CHAR(5), MEM_BALANCE NUMBER(10,2) ); CREATE TABLE RENTAL ( RENT_NUM NUMBER(8,0) PRIMARY KEY, RENT_DATE DATE DEFAULT SYSDATE, MEM_NUM NUMBER(8,0) CONSTRAINT RENTAL_MEM_NUM_FK REFERENCES MEMBERSHIP ); INSERT INTO MEMBERSHIP VALUES (102, 'TAMI', 'DAWSON', '2632 TAKLI CIRCLE', 'NORENE', 'TN', '37136', 11); INSERT INTO MEMBERSHIP VALUES (103, 'CURT', 'KNIGHT', '4025 CORNELL COURT', 'FLATGAP', 'KY', '41219', 6); INSERT INTO MEMBERSHIP VALUES (104, 'JAMAL', 'MELENDEZ', '788 EAST 145TH AVENUE', 'QUEBECK', 'TN', '38579', 0); INSERT INTO MEMBERSHIP VALUES (105, 'IVA',…
Insert a row into the LARGE_PROPERTY table for a new property. The office number is 1, The address is 2643 Lugsi Dr., The number of bedrooms is 3, The number of floors is 2, The monthly rent is $775, The owner number is MA111. Make sure to include the period (.) in the address.