0o.You Normalized database up to 3 nf. . Deasect DescriptionDessect Price AmountDeaseet HameDessertDeasect Categocy WameBooth Type CodeBooth Type textBooth1Booth Location CodeDeasect Offered Date RangeGenerateContainMDessect CodeTopping HameNDeink ameBooth CapacityMSmoking section IndicatorOfferCeanuity AmountRestaurant Owneel JameRestaurant Maximum Capacity HumberBill_10BillNRestaurant Owne2 NameRestaurant Region HameReataucant Ownee3 WameBill_AmountMRestaurantProcessBill Date and TimeNRestaurant IdentifierContain1Restaurant Region Code | RESTAURANT_ID | RESTAURANT OWNER1_NAME | RESTAURANT_OWNER2_NAME| 123| Paul Smith| 124| James Pierce| NULL125126326454789Bob JonesBill BarkerMary DoeMary DoeMary Doe| Mary DoeMary Doel| Mike Myers| Mike Myers| Mike MyersMike Myers| RESTAURANT_OWNER3_NAMEMary DoelBob JonesNULLNULLNULLNULLNULL| RESTAURANT_REGION_CODE| NE| NE|SW| SW| SW| NENE| RESTAURANT_REGION_NAME | RESTAURANT_MAX_CAPACITY |NortheastNortheastSouthwestSouthwest| SouthwestNortheastNortheast50200 |175100 |322145678

Normalization in DBMS is the process of structuring the data and properties in a database to…

RESTAURANT_ID | RESTAURANT OWNER1_NAME | RESTAURANT OWNER2_NAME | RESTAURANT OWNER3_NAME | RESTAURANT REGION_CODE | RESTAURANT REGION_NAME | RESTAURANT_MAX_CAPACITY | | Paul Smith | Mary Doel | NE Bob Jones | NE SW James Pierce | NULL Mike Myers | Mike Myers Mike Myers Mike Myers 123 124 125 126 326 454 789 Bob Jones | Bill Barker Mary Doel Mary Doe Mary Doel Mary Doe Mary Doe | NULL NULL NULL | NULL NULL SW | SW NE | NE Northeast Northeast Southwest | Southwest Southwest Northeast | Northeast 50 200 175 100 322 | 145 | 678

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter7: Database Administration

Section: Chapter Questions

Problem 4TD: Write, but do not execute, the commands to grant the following privileges: a. User Ashton must be...

See similar textbooks

Similar questions

