Perform a logical design on the proposed database environment without going through the full normalization process. Include the identification of all entities and attributes associated with the environment. 

Discuss the process you went through to select the appropriate data types, primary and foreign keys, and other constraints that are necessary to maintain the integrity of the database.

Create a detailed Entity Relationship Diagram (ERD) using the data specifications from the logical design. Use Microsoft^® Visio^®, Lucidchart, or another software tool of your choice 

  

Transcribed Image Text:

Database Environment Proposal of an Art Museum. Name: Zayeir Bent University of Phoenix Introduction A database environment refers to a system that is collectively composed of components such as data, its management and things that entail its use such as software programs (operating system and application programs), people (that deal with administrative duties), hardware (computer and computer peripherals) and techniques (including the practices, rules and concepts given). The data is managed by a controlling agent and then stored in a convenient and standardized form that makes retrieval easy. Database environments are important to organizations because they reduce redundancy; they enhance standards, improve the quality of data and increase the accessibility and responsiveness of data (Hoffer et al, 2005). Analysis of the database environment In the museum, exists a generalized strategy of storing data about exhibits present. A website is used to manage a portion of exhibits, because only that portion has been fed into the database. Most of the employees of the museum are elderly retirees or young volunteers, most of whom are not tech-savvy. There are only a few computers at the establishment, with most of them being available at the information desks for the staff, and none available for museum visitors. Problems and Constraints Given the huge size of the museum and the corresponding substantial number of documents and artefacts that require to be documented, the staff has found the task quite huge and considered it impossible. The biggest challenges being faced as a result are difficulties in keeping track of material, especially because most of the staff ends up retiring before establishing programs that can be used to help their successors. Redundancy is also a challenge as some artefacts end up appearing more than once on the database. This is because the database is not reviewed as frequently as it should be. Objectives of the Database Environment Database Environment Proposal of an Art Museum. Name: Zayeir Bent University of Phoenix Introduction A database environment refers to a system that is collectively composed of components such as data, its management and things that entail its use such as software programs (operating system and application programs), people (that deal with administrative duties), hardware (computer and computer peripherals) and techniques (including the practices, rules and concepts given). The data is managed by a controlling agent and then stored in a convenient and standardized form that makes retrieval easy. Database environments are important to organizations because they reduce redundancy; they enhance standards, improve the quality of data and increase the accessibility and responsiveness of data (Hoffer et al, 2005). Analysis of the database environment In the museum, exists a generalized strategy of storing data about exhibits present. A website is used to manage a portion of exhibits, because only that portion has been fed into the database. Most of the employees of the museum are elderly retirees or young volunteers, most of whom are not tech-savvy. There are only a few computers at the establishment, with most of them being available at the information desks for the staff, and none available for museum visitors. Problems and Constraints Given the huge size of the museum and the corresponding substantial number of documents and artefacts that require to be documented, the staff has found the task quite huge and considered it impossible. The biggest challenges being faced as a result are difficulties in keeping track of material, especially because most of the staff ends up retiring before establishing programs that can be used to help their successors. Redundancy is also a challenge as some artefacts end up appearing more than once on the database. This is because the database is not reviewed as frequently as it should be. Objectives of the Database Environment