a. Insert a new field email after TelephoneNo at the table Customers.b. Drop the field email that you have created at (a).C. Get the customer's name who has bought the furniture "Bedroom Set".d. Get the customer's name that has bought exceeding RM1000.00.e. Get the number of customers who have registered for NAZ Furniture Database System.f. Insert the following data into the table Furnitures.FurnitureID=B002ItemName = Shoe Rack Design APrice = 89.90FurnitureID=B003ItemName = Shoe Rack Design BPrice = 99.90g. Get the customers name who have bought furniture that dealt with Intan Amira.h. Update "Wardrobe" to "Italian Wardrobe" at the table Furniture. 2. The following is relationship tables of database for the NAZ Furniture Database System.Using the Structured Query Language (SQL), write the commands for each of the followingproblems.CustomersBuysBuylD12FurnituresCustIDP001P011P022CustIDStaffsP001P011FurnitureIDB001B111B101StaffIDS01S02FurniturelDB001B111CustNameAbdul SalamSiva PrakashTan Leong TaiStafflDWardrobeBedroom SetDining TableS01S01ItemNameDate1/11/20222/11/2022StaffNameIntan AmiraHusna AisyahTelephoneNo010123456701111123040117823433Quantity799.00111999.003000.00PricePaymentMethodcashcashTelephoneNo012222222101111111

Note: Here you have posted a question having multiple subparts. As per our guidelines, we are…

a. Insert a new field email after TelephoneNo at the table Customers. b. Drop the field email that you have created at (a). C. Get the customer's name who has bought the furniture "Bedroom Set". d. Get the customer's name that has bought exceeding RM1000.00. e. Get the number of customers who have registered for NAZ Furniture Database System. f. Insert the following data into the table Furnitures. FurnitureID=B002 ItemName Shoe Rack Design A Price = 89.90 FurnitureID=B003 ItemName=Shoe Rack Design B Price = 99.90 g. Get the customers name who have bought furniture that dealt with Intan Amira.

a. Insert a new field email after TelephoneNo at the table Customers. b. Drop the field email that you have created at (a). C. Get the customer's name who has bought the furniture "Bedroom Set". d. Get the customer's name that has bought exceeding RM1000.00. e. Get the number of customers who have registered for NAZ Furniture Database System. f. Insert the following data into the table Furnitures. FurnitureID=B002 ItemName Shoe Rack Design A Price = 89.90 FurnitureID=B003 ItemName=Shoe Rack Design B Price = 99.90 g. Get the customers name who have bought furniture that dealt with Intan Amira.

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

The PatientDim table contains columns. PatientEpicId and name. Use the following query to answer the questions below it: SELECT PatientEpicID Name FROM PatientDim What does this query return? select one of the following: A. Nothing because the query won't run.B. The column PatientEpicId and name from the table PatientDimC. The PatientEpicID column from the table PatientDim, with an alias of name.D. The name column from the table PatientDim, with an alias of PatientEpicId
The Finance team wants to calculate a VAT (8%) on the amount of the stay reservations in the database. However, the team wants to calculate the VAT after the discounts are applied on the prices. In addition, it is important to remember if there is no discount/offers, then the value is NULL in the TRAVELS table. Create a procedure called VATCalculator to calculate the VAT amount and return with the corresponding travel ID. In addition, execute the procedure to account for NULL values and send the respective result to the team. The VAT value should be rounded to 2 decimals.
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)
Task 2: The Car Maintenance team also wants to store the actual maintenance operations in the database. The team wants to start with a table to store CAR_ID (CHAR(5)), MAINTENANCE_TYPE_ID (CHAR(5)) and MAINTENANCE_DUE (DATE) date for the operation. Create a new table named MAINTENANCES. The PRIMARY_KEY should be the combination of the three fields. The CAR_ID and MAINTENACNE_TYPE_ID should be foreign keys to their original tables. Cascade update and cascade delete the foreign keys. Answer in MYSQL please
Go to the w3schools website’s SQL browser IDE. This is where you canwrite and test your SQL code using their databases. Once you are happywith it, paste your code in a text file named Student.txt and save it in yourtask folder.● Write the SQL code to create a table called Student. The table structure issummarised in the table below (Note that STU_NUM is the primary key):Attribute Name Data TypeSTU_NUM CHAR(6)STU_SNAME VARCHAR(15)STU_FNAME VARCHAR(15)STU_INITIAL CHAR(1)STU_STARTDATE DATECOURSE_CODE CHAR(3)PROJ_NUM INT(2)● After you have created the table in question 1, write the SQL code to enterthe first two rows of the table as below:STU_NUMSTU_SNAMESTU_FNAMESTU_INITIALSTU_STARTDATECOURSE_CODEPROJ_NUM01 Snow John E 05-Apr-14 201 602 Stark Arya C 12-Jul-17 305 11● Assuming all the data in the Student table has been entered as shownbelow, write the SQL code that will list all attributes for a COURSE_CODE of305.…
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