in Rstudio

1. Choosing a suitable customer number, add a new customer Charles, whose address is ATLANTIC, to your database. 2. a) Create a new relation in your database using the schema below. Make sure you implement the PRIMARY KEY. SHOES (SHOE ID, MODEL, COLOR) b) Write code to check that SHOES exists in your database. c) Add the following tuples to SHOES: , d) Try adding the tuple: Show that this results in an error and explain why the error occurred. 3. A new relation is to be added to the database using following the schema. (You are NOT asked to create this relation) SHOE_SALES_ASSISTANT (SHOE_SALES_ASSISTANT_ID, SHOE_ID, QUANTITY_SOLD) a) Choose a suitable primary key for this relation. b) Identify any foreign keys. c) What SQL statement would you need to run to enable foreign key support in your database