Free Essay

Art Museum Database

In:

Submitted By nynevolt
Words 671
Pages 3
Art Museum Database
What is Needed and What Can Go Wrong

Craig Hill
University of Phoenix
Analysis-
A database needed to accomidate an art museum would be vary simple an very complicated at the same time. The database would need to have the names of the artists, name of the art and where it is located. Along with the entities stated above, there would also be the details that are unseen in the database. When the art was purchased or donated, the estimated value, the year it was painted, what kind of media was used, ect. In order to have a full database of information you would need the afformentioned data, and that is where you come into trouble and constraints.
Problems-
The amount of data that could be entered would be endless when it comes to art, so when the database is being created it needs to be taken into account that memory limits are in place. So choosing what query criteria should be used is vital. Obviously you want to be able to search for art by name, easy enough. What if someone at the museum wanted some deeper information such as what art is the oldest, what is the most expensive art and what art was done with a specific type of media. You would need to think critically so that these questions could actually be answered upon request.
There are plenty of problems that can stem from database creation. 1. “Poor design/planning 2. Ignoring normalization 3. Poor naming standards 4. Lack of documentation 5. One table to hold all domain values 6. Using identity/guid columns as your only key 7. Not using SQL facilities to protect data integrity 8. Not using stored procedures to access data 9. Trying to build generic objects 10. Lack of testing” (Davidson, 2007)
One notable issue you could run into is the naming standards. Everything shouldn’t start with the word art or even the letter A. Every name should represent each query appropriatly leaving the word art only in two names.
ArtTitle
Artist (You should only use the word artist so that you can avoid naming something such as ArtName which could misconstrue for the name of the Art instead of the artist) Objective- The goal of the databse is so that art information can be stored and retrieved. More specifically in this scenario, the database want to be able to call upon the name of an art, the artist who created it and where it can be located in the museum. Any of the extra information is there for asthectic and potential insurance purposes. Scope and Boundries- As stated above, the database in this situation is simble and complex at the same time. The complex part is the actual work that goes into it. The simple part however is what is coming our of it in the end. “The designer must recognize the existance of two sets of limits: scope and boundries. The systems scope defines the extent of the design according to the operational requirements.” And also consider, “Has any designer ever been told “We have all the time in the world or “Use an unlimited budget and use as many people needed to make the design come together”? Boundaries are also imposed by existing hardware and software.” (Rob/Coronel) The databse isn’t for some fortune 500 company, so it needs to be kept in mind that it does not nee a ton of money and resources thrown at it just a few workers and a well though out plan. A visual aid of what the design would take them miles in the creation process.

References- Rob, Peter/ Coronel, Carlos (2009) Define Scope and Boundraies
Database Systems: Design, Implementation, and Management
Retrieved from http://books.google.com/books?id=gCzfjlWOVAAC&dq=scope+and+boundaries+database+design&source=gbs_navlinks_s

Davidson, Louis (Feburary 26, 2007) Ten Common Database Design Mistakes
Simple-Talk
Retrieved from http://www.simple-talk.com/sql/database-administration/ten-common-database-design-mistakes/

Similar Documents

Premium Essay

Art Museum Database

... Art Museum Database By: For the past couple of years, a local art Museum has been collecting different art pieces from various artists. The Museum then displays the art throughout different galleries across town. The collection has significantly grown and it is now complicated for the museum to keep track of the many different artist and their different art pieces and collections, as well as where the art is located, whether it is stored in different galleries or the Museum itself. It is important for the Museum to develop a database that can keep track of the different art pieces, the artists, the different locations the pieces can be located and a total amount of pieces collected since it continues to grow at a very fast rate. The database will help the Museum substantially as well as the artists who create many various art pieces. Problems and Constraints The Museum continues to grow and it has become difficult for the manager and staff to keep track of the art collection. Not having a database that can tie the artist with his art and the location of it has caused the Museum to lose some of the different art pieces which in return equal financial losses to the Museum. Another problem the Museum continues to have is keeping track of when and where the art is being displayed. Most of the art is displayed for a period of time throughout the different galleries then either stored back in the Museum or, returned to the artist. It is important that the Museum is well...

Words: 1015 - Pages: 5

Premium Essay

Database Paper

