A database is used to store information for a certain purpose. When you are deciding on the type of data base and the requirements of the database you need to take into account many factors. Ease of use, you do not want a database to be so cluttered that the users the database wastes lots of time search for information or entering information. The database should be streamlined so that user can open the database do what they need to do and move on. Also, what needs to be taken into account is future expansion of the database. You do not want to create a database that is structured in such a way that expansion would not be possible or take way to much to reconfigure, thus costing lots of time and money.
The Database that best fits an Art Museum that needs to track the artwork, artists, and locations where the art is displayed or stored within the museum; is MS access.” Microsoft Access, is a database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft Office suite of applications, included in the Professional and higher editions or sold separately. On May 12 2010, the current version of Microsoft Access 2010 was released by Microsoft in Office 2010; Microsoft Office Access 2007 was the prior version.” In other word MS access in my opinion is the best to be used as a DMBS for this art museum.
The database needs to keep track of artwork, artists, and locations where the art is displayed or stored within the museum. Since this museum has out grown it current DBMS then the data currently stored will need to transfer into a new created in MS access.
Many problems will develop during creation of the database and the transfer of information to MS access. It being an Art Museum with hundreds of works done dozen of artists; keep track of the location of every painting is going to be a huge task. As painting could...