(Size : 2.98 MB)

Entity-relationship (E-R) diagrams are time-tested models for database development well-known for their usefulness in mapping out clear database designs. Also commonly known is how difficult it is to master them. With this comprehensive guide, database designers and developers can quickly learn all the ins and outs of E-R diagramming to become expert database designers. Because E-R diagrams are so fundamental to database design, this book is also an indispensable text for teaching computer science students the basics of database development. Database Design Using Entity-Relationship Diagrams clarifies E-R diagramming by defining it in terms of requirements (end user requests) and specifications (designer feedback to those requests).

The book explains how open communication between designers and end users is critical to developing usable, easy-to-understand E-R diagrams that model both requirements and specifications. The authors explain, in an intuitive, informal manner, how to develop an E-R diagram, how to map it to a database, and how the resulting database can be tested. This definitive guide is a basic component for any database course, and is also an invaluable reference that database professionals can use throughout their careers.

This book is intended to be used by database practitioners and students for data modeling. It is also intended to be used as a supplemental text in database courses, systems analysis and design courses, and other courses that design and implement databases. Many present-day database and systems analysis and design books limit their coverage of data modeling. This book not only increases the exposure to data modeling concepts, but also presents a detailed, step-by-step approach to designing an ER diagram and developing the relational database from it.

TABLE OF CONTENT:
Chapter 01 - The Software Engineering Process and Relational Databases
Chapter 02 - The Basic ER Diagram—A Data Modeling Schema
Chapter 03 - Beyond the First Entity Diagram
Chapter 04 - Extending Relationships/Structural Constraints
Chapter 05 - The Weak Entity
Chapter 06 - Further Extensions for ER Diagrams with Binary Relationships
Chapter 07 - Ternary and Higher-Order ER Diagrams
Chapter 08 - Generalizations and Specializations
Chapter 09 - Relational Mapping and Reverse-Engineering ER Diagrams
Chapter 10 - A Brief Overview of the Barker/Oracle-Like Model

READ MORE - Database Design Using Entity-Relationship Diagrams

(Size : 3.47 MB)

This book starts right from the basics with databases and SQL. Prior database or SQL knowledge is not necessary, as this book covers everything from database design to creating your first database and understanding how the SQL language is used with databases.

If you have some previous experience with databases and SQL, then you’ll have a head start and you may want to just skim Chapter 1. You’ll need to follow its instructions for creating the book’s example database, as this is used for all the examples throughout the book.

This book will look at Structured Query Language, or SQL as it’s usually abbreviated. SQL works with a database to create the database and to insert and extract data. Therefore, it’s essential to understand the theory and concepts behind database systems. Hence, this book also covers database theory and database design, so that you’re equipped to create an effective database.

The SQL code in this book reflects the modern SQL standards set by organizations such as the American National Standards Institute (ANSI) and the International Standards Organization (ISO). However, while standards are great, what’s available for practical use is what really counts. This book, then, concentrates on the sort of SQL supported by most modern database systems. You should that find most of the code runs with little or no modification on most database systems released within the last six or seven years.

TABLE OF CONTENT:
Chapter 01 - Introduction to SQL
Chapter 02 - Entering Information
Chapter 03 - Extracting Information
Chapter 04 - Advanced Database Design
Chapter 05 - Manipulating Data
Chapter 06 - Grouping and Aggregating Data
Chapter 07 - Selecting Data from Different Tables
Chapter 08 - Queries within Queries
Chapter 09 - Advanced Queries
Chapter 10 - Views
Chapter 11 - Transactions
Chapter 12 - SQL Security
Chapter 13 - Database Tuning
Appendix A - Exercise Answers
Appendix B - Setting up and Using the Five Database Systems
Appendix C - Initial Data Setup

READ MORE - Beginning SQL (with source code)

(Size : 5.03 MB)

This essential resource for Oracle DBAs has been completely updated to cover the new features of Oracle Database 11g, the industry standard Web-enabled enterprise database system. Oracle Database 11g DBA Handbook details each topic with an emphasis on the big picture, enabling you to achieve effective and efficient database management.

You will learn to get up-and-running on Oracle Database 11g, develop and implement applications, manage storage space, and create reliable system backups. New and revised sections cover high availability, performance optimization, information management, and security procedures. Real-world examples and case studies illustrate each concept along the way.

READ MORE - Oracle Database 11g DBA Handbook

(Size : 13.09 MB)

The purpose of this book is to describe a practical approach for making sense out of data. A step-by-step process is introduced that is designed to help you avoid some of the common pitfalls associated with complex data analysis or data mining projects. It covers some of the more common tasks relating to the analysis of data including (1) how to summarize and interpret the data, (2) how to identify nontrivial facts, patterns, and relationships in the data, and (3) how to make predictions from the data.

The book is focused on practical approaches and contains information on how the techniques operate as well as suggestions for when and how to use the different methods. Each chapter includes a further reading section that highlights additional books and online resources that provide background and other information. At the end of selected chapters are a set of exercises designed to help in understanding the respective chapter’s materials.

Making Sense of Data educates readers on the steps and issues that need to be considered in order to successfully complete a data analysis or data mining project. The author provides clear explanations that guide the reader to make timely and accurate decisions from data in almost every field of study. A step-by-step approach aids professionals in carefully analyzing data and implementing results, leading to the development of smarter business decisions. With a comprehensive collection of methods from both data analysis and data mining disciplines, this book successfully describes the issues that need to be considered, the steps that need to be taken, and appropriately treats technical topics to accomplish effective decision making from data.

TABLE OF CONTENT:
Chapter 1 - Introduction
Chapter 2 - Definition
Chapter 3 - Preparation
Chapter 4 - Tables and graphs
Chapter 5 - Statistics
Chapter 6 - Grouping
Chapter 7 - Prediction
Chapter 8 - Deployment
Chapter 9 - Conclusions

READ MORE - Making Sense of Data (with additional files)