...Database Environment Paper This database environment paper contains info about a database environment for an art museum. The art museum will track artwork, artists and locations of where specific art pieces are held in the museum. An analysis of the environment will be covered, along with a description of the problems and constraints. A description of the objectives of the database environment along with the scope and boundaries are included as well. Lastly, a small list of data specifications is included. The arrangement of a collection of data is not a simple procedure. Normally, the intricacies of the data wants and the number of data methods make it difficult.  As a result, arranging a collection of data is best suited to practice the traditional plan of action of separate and overcome. As a result, it should break down the arrangement method in many levels, with every transitional development is acquired that works as a beginning mark for the following phase and the final phase produces the wanted effect. In doing so, this removes the want to answer every question at one time ("Stages of Database Design", n.d.). In the case of the Denver Art Museum, a database must be created that allows users to track all the artworks, the artists who created them, and places within the museum where these works of art displayed. With an assortment of more than seventy thousand pieces of art distributed among 9 long-lasting assortments that includes western American art, African...

Words: 965 - Pages: 4

Free Essay

Research Study to Apply Information Technology to Sri Lankan Museum System

...Rational A museum is an institution that cares for (conserves) a collection of artefacts and other objects of scientific, artistic, cultural, or historicalimportance and makes them available for public viewing through exhibits that may be permanent or temporary.Most large museums are located in major cities throughout the world and more local ones exist in smaller cities, towns and even the countryside. Museums have varying aims, ranging from serving researchers and specialists to serving the general public. Early museums began as the private collections of wealthy individuals, families or institutions of art and rare or curious natural objects and artefacts. The oldest public museums in the world opened in Rome during the Renaissance. However, many significant museums in the world were not founded until the 18th century and the Age of Enlightenment The Colombo Museum was established on January 1, 1877. The founder is Mr. William Henry Gregory, who was the British Governor of Sri Lanka at the time. JG Smither was the architect of the Public Works Department and was able to prepare the plans for the new structure based on Italianate architecture(Colombo National Museum). In 1876 Kandy Museum was established by Sri WicramaRajasinha and it was called “PalleVahala”.This is used as a place somewhere in the queen of king lived. Was used to deposit the types of historical value made by the art association established in 1832.this Kandy museum has more than 5,000 goals that represents...

Words: 3756 - Pages: 16

Premium Essay

Art101Rodriguez Assignment6.2

...Running Head: Historical Context of Images for your Virtual Art Gallery Tour Historical Context of Images for your Virtual Art Gallery Tour Louis Rodriguez Jones International University Historical Context of Images for your Virtual Art Gallery Tour [pic] Broken Glass By: Victor F. Gonzalez Dated: 7/27/2012 Artist Victor F. Gonzalez and I quote “Forget for a moment what country your from, what race, what color, and what religion, we are all reaching out, life, and love. The moments that we live! Mr. Gonzalez is an ex-brother in law from East Broadway, New York. From my knowledge he was raised most of his life in the projects of the lower Eastside, my reminder of that area is the Brooklyn Bridge that obviously crosses from lower Manhattan to Brooklyn. To this day I’ve had nothing but great admiration for his artistic paintings and point of view. I find Joey’s painting (It’s the name I always knew him by or called him, since he was a little child) somewhat Neo- Expressionist. Neo-Expressionism as we all know was practiced during the 1920s. According to Artstory.com a Mr. George Baselitz led a revival which dominated German Art in the 1970s. In Germany the return of expressionist art was part of a more general shift in society towards addressing the country’s modern history. Led by Mr. Baselitz revival in the 1980s this resurgence had become part of the...

Words: 1894 - Pages: 8

Free Essay

Journal of Popular Film and Television 30.1 (Spring 2002) 63-68

...American art museums faced another of their cyclical crises of relevance, causing them to reevaluate their role in American society. The dominant paradigm in most traditional art museums was the display of Great Works, aesthetic objects existing outside of time and space for the museumgoer's pure contemplation. Since such works were universal in their artistic appeal, they were expected to reach across barriers of time and space to speak to the patron's sensibilities. The insights of great individual artists enriched the consciousnesses of museumgoers who briefly shed their individual subjectivities to encounter the eternal verities of Beauty and Truth. Outside the walls of the art museum, these eternal verities were in much disarray. The feminist and civil rights movements began publicly questioning whose idea of beauty and whose concept of truth was being articulated. The relevance of historical tableaux and delicate still lifes created for wealthy patrons came into question in an era increasingly aware of social inequities and gender and racial politics. How could the museum maintain its position as the repository of classical Beauty while attracting a population which pondered if black were beautiful or if nudes were sexist? Some museums attracted audiences with the promise of the new. Museums such as the Museum of Modern Art offered new movements of new artists, marketing to a hip audience with a modern pop sensibility. Some began to question the nature of the museum itself...

