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

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 Canvas

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!