DATABASE DESIGN FOR ART GALLERY MANAGEMENT

Running head: DATABASE DESIGN FOR ART GALLERY MANAGEMENT
DATABASE DESIGN FOR ART GALLERY MANAGEMENT
Name of the Student
Name of the University
Author Note

DATABASE DESIGN FOR ART GALLERY MANAGEMENT1
Table of Contents
Task 1.1 2
Task 1.2 Conceptual Database Design 4
EER Diagram 4
Task 2.1 Logical Database Design 6
Task 2.2 Table Creation using Oracle DBMS 6
Task 2.3 Index Creation 8
Task 2.4 Data Population 10
Task 2.5 SQL Query 13
Bibliography 16

DATABASE DESIGN FOR ART GALLERY MANAGEMENT2
Task 1.1
Art Gallery Management: Art Gallery is a place where different types of painting,
photography and visual arts exhibition. Different types of art are buys and sell here. The
owner of the art gallery wanted to develop a digital system for managing all the functionality
of the art gallery where customer can view, buy and sells there arts without going to the art
gallery they can view and buy from their home. The art gallery management has three
different users, and they are Admin, Artist and Customer.
Admin can handle all the details of the customer and artist of the art gallery, and
admin can also change and modify the details of the users. The art gallery charge price for the
arts based on different parameter and type of the arts.
Artist is very important for the Art Gallery because the artist is one who sells art to
the customer through the Art Gallery and art gallery pay for that. The artist sets the price of
the painting and photographs, but sometimes the art gallery sets the final gross price of visual
arts depends on the quality and presence of the art. The Art gallery maintains relevant
information about the artists with their product details.
Customers of the art gallery can buy different types of product from the art gallery.
The art gallery maintains all the necessary details of the customer for future references like
name, address, and contact details along with the product details. The system performs the
following functionality:
 Admin can add, remove and modify any details of the customer and artist of the art
gallery. Admin of the art gallery can also add and remove the painting and other
visual arts details from the system.
 Only the Admin of the art gallery is responsible for managing all the necessary details
of the system.

DATABASE DESIGN FOR ART GALLERY MANAGEMENT3
 Artist can only sell their paintings, and other visual arts for the exhibition and art
gallery pay the respective amount to the artists.
 Customer can buy and sell their visual arts from the art gallery. Customer can also
modify their details.
 All the details of visual arts are maintained separately by the Art Gallery, and the
Administrator of the Art Gallery maintains this detail.
 Every user has to login first to perform the above task. Only the Admin can create a
new user account with appropriate details.
 Every user of the system can view the details of the arts, but only the administrator
can modify and remove the details of the product.
 Artists can sell their visual arts directly to the art gallery without searching for the
customer.
 The admin of the system maintains all the orders details with a unique id to track
every single order details whenever required.