Create a database store. Create the table using design view. Item ItemID ItemName Section Price Sold CustomerNo IT101 Tshirt Garments 3 25 C1 IT102 Handbag Accessories 7 12 C2 IT103 Socks Garments 1 20 C1 IT104 Bracelet Accessories 5 C3 IT105 Blanket Décor 12 9 C2 IT106 Pillow Décor 10 32 C4 Create the table using SQL Create statement. Customer CustomerNo Location PurDate Amount C1 Nizwa 2/25/2021 30 C2 Muscat 2/24/2021 45 C3 Muscat 2/22/2021 55 С4 Nizwa 2/22/2021 60 Solve the following queries: 1. Display all details of the item table. 2. Display item name, section and price of all garments. 3. Display the number of customers from Muscat and their total amount. 4. Display the average of all garment items sold. 5. Display the maximum and minimum amount of the customer. 6. Display all items ending with 'et' and are décor. 7. Display customer number and location of customer with amount not less than 50.

Create a database store. Create the table using design view. Item ItemID ItemName Section Price Sold CustomerNo IT101 Tshirt Garments 3 25 C1 IT102 Handbag Accessories 7 12 C2 IT103 Socks Garments 1 20 C1 IT104 Bracelet Accessories 5 C3 IT105 Blanket Décor 12 9 C2 IT106 Pillow Décor 10 32 C4 Create the table using SQL Create statement. Customer CustomerNo Location PurDate Amount C1 Nizwa 2/25/2021 30 C2 Muscat 2/24/2021 45 C3 Muscat 2/22/2021 55 С4 Nizwa 2/22/2021 60 Solve the following queries: 1. Display all details of the item table. 2. Display item name, section and price of all garments. 3. Display the number of customers from Muscat and their total amount. 4. Display the average of all garment items sold. 5. Display the maximum and minimum amount of the customer. 6. Display all items ending with 'et' and are décor. 7. Display customer number and location of customer with amount not less than 50.

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter13: Views

Section: Chapter Questions

Problem 5MC

See similar textbooks

Similar questions

Write, but do not execute, the commands to grant the following privileges: a. User Oliver must be able to retrieve data from the CONDO_UNIT table. b. Users Crandall and Perez must be able to add new owners and condo units to thedatabase. c. Users Johnson and Klein must be able to change the condo fee of any unit. d. All users must be able to retrieve the unit number, condo fee, and owner number forevery condo unit. e. User Klein must be able to add and delete service categories. f. User Adams must be able to create an index on the SERVICE_REQUEST table. g. Users Adams and Klein must be able to change the structure of the CONDO_UNITtable. h. User Klein must have all privileges on the LOCATION, OWNER, and CONDO_UNITtables.
Write, but do not execute, the commands to grant the following privileges: a. User Ashton must be able to retrieve data from the ITEM table. b. Users Kelly and Morgan must be able to add new orders and order lines. c. User James must be able to change the price for all items. d. User Danielson must be able to delete customers. e. All users must be able to retrieve each customers number, name, street, city, state,and postal code. f. f User Pere7 must be able to create an index on the ORDFRS table. g. User Washington must be able to change the structure of the ITEM table. h. User Grinstead must have all privileges on the ORDERS table.
Write, but do not execute, the commands to grant the following privileges: a. User Rodriquez must be able to retrieve data from the TRIP table. b. Users Gomez and Liston must be able to add new reservations and customers to thedatabase. c. Users Andrews and Zimmer must be able to change the price of any trip. d. All users must be able to retrieve the trip name, start location, distance, and type forevery trip. e. User Golden must be able to add and delete guides. f. User Andrews must be able to create an index for the TRIP table. g. Users Andrews and Golden must be able to change the structure of the CUSTOMERtable. h. User Golden must have all privileges on the TRIP, GUIDE, and TRIP_GUIDEStables.
Assign privileges to the new account that allow connecting to the database, creating new tables, and altering an existing table.
Which of the following represents a field in a table? a record a row a column an entity
Which of the following has no repeating groups but can contain partial or transitive dependencies? unnormalized data 1NF 2NF 3NF
How do you create an index? How do you create a unique index? What is the difference between an index and a unique index?
Do the tables exhibit referential integrity? Answer yes or no, and then explain your answer. Write NA (Not Applicable) if the table does not have a foreign key. FIGURE P3.17 THE CH03_TRANSCO DATABASE TABLES

Recommended textbooks for you

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS