Create a creative art application in C# that is required to access its art prize competition database, which documents local artists, the names of their submitted artwork, and the retail price of their artwork. The application will allow the staff of the creative art commission to easily view, update, and delete local artists information. By accessing the creative art windows application the entire staff can identify local artists, their exhibition locations, and the sale price of their art.

The application must include the following: The user first views a Window application that loads the database table, which includes fields (text boxes and labels) for the Art ID, Art Title, Location, Collection (public or private), and Retail Price. Combo box for the Artist Name, so the user can select from. If the user select a different name from the list, then all the associated fields (Art ID, Art Title, Location and Collection) will change to show the information related to that artist. A navigation tool bar appears at the top of the Windows form, allowing the user to move from record to record. The information will be viewed in the fields. The Windows form also includes a title and artistic image. The user can tap or click the Add new button on the navigation toolbar to add new artist. The record is saved when the user taps or clicks the Save Data button on the navigation toolbar. The user can tap or click the Delete button on the navigation toolbar to delete an artists record. The record is permanently deleted when the user taps or clicks the Save Data button on the navigation toolbar. The user can click on the Total Value button to compute the total value of the Art Prize collection. It will allow the user to compute the total retail price of all art records within the database.