Cis 106: Assignment 3 Databases

1605 Words7 Pages
Assignment 3: Databases Professor David Moore Course Title: CIS 106: Introduction to Technology 28 May 2014 Assignment 3: Databases A relational database is a compilation of data items arranged as a group of tables from which data can be evaluated or reconstructed without needing to rearrange the database tables. A database is comprised of one or more tables of data. The rows in a table are called records, and the columns in a table are called fields or attributes. A database that holds one table is called a flat database, and a database that is comprised of two or more related tables is called a relational database. The Historical Data Warehouse design permits successive automatic transformations to obtain one of the implementations of the model in a Relational Data Base Management System [RDBMS] (Neil, De Vincenzi, and Pons, 2014). While relational databases have benefits, they require a lot of effort. The technique utilized to ensure data is accessible (both in and out of the database) is not that responsive. Changes in data representation will often be needed as a result of changes in query, update, and report traffic and natural growth in the types of stored information (Codd, 1970). The benefits of relational databases far out way the disadvantages. Relational database designers waste a lot of time outlining data affiliations, only to discover that users' data conditions are constantly changing. These changes in user requirements entail revisions to the database structure and the application programs. This causes the developer to maintain applications that are rigid and don’t really meet the needs of the user. In addition, the complication of gaining access to data reduces programmer efficiency (who are then compelled to code at a low level of structural detail). Relational databases are needed to organize data better, to

More about Cis 106: Assignment 3 Databases

Open Document