Mr Kavule

Database Environment for Art Museum

Intro

The Art museum needs to track the artwork, artist, and locations where the art is displayed or stored within the museum. Therefore there is need to design and develop a central database system that will accommodate the above-mentioned requirements as per the art Museum.

The Information team has initiated a database environment, which is to deploy workbench in a multiuser environment, and the single user mode will be reserved for special needs.

Analyze the database environment.

Database environment will consist of five major parts namely, hardware, software, people, procedures and data.

The hardware components in the database system environment will identify all the systems, physical devices such as computers, network components and computer peripherals.

The software refers to the collection of programs used within the database system, for example the operating system, DBMS software, application programs and utilities. For this environment, we shall use microsoft’ MS Acess and SQL server

The people in the database system environment include all users affiliated with Art museum. Other users identified are system administrators, and database administrators,

Describe the problems and constraints.

By using constraints, there is already means to create test driven database. (Although Test-Driven database development is an excellent discipline to adopt,)

there are several different types of database constrains, and the common ones associated with the database environment are primaryKey, foreign key, Datatypes, null ability constraint and so many.

Describe the objectives of the database environment.

Scope and Boundary

The system scope has been documented in the project plan. The external business requirements for the art museum

In addition to the scope, the system boundaries are clearly understood, the boundaries identify where the system to be sized starts and ends.  The sizing...