" MY_IDEA_IS"

PART II

A. Discuss what you have learned and understood about what Relational Database Management System is, so far.

= as what I have understood about Relational Database Management System is, it is about saving or keeping a data that uses a System or Software for proper management of data for future uses. Specially to those person whom to be very reliable to data, this is very important.

= A Relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as introduced by E. F. Codd. Most popular commercial and open source databases currently in use are based on the relational model.

A short definition of an RDBMS may be a DBMS in which data is stored in the form of tables and the relationship among the data is also stored in the form of tables.

B. Define how each of the following fit and function within the framework of relational DBMS systems:

1. Key field= is a field or set of fields of a database (typically a relational database) table which together form a unique identifier for a database record (a table entry). The aggregate of these fields is usually referred to simply as "the key".

2. Database records=it is the records of files or data that uses database management.

3. Data queries=it lets you to put some data or question on the database.

4. Data types=is a set of values and the operations on those values.

5. Data forms=it is the form of saving or keeping data according to the user of it.

6. Table/ Database files=tables is used in database for easy easy manipulation of data and for proper arranging on it.

=is a set of data elements (values) that is organized using a model of vertical columns (which are identified by their name) and horizontal rows. A table has a specified number of columns, but can have any number of rows. Each row is identified by the values appearing in a particular column subset which has been identified as a candidate key.

7. Relationship (Table linkages)= it is use in forming tables, for example, if you have the name of the person as one of your data and you want to put some more information on it so your going to use link. It is somehow like HTML.