Words: 4840 - Pages: 20

Premium Essay

Yeahet

...to, you will listen better. Task 1 Complete the table below using no more than 2 words or a number. Proposal | Main Body | Reference Section | An introduction with a 1. _____ statement, an outline of 3 paragraphs, and a justification | 3. _____ or four main sections advised. Headings are 4. _____. Pictures, charts and 5. _____ if necessary. | At least 7. _____ references. Sources must be in 8. _____. Use 9. _____ order Harvard referencing system | around 2. ______ | around 1200 words | separate 10. _____ | to take two weeks | to take 6. _____ | | Task 2 Questions 11 – 16 Complete the notes below. Write NO MORE THAN THREE WORDS AND/OR A NUMBER for each answer. THE NATIONAL ARTS CENTRE | Well known for | 11. _________ | Complex consists of | concert rooms theatres cinemas art galleries public library restaurants12. _________ | Historical background | 1940 – area destroyed by bombs 1960s – Centre was 13. _________In 14. _________ – opened to public | Managed by | 15. _________ | Open | 16. _________ days per year | Questions 17 – 20 Complete the table below. Write NO MORE THAN THREE WORDS AND/OR A NUMBER for each answer. Day | Time | Event | Venue | Ticket price | Monday and Tuesday | 7.30 p.m. | ‘The Magic Flute’ (opera by Mozart) |...

Words: 352 - Pages: 2

Free Essay

Art History

...If we take into account the ideological nature of Art, we would observe how images serve the interest of some and not all members of society. We would also discover that ideological art attempts to establish a link between art and political courses of action in order to secure complete domination. In John Bergers book, “Ways of Seeing”, he explains that his essential aim for putting together this manuscript was to start a process of questioning about how we look, interpret and judge images (Art). I believe his urge to initiate this process of questioning is because he wants people to being, “truly understanding art”, not based off of the interpretation of a select few but from their own personal prospective. In other words, Berger does not want us to be told what to see within a work of art, but he wants us to discover ourselves within that masterpiece. In a way, Berger gives us the definition of beauty in art. Not by standard definition but by exposing us to the fact that beauty is not defined by what we are told but it is defined by what we perceive. As Berger continued, I deduced that he believes, the ruling class deliberately exploits art as a repressive tactic and tool, in order to create a culture of isolation. He also introduces statistical data proving that many people identify museums with the church. So here we have a house of worship and a secular institution dedicated to art. A house of worship is a specifically designed edifice or consecrated space where groups...

Words: 871 - Pages: 4

Free Essay

Art 101

...Joy Chambers 01/14/13 Art 101 Week 9 Checkpoint Art is found in every community. Whether it is a billboard someone has painted to advertise a business, or a sculpture someone has sculpted. Art is what gives the community its personality. In order for the piece of art to stay where it is it has to be supported by the agency where it is located and also by the community in which it resides. Agencies where art is found as well as the general public provide the greatest support for art in the community. I live in southern Maryland which is about 30 minutes from Washington, DC. In my community there are a lot of art museums and sculptures in various parts of DC. The art ranges from African art all the way to different types of performance art. The art in my community is very well supported by the agencies and the general public. The agencies that own the art whether it is inside the building or outside, hire people to maintain the work. This includes keeping the sculptures clean and in good condition and also cleaning of the area around where the art is kept. Each agency does fundraisers and events to show off their art. The purpose of the fundraisers is to make sure the art is kept in good condition so they can keep it available for the public to enjoy. They also do events at the museums to bring more public attention to the art they have. The citizens support the art by going to the museum and paying the entrance fees. They also advertize to their friends and coworkers...

Words: 496 - Pages: 2

Premium Essay

Getty Museum Analysis

