Database Enviroment
Database EnvironmentDavid BrankerDBM 380April 4, 2016Craig RoseDatabase EnvironmentIntroduction A database is a computer structure that classifies a collection of data that can be retrieved, updated and edited as quickly and efficiently as possible. There are many classifications of databases. For instance they can be classified by the amount of users, location of the data, the type off data, the intended use of said data and the level to which the data are structured. When only one user is supported at a time it is known as a single-user database. This type of database is most common on a desktop computer and is known as a desktop database. Multiuser databases is the other type of database. When it supports 50 or fewer users like in a specific department of a business it is refered to as a workgroup database. In contrast when 50 or more , usually in the hundreds, of users are supported, it is referred to as an enterprise database. (Cornel, Morris, & Rob, 2013, p. 9)Analyze Database The Nevada Museum of Art is a museum of ideas. While building upon their founding collections and values, they strive to offer meaningful art and cultural experiences, and foster new knowledge in the visual arts by encouraging interdisciplinary investigation. The Nevada Museum of Art serves as an educational resource for everyone. For that reason it is essential that they have a updated database that allows them to properly track artwork, artists and the location of art.Problems and Constraints
The current database that The Nevada Museum of Art is using has many limitations that hinder them from searching for specific information like showings and museum events. Another issue with the existing database is the inability to update the venues of artists and their artwork, meaning locally at museum or out at a venue. Finally there is a lack of ability to generate reports that accurately show what is available and what art is not, resulting in a loss of profits from potential customers.Objectives The new database will assists Nevada Museum of Art in keeping accurate records of all art that is in the museum as well as out at a venue. This newly designed database will also implement the artist’s information such as, address, phone number, art pieces included in collection, and any client information pertaining to sales or potential sales of artwork. Finally the amount of art pieces that are currently on hand, together with all art that was sold and its selling price will ensure the museum’s capabilities for precise and real- time reports being generated, leading to an increase in profits earned.