Chapter 1, Problem 3EYW

Ensure that the only legal values for the TYPE column in the TRIP table are Biking, Hiking, or Paddling.

Change the CONTACT view so that no users can accidentally perform DML operations on the view.

Create a view called HOMEWORK13 that includes the columns named Col1 and Col2 from the FIRSTATTEMPT table. Make sure the view is created even if the FIRSTATTEMPT table doesn’t exist.

Create a view named CONDO_FEES. It consists of two columns: the first is the square footage, and the second is the average fee for all condos in the CONDO_UNIT table thathave that square footage. Use AVERAGE_FEE as the column name for the average fee.Group and order the rows by square footage. a. Write and execute the CREATE VIEW command to create the CONDO_FEES view. b. Write and execute the command to retrieve the square footage and average fee foreach square footage for which the average fee is greater than 500. c. Write and execute the query that the DBMS actually executes. d. Does updating the database through this view create any problems? If so, what arethey? If not, why not?

Create a trigger named Products_UPDATE that checks the new value for the DiscountPercent column of the Products table. This trigger should raise an appropriate error if the discount percent is greater than 100 or less than 0. If the new discount percent is between 0 and 1, this trigger should modify the new discount percent by multiplying it by 100. That way, a discount percent of .2 becomes 20. Test this trigger with an appropriate UPDATE statement.

Use the HOL Small Company ERD and HOL Small Company Details xlsx to completethe steps listed below.It is important to name the tables and columns exactly as they are shown in theERD/xlsx.Failure to do so will cause future assignment to fail.*//*()Comments1. At the beginning of your script,  make single-line comments for yourname, the name of the assignment, and the date.2. At the beginning of your script, make a multi-line comment thatdescribes the issues you had with this assignment.*//* ()Creating TablesAfter the 5 DROP TABLE statements, complete the 5 CREATE TABLE statementsbelow to create the tables listed below.Make sure you choose the appropriate data types.Include NOT NULL and UNIQUE constraints.DO NOT include key constraints (i.e., primary keys, foreign keys) in yourstatements.The table names are:() HOL_CUSTOMERS(6) HOL_BOOKS(6) HOL_BOOK_CATEGORY(6) HOL_ORDERS(6) HOL_ORDER_ITEMS   */DROP TABLE HOL_ORDER_ITEMS;DROP TABLE HOL_ORDERS;DROP TABLE HOL_CUSTOMERS;DROP TABLE…

Type Reduction in cell M1   The amount is 50% of sick days above 10, whenever sick days exceed 10. For all other records, the amount is 0 Create the criteria area, starting in cell P8   Enter formula(s) to complete column M, using an IF Statement.

Create a scatterplot in Excel of age and years worked.Comment on what this scatterplot tells you about the data.

please solve the last 3 questions  with the fact that I have posted it before and the person who answered it said that I have to publish it again so you can solve the last 3 questions