Database Environment Week 2
Database Environment: Week 2
Joe Snuffy
DMB/380
October 6, 2002
Database Environment Intro
The Tampa Art Museum needs to track the artwork, artists, and locations where the art is displayed or stored within the museum. Currently The Tampa Art Museum is using an inaccurate set of spreadsheets to keep track of art, artist, and location data within the Museum and it is very cumbersome for end users. The Project teams Goal is to create a reliable database to streamline operations at the museum and make inventory accurate and reliable.
Database Environment
The database environment consists of the system hardware, software, people, procedures, and data. The hardware that will be used for the database is a network of Dell workstations at each museum location. The workstations used are Dell OptiPlex 390’s, connected to a main server which the database will be stored. Each workstation will have access to the server to retrieve the data needed. Each museum location will also have a Dell C3760dn Multifunction Laser Printer to print results obtained from the database.
Each individual workstation will use Microsoft Windows 7 professional x64 service pack 1 for the operating system. The Main database server will use Microsoft Server 2008 R2 x64 for the operating system. The DBMS that will be used will be Microsoft Office Access. A form will be created to add data to the database and make it easy to retrieve data when needed. Reports can be downloaded and printed to show results of the data base inquiry.
The people involved in the database system are the system administrator, data modelers, database administrator, system analysts, and end users. The system administrator will oversee the general operations of the database. The database modelers will create the design of the database. The system analysts will create GUI based input screens, reports, and procedures which end users will use to modify the database, and retrieve the needed data.
The procedures of
Joe Snuffy
DMB/380
October 6, 2002
Database Environment Intro
The Tampa Art Museum needs to track the artwork, artists, and locations where the art is displayed or stored within the museum. Currently The Tampa Art Museum is using an inaccurate set of spreadsheets to keep track of art, artist, and location data within the Museum and it is very cumbersome for end users. The Project teams Goal is to create a reliable database to streamline operations at the museum and make inventory accurate and reliable.
Database Environment
The database environment consists of the system hardware, software, people, procedures, and data. The hardware that will be used for the database is a network of Dell workstations at each museum location. The workstations used are Dell OptiPlex 390’s, connected to a main server which the database will be stored. Each workstation will have access to the server to retrieve the data needed. Each museum location will also have a Dell C3760dn Multifunction Laser Printer to print results obtained from the database.
Each individual workstation will use Microsoft Windows 7 professional x64 service pack 1 for the operating system. The Main database server will use Microsoft Server 2008 R2 x64 for the operating system. The DBMS that will be used will be Microsoft Office Access. A form will be created to add data to the database and make it easy to retrieve data when needed. Reports can be downloaded and printed to show results of the data base inquiry.
The people involved in the database system are the system administrator, data modelers, database administrator, system analysts, and end users. The system administrator will oversee the general operations of the database. The database modelers will create the design of the database. The system analysts will create GUI based input screens, reports, and procedures which end users will use to modify the database, and retrieve the needed data.
The procedures of
References: Coronel, C. (2013). Database Systems: Design, Implementation, and Management, Tenth Edition. Mason, Ohio, United States: Cengage Learning. Dell. (2012, September 30). Shop all Color Single Function Lasers. Retrieved from http://accessories.us.dell.com/sna/sna.aspx?c=us&cs=ussoho1&l=en&s=soho&~topic=printer_shopall_colorlasers_single_function JKiNFOLINE.com. (2010). Database System Environment . Retrieved September 30, 2012. Retrieved from http://www.jkinfoline.com/dbms-introduction.html microsoft.com. (2012, September 30). Database basics. Retrieved September 30, 2012. Retrieved from http://office.microsoft.com/en-us/access-help/database-basics-HA010064450.aspx