$3\mathrm{.}2$ The Database

A database system is required to store data on a chain of art galleries called The Tate.

Each gallery is identified by a unique three character code called gallery id$.$ The

name, location, city and postcode of a gallery may be stored in the database. The

database checks that no two galleries have the same name. Each gallery displays

many paintings. Not every painting is on display because some paintings are kept in

storage.

Obviously, at any moment in time, a painting cannot be on display at more than one

gallery. This database represents a snapshot in time and so does not record data on

loans of paintings from one gallery to another.

A gallery may hold one or more exhibitions. An exhibition is where some paintings

which fit into a theme are displayed next to each other in a particular gallery. A painting

cannot feature in more than one exhibition.

The Tate only has originals; it does not have any copies of paintings. Paintings have

a unique three character code called painting id$.$ Where they are known, data on

the title, height and width of paintings are stored. The medium on which the paint was

applied may also be stored. Each painting is painted by one artist.

Each artist is identified by a unique three character code called artist id and must

have a name. Other data on artists which may be stored in the database includes their

nationality, the year in which they were born and the year in which they died. Some

artists paint in one or more recognised styles. Each style has a one word description

and a detailed textual description. The design of the database assumes that every style

is followed by at least one artist in the database.

Dr C$.$H$.$Bryant, School of SEE, Salford, United Kingdom. Page $2$ Not to be reused without permission. c$$University of Salford $2024$

Database Systems CRN $32741,$UMC UMC G$40010045$ Assessment Information$/$Brief

$3\mathrm{.}3$ Sample of Data

Gallery Paintings on

Name Location City Postcode display

TateBritain Millbank London SW$1$P $4$RG P$01,$P$02,$P$09,$P$10$

TateModern Bankside London SE$19$TG P$06$

TateLiverpool Albert Dock Liverpool L$34$BB P$03,$P$07$

ID Title of Painting Media Height Width Artist

$($mm$)($mm$)$

P$01$ Opening of Waterloo Bridge Oil on canvas $13082180$ Constable

P$02$ Flatford Mill Oil on canvas $10161270$ Constable

P$03$ Autumnal Cannibalism Oil on canvas $651651$ Dali

P$04$ Girl in a Chemise Oil on canvas $727600$ Picasso

P$05$ The Three Dancers Oil on canvas $21531422$ Picasso

P$06$ Head of a Woman Oil on canvas $345265$ Picasso

P$07$ Weeping Woman Oil on canvas $608500$ Picasso

P$08$ Circus Artist and Child Ink,watercolour $168105$ Picasso

P$09$ Haymakers Oil on wood $8951353$ Stubbs

P$10$ The Bay of Baiae Oil on canvas $14542375$ Turner

Name of Artist Birth Death Nationality Styles

John Constable $17761837$ English Romanticism

Salvador Dali $19041989$ Spanish Cubism,Dada,Surrealism

Pablo Picasso $18811973$ Spanish Cubism

George Stubbs $17241806$ English

Joseph Turner $17751851$ English Romanticism

Style Description

Romanticism Romantic, as opposed to classical, art of the late $18$th and

early $19$th century.

Cubism Amalgamated viewpoints of natural forms into a multifaceted

surface of geometrical planes.

Dada Founded on principles of irrationality, incongruity and irrever$-$

ence.

Surrealism Juxtaposition of incongruous images including unconscious

and dream elements.

Dr C$.$H$.$Bryant, School of SEE, Salford, United Kingdom. Page $3$ Not to be reused without permission. c$$University of Salford $2024$

Database Systems CRN $32741,$UMC UMC G$40010045$ Assessment Information$/$Brief

Theme of Exhibition Host Gallery Paintings featured

English landscapes TateBritain P$01,$P$09$

Spanish abstraction TateLiverpool P$03,$P$07$

Water scenes TateBritain P$02,$P$10$

$1)$ A listing of your logical $($relational$)$ model.

$2)$ An explanation of why your logical model is in first, second and third normal form