1 Creating factory DatabaseSUPPLIERCUSTOMERldldCompanyNameFirstNameContactNameLastNameCityCityCountryCountryPhonePhoneFaxPRODUCTORDERldORDERITEMIdProduct NameOrderidOrderDateProductid TOCustomerldSupplierldUnitPriceUnitPriceTotalAmountPackageQuantityIsDiscontinuedCraete table by using SQLDrop Column IsDiscontinued from table ProductAdd column Email to Table CustomerName change column Lastname to Name SurnameAdd restrictions (primary key + foreign key) comtained in the tableOrderitmeHint: the image of the key indiceates primary key=O

How to Add a New Column with ALTER TABLE To add a new column, you first need to select the table…

Creating factory Database SUPPLIER CUSTOMER Id ld CompanyName FirstName ContactName LastName City City Country Country Phone Phone PRODUCT ORDER Id ORDERITEM Id Orderid OrderDate ProductName Supplierld Productid TO Customerid UnitPrice TotalAmount UnitPrice Package Quantity IsDiscontinued Craete table by using SQL Drop Column IsDiscontinued from table Produc Add column Email to Table Customer Name change column Lastname to Name Surname Add restrictions (primary key + foreign key) comtained in the table Orderitme Hint: the image of the key indiceates primary key -0

Creating factory Database SUPPLIER CUSTOMER Id ld CompanyName FirstName ContactName LastName City City Country Country Phone Phone PRODUCT ORDER Id ORDERITEM Id Orderid OrderDate ProductName Supplierld Productid TO Customerid UnitPrice TotalAmount UnitPrice Package Quantity IsDiscontinued Craete table by using SQL Drop Column IsDiscontinued from table Produc Add column Email to Table Customer Name change column Lastname to Name Surname Add restrictions (primary key + foreign key) comtained in the table Orderitme Hint: the image of the key indiceates primary key -0

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
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.
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
Which of the following is a valid SQL statement?a. ALTER TABLE secustomersspent ADD DATE lastorder;b. ALTER TABLE secustomerorders DROP retail;c. CREATE TABLE newtable AS (SELECT * FROM customers);d. ALTER TABLE drop column *;
134. EMPDET is an external table containing the columns EMPNO and ENAME. Which command would work in relation to the EMPDET table? a. UPDATE empdetSET ename = 'Amit'WHERE empno = 1234; b. DELETE FROM empdetWHERE ename LIKE 'J%'; c. CREATE VIEW empvuASSELECT * FROM empdept; d. CREATE INDEXempdet_idxON empdet(empno);
InstructionsGiven the query below in green text, rewrite it to make it more readable and easy to maintain using your personal best practices in writing query. If you don't have any personal best practices, you may follow these simple rules to start with:Use inline comments if neededUse tabs instead of spacesIndent all sub-queriesUse "WHERE 1=1" followed by " AND ..."Split column names to new linesAdd empty lines for complex queriesDo not shorten table name aliasesUse the backtick (`) before and after table & column namesNever use wildcard (*) operator in any query as much as possible, unless it's necessaryUse uppercase letters to all sql keywordsselect e.id, concat(e.first_name, ' ', e.last_name) AS employee_full_name, e.first_name, d.id AS department_id, d.name AS last_department_name from employee e inner join ( select der.employee_id, max(der.id) AS max_id from department_employee_rel der where der.deleted_flag = 0 group by der.employee_id ) derm ON derm.employee_id = e.id inner…
I am stuck on a question. Please assist with writing this code: Create a trigger for the EMPLOYEES table that will set the commission amount to .4 whenever the department_id is 80. Test your trigger COMPLETELY for every event it is defined. (Sometimes, UPDATE statements must have UPDATE tablename on a separate line by itself to keep APEX from hanging). This should work both for new rows and existing rows that are updated. Scenerio: All employees who are in the sales department (80) will have their commission always set to .4. This trigger is to enforce this business rule automatically.
Which of the following is a feature of Power Query? a) Change column headings so the new name appers in the File list of a Pivot Table b) Change the raw data c) Build relationships between tables d) uses Visual Basic to create steps for import
Two tables are created: Horse with columns: ID - integer, primary key RegisteredName - variable-length string Student with columns: ID - integer, primary key FirstName - variable-length string LastName - variable-length string Create the LessonSchedule table with columns: HorseID - integer with range 0 to 65 thousand, not NULL, partial primary key, foreign key references Horse(ID) StudentID - integer with range 0 to 65 thousand, foreign key references Student(ID) LessonDateTime - date/time, not NULL, partial primary key If a row is deleted from Horse, the rows with the same horse ID should be deleted from LessonSchedule automatically. If a row is deleted from Student, the same student IDs should be set to NULL in LessonSchedule automatically.
Two tables are created: Horse with columns: ID - integer, primary key RegisteredName - variable-length string Student with columns: ID - integer, primary key FirstName - variable-length string LastName - variable-length string Create the LessonSchedule table with columns: HorseID - integer with range 0 to 65 thousand, not NULL, partial primary key, foreign key references Horse(ID) StudentID - integer with range 0 to 65 thousand, foreign key references Student(ID) LessonDateTime - date/time, not NULL, partial primary key If a row is deleted from Horse, the rows with the same horse ID should be deleted from LessonSchedule automatically. If a row is deleted from Student, the same student IDs should be set to NULL in LessonSchedule automatically. Sent from Mail for Windows
Two tables are created: Horse with columns: ID - integer, primary key RegisteredName - variable-length string Student with columns: ID - integer, primary key FirstName - variable-length string LastName - variable-length string Create the LessonSchedule table with columns: HorseID - integer with range 0 to 65 thousand, not NULL, foreign key references Horse(ID) StudentID - integer with range 0 to 65 thousand, foreign key references Student(ID) LessonDateTime - date/time, not NULL Primary key is (HorseID, LessonDateTime) If a row is deleted from Horse, the rows with the same horse ID should be deleted from LessonSchedule automatically. If a row is deleted from Student, the same student IDs should be set to NULL in LessonSchedule automatically. Notes: Table and column names are case sensitive in the auto-grader. Your SQL code does not display any results in Develop mode. Use Submit mode to test your code.
Two tables are created: Horse with columns: ID - integer, primary key RegisteredName - variable-length string Student with columns: ID - integer, primary key FirstName - variable-length string LastName - variable-length string Create the LessonSchedule table with columns: HorseID - integer with range 0 to 65 thousand, not NULL, foreign key references Horse(ID) StudentID - integer with range 0 to 65 thousand, foreign key references Student(ID) LessonDateTime - date/time, not NULL Primary key is (HorseID, LessonDateTime) If a row is deleted from Horse, the rows with the same horse ID should be deleted from LessonSchedule automatically. If a row is deleted from Student, the same student IDs should be set to NULL in LessonSchedule automatically.