tailieunhanh - Beginning Database Design- P2

Beginning Database Design- P2:This book focuses on the relational database model from a beginning perspective. The title is, therefore, Beginning Database Design. A database is a repository for data. In other words, you can store lots of information in a database. A relational database is a special type of database using structures called tables. Tables are linked together using what are called relationships. You can build tables with relationships between those tables, not only to organize your data, but also to allow later retrieval of information from the database | Introduction This book contains a glossary allowing for the rapid look up of terms without having to page through the index and the book to seek explicit definitions. Part 1 Approaching Relational Database Modeling Part I examines the history of relational database modeling. It describes the practical needs the relational database model fulfilled. Also included are details about dealing with people extracting information from people and existing systems problematic scenarios and business rules. Chapter 1 Database Modeling Past and Present This chapter introduces basic concepts behind database modeling including the evolution of database modeling different types of databases and the very beginnings of how to go about building a database model. Chapter 2 Database Modeling in the Workplace This chapter describes how to approach the designing and building of a database model. The emphasis is on business rules and objectives people and how to get information from them plus handling of awkward and difficult existing database scenarios. Chapter 3 Database Modeling Building Blocks This chapter introduces the building blocks of the relational database model by discussing and explaining all the various parts and pieces making up a relational database model. This includes tables relationships between tables and fields in tables among other topics. Part 11 Designing Relational Database Models Part II discusses relational database modeling theory formally and in detail. Topics covered are normalization Normal Forms and their application denormalization data warehouse database modeling and database model performance. Chapter 4 Understanding Normalization This chapter examines the details of the normalization process. Normalization is the sequence of steps normal forms by which a relational database model is both created and improved upon. Chapter 5 Reading and Writing Data with SQL This chapter shows how the relational database model is used from an application perspective. A .