Normalized 3nf int. | 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 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

1NF (First Normal Form): A relation is in 1NF if every attribute value in a tuple is atomic, i.e.,…

Answered: ormalized 3nf int.

Engineering

Computer Science

ormalized 3nf int.

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

A new table has been requested to support tracking automated emails sent to customers. Create the table and add data as described below. Tablename: email_log Columns: emailid (numeric), emaildate (datetime), customer# (numeric) Primary key: emailid column, define as an Identity Column Add the following data rows and display resulting rows (if any errors occur, explain why the error is expected) Emaildate = current date, customer# = 1007 Emailid = specify to use the column default value, emaildate = current date, customer# = 1008 Emailid = 25, emaildate = current date, customer# = 1009
Table Name Item Column name Constraint Primary key Datatype Varchar2 Varchar2 Varchar2 Size 6 ID ITEM N AME MANUFACTUR ER 30 PRICE Number Not Null DELIVERY DATE Date Varchar2 STATUS 10 Table Name Customer_ Details Column name ID CUSTOMERNAME Datatype Varchar2 Constraint Foreign Key Size Varchar2 Varchar2 30 30 LOCATION CUSTOMERID Varchar2 Number QUAΝΤΙΤΥ Data for Item table ID ΙTEΜ ΑΜΕ MANUFACTURER PRICE DELIΙVERYΥ DAΤΕ STATUS COMPUTER KEYBO ARD COMP UTER COMPUTER 09001 DELL 35000 12-June-2020 PENDING 09002 INTEX 10000 25-June-2020 PENDING COMPL ETED COMPL ETED COMPL ETED 09003 SAMSUNG 32000 18-Feb-2020 09004 LENOVO 37000 о3-Аргil-2020 0900s LAPTOP DELL 57000 20-May-2020 Data for Customer_ Details table ID CUSTOMERNAME CITY CUSTOMERID C0001 C0002 QUANΤITY 525 09001 KALIFA NIZWA 09002 BARKA 8400 09003 09004 SOHAR C0003 C0001 5250 525 NIZWA 09005 BARKA C0004 3150 6. Write an SQL query to display the ID, ITEMNAME, CUSTOMERNAME and price is not equal 35000 and 37000 . 7. Write an SQL query…
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
Normalise the data : Table: Administrator Field Name Data Field Constraints Description size type varchar Admin ID 15 Primary Key Contains the Admin id Admin char 50 Not null Contains the Name Admin name Not null Contains email Email varchar 20 the Address char 10 Not null Contains the address Phone int 8 Not null Contains the Number phone number Table: Product Field Name Data type Field size Constraints Description Product ID varchar 20 Primary Key Contains the product id Product Name char 25 Not null Contains product name Category char 13 Not null Contains the category CustomerlD varchar 15 Foreign key Contains the customer id
SQL: Add a table-level PRIMARY KEY constraint to the EMPLOYEE table using the ID column. The constraint should be named at creation. (Which means you'll need to drop the table, then recreate.) Create a PRIMARY KEY constraint on the DEPARTMENT table using the ID column. The constraint should be named at creation. (Which means you'll need to drop the table, then recreate.) Add a foreign key reference on the EMPLOYEE table that will ensure that the employee is not assigned to a nonexistent department. Confirm that the constraints were added by querying USER_CONSTRAINTS. Note the types and names of the constraints and include them in your statement comments. Display the object names and types from the USER_OBJECTS data dictionary view for EMPLOYEE and DEPARTMENT tables. You will want to format the columns for readability. Provide comments that include the new tables and indexes created. Modify the EMPLOYEE table by adding a SALARY column of NUMBER data type, precision 7. Confirm…
SERVICE_ID PROPERTY_ID CATEGORY_NUMBER OFFICE_ID DESCRIPTION STATUS EST_HOURS SPENT_HOURS NEXT_SERVICE_DATE 1 11 2 2 The second bedroom upstairs is not heating up at night. Problem has been confirmed. central heating engineer has been scheduled. 2 1 2019-11-01 2 1 4 1 A new strip light is needed for the kitchen. Scheduled 1 0 2019-10-02 3 6 5 1 The bathroom door does not close properly. Service rep has confirmed issue. Scheduled to be refitted. 3 1 2019-11-09 4 2 4 1 New outlet has been requested for the first upstairs bedroom. (There is currently no outlet). Scheduled 1 0 2019-10-02 5 8 3 2 New paint job requested for the common area (lounge). Open 10 0 NULL 6 4 1 1 Shower is dripping when not in use. Problem confirmed. Plumber has been scheduled. 4 2 2019-10-07 7 2 2 1 Heating unit in the entrance smells like it’s burning. Service rep confirmed the issue to be dust in the heating unit. To be cleaned. 1 0 2019-10-09 8 9 1 2 Kitchen sink does not drain properly. Problem…
Product_id Product_name Category Mfg_date Exp_Dte Product_price 01 Dairy Milk Choclate Junk 2,Aug, 2019 2aug, 2020 80 02 Lipton Tea Bags Not junk 2,jan 2019 2, jan 2020 160 03 Kurkure junk 2, april 2919 2, april, 2021 30 04 Shezan Juice Junk 3,Aug, 2019 3,aug, 2020 30 06 Olpers Milk Not junk 3,april, 2018 3,april, 2020 350 Canteen_table 1: Write query to create canteen_table. Put check on category values as only “junk” and “Not junk”. Change colum name of product_price to unit_price. Display products manufactured between 1, jan 2019 to 1, May 2019. Display count of only junk food items in canteen_table with alias name as “junk Food Count”. Display Count Of both Junk food and not junk food products whose count is greater then 1.
artists: artist_id, first_name, last_name, contact_no, Profession ,birth_date ,address awards: awards_id, movie_id, person_id, category movie_cast: id, movie_id, person_id, category movies: movie_id, title, genre, gross, Distributor, release_date movies_ratings: rating_id, movie_id, person_id, number_of_stars 1. Write a query in SQL to list the following information of the artists in movie industry. Limit this information to only 5 artists. Sort the information by age descending order. Full name : first name and last name separated by space Age: Current age Address: State that he resides Contact number: Phone number. 2. Write a query in SQL to find the full name of the "Actors" who appeared in the movie titled Star Wars (using JOIN ) 3. Write a SQL query to find the movie Title that has received Lowest rating from reviewers, but whose actors have received an award for their contribution in movie. Output:Fantastic Beasts and Where to Find Them 4. Write a SQL query that display the list…
Create a trigger named trg_line_prod that will automatically update the product quantityon hand for each product sold after a new LINE row is added. Output:After inserting a new row in to LINE: Before running the Trigger the P_QOH was 23: After running the Trigger the P_QOH was 21:
The following code would include: CREATE OR REPLACE TRIGGER TRG_LINE_PROD AFTER INSERT ON LINE FOR EACH ROW BEGIN UPDATE PRODUCT SET P_QOH = P_QOH - :NEW.LINE_UNITS WHERE PRODUCT.P_CODE = LINE.P_CODE; END; Group of answer choices A) Create a trigger named trg_line_prod that will automatically increase the product quantity on hand for each product sold after a new LINE row is added. B) Create a trigger named trg_line_prod that will automatically update the product quantity on hand for each product sold after the LINE table is modified. C) Create a trigger named trg_line_prod that will automatically reduce the product quantity on hand for each product sold after a new LINE row is added. D) This query will not work as it has syntax errors.
Please create this two trigger and write down as Mysql statement Create a trigger named trg_charter_time that will automatically update the AIRCRAFT table when a new CHARTER row is added. Use the CHARTER table’s CHAR_HOURS_FLOWN to update the AIRCRAFT table’s AC_TTAF, AC_TTEL, and AC_TTER values. The meaning for the AIRCRAFT table columns are as follows: AC_TTAF: Total time on the air frame (before maintenance) AC_TTEL: Total time on the left engine (before maintenance, also track single engine) AC_TTER: Total time on the right engine (before maintenance) So in the trigger, you need to decrease all of them by the number of CHAR_HOUR_FLOWN Create a trigger named trg_cust_charge that will automatically update the CUSTOMER table’s CUS_BALANCE when a new CHARTER row is added. Use the CHARTER table’s CHAR_TOT_CHG as the update source (Assume that all charter charges are charged to the customer balance.) In addition to the CHAR_TOT_CHG, add a $5 service charge for every 50 miles…
Display the JOB_ID and the position of the character S in the JOB_ID on jobs table as the following: Search of the character S in the JOB_TITLE Result S not found in the name Not Found S in the last character of the name Last Character The name contains the character S Contains S S in the first character of the name First Character