IT163_Unit4.docx IT163 Unit 4 Assignment: Rational Database IT163 Purdue Global Univer

IT163_Unit4.docx  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. Rel