...Two weeks ago I had the opportunity to visit the Getty Center in Los Angeles for the first time. It was an incredible place and experience. The museum is isolated from the city, located at the very top of a mountain surrounded by breath taking panoramic views. The architecture of the Getty is very contemporary designed by Richard Meier. The interior and exterior of all the buildings are almost entirely built with white travertine, making it feel very bright and serene. All visitors must enter through the entrance hall building in order to access all the galleries, and that is where a tall, elegant sculpture immediately caught my eye. The title of the sculpture is Femme Debout I or Standing Woman I) by the artist Alberto Giacometti. Femme Debout I is located in the entrance hall where receptionists greet visitors. The figure stands tall and isolated on the right hand side of the hall. It stands in front of a large blank white wall making a strong presence in the space, and making it nearly impossible for anyone to miss. After I grabbed the museum’s site map, I walked up to it and began observing its beauty....

Words: 576 - Pages: 3

Free Essay

Ssssss

...Chen 1 Wenliang Chen (Mike) Professor O’Toole Capstone September 20, 2013 The Louvre, Winter Sunlight, Morning On Capstone class, I had a chance to go to the Museum of Fine Arts. “The MFA is one of the most comprehensive art museums in the world, the collection in the MFA encompasses nearly 450000 works of art.” (About the MFA) A lot of professional artworks in the museum brought a great visual feast to me, but the one that most attracted my attention is a painting, called "The Louvre, Winter Sunlight, Morning." (Pissarro) Pissarro “understand and appreciate the importance of expressing on canvas the beauties of nature without adulteration.”(John) After a year in Paris, “he therefore began to leave the city and paint scenes in the countryside to capture the daily reality of village life. He found the French countryside to be ‘picturesque’ and worthy of being painted. It was still mostly agricultural and sometimes called the ‘golden age’ of the peasantry.”(Art Gallery of New South Wales) Pissarro explained the technique of painting outdoors to his student: “Work at the same time upon sky, water, branches, ground, keeping everything going on and equal basis and unceasingly rework until you have got it. Paint generously and unhesitatingly, for it is best not to lose the first impression.”(John) Chen 2 The picture that I want to depict belongs to Pissarro’s early series, begun in 1901. In the foreground...

Words: 439 - Pages: 2

Free Essay

Papers

...assignments. U.S. Art Museums The Metropolitan Museum of Art: http://www.metmuseum.org/ The Museum of Modern Art: http://www.moma.org/ National Gallery of Art: http://www.nga.gov/ Museum of Fine Arts, Boston: http://www.mfa.org/ The Phillips Collection: http://www.phillipscollection.org/ The Art Institute of Chicago: http://www.artic.edu/aic/index.php Whitney Museum of American Art: http://www.whitney.org/ Guggenheim Museum New York: http://www.guggenheim.org/new_york_index.shtml Guggenheim Museum Bilbao: http://www.guggenheim-bilbao.es/ Smithsonian American Art Museum and the Renwick Gallery: http://americanart.si.edu/index3.cfm Hirshhorn Museum and Sculpture Garden: http://hirshhorn.si.edu/ Smithsonian Institution National Museum of African Art: http://www.nmafa.si.edu/voice.html Freer Gallery of Art and Arthur M. Sackler Gallery: http://www.asia.si.edu/ The National Portrait Gallery: http://www.npg.si.edu/ Cooper-Hewitt, National Design Museum: http://cooperhewitt.org/ National Museum of the American Indian: http://www.nmai.si.edu/ The Getty: http://www.getty.edu/ San Francisco Museum of Modern Art: http://www.sfmoma.org/ National Hispanic Cultural Center: http://www.nationalhispaniccenter.org/index.php American Visionary Art Museum: http://www.avam.org/ American Folk Art Museum: http://www.folkartmuseum.org/default.asp?id=886 National Museum of Mexican Art: http://www.nationalmuseumofmexicanart.org/ Global Museums The British Museum: http://www.thebritishmuseum...

Words: 511 - Pages: 3

Free Essay

Ed Pien

