Database Enviroment Essay

THE DATABASE purlieuA selective disciplinebase defines a structure for storing info and it collects study that is organized in such a way that a computer program back end quickly select desired pieces of data. A database can in any case be thought of as an electronic filing administration. Data and information atomic number 18 extracted from a database by creating a query and then submitting it to the query database perplexity system (database management system) and it is posed in a language that only the DBMS can understand.PROBLEMS AND CONSTRAINTSThe museums circulating(prenominal) system is efficient but thither seems to be some problems with the rights and privileges to the current drug users. For example, all users currently give way the rights to input signal registration dates for trus 2rthy events. The current system in not trailing the dates therefor there is no log of how galore(postnominal) people are attending or the dates that they are supposed to attend. There seems to be wooly inventory because the inventory does not match the reports that are generated. Some former(a) problems that may exist is if nontextual matter is removed and it is not enter into the database positioning it leave al unmatchable not be updated. The reports also take too great to generate and scan the inventory.This requires the help of a user who has better get at to the system rights. The administrator testament have the rights to go in, entre information and change and fix issues that occur. The basic employees allow for have limited rights to access certain information such as certain finesseist and artistic creation in the museum as substantially as dates that the artist will be in the museum. There is also a need for an explicit attendant and recovery implementation. The administrator also involve to track openings for rude(a) artwork in the museum.SecurityThe administrative support can use the systems database on with other perishd perso nal as long as he or she has a username and a battle cry to access it. The system is password protected and is a secure system. Security is a plus when employ a database where many users will be accessing the system. There will be a set exemplification to what a user can and cannot do based on what their position is on the databases.OBJECTIVESThe Museum of Fine Arts need to install an updated database to track the new and animated art work on with the location of the art and artist as salutary as new artist. It needs to store all of the artists information as far as phone numbers, how many pieces of art they have in the museum, as well as clients that have purchased artwork or that is interested in certain pieces of art. The database also needs to store the quantity of art pieces sold and its current inventory at the museum along with the prices. They also need to log the attendance of the people that come to the museum. This system is maintained so that personnel have the ab ility to check the artist details, updated artwork as well as the entire museum notices, if any should be in the database.SCOPE AND BOUNDARIESThe scope is to jut out a database that holds the museums information in a secure environment. The database design will encompass one or more functions in a atomic number 53 environment or department. One of the boundaries is working with the existing hardware. Since the new database system will use standard reusable components, such as standard date routines or file access routines that will be modified. We will improve service by providing an information system to respond to guest inquiries which is all screen based. Cost of implementing the database, training and training materials for the employees might be another boundary. We will also, be implementing a disaster recovery cast for the system.Data Specifications List-Purpose- The purpose is to store information about the artists as well as current and new artwork in the museum. The da tabase will also store information about the entire inventory that is currently in the museum along with the sale prices.A list of the major entities and the attributes about which information will be captured.Entities Attributes1. ArtworkYear and Date Made, size, name2. ArtistName, Artist ID number, Phone number,3. PriceHow many SaleDate of purchase, Item Purchases, Cost of ItemFunctionality- The data will be apply to generate reports and track the inventory that is in the museum as well as facilitate searching and matching of the artist and artwork. Data Quality- The art museums theater director and assistant manager will work to keep the data up to date. The data quality of the art museum is very important to the operation of the business. Without data quality for the museum it could lead to the loss of cliental, artist, revenue and potential closing of the art museum.Business Rules- There is many business rules that apply to the database. To determine whether a client is consi dered active or inactive they should have some flake of communication and or contribute artwork to the museum every six months. original clients information is mandatory such as talk but we need to have at least their name and two contact numbers. The art museums manager is the only one who has the authority to authorize particular transactions. Classifications The classification schemes that might be used by the database is alphabetic order or last names first. Data, which is categorized in a meaningful way, is much easier to search, sort and report on.User Interface-The user porthole should look and behave in a simple manor for the user to navigate between different parts of the database. Specific functionality should be use and easy to use for such things as searching, adding new records and updating existing records. Reports- There are many reports that are required. There needs to be an inventory report done weakly to track the inventory. There needs to be an expense repor t generated as well as a loss and gain report.Security- The access to certain data needs to be restricted by user name and password because some information in the database contains sensitive information. The manager will be the only one that can add, edit or delete information. The types of art, prices and the artist information will be accessible to people outside of the museum via the internet. Scale- The museum needs a thumping database considering the amount of work it is required to do for example, the records the database will contain and the fact that it is available 24 hours a day. Operating Environment- The museum will need a system that can be added to in the future.ReferencesManagement-Hub.Com. (2013). Understanding the Objectives of Database Management in an Organization. Retrieved February 2, 2013, from URL http//www.management-hub.com/database-management-objectives.htmlBenda, S. (2011).Constraints and the Test-Driven Database Retrieved January 30, 2013, from URL htt p//www.simple-talk.comPeter, R. and Coronel, C. (2009). Database Systems Design, Implementation, and Management Computers, Scope and Boundaries. Retrieved February 1, 2013 from URL http//books.google.comUniversity of Phoenix. (2004).hebdomad Two overview. Retrieved February 1, 2013, from University of Phoenix, Week Two, Resource. DBM/380-Database Designs Web site www.ecampus.phoenix.edu