Individual: Database Design and ERD Creation
MEMORANDUM
To: from:
Date:
Subject: Art Museum Database
An appropriate database system:
The memo is in regard to an art museum that needs to track the artwork, artist and locations where the arts is displayed and stored within the museum. There are a lot of art pieces in the art museum that a human mind cannot remember all at once. An arts museum needs to develop a system where they can easily find updated information and maintain the art pieces in museum easily. It has always been a hectic job to gather information on the spread sheets about the complete data of museum. An appropriate database system is required for this. A type of digital data base will better help. SQL is used for this purpose. It is used to update and retrieve data from the data base.
A similar environment that you have has some experience with in the past
Libraries, laboratories and universities have been using the SQL data management system in the past. The storage system helps to store data in shape of table, charts, diagram, mapping about the name, address, telephones number, location and client information relevant to be kept in data about the character.
Analyze the database environment:
Data analysis is used to have the identification of the data in an organization through placing logical groups. System analyst usually required to make flow charts through a conceptual framework. The development of the techniques and methods for the data analysis the organizations are using conventional methods to avoid complexities of data.
Describe problems and constraints:
Designer have formal and informal information access
No perfect problem solution
Time, budget and personnel constraints
Describe objectives of the data base environment
The objectives of a database management system are as:
Provide perfect solution to the user requirement
Support data communication
Provide a user accessible catalog
Provide data base design and logical, conceptual and physical framework
Security is provided through access restriction policy, account control to finds information regarding the piece of study
Provide ease to the management for handling and maintain huge set of data
Provide cost effective solution
Describe scope and boundaries
For the purpose of the database management system design meets the exponential requirements like hardware and software requirements for the database management system
Provide solution to the current requirements of the organization related to memory issues
Provide system design, design modifications and standard format
Provide solution to large analysis system
Define design according to the requirements of the organization
Summary: the database management system is requires to keep the large set of information about the museum such as its employees, client information, the art pieces kept, complete information regarding each piece of art. It is helpful in easy access of the information. It saves time and budget through providing easy access to the information. The data base management system is helpful to avoid a sprees sheet data where it is hard to access information. It helps through providing a structural framework.
Future issues: operational maintenance of the data base
References
Access. 2012. Retrieved frfom http://office. Cicrsot.com/en-us/access/what is Microsoft access database software and application-FX102473444.aspx.
Raggett., D. 1997. HTML 3.2 reference specification. REC-html. W3C.
Robbins., R. J. 1995. Database fundamentals.
