Database Environment Paper Essay

In the production nisus world, the use of m each different attributes of databases is not only(prenominal) commonplace, but an essential part of sidereal day to day operations. A database is a structured collection of training that is stored on a computer or master of ceremonies that onlyows the data to be industriously penetrationed, analyzed, and wholeows the ability for queries to be run. The use of a database allows businesses to greatly increase force regaining data and accuracy maintaining data. The Sacramento chapiter art Museum is currently in need of a database to accurately track the artwork, the take a leak of the artist, and for each one piece of artworks location. sooner moving any further, it is important to analyze the caseful of environment that you be functional with. Database milieu A database environment describes all of the hardw atomic number 18, software, data, procedures, and personnel that you are working with. It directly relates to a p rojects scope and boundaries (part of the DBLC), as the boundaries are contained in spite of appearance the environment. Sacramento Capital Art Museum is a relatively new museum that was complete in 2012 by a group of avid art collectors reinforcement in the capital city.As a give of this, in that respect is not any type of established database currently running inside of diddle. While travel by databases have been used by employees on and off, there is nothing that is permanently kept on a public drive. The need to track all the artwork throughout the museum is a direct result of a piece of valuable art that was misplaced. Currently, the museum has 20 employees, each with their own work PC. There is a bittie server that is kept in house that stores the play alongs schooling and is accessible by all work PCs via a erratic user login. The company is open to using any type of database management system that leave behind fit Database surround authorship 3 their needs. I ha ve elect Microsoft Access as the DBMS for SCAM. Microsoft Access is a tool for gathering and understanding all of your dataand providing a convenient way to enter, navigate, and report your data. (Microsoft SQL and Access, 2014) We depart be using a relational database for this project. A relational database was developed in 1970 by an IBM detective named E.F. Codd. (What are relationship databases, 2001) With a relational database, information is stored in uniform. Instead of one long, flat line of information, data is stored in tables.This allows data to be stand for in columns and rows. This type of representation of data allows for quick comparisons, sort information by entity or attribute. They are referred to as relational databases because of the ability to use the relationship of other similar data to increase the urge on and overall versatility of the database. Because of the type of data used for this database, a relational type would make the most sense. This DBMS v olition also allow for easy database maintenance. SCAM currently wants all employees to be able to access the database, while only allowing 10 of the 20 employees access to modify the database. Access will be given via unique personal logins and all access to the database will be monitored and logged in an attempt to dissuade theft. Attributes and Entities An entity is a person, place, or thing, or concept to the highest degree which data can be collected. (Attributes, n.d.) An attribute describes the facts, details, or characteristics of an entity. For this project, the entities we are using are the individual pieces of artwork, the name of the artist, and the location of the artwork.The attributes that we are using are the type of art, the origin of the artist, whether it is stored or on display within the museum. Using a data modelling approach, such(prenominal) as the entity relationship model (ER) that was created by dick Pin-Shan Chen, allows for the proper conceptual proce ss to be displace out prior to the actual construction of the database. Database Environment Paper 4 Essentially, it is a database blueprint of how allthing will be mapped out. During this process, you want to ensure that all the entities and attributes you care to represent are logically and concisely lay out. Once the database is mapped out, construction of the database can begin.In the end, the database will be able to give the employees of the Sacramento Capital Art Museum immediate access to the location of every piece of art in the museums custody. The employees will be able to run queries to find out specifics or so the art. For example, if they wanted to do an exhibit on Chinese art, they could run a query to find all the art that originated from China within their collection. Database Environment Paper 5ReferencesMicrosoft SQL and Access (2014) Retrieved from http//www.computerhouse.com/microsoft- sql-and-access/ What are relational databases? (2001) Retrieved from htt p//computer.howstuffworks.com/question599.htm Attributes (n.d.) Retrieved from http//www.teach- ict.com/as_a2_ict_new/ocr/AS_G061/315_database_concepts/attributes_entities/miniweb/pg3.ht