Question: We are using HeidiSQL In class. Please provide the proper code for this questions. Thanks! You have been deputized by the President of Toledo Art

We are using HeidiSQL In class. Please provide the proper code for this questions. Thanks!
You have been deputized by the President of Toledo Art Gallery ho develop a database. The datab must be able to store and track data regarding artists and their paintings, copies of the paintings, customers. Based on your analysis, you have identified the following entities for your database: ARTIST, PAINTING, COPY, CUSTOMER. The following is the database design: 1. Code the SQL statements to create all five tables with their PK and FK(s). You can choose appropriate data types for the table attributes/columns, all table attributes/columns mus have NOT NULL status other than COPY.CustomerID. (50 pts) 2. Code the SQL statements to insert three fictitious records into each of the tables. (50pts) Copyyour entire code in sequential order into a Notepad file and upload it to Canvas. You have been deputized by the President of Toledo Art Gallery ho develop a database. The datab must be able to store and track data regarding artists and their paintings, copies of the paintings, customers. Based on your analysis, you have identified the following entities for your database: ARTIST, PAINTING, COPY, CUSTOMER. The following is the database design: 1. Code the SQL statements to create all five tables with their PK and FK(s). You can choose appropriate data types for the table attributes/columns, all table attributes/columns mus have NOT NULL status other than COPY.CustomerID. (50 pts) 2. Code the SQL statements to insert three fictitious records into each of the tables. (50pts) Copyyour entire code in sequential order into a Notepad file and upload it to CanvasStep by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
