The Database Systems and Design

Running heading: DATABASE SYSTEMS AND DESIGN
Database Systems and Design
Name of the Student
Name of the University
Author’s note:

DATABASE SYSTEMS AND DESIGN1
Table of Contents
Task 1: Scenario..............................................................................................................................2
Task 2: Conceptual ER Diagram:....................................................................................................3
Task 3: Logical ER Diagram...........................................................................................................5
Task 4: Create Table........................................................................................................................6
Task 5: Create Index........................................................................................................................7
Task 6: Populate Date......................................................................................................................8
Task 7: Queries................................................................................................................................9
Bibliography:.................................................................................................................................11

DATABASE SYSTEMS AND DESIGN2
Task 1: Scenario
National Gallery of Victoria is an art gallery at Victoria wants to implement a database
management system into its premise. This system will replace its current system. Current system
does not store the details of the artist and customer who take participation in exhibitions. This is
creating issues for the organization. The organization wants the database to store details of
customer, artist, exhibition, customer visiting exhibitions and art objects.

DATABASE SYSTEMS AND DESIGN3
Task 2: Conceptual ER Diagram:
Figure 1: Conceptual Database Model
(Source: Created by Author)