A database defines a structure for storing information and it collects information that is organized in such a way that a computer program can quickly select desired pieces of data. A database can also be thought of as an electronic filing system. Data and information are extracted from a database by creating a query and then submitting it to the query database management system (DBMS) and it is posed in a language that only the DBMS can understand.
PROBLEMS AND CONSTRAINTS:
The museum’s current system is efficient but there seems to be some problems with the rights and privileges to the current users. For example, all users currently have the rights to input registration dates for certain events. The current system in not tracking the dates therefor there is no log of how many people are attending or the dates that they are supposed to attend. There seems to be lost inventory because the inventory does not match the reports that are generated. Some other problems that may exist is if artwork is removed and it is not enter into the database location it will not be updated. The reports also take too long to generate and scan the inventory. This requires the help of a user who has better access to the system rights. The administrator will have the rights to go in, access information and change and fix issues that occur. The basic employees will have limited rights to access certain information such as certain artist and artwork in the museum as well as dates that the artist will be in the museum. There is also a need for an explicit backup and recovery implementation. The administrator also needs to track openings for new artwork in the museum.
The administrative support can use the systems database along with other authorized personal as long as he or she has a username and a password to access it. The system is password protected and is a secure system. Security is a plus when using a database...