StudentId Lastname Firstname ProgramCode Email ____________________________________________________________________________ 300111222 Anna Rav 3409 r..a@my.centennialcollege.ca 300123123 Chong Raul 3409 r..g@my.centennialcollege.ca 300124124 Vasudevan Hima 3408 h..u@my.centennialcollege.ca 1) Create Student table as defined above. Have the StudentId be the primary key, and ensure the lastname and firstname are not null [1 mark] 2) Insert one row into the Student table for student Rav Anna [1 mark] 3) Insert the second and third rows in one Insert command in the Student table [1 mark] 4) Assume that Rav Anna has switch to program 3408, update the data about him in the table correspondingly [1 mark] 5) Delete the row for student Raul Chong from the table [1 mark]

Part-B All questions below refer to the tables in the JustLee database 1) Display a list of all data contained in the Publisher table [1 mark] 2) List title, publication date and retail price for each book in table Books. Use the column heading "Publication Date" for the Pubdate filed [1 mark] 3) List the customer name (first name & last name) in Customers table along with the city and state in which the customer lives [1 mark] 4) Determine which categories are represented in the current book inventory. List each category only once [1 mark] 5) List all items included in order# =1007 [1 mark