Relational Database Design Clearly Explained
|
Contents
Entities and Data Relationships | 11 |
12 | |
13 | |
15 | |
17 | |
18 | |
19 | |
20 | |
21 | |
23 | |
24 | |
26 | |
27 | |
28 | |
32 | |
33 | |
34 | |
36 | |
37 | |
39 | |
43 | |
44 | |
Historical Antecedents | 47 |
48 | |
50 | |
52 | |
53 | |
54 | |
57 | |
59 | |
62 | |
65 | |
73 | |
74 | |
75 | |
76 | |
77 | |
78 | |
80 | |
81 | |
82 | |
85 | |
86 | |
87 | |
88 | |
89 | |
90 | |
92 | |
93 | |
94 | |
95 | |
96 | |
97 | |
98 | |
100 | |
102 | |
103 | |
104 | |
105 | |
106 | |
108 | |
110 | |
111 | |
112 | |
113 | |
116 | |
119 | |
121 | |
122 | |
124 | |
126 | |
127 | |
128 | |
129 | |
130 | |
132 | |
133 | |
134 | |
135 | |
136 | |
137 | |
138 | |
139 | |
141 | |
142 | |
143 | |
144 | |
145 | |
146 | |
178 | |
179 | |
181 | |
182 | |
183 | |
184 | |
Column Data Types | 185 |
Default Values | 190 |
Primary Keys | 191 |
Additional Column Constraints | 194 |
Views | 198 |
View Updatability lssues | 199 |
Temporary Tables | 201 |
Creating Temporary Tables | 202 |
Loading Temporary Tables with Data | 203 |
Creating indexes | 204 |
Modifying Database Elements | 205 |
Adding Table Constraints | 206 |
Deleting Elements | 207 |
Renaming Elements | 208 |
Deleting Database Elements | 209 |
Types of Access Rights | 210 |
Granting Rights | 211 |
Revoking Rights | 212 |
ObjectRelational Extensions | 213 |
Using CASE Tools for Database Design | 215 |
CASE Capabilities | 216 |
ER Diagram Reports | 218 |
Data Flow Diagrams | 220 |
The Data Dictionary | 222 |
Code Generation | 225 |
Sample Input and Output Designs | 228 |
The Drawing Environment | 229 |
For Further Reading | 230 |
Database Design Case Study 1 MightyMite Motors | 231 |
Corporate Overview | 232 |
Manufacturing Division | 238 |
Marketing Sales Division | 239 |
Reengineering Project | 240 |
New Information Systems Division | 241 |
Current Business Processes | 242 |
Designing the Database | 251 |
Examining the Data Flows | 253 |
Creating the ER Diagram | 256 |
Creating the Tables | 261 |
Generating the SQL | 262 |
The ObjectRelational Design | 268 |
Creating the Classes | 273 |
Using the Classes in the Schema | 275 |
Database Design Case Study 2 East Coast Aquarium | 281 |
Organizational Overview | 282 |
Animal Tracking Needs | 284 |
The Volunteer Organization | 288 |
The Volunteers Database | 290 |
Creating the ER Diagram | 300 |
Generating the SQL | 301 |
Highlights of the Application Prototype | 303 |
Creating the ER Diagram | 308 |
Creating the Tables | 311 |
Generating the SQL | 312 |
The ObjectRelational Design | 316 |
The Animal Tracking Database | 317 |
Database Design Case Study 3 Independent Intelligence Agency | 321 |
Organizational Overview | 322 |
Current Information Systems | 324 |
Summary of IS Needs | 327 |
System Specifications | 328 |
Designing the Database | 333 |
ER Diagram for People | 334 |
ER Diagram for Intelligence Gathering and Sales | 337 |
ER Diagram for System Security | 340 |
ER Diagram for Equipment Tracking | 341 |
Designing the Tables | 343 |
Generating the SQL | 344 |
The ObjectRelational Design | 355 |
Creating the Classes | 362 |
Writing the Schema | 365 |
Glossary | 375 |
Index | 387 |