1. Now, consider the following instances of the Customer and Reserves tables: (20 Pts)

1) Write the DDL code to build the above database. (8 Pts)

i. Please determine the data type for each attribute by yourself.

ii. Make sure you can set primary key and foreign key correctly.

iii. Create table command only.

Customer Reserves CID Title CID.| Name | Age | City | State 1Joe 27BerkeleyCA 2 Betty 23Oakland CA 3 Sally 49Albany CA 4Hamy 38Berkeley CA 1 Sleeper Bananas 2 Sleeper Date 01/01/01 01/01/01 01/01/01 2Annie Hall 0201/01 2 Sleeper Interiors 4 Sleeper 02/01/01 02/01/01 03/01/01