Design Simple Access Database

Cancelled Posted Mar 2, 2015 Paid on delivery
Cancelled Paid on delivery

Design the database and draw an ER diagram.

An art museum owns a large volume of work of art. Each work of art is described by an item code (identifier), title, type, and size; size is further composed of height, width, and weight. A work of art is developed by an artist, but each artist may have many works. An artist is described by an [Artist_ID] (identifier), name, date of birth, and date of death (which is null for still living artists).

At any point in time, a work of art is either on display at the museum, away from the museum as part of a traveling show, or on loan to another gallery. If on display at the museum, a work of art is also described by its location ([Location_ID]) within the museum. Each work of art is associated with one fixed location.

A traveling show is described by a [Show_ID] (identifier), the city in which the show is currently appearing, and the start and end dates of the show. Many of the museum works may be part of a given show. On the other hand, each work of art may be in different show at different periods. The database should store historic data about which item was in which show.

Finally, a gallery is described by a [gallery_ID] (identifier), name, and city. Each work could be loaned to different galleries at different periods. Each gallery may also request many different works. The museum wants to retain a complete history of loaning a work of art to other galleries, and each time a work is loaned the museum wants to know the date the work is loaned and the date it was returned.

This is a quick and easy project.

Database Administration Microsoft Microsoft Access SQL

Project ID: #7234942

About the project

9 proposals Remote project Active Mar 2, 2015

9 freelancers are bidding on average $74 for this job

it2051229

Hi, I am placing my bid on your project because I have read the requirements and I am confident enough with my Database design skills. I am focused mostly on doing computer science work here in freelancer.com and I wou More

$30 USD in 1 day
(83 Reviews)
5.4
pivn

let expert do this...................................................................................

$55 USD in 1 day
(21 Reviews)
5.4
mikeblane

Warm Regards, I am pleased to inform you that your PR matches our expertise who own all the right credentials to execute this job in a very proficient way with a proven track record which shows our dedication towards s More

$157 USD in 3 days
(4 Reviews)
4.8
abagunjal

I am experienced database designer and programmer. I will deliver the best.

$111 USD in 5 days
(1 Review)
3.0
pegasus9529

I am very good in Microsoft Access, you can see in my portofolio. Let's discuss and let me do this project for you.

$55 USD in 3 days
(1 Review)
3.2
mlawre10

A proposal has not yet been provided

$111 USD in 1 day
(0 Reviews)
0.0
gideonlal

I'm a certified Microsoft Office Specialist meaning that i know how to work Microsoft Office Access inside and out. I know how to create a good efficient database.

$30 USD in 1 day
(0 Reviews)
0.0
anmarasa

Hello, I would like to be considered for your project. I am an IT Sr. Consultant with a strong background with the technologies you describe. Looking forward to hearing from you. - Mauricio

$35 USD in 1 day
(0 Reviews)
0.0