Chapter 5 Introduction to database applications
Introduction to multi-user database applications 172
The hardware components of a multi-user system 172
The software components of a typical multi-user database application 174
How a relational database is organized 176
How a table is organized 176
How the tables in a database are related 178
How the fields in a table are defined 180
How to use SQL to work with the data in a relational database 182
How to query a single table 182
How to join data from two or more tables 184
How to modify the data in a table 186
How to use views, stored procedures, and triggers 188
How a DBMS provides for referential integrity, security, and locking 190
How referential integrity works 190
How data security works 192
How locking works 194
Data access options and implementations 196
Common data access options 196
Common data access implementations 198
Client/Server implementations 200
Multi-tier systems and ActiveX components 200
Enterprise systems 202
Internet and intranet applications 204
t
[Prev]
[Next]