Consider the following relations: > Chapter (id, title, subject, start_page, end_page, year, author_id, publisher_id), Author (id, name, address, phone); Publisher(id, name, address, phone); 1. Write the SQL DDL to create chapter" table taking in your consideration the following constraints: (03 Points) The value of the end_page attribute is never less than that of end_page. The value of the subject attribute does not contain physics'. The value of the title attribute is required. The value of year is filled with four digits (e.g. 2019 cannot be abbreviated as 19) 2. Write SQL DDL to create a view that is used to select the names of all authors and number of ters they have written, the view must also include the names of the authors who didn't write any chapter. You are not allowed to "where" clause. (03 Points) use 3. Write SQL statement to select author names and their chapters' titles with the publisher name. Your statement must also select the names of the authors who didn't write any chapter. You are not allowed to use where clause. (04 Points)