IT163
Unit 4 Assignment: Rational Database
IT163
Purdue Global University
A database is a collection of data is organized in a manner to be quickly searched
and retrieved. Databases require a program of software, referred to as a database
management system (DBMS). The database management system is an interface between the
database and the end-users that simultaneously manages data. Meanwhile in a relational
database management system (RDBMS) is a collection of programs and capabilities that is
designed to create and update tables and rows.
In a relational database model, the table is a collection of data elements that are
organized in rows and columns. Tables are similar to worksheets in applications much like
Excel, the rows run horizontally while columns run vertically. A table can have multiple rows
of data that have true relation but do not have any duplicate data. The intersection of the rows
and columns define each cell in the table. Records are represented by rows and columns
represent fields. Fields and records are two basic components of a database where a
collection of information is organized.
Relational databases maintain data in tables which provides an efficient and flexible
way to store and access structured information. This allows you to retrieve a new table from
data in one or more tables with a query. It allows an understanding of the relationship among
the available data and to gain insight into making decisions on identifying new
opportunities. Relational databases provide an environment from which data can be accessed
in many ways without needing to reorganize the database tables. Some of the many benefits
