University of Phoenix
Data Systems Learning Team Paper
Team A: Renee Wilson, Ferdinand Habijan,
Maryrose DeFino, Stasia Bowling
HCI 520 Data Management and Design
January 16, 2012
This paper will address data systems; a database is an organized group of files that are related and considered the supporting constructs of a database management system. It is maintained and considered an integral part of most organizations worldwide. The database management system houses a program that enables storage, modification, and extraction of information from a database. In this paper team A will address database the phases of the database life cycle, and ...view middle of the document...
Security is also addressed at this time, physical and password security a determination of access rights and audit trails are developed. Data encryption and firewall are built. An implementation plan or written schedule is important to take steps to ensure deployment and transition is achieved. Implementation includes developing training requirements and schedules. A good training experience is the first step towards end user acceptance.
Analysis of Database Types
Database System types include single, multi-user, centralized and distributed. The objective of the database is to maintain the integrity and consistency of the data. This consists of a data dictionary that provides definitions of the data, elements and their relationships. Data storage and security management both need to be considered when deciding upon a database type for an organization. Database Models are used to represent data structures and display relationships within a database. Conceptual models include Entity relationship database models (ERDBD) and Object-oriented models (OODBM). Relationships in Conceptual models are 1:1, 1: M, and M: M. Implementation models include: Hierarchical database model (HDBM), Network database model (NDBM), Relational database model (RDBM) and Object oriented database model (ODBM) (Learn IT: The Power of the Database, 2008). Following is a description of each type of database.
Hierarchical Databases: are represented by an inverted tree. Each parent can have many children. Each child has one parent.
Network Databases: allows more flexibility than the hierarchical model, each record can have multiple parents; introduced set to describe relationship. Each set has its own record and member record, parallel to parent and child in HDM. Member may have several owners; one ownership.
Relational Database: a collection of tables for data storage, while the RDBMS handles the physical details. Tables, records, and fields are the basic components.
Object-Oriented Database: the object-oriented database model was developed to handle the types of data that the relational model was not well suited for.
Object-Relational Databases: a hybrid model, combining features of the relational and objection–oriented models (“Learn IT: The Power of the Database,” 2008).
Conceptual Representation for the Database System
The database system plays an important role during the operation of a business. Although database design is a time consuming process, organizations should pay close attention to every phase during development of database system to produce a well-designed database. See Appendix for the diagram.
During the development of a database system, designers and developers should ensure that every element of the system performs its vital function properly. During the process of database system production performance issues can be resolved prior completion of the final product. Database system design should always be aligned to the goal and...