Database Environment Paper Essay Essay Example

Database Environment Paper Essay Essay In the concern universe. the usage of many different types of databases is non merely platitude. but an indispensable portion of twenty-four hours to twenty-four hours operations. A database is a structured aggregation of information that is stored on a computing machine or waiter that allows the informations to be rapidly accessed. analyzed. and allows the ability for questions to be run. The usage of a database allows concerns to greatly increase efficiency accessing informations and truth keeping informations. The Sacramento Capital Art Museum is presently in demand of a database to accurately track the graphics. the name of the creative person. and each piece of graphicss location. Before traveling any farther. it is of import to analyse the type of environment that you are working with. Database Environment A database environment describes all of the hardware. package. informations. processs. and forces that you are working with. It straight relates to a undertakings range and b oundaries ( portion of the DBLC ) . as the boundaries are contained within the environment. Sacramento Capital Art Museum is a comparatively new museum that was established in 2012 by a group of devouring art aggregators populating in the capital metropolis. We will write a custom essay sample on Database Environment Paper Essay specifically for you for only $16.38 $13.9/page Order now We will write a custom essay sample on Database Environment Paper Essay specifically for you FOR ONLY $16.38 $13.9/page Hire Writer We will write a custom essay sample on Database Environment Paper Essay specifically for you FOR ONLY $16.38 $13.9/page Hire Writer As a consequence of this. there is non any type of established database presently running inside of SCAM. While Excel databases have been used by employees on and off. there is nil that is for good kept on a public thrust. The demand to track all the graphics throughout the museum is a direct consequence of a piece of valuable art that was misplaced. Presently. the museum has 20 employees. each with their ain work Personal computer. There is a little waiter that is kept in house that shops the company’s information and is accessible by all work PC’s via a alone user login. The company is unfastened to utilizing any type of DBMS that will suit Database Environment Paper 3 their demands. I have chosen Microsoft Access as the DBMS for SCAM. Microsoft Access is a â€Å"tool for assemblage and understanding all of your information†¦and supplying a convenient manner to come in. navigate. and describe your informations. † ( Microsoft SQL and Access. 2014 ) We will be utilizing a relational database for this undertaking. A relational database was developed in 1970 by an IBM research worker named E. F. Codd. ( What are relationship databases. 2001 ) With a relational database. information is stored in unvarying. Alternatively of one long. level line of information. information is stored in tabular arraies. This allows informations to be represented in columns and rows. This type of representation of informations allows for speedy comparings. kind information by entity or property. They are referred to as relational databases because of the ability to utilize the relationship of other similar informations to increase the velocity and overall versatility of the database. Because of the type of informations used for this database. a relational type would do the most sense. This DBMS will besides let for easy database care. SCAM presently wants all employees to be able to entree the database. while merely leting 10 of the 20 employee’s entree to modify the database. Access will be given via alone personal logins and all entree to the database will be monitored and logged in an effort to discourage larceny. Properties and Entities An entity is a individual. topographic point. or thing. or construct about which informations can be collected. ( Attributes. n. d. ) An property describes the facts. inside informations. or features of an entity. For this undertaking. the entities we are utilizing are the single pieces of graphics. the name of the creative person. and the location of the graphics. The properties that we are utilizing are the type of art. the beginning of the creative person. whether it is stored or on show within the museum. Using a information modeling attack. such as the entity relationship theoretical account ( ER ) that was created by Peter Pin-Shan Chen. allows for the proper conceptual procedure to be laid out prior to the existent building of the database. Database Environment Paper 4 Essentially. it is a database design of how everything will be mapped out. During this procedure. you want to guarantee that all the entities and attributes you wish to stand for are logically and briefly laid out. Once the database is mapped out. building of the database can get down. In the terminal. the database will be able to give the employees of the Sacramento Capital Art Museum immediate entree to the location of every piece of art in the museums detention. The employees will be able to run questions to happen out particulars about the art. For illustration. if they wanted to make an exhibit on Chinese art. they could run a question to happen all the art that originated from China within their aggregation. Database Environment Paper 5 Mentions â€Å"Microsoft SQL and Access† ( 2014 ) Retrieved from: hypertext transfer protocol: //www. computerhouse. com/microsoft- sql-and-access/ â€Å"What are relational databases? † ( 2001 ) Retrieved from: hypertext transfer protocol: //computer. howstuffworks. com/question599. htm â€Å"Attributes† ( n. d. ) Retrieved from: hypertext transfer protocol: //www. teach- ict. com/as_a2_ict_new/ocr/AS_G061/315_database_concepts/attributes_entities/miniweb/pg3. ht