Database Environment Paper Essay

subsequently 45 minutes of passporting through the cummers museum and realizing that Jacksonville is home to four pretty museums. These museums volition not only captivate you but also secern you a story in history. By understanding this I walk through the commer museum in amazement but being from a IT oscilloscope my mind soon begin to wonder how do they keep wipe altogether of these beautiful works of guile. I mean theres things that have to be taken into consideration. In example who is the artist, the placement where the art is march, thunder mug it be or is it on loan, the year the artist created the art. after(prenominal) remembering ab proscribed this for a few minutes a database popped in to my mind. A database management system asshole easily do each(prenominal) of these things and more. A museum cornerstone choose a variety of databases to complete this childbed but just for explanation purposes were going to use Microsoft admittance to back up us under stand how a database can complete the assign of tracking the artwork and giving us an accurate account and location. every last(predicate)ows keep in mind while we are innovationing and building the database three words real, conceptual, and representations if we keep these three keywords at the header of our design we will design a us satisfactory and efficient database. patently put the design of a database is to define the structure of data that can be queried and give out meaningful information to the end-user. And will design database also allows for easy maintenance and upkeep.With over 5000 works of arts in the cummers museum theres a lot of data that has to be tape into access on the front and ongoing in order for the museum to be able to used the software. But in order to do this we must first understand how the data or where the data is entered in Microsoft access. selective information is stored in what is called a remands, each table consists of data about a sp ecific subject in example painters piss, date art was created, location ,Address, zip code,city. By putting data in a table that is specific it allows for changing of data in specific table and it will automatically populating throughout the whole database. This also allows for different types of queriers making the database efficient. permit also look at what is a query. A query is a search by the end users which displays usable information. A query can sometimes and most time often will also display subsets of data as well. The subsets of the table is referred to as A field or as an attribute.To understand this a little better you can think about the squares in Microsoft excel those squares are fields and/or attributes is a place with database tables used to store one piece of given data. When go in data into a table or A field is called an accounting entry. An entry is data that needs to be tracked. Now the question how can all of this information help the museum track there artwork. When billing the initial database you can one can use the artwork name as the take in the fields or attributes can be the artist name the date the artist created the piece of artwork artwork that exactly where the artwork is located inside the singing is the artwork being load out or is it all from another museum what does the museum that peace of artwork. After entering all of the fields and tables we can then run a ERD report to help us see how the database is coming along by doing so were able to see from it overview what tables relate to what and in sure that all of the tables that need to chew up to each other are doing so. It is easy to see if you museum created a database as explained above that you can effortlessly track each keys of work.ReferencesWhat is a Database. (2011). Retrieved from http//databases.about.com/od/specificproducts/a/whatisadatabase.htmWhat Is Database Architecture. (2003-2014). Retrieved from http//degreedirectory.org/articles/What_is_Databas e_Architecture.htmlCoronel, C., Morris, S., & Rob, P. (2013 ). Database Systems (10th ed.). Cengage Learning