Databases DemystifiedThrough clear language, step-by-step discussions, and quizzes at the end of each chapter, the author makes databases easy. Quickly learn the core skills needed to design, configure, manage, and manipulate databases, whether at work or at home. Topics such as exploring different database models, planning their design, minimizing redundant data, designing tables, applying database design concepts, and implementing database security are covered. This is that fast, easy-to-understand tutorial that you’ve been looking for. |
Contents
CONTENTS AT A GLANCE | 16 |
Database Fundamentals 1 | 17 |
Exploring Relational Database Components | 25 |
Copyright | |
19 other sections not shown
Other editions - View all
Common terms and phrases
Acme Industries automatically business rules Chapter Check constraints clause client workstation column names connected create cursor Customer ID CUSTOMER NUMBER CUSTOMER_NUMBER CustomerID data independence data marts data type data warehouse database design database objects database user DBMS delete DEPARTMENT_ID Design View E.F. Codd Edit View Insert EMPLOYEE_ID EMPLOYEES table entity example firewall FIRST_NAME foreign key implemented Internet INVOICE LINE ITEM Invoice Number Iools Window Help key columns language LAST_NAME layer lock logical design Manager Microsoft Access Microsoft SQL Server multiple multivalued attributes Northwind NULL NUMBER option Oracle Order Detail outer join panel primary key primary key constraint privileges query results Query1 RDBMS RDBMSs referential constraint relational databases relationship Sales schema second normal form Select Query shown in Figure SQL statements SQL*Plus stored subtypes super type Sybase third normal form transaction unique identifier update user views vendors Window Help Show ZIP CODE