Consider the following schema for a relational database that stores customers'

book reviews. A book may receive multiple reviews, but a customer can only

review a book once.

Primary keys are underlined, and foreign keys are in italics. With reference to

the schema, answer the following questions.

$($a$)$ Using the following information, write an SQL query to create the Review

table. You should use appropriate data types and include all applicable

constraints of the relational model.

BookID is a fixed$-$length string of $7$ characters in length, e$.$g$.,$ B$123456.$

CustomerNo is a fixed$-$length string of $8$ characters in length, e$.$g$.,$

C$2301000.$

Allowed rating values are whole numbers from $1$ to $5.$

ReviewDate should default to the current date.