PROJECT OF SAMPLE: THE ARTGALLERY Purpose of the sample project
The sample project sections included for many of the chapters of this book are intended to provide models for applying the concepts covered in the chapters. The project is a continuous example illustrating a practical application of database design and implementation techniques. This website contains several student projects. Students must choose at least one of the projects and work on their development as they progress through the book. The project shows how each step can be performed. The student should read the sample and apply the steps to the chosen project. • Basic operations
When an artist wants to sell works, contact the gallery. Alan Hughes, the owner, visits the artist's studio and selects works to be sold through the gallery. If the artist is well known in the gallery, this visit can be eliminated, and works can be accepted automatically. An artist can present one or several pieces for sale at a time. The artist, working with Alan, identifies a price that asks for each job. The sales staff tries to sell the job at that price, or as close to that price as possible. Customers can negotiate with sellers, so that the actual sales price may be lower than the requested price. If it is below the requested price, the final sale price must be approved by the artist. The commission charged by the gallery is 10% of the sale price. The gallery divides the commission with the seller who makes the sale. Any seller can sell any work in the gallery. However, customers work with a single vendor when they purchase each part, so that the commission seller portion for a single part goes to only one vendor.
The gallery promotes the works by holding exhibitions with several pieces. Presentations are advertised in newspapers and other media, and potential clients are sent personal invitations. A demonstration is actually a reception that offers an opportunity for the public to see the pieces and meet the artist or artists whose works appear. A "one-man show" features works by a single artist, while a thematic show features works by multiple artists focusing on a single theme, such as "Mediterranean Seascapes". The works of art that have been presented at an exhibition remain on display until they are sold or returned to the artists. A piece can be purchased at the show or at any time thereafter. Occasionally, a work from the gallery before the show can be purchased and included in the exhibition, marked "Sold", to offer the public a better view of the artist's work. Not all works are promoted through projections. Some are shown simply in the gallery. If a work has been in the gallery for six months without being sold, Alan contacts the artist and returns the work, unless both agree to continue showing the work for an additional period of time.
At present, all data relating to artists, unsold works, shows, sales and customers are stored in printed files. A description card is composed for each job currently on display, and is placed on the wall or floor stand next to the piece. A copy of the card is also placed in a file. The card contains the name of the artist, title of the work, year created, type, medium, style, size and sale price. Each work is an original piece, unique, produced by a single artist. No two artists have the same name. The title of the work must be unique to the artist, but may not be entirely exclusive to the gallery. For example, many artists may have works like "Composition number 5", but no artist has two works with that title. No prints or reproductions are sold in the gallery. An artist can produce several works in the same year. The type refers to the type of work, which can be painting, sculpture, collage, etc. The medium refers to the materials used in the work, such as oil, watercolor, acrylic, marble, mixed, etc. A piece that uses more than one medium is classified as mixed. Style means the style of the work, which can be contemporary, impressionistic, folk, etc. Size is expressed in units appropriate for the job; For example, for a painting, the size would be the number of inches wide and tall, while a sculpture would have three dimensions.
When a purchase is made, a receipt is made for the buyer, a payment check and a heel are made for the artist, the commission is allocated between the gallery and the seller, and all paper files are individually updated.
This Page May Contain What is online artgallery projects on asp net free download And Latest Information/News About online artgallery projects on asp net free download,If Not ...Use Search to get more info about online artgallery projects on asp net free download Or Ask Here