Database Principles

Author: Kroenke
Publisher:
Publish Date: 2004-02-01
Features: This book includes 6 chapters and an appendix. Chapter 1 explains the reasons for using databases, the composition of databases, and methods for developing databases. Students will learn about the uses of databases and their applications, the differences and advantages of databases compared to spreadsheet lists. Chapter 2 introduces the relational model, defines basic relational terms, and also introduces the basic concepts of normalization, setting the stage for further discussion of this topic in Chapter 5. Chapter 3 covers basic SQL statements. It describes fundamental SQL statements for defining data, such as SQL SELECT and data modification statements. This book does not introduce advanced SQL statements but focuses on core statements. The next three chapters discuss database design and management. Chapter 4 uses the entity-relationship (E-R) model to solve data modeling problems, including the need for data modeling, basic E-R terms and concepts, and a brief E-R modeling example application. Chapter 5 discusses database design, explaining the basic concepts of normalization. The data model from the example in Chapter 4 is converted into a relational design in Chapter 5. Chapter 6 discusses database management. This chapter covers the needs of database management, outlines concurrency control, security, and backup and recovery techniques. These topics are important for all databases, including personal single-user databases. In fact, these topics are even more important for such private databases because they lack professional database administrators to ensure the execution of critical tasks. The appendix after explains the use of Microsoft Access. Combined with Access technical documentation, it helps students create simple databases and applications. In the information age, databases and their related applications have become the core of various business activities and daily operations, making a thorough understanding and grasp of database principles crucial. This book incorporates David M. Kroenke's in-depth understanding and rich practical experience in databases, vividly depicting the principles and applications of databases in an accessible manner. It is an invaluable database guide for beginners and junior developers. Main contents of the book:
· Basics of the relational model
· Structured Query Language (SQL)
· Data modeling
· Data design solutions
· Database management