...Detail of "The Night Gathering" by Ed Pien Ed Pien has a permanent scar on the tip of his index finger. After discovering the traditional Chinese way of cutting paper several years go, he creates grand 3D realms and environments with an X-Acto knife. Welcome to Haven of Delight, Pien’s hauntingly beautiful exhibit on display at The Rooms Provincial Gallery. “I cut vertically,” says Pien. “Even though I have an image to work with while cutting, I am still doing a lot of improvisation in order to feel that there is a continued sense of exploration and negotiation with making the paper-cut.” Haven of Delight exhibit features an out of this world installation; it’s an all encompassing paper maze of celestial celebration. Haven of Delight is a universe in itself. Viewers are welcomed into the tranquility of the grand-scale sanctuary where imagination, myth and spirits come to life. Pien’s ethereal paper cut-outs begin as a photograph, images of trees and human figures. He combines the two digital photographs and manipulates it until the visual aligns with his mind’s eye. “I am interested in exploring realms where language is inadequate to explain away mysteries and wonders,” he says. On the night of Haven of Delight‘s opening Pien wandered around with a small keychain flashlight, asking patrons to hold it up at eyelevel. The small light showcased an entirely different interpretation, Haven of Delight became lucid, a dream within a dream. Pien is fascinated with the unconscious...

Words: 1968 - Pages: 8

Free Essay

Museum

...to say that, in the mind of the public, the MMA has no image. There is nothing about this [building] that says, “I’m a museum,” or “Come in.” There are a lot of people that are not interested in high culture and think this is a drive-in bank or an office building. Most art museums in America have a problem with image. One of the things that makes me mad is that people think there is something wrong with the museum. The MMA is one of the most public in the country, and more heavily dependent on the mem- bership contribution than any other [museum]. Like most, it is underendowed and underfunded from reliable public funds. In fact, the American Association of Museums reports that only about 60 percent of America’s 2000-plus art museums have enough income from their endowment to cover their operating costs. Nevertheless, this institu- tion has chosen to be public, with free access, and this is very noble. It is wonderful that the museum has decided not to belong to an agglomeration of very rich people. This museum has more character than it thinks it has. It has the best balanced collection between Western and non-Western art of any museum in the country. We have not chosen to sell or promote the unique aspects of this collection or the museum’s emphasis on historical context.What we have are the makings of an institu- tion that is very different from other museums, and we ought to be able to make that into an advantage rather than apologize for...

Words: 273 - Pages: 2

Free Essay

Art Museum

...Museum Extra Credit Art is the product or process of deliberately arranging symbolic elements in a way that influences and affects the senses, emotions, and/or intellect. Many types of art, even if from different eras, can be not only different but also very similar. By going to a museum and learning about all the different types of art, you realize how different pieces of art can have a lot in common. I decided to visit both the Getty Villa and the Getty center museums to learn more about the artwork that we learned about in class. I went to the Getty Villa to find my work of art during the Neolithic era and I went to the Getty Center to find art from the Roman Imperial era. Both museums were very interesting and it was hard for me to pick just one piece of artwork, one from both eras. I found the pottery and pots the most interesting so I decided to learn about the beautiful pots in more detail. They were so similar and different in so many ways. One vessel that I found to be very interesting is from the Heliolithic era and is titled “Flask Shaped as the Head of Bacchus”. It is a very beautiful vessel. The flask is made of glass and had a very detailed design on it. It had a crown of ivy leaves, which identifies the head of Bacchus. Bacchus is also referred to Dionysus, the god of wine and intoxication. The god and his followers were often depicted with ivy, alluding to the deity’s close association with wine and fertility. This flask was created by molten glass...

Words: 1021 - Pages: 5

Premium Essay

Ielts Writing

...Public museums and art galleries are not necessary because people can see the objects stored in those places on the Internet.To what extent do you agree or disagree? With the fast development of science and technology, an increasing number of people are likely to enjoy art stuffs by Internet for its convenience and speedy. In this case, some argued that public museums and art galleries should be abandoned. However, in my view, this argument is not convincing for the following reasons. The infornations online pictures carried are restricted on the perspective of quality and color. The pictures showed online may get revised or lightened, losing its original looking. Also, the computer screen just own two division, which cannot have a wholly perspective when they showed a valuable antique or art masterpiece online. Therefore, people, especially expert in this area, sometimes make a fault judgement because only a part can be seen by computer. In addition, the museums and galleries cannot disappear for they have their own advantage---fully artificial atmosphere. When someone walking in a museum, it is an absolutely different experience from sitting behind a small screen. Not only the items on display can be appreciated closely, but also the atmosphere one will enjoy in the museum. Take art gallery for an example, only when you walk in and stand afront of a painting, indulged in the atmosphere, can you understand what author want audience to see, to feel, and to experience...

Words: 341 - Pages: 2