Design Simple Access Database - Repost - open to bidding
Rp100000-300000 IDR
Cancelled
Posted about 9 years ago
Rp100000-300000 IDR
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.
I have bachelor and master degrees in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administration and maintenance with Linux/Unix and Windows Networking.
Hello,. I can help you on that requirements. PM me,. Feel free to check my profile and portfolio. My skills guarantee you the result according to your specification or details. Looking forward for this project. Thank you
HI.I AM AN EXPERIENCED DATABASE DEVELOPER USING BOTH SQL SERVER AND ACCESS.
IN ADDITION I FULLY UNDERSTAND ERD CONCEPTS AND DRAWING OF ERD ,GIVE USER A GOOD UNDERSTANDING F DATABASE.
DATABASE DESIGN TAKE SKILL TO IMPLEMENT ENTITY ENTEGRITY,NORMALISATION,REFERENTIAL ENTEGRITY ETC.
I CAN GREATLY ASSIST IN THIS REGARD.
Final year computer science student at University of Warwick. Experienced with databases. (70% + marks in second year intro to database). Currently studying advanced databases as one of my modules (Exam in May). I am doing this at very low cost to build up my reputation as a freelancer.