Based on the following table, please find the customers who locate in the same state. sales.customers *customer_id first_name last_name phone email street city state zip_code . Based on the following table, please display the staff and their corresponding manager in the same store. Please display staff’s full name in one column, manager’s full name in another column, and store_id. sales.staffs *staff_id first_name last_name email phone active store_id manager_id
CREATE TABLE employees8(employee_id NUMBER(10) PRIMARY KEY,first_name VARCHAR(25) UNIQUE,last_name VARCHAR(25) UNIQUE,job_id NUMBER(3),salary NUMBER(6) NOT NULL,department_name VARCHAR2(20));CREATE TABLE jobs8(job_id NUMBER(3) PRIMARY KEY,job_title VARCHAR2(25),min_salary NUMBER(4)check(min_salary >=2900),max_salary NUMBER(6)check(max_salary<=100000)); CREATE TABLE departments8(department_id NUMBER(2) PRIMARY KEY,department_name VARCHAR2(30),location_name VARCHAR2(15) DEFAULT 'Istanbul'); how can I do this question according to these 3 tables ? Create a complex view that joining with three tables.
Name Null? Type --------- ----- ------------ GIFT VARCHAR2(15) MINRETAIL NUMBER(5,2) MAXRETAIL NUMBER(5,2) Based on the structure of the PROMOTION table, which of the following commands will add a PRIMARY KEY constraint to the GIFT column? 1. CREATE constraint promo_pk (gift VARCHAR2(15) PRIMARY KEY; 2. ALTER TABLE promotion MODIFY constraint promo_pk (gift PRIMARY KEY); 3. ALTER TABLE promotion SET constraint promo_pk PRIMARY KEY gift; 4. ALTER TABLE promotion ADD constraint promo_pk PRIMARY KEY(gift);
Examine this product table's column definitions:pid number primary keypname varchar2(50)You must display column headings as shown:Product_ID Product NameWhich SELECT statement does this? SELECT pid Product_ID, pname Product Name FROM product; SELECT pid Product_ID, pname "Product Name" FROM product; SELECT pid @Product_ID, pname @"Product Name" FROM product; SELECT pid AS Product_ID, pname AS Product Name FROM product
8. Create a trigger for the Invoices table that automatically inserts the vendor name and address for a paid invoice into a table named ShippingLabels. The trigger should fire any time the PaymentTotal column of the Invoices table is updated. The structure of the ShippingLabels table is as follows: CREATE TABLE ShippingLabels (VendorName varchar(50), VendorAddress1 varchar(50), VendorAddress2 varchar(50), VendorCity VendorState VendorZipCode varchar(50), char(2), varchar(20)); Use this UPDATE statement to test the trigger: UPDATE Invoices SET PaymentTotal = 67.92, PaymentDate = '2020-02-23' WHERE InvoiceID = 100;
Assume you have these table CREATE TABLE Student (studid Char(9) Primary Key,FirstName Varchar2(50) NOT NULL,LastName Varchar2(50) NOT NULL,Email Varchar2(50) NOT NULL UNIQUE,PhoneNumber Number(8) NOT NULL UNIQUE,DateOfBirth Date NOT NULL,GPA Number(1,2) NOT NULL); CREATE TABLE Club (clubID Number(3) Primary Key,ClubName Varchar2(20) NOT NULL,studid Char(9) NOT NULL UNIQUE, Foreign key(studid) references Student(studid)); CREATE TABLE MemberOf (ClubID Number(3) Primary Key, Studid char(9), JoiningDate date, Foreign Key(ClubID) references club(clubID), Foreign Key(Studid) references Student(studid)); CREATE TABLE Activities (Actid Number(3) Primary Key,Acdt DATE NOT NULL,Place Varchar2(50) NOT NULL,durationNbHour Number NOT NULL); CREATE TABLE Organize (actid Number(3) Primary Key, clubID Number(3), Fee Number(4,2), Foreign Key(actid) references Activities(Actid),Foreign Key(clubID) references MemberOf(ClubID)); Write in SQL queries to populate the above tables by inserting minimum 4…
My update button does not work, when i press edit to update data. i get an unidentified index. Plz help! EDIT_PRODUCT.PHP <?php // Get the product data $category_id = $_POST['category_id']; $code = $_POST['code']; $name = $_POST['name']; $price = $_POST['price']; $product_id = $_POST['productID']; // Validate inputs if (empty($code) || empty($name) || empty($price)) { $error = "Invalid product data. Check all fields are try again."; include('error.php'); } else { // If valid, add the product to the database require_once('database.php'); $query = "UPDATE products SET categoryID = $category_id, productCode = $code, productName = $name, listPrice = $price WHERE productID = $product_id"; $db->exec($query); // Display the Product List page include('index.php'); } EDIT_PRODUCT_FORM.PHP <?php // get post values $product_id = $_POST['product_id']; // This is the drop down menu next to 'Category:' require('database.php'); $query = 'SELECT * FROM categories ORDER BY…
1. Create/ a sequence, GOV_SEQUENCE_xx, that begins with 100 and increments by 100 and uses all other defaults. Use your initials instead of the xx in the sequence name. 2. Select the next value of your sequence. 3.Use the next value of the sequence you created , GOV_SEQUENCE_xx as the value for the employee ID for every row inserted
Some rows of a User table are shown below: User ucode name phone scode 7 Alex 847 - 3902 UX 8 Tony 203 - 3902 PX 9 Charles BD 11 Mary 877 - 3333 BD Which of the following queries retrieves the rows where there is no phone? a. SELECT * FROM User WHERE phone IS NULL b. SELECT * FROM User WHERE phone = “ ” c. SELECT * FROM User WHERE phone NOT IS NULL d. SELECT * FROM User WHERE phone > 0
1. Display the last name and salary for all employees whose salary is not in the range of $5,000 and $12,000. 2. Display the employee last name, job ID, and start date of employees hired between February 20, 1998, and May 1, 1998. 3. Display the last name and salary of employees who earn between $5,000 and $12,000, and are in department 20 or 50. 4. Display the last name, job, and salary for all employees whose job is sales representative or stock clerk and whose salary is not equal to $2,500, $3,500, or $7,000. 5. Display the last name, salary, and commission for all employees whose commission amount is 20%. Note: this question is related from database subject.
what is these codes insert into values()... CREATE TABLE [Car] ([CarID] varchar(30),[SerialNumber] varchar(50),[Model] varchar(30),[Colour] varchar(30),[Year] varchar(20),PRIMARY KEY ([CarID])); CREATE TABLE [ServiceTicket] ([ServiceticketID] varchar(40),[Serviceticketnumber] varchar(40),[CarID] varchar(30),[CustomerID] int,[Datarecieved] varchar(30),[Comments] varchar(100),[Datareturnedcustomer] varchar(100),PRIMARY KEY ([ServiceticketID]),CONSTRAINT [FK_ServiceTicket.CustomerID]FOREIGN KEY ([CustomerID])REFERENCES [Customer]([CustomerID]),CONSTRAINT [FK_ServiceTicket.CarID]FOREIGN KEY ([CarID])REFERENCES [Car]([CarID])); CREATE TABLE [ServiceMechanic] ([ServicemechanicID] varchar(40),[ServiceticketID] varchar(40),[ServiceID] int,[MechanicID] int,[Hours] varchar(10),[Comment] varchar(100),[Rate] varchar(40),PRIMARY KEY ([ServicemechanicID]),CONSTRAINT [FK_ServiceMechanic.MechanicID]FOREIGN KEY ([MechanicID])REFERENCES [Mechanic]([MechanicID]),CONSTRAINT…
The view V_PAT_ADT_LOCATION_HX returns one row of information per bed stay. The column ADT_DEPARTMENT_ID is the ID of the bed's department. The column ADT_DEPARTMENT_NAME is that department's name. Two distinct departments can potentially share the same name. Which of the following queries would return exactly one row per department and display the name of the department? A. SELECT ADT_DEPARTMENT_ID, MIN(ADT_DEPARTMENT_NAME) FROM V_PAT_ADT_LOCATION_HX GROUP BY ADT_DEPARTMENT_ID B. SELECT MIN(ADT_DEPARTMENT_ID), ADT_DEPARTMENT_NAME FROM V_PAT_ADT_LOCATION_HX GROUP BY ADT_DEPARTMENT_ID C. SELECT 'ADT_DEPARTMENT_ID', ADT_DEPARTMENT_NAME FROM V_PAT_ADT_LOCATION_HX GROUP BY ADT_DEPARTMENT_ID D. SELECT ADT_DEPARTMENT_ID, 'ADT_DEPARTMENT_NAME' FROM V_PAT_ADT_LOCATION_HX GROUP BY ADT_DEPARTMENT_ID