1. (DDL CREATE) Write syntax to create Customer, ShoppingBasket, ShoppingBasketBook, and Book tables with Domain Constraint:

• Book ISBN started with a character (A-Z) and followed by 11 number character, e.g.: P20190418001
• Year must be greater than 2000
• Price between 10.000 and 100.000

Author Name varchar(255) N Address varchar(255) N URL varchar(255) N Publisher Name varchar(255) N Address varchar(255) N Phone varchar(255) N URL integer(10) N Customer Email varchar(255) Name varchar(255) N Phone varchar(255) N Address varchar(255) N Book ISBN varchar(255) Publisher Name varchar(255) AuthorName varchar(255) AuthorAddress varchar(255) Year integer(10) Title varchar(255) Price numeric19,0) Shopping Basket Book Shopping Basket1D integer(10) BookISBN varchar(255) Count integer(10) Shopping Basket ID integer(10) CustomerEmail varchar(255) N N Warehouse_Book WarehouseCodeinteger(10) Book ISBN varchar(255) Warehouse Code integer (10) Phone varchar(255) N O Address varchar(255) N Count integer(10) N Source: www.visual-paradigm.com%2Fguide%2Fdata-modeling%2Fwhat-is-entity-relationship-diagram