Dbm 380 week 2 individual assignment database design paper

Dbm 380 week 2 individual assignment database design paper

Write a 350- to 700-word paper in which you do the following:
 
• Explain what database systems are and how they are used at your workplace.
• Define database architecture. For the database systems in your workplace, identify which architecture they fall under.
• Define relational database architecture. Consider Microsoft® Access®, Microsoft SQL Server®, Oracle®, IBM DB2®, and so on. 
 
Include three to five references.
Format your paper consistent with APA guidelines.


Preview of solution:
 

The Tampa Museum of Art is necessary to monitor the works of art, artists and places where the art museum or stored on the display. Currently, the Tampa Museum of Art together using incorrect spreadsheets to track art, artist, and location data within the museum and takes a long time for end users. The work of the working groups is to create a reliable data base to streamline operations in the museum and take inventory accurate and reliable.

Environment Database

The database environment consists of the system hardware, software, people, processes and data. The material used for the database is a network of Dell workstation to each site museum. Jobs used Dell OptiPlex 390, which has been linked to a central server that will be stored in the database. Each workstation will have access to the server to retrieve the requested data. Each site museum will also have a Dell C3760dn laser multifunction printer to print the results obtained from the database.

Every single workstation using Microsoft Windows 7 Professional x64 Service Pack 1 service for the operating system. The central database server will use the R2 x64 Microsoft Server 2008 operating system. The DBMS will use the Microsoft Office Access. You will be created to add data to the database and make it easier to recover data in case you need a form. Reports can download and print the presentation of the results of the research data base.

People involved in database system is the system administrator, data models, database administrator, system analysts and end users. The system administrator will oversee the general operations of the database. The database modelers will create the project database. Analysts system will create GUI-based input screens, reports and procedures that end users can use to change the database and retrieve the necessary data.The procedures of the database are a group of instructions and business rules that will be used to add and remove and search throughout the database. The data in the database will represent the artwork, artists, and locations art is stored within the museum. The data will  be stored into tables created with Microsoft Access.

Problems and Constraints
Problems and constraints for the new database will be the collection of data to be represented in the new database. Currently spreadsheets to Microsoft Excel that is used to store data on the positions of art, artists and art. These cards are not always up to date and accurately represented in all current jobs. Data should be collected and documented before creating the new database to ensure that the new database will be accurate.
Time is another limitation of the new database project. The database should be operational before the start of the next financial year and within the allotted budget of $ 20,000. The budget for the work, just like all of the material has already been taken and the software for the database.
 
Objectives of the database environment
The aim of the database is to record what is art, artists, and the position of art included in the museum. This will help those responsible for the museum project knows exactly what the museum has art in his hand, and organize the inventory and prepare for future exhibitions.

For Full solution please contact us
24*7 Live chat with Experts