Beginning Database Design Solutions PDF (Adobe DRM) download by Rod Stephens

Beginning Database Design Solutions

Wrox
Publication date: April 2009
ISBN: 9780470440513
Digital Book format: PDF (Adobe DRM)

Buy PDF

List price:
$31.99
Our price:
$29.99

You save: $2.00 (6%)
GET THIS EBOOK
FOR FREE!
Join our Facebook sweepstake, share and
get 10 likes. Winners
get notified in 24H!
This book is intended for IT professionals and students who want to learn how to design, analyze, and understand databases. The material will benefit those who want a better high-level understanding of databases such as proposal managers, architects, project managers, and even customers. The material will also benefit those who will actually design, build, and work with databases such as database designers, database administrators, and programmers. In many projects, these roles overlap so the same person may be responsible for working on the proposal, managing part of the project, and designing and creating the database.

This book is aimed at IT professionals and students of all experience levels. It does not assume that you have any previous experience with databases or programs that use them. It doesn’t even assume that you have experience with computers. All you really need is a willingness and desire to learn.

This book explains database design. It tells how to plan a database’s structure so the database will be robust, resistant to errors, and flexible enough to accommodate a reasonable amount of future change. It explains how to discover database requirements, build data models to study data needs, and refine those models to improve the database’s effectiveness.

The book solidifies these concepts by working through a detailed example that designs a realistic database. Later chapters explain how to actually build databases using two common database products: Access 2007 and MySQL.

The book finishes by describing some of the topics you need to understand to keep a database running effectively such as database maintenance and security.

This book explains database design. It tells how to determine what should go in a database and how the database should be structured to give the best results.

This book does not focus on actually creating the database. The details of database construction are different for different database tools so, to remain as generally as useful as possible, this book doesn’t concentrate on any particular database system. You can apply the techniques described here equally to whatever database tool you use whether it’s Access, SQL Server, Oracle, MySQL, or some other database product.

Most database products include free editions that you can use for smaller projects. For example, SQL Server Express Edition, Oracle Express Edition, and MySQL Community Server are all free.

To remain database neutral, the book does not assume you are using a particular database so you don’t need any particular software or hardware. To work through the Exercises, all you really need is a pencil and some paper. You are welcome to type solutions into your computer if you like but you may actually find working with pencil and paper easier than using a graphical design tool to draw pictures, at least until you are comfortable with database design and are ready to pick a computerized design tool.

  • “Goals of Effective Database Design,” explains the reasons why people and organizations use databases. It explains a database’s purpose and conditions that it must satisfy to be useful. This also describes the basic ACID (Atomicity, Consistency, Isolation, Durability) and CRUD (Create, Read, Update, Delete) features that any good database should have. It explains in high-level general terms what makes a good database and what makes a bad database.

  • “Database Types,” explains some of the different types of databases that you might decide to use. These include flat files, spreadsheets, hierarchical databases (XML), object databases, and relational databases. The relational database is one of the most powerful and most commonly used forms of database so it is the focus of this book, but it is important to realize that there are alternatives that may be more appropriate under certain circumstances. This gives some tips o

Please sign in to review this product.
Format:
Devices:
Beginning Database Design Solutions PDF (Adobe DRM) can be read on any device that can open PDF (Adobe DRM) files.

File Size:
7176 Kb
Language:
ENG
Copy From Text:
Enabled. Limit of 5 selections within 365 days.
Printing:
Enabled and unlimited.
Beginning Database Design Solutions PDF (Adobe DRM) download by Rod Stephens
Wrox, April 2009
ISBN: 9780470440513
EAN:  9780470440513
PDF (Adobe DRM)
List Price: $31.99 eBook price: $29.99
Beginning Database Design Solutions ePub (Adobe DRM) download by Rod Stephens
Wrox, December 2010
ISBN: 9780470440520
EAN:  9780470440520
ePub (Adobe DRM)
List Price: $31.99 eBook price: $29.99
Other books by Rod Stephens
C# 5.0 Programmer's Reference PDF (Adobe DRM) download by Rod Stephens
C# 5.0 Programmer's Reference
Rod Stephens
Wrox, April 2014
ISBN: 9781118847282
Format: PDF, ePub
Our price: $32.99
Essential Algorithms: A Practical Approach to Computer Algorithms ePub (Adobe DRM) download by Rod Stephens
Essential Algorithms: A Practical Approach to Computer Algorithms
Rod Stephens
Wiley, July 2013
ISBN: 9781118612101
Format: ePub, PDF
Our price: $48.99
MCSD Certification Toolkit (Exam 70-483): Programming in C# PDF (Adobe DRM) download by Tiberiu Covaci
MCSD Certification Toolkit (Exam 70-483): Programming in C#
Tiberiu Covaci & Rod Stephens & Vincent Varallo
Wrox, May 2013
ISBN: 9781118612095
Format: PDF, ePub
List Price: $41.99 Our price: $38.99
Visual Basic 2012 Programmer's Reference ePub (Adobe DRM) download by Rod Stephens
Visual Basic 2012 Programmer's Reference
Rod Stephens
Wrox, August 2012
ISBN: 9781118314074
Format: ePub, PDF
List Price: $31.99 Our price: $29.99