Synopsis
This text provides a comprehensive, yet concise introduction to database systems. It discusses the database as an essential component of a software system, as well as a valuable, mission critical corporate resource. The book is based on lecture notes that have been tested and proven over several years, with outstanding results. It also exemplifies mastery of the technique of combining and balancing theory with practice, to give students their best chances at success.
The book discusses concepts, principles, design, implementation, and management issues of databases. Each chapter is organized systematically into brief, reader-friendly sections, with itemization of the important points to be remembered. It adopts a methodical and pragmatic approach to solving database systems problems. Diagrams and illustrations also sum up the salient points to enhance learning. Additionally, the book includes a number of Foster s original methodologies that add clarity and creativity to the database modeling and design experience, while making a novel contribution to the discipline.
Upholding his aim for brevity, comprehensive coverage, and relevance, Foster s practical and methodical discussion style gets straight to the salient issues, and avoids unnecessary fluff as well as an overkill of theoretical calculations. Readers should find this approach useful in their respective needs.
Brief Contents:
Division A: Preliminary Topics
1. Introduction to Database Systems
2. The Database System Environment
Division B: The Relational Database Model
3. The Relational Model
4. Integrity Rules and Normalization
5. Database Modeling and Design
6. Database User Interface Design
7. Relational Algebra
8. Relational Calculus
9. Relational System a Closer Look
Division C: Structured Query Language (SQL)
10. Overview of SQL
11. SQL Definition Statements
12. SQL Data Manipulation Statements
13. Logical Views and Security
14. The System Catalog
15. Some Limitations of SQL
Division D: Some Commonly Used DBMS Suites
16. Overview of Oracle
17. Overview of DB2
18. Overview of Microsoft SQL Server
19. Overview of Gupta Team Developer and MySQL
20. Overview of Borland Delphi
Division E: Advanced Topics
21. Database Administration
22. Distributed Database Systems
23. Object Databases
24. Data Warehousing and Information Extraction
25. Web-Accessible Databases
Division F: Final Preparations
26. Sample Exercises and Examination Questions
Division G: Appendices
Appendix-1: Review of Trees
Appendix-2: Review of Hashing
Appendix-3: Review of Information Gathering Techniques
"synopsis" may belong to another edition of this title.
About the Author
Elvis C. Foster is Assistant Professor of Computer Science at Keene State College, New Hampshire. He holds a Bachelor of Science (BS.) in Computer Science and Electronics, as well as a Doctor of Philosophy (PhD) in Computer Science (specializing in strategic information systems and database systems) from University of the West Indies, Mona Jamaica. Dr. Foster has over 20 years of combined experience as a software engineer, information technology executive and consultant, and computer science educator. He has had the favorable experience of being involved with the design and/or development of software systems for various medium and large organizations, including the central bank of his own country. He has lectured at the tertiary level in three different countries, including the United States, and has produced many outstanding computer science and information technology professionals. Many of them have excelled at graduate school, and are doing well in leading software engineering enterprises around the world. He now makes his winning lecture notes available to you.
Shripad V. Godbole is an independent database consultant with over 20 years of experience in diverse business environments, information infrastructure planning, diagnostics, and administration. His qualifications include Bachelor of Science (BS) in Computer Science, Master of Science (MS) in Physics with Specialization in Electronics -- all from Poona University, Pune, India. He is also an Oracle Certified Professional Database Administrator (OCPDBA), and holds a Master of Business Administration (MBA) in Technology Management. Currently Shripad is pursuing CISSP.
From the Back Cover
This text provides a comprehensive, yet concise introduction to database systems. It discusses the database as an essential component of a software system, as well as a valuable, mission critical corporate resource. The book is based on lecture notes that have been tested and proven over several years, with outstanding results. It also exemplifies mastery of the technique of combining and balancing theory with practice, to give students their best chances at success.The book discusses concepts, principles, design, implementation, and management issues of databases. Each chapter is organized systematically into brief, reader-friendly sections, with itemization of the important points to be remembered. It adopts a methodical and pragmatic approach to solving database systems problems. Diagrams and illustrations also sum up the salient points to enhance learning. Additionally, the book includes a number of Foster's original methodologies that add clarity and creativity to the database modeling and design experience, while making a novel contribution to the discipline. Upholding his aim for brevity, comprehensive coverage, and relevance, Foster's practical and methodical discussion style gets straight to the salient issues, and avoids unnecessary fluff as well as an overkill of theoretical calculations. Readers should find this approach useful in their respective needs.
From the Inside Flap
Brief Contents:
Division A: Preliminary Topics
1. Introduction to Database Systems
2. The Database System Environment
Division B: The Relational Database Model
3. The Relational Model
4. Integrity Rules and Normalization
5. Database Modeling and Design
6. Database User Interface Design
7. Relational Algebra
8. Relational Calculus
9. Relational System - A Closer Look
Division C: The Structured Query Language (SQL)
10. Overview of SQL
11. SQL Data Definition Statements
12. SQL Data Manipulation Statements
13. SQL Views and System Security
14. The System Catalog
15. Some Limitations of SQL
Division D: Some Commonly Used DBMS Suites
16. Overview of Oracle
17. Overview of DB2
18. Overview of MS SQL Server
19. Overview of MySQL
20. Overview of Delphi
Division E: Advanced Topics
21. Database Administration
22. Distributed Database Systems
23. Object Databases
24. Data Warehousing
25. Web-Accessible Databases
Division F: Final Preparations
26. Sample Exercises and Examination Questions
Division G: Appendices
Appendix 1: Review of Trees
Appendix 2: Review of Hashing
Appendix 3: Review of Information Gathering Techniques
"About this title" may belong to another edition of this title.
