1.4. RDBMS: TABLES AND DATABASES
Officially, an RDBMS is a software package designed to manage large amounts of data organized as collections of tables. Commercial RDBMS characteristics include
Being organized as collection(s) of tables
Using client-server architecture
Being ANSI SQL compliant, usually SQL-92 at the entry level
SQL Server specifies a single collection of related tables as a database, which contains the data tables, system tables and other objects, such as views, indexes, stored procedures and triggers used in operations on the data. Table 1-4 represents a collection of two tables: emps and depts.
| COMPANY ORGANIZATION | ||||
|---|---|---|---|---|
| emps | ||||
| ename | empid | deptno | telnum | sales_amt |
| Mary Smith | 5555 | 100 | 5678 | |
| Sammy Sosa | 2222 | 102 | 2345 ... | |
Get Transact-SQL Desk Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
