Oracle Relational Database Management System (RDBMS)
Oracle Relational Database Management System is a general purpose relational database package which is available on SSA, and can be bought for Suns and PCs under a site licence. Files produced on one computer system can easily be migrated to another system. Definition of database terms A database is a collection of data relating to a particular topic. The data is arranged in tables consisting of rows and columns. Each row is a single entry or record in the table and is divided into fields, one for each column in the table. Data records are usually accessed by their content, rather than their position in the table. A relational database can contain more than one table, which may be related to each other using one or more columns in common. Example database For example, a database containing information about cars built before 1960 might be divided into two tables, one with information about each model of car and one with information about the manufacturers of the cars. Since each manufacturer might make several models of car, having two tables avoids duplicating the information about the manufacturer. The tables are related by the column 'make' in the CAR table which is the same as the column 'name' in the MANUFACTURER table. This database is used as an example together with the Injury database in local documents describing Oracle.
|
