Database Concepts for the Systems Analyst
Databases
- Relational Database Management Systems:
- There are several types of database management systems and they can be classified according to the way they structure records.
- Early database management systems organized records in hierarchies or networks implemented with indexes and linked lists.
- Relational databases implement data in a series of tables that are ‘related’ to one another via foreign keys.
- Files are seen as simple two-dimensional tables, also known as relations.
- The rows are records.
- The columns correspond to fields.