Chapter 17, Problem 7QY

What is the maximum number of columns you can define as a primary key when using the column-level approach to creating a table? a. 0 b. 1 c. 30 d. 255

Write a SQL statement that will add the below row to the Task table.TaskID Description Duration StartDate TeamMemberID4 Implementemailnotifications2

Syntax for drop table cascade constraints drop table with restrict  syntax for On delete/update set default

3. Write a SELECT statement that joins the Departments, Courses, and Instructors tables. This statement should return these columns: DepartmentName, CourseDescription, FirstName, and LastName. Use aliases for the tables and return only those courses with three units. Each course description should only be listed once. Sort the result set by DepartmentName and then by CourseDescription in ascending sequence.

Question 42: Match each argument within a lookup function with its best description. Lookup value Table array Column index number Range lookup         Optional logical value that specifies a search for an exact or approximate value in the table array Column number in a table array that contains the corresponding data to be retrieved The cell range containing the lookup table Value in the worksheet to be looked up in the first column of the table array

Create view_admin.php for this table.

True or False Each column in a table must have a name.

Create table statements (file name must be: 1_create_table.txt). Make sure you specify primary keys and foreign keys. Specifying “not null” constraint is optional. Specifying “on delete action” and “on update action” are optional.

Using the getFirst() function as a template for reference, code the saveProduct() function that will be called when the save button of the depicted screen is clicked. The text from the JTextFields will be used as parameters.The database schema for the SQL tables are also depicted. The number of the product is the primary key and is set to auto-increment.  public Product getFirst()    {                 if (openConnection())         {             try{                 Product temp = null;                 String query = "SELECT * FROM products order by number asc limit 1"; // our SQL SELECT query.                 Statement st = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); // create the java statement                 ResultSet rs = st.executeQuery(query);// execute the query, and get a java resultset                 while (rs.next()) // iterate through the java resultset                 {                     temp = new…