The Horse table has the following columns: • ID - integer, auto increment, primary key RegisteredName - variable-length string Breed- variable-length string, must be one of the following: Egyptian Arab, Holsteiner, Quarter Horse, Paint, Sad Height- decimal number, must be > 10.0 and s 20.0 • BirthDate - date, must be 2 Jan 1, 2015 Make the following updates: 1. Change the height to 15.6 for horse with ID 2. 2. Change the registered name to Lady Luck and birth date to May 1, 2015 for horse with ID 4. 3. Change every horse breed to NULL for horses born on or after December 22, 2016.

Insert any 5 rows of athletes including your details into the Athletics table you created in the previous Question. The table created previously  CREATE TABLE Athletics ( AthleteID int NOT NULL  First_name varchar(255) NOT NULL, Last_name varchar(255) NOT NULL, DOB DATE NOT NULL, SportsCode INT, Date_Last_event DATE,     PRIMARY KEY (ID) );   varchar(255) use for define string column, int stand for integer field etc.

C. d. ne: ID: A 7. A summer camp offers a morning session and an afternoon session. The list morningList contains the names of all children attending the morning session, and the list afternoonList contains the names of all children attending the afternoon session. Only children who attend both sessions eat lunch at the camp. The camp director wants to create lunchList. which will contain the names of children attending both sessions. The following code segment is intended to create lunchList, which is initially empty. It uses the procedure IsFound (list, name), which returns true if name is found in list and returns false otherwise. FOR EACH child IN morningList Which of the following could replace so that the code segment works as intended? IF (ISFound (lunchList, child)) IF (IsFound (afternoonList, child)) APPEND (afternoonList, child) APPEND (lunchList, child) a. IF ((Is Found (morningList, child)) OR (IsFound (afternoonList, child) )) IF (IsFound (morningList, child)) APPEND…

Create lookup functions to complete the summary section. In cell I6, create a formula using the VLOOKUP function to display the number of hours worked in the selected week. Look up the week number in cell I5 in the range A17:G20, and return the value in the 2nd column. Use absolute references for cell I5 and the range A17:G20.