Appendices
Appendix A provides a description of DreamHome, a case study that is used extensively
throughout the book.
Appendix B provides three additional case studies, which can be used as student projects.
Appendix C provides some background information on file organization and storage
structures that is necessary for an understanding of the physical database design methodology
presented in Chapter 17 and query processing in Chapter 21.
Appendix D describes Codd’s 12 rules for a relational DBMS, which form a yardstick
against which the ‘real’ relational DBMS products can be identified.
Appendix E examines embedded and dynamic SQL, with sample programs in ‘C’.
The chapter also examines the Open Database Connectivity (ODBC) standard, which has
emerged as a de facto industry standard for accessing heterogeneous SQL databases.
Appendix F describes two alternative data modeling notations to UML, namely Chen’s
notation and Crow’s Foot.
Appendix G summarizes the steps in the methodology presented in Chapters 15–18 for
conceptual, logical, and physical database design.
Appendix H (see companion Web site) discusses how to estimate the disk space requirements
for an Oracle database.
Appendix I (see companion Web site) provides some sample Web scripts to complement
Chapter 29 on Web technology and DBMSs.
Appendix A provides a description of DreamHome, a case study that is used extensively
throughout the book.
Appendix B provides three additional case studies, which can be used as student projects.
Appendix C provides some background information on file organization and storage
structures that is necessary for an understanding of the physical database design methodology
presented in Chapter 17 and query processing in Chapter 21.
Appendix D describes Codd’s 12 rules for a relational DBMS, which form a yardstick
against which the ‘real’ relational DBMS products can be identified.
Appendix E examines embedded and dynamic SQL, with sample programs in ‘C’.
The chapter also examines the Open Database Connectivity (ODBC) standard, which has
emerged as a de facto industry standard for accessing heterogeneous SQL databases.
Appendix F describes two alternative data modeling notations to UML, namely Chen’s
notation and Crow’s Foot.
Appendix G summarizes the steps in the methodology presented in Chapters 15–18 for
conceptual, logical, and physical database design.
Appendix H (see companion Web site) discusses how to estimate the disk space requirements
for an Oracle database.
Appendix I (see companion Web site) provides some sample Web scripts to complement
Chapter 29 on Web technology and DBMSs.
No comments: