Database Concepts for the Systems Analyst
Databases
- Relational Database Management Systems:
- Both the DDL and DML of most relational databases is called SQL (which stands for Structured Query Language).
- SQL supports not only queries, but complete database creation and maintenance.
- A fundamental characteristic of relational SQL is that commands return ‘a set’ of records, not necessarily just a single record (as in non-relational database and file technology).