Beginning Database Design Solutions

3.77 avg rating
( 43 ratings by Goodreads )
 
9780470385494: Beginning Database Design Solutions
View all copies of this ISBN edition:
 
 

This book is intended for IT professionals and students who want tolearn how to design, analyze, and understand databases. Thematerial will benefit those who want a better high-levelunderstanding of databases such as proposal managers, architects,project managers, and even customers. The material will alsobenefit those who will actually design, build, and work withdatabases such as database designers, database administrators, andprogrammers. In many projects, these roles overlap so the sameperson may be responsible for working on the proposal, managingpart of the project, and designing and creating the database.

This book is aimed at IT professionals and students of allexperience levels. It does not assume that you have any previousexperience with databases or programs that use them. Itdoesn’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 adatabase’s structure so the database will be robust,resistant to errors, and flexible enough to accommodate areasonable amount of future change. It explains how to discoverdatabase requirements, build data models to study data needs, andrefine those models to improve the database’seffectiveness.

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

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

This book explains database design. It tells how to determinewhat should go in a database and how the database should bestructured to give the best results.

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

"synopsis" may belong to another edition of this title.

From the Back Cover:

Beginning Database Design Solutions

Databases play a critical role in the business operations ofmost organizations; they're the central repository for criticalinformation on products, customers, suppliers, sales, and a host ofother essential information. It's no wonder that the majority ofall business computing involves database applications.

With so much at stake, you'd expect most IT professionals wouldhave a firm understanding of good database design. But in fact mostlearn through a painful process of trial and error, withpredictably poor results.

This book provides readers with proven methods and tools fordesigning efficient, reliable, and secure databases. Author RodStephens explains how a database should be organized to ensure dataintegrity without sacrificing performance. He shares procedures fordesigning robust, flexible, and secure databases that provide asolid foundation for all of your database applications. The methodsand techniques in this book can be applied to any databaseenvironment, including Oracle®, Microsoft Access®, SQLServer®, and MySQL®. You'll learn the basics of gooddatabase design and ultimately discover how to design a real-worlddatabase.?

What you will learn from this book

  • How to identify database requirements that meet users' needs

  • Ways to build data models using a variety of modelingtechniques, including entity-relational models, user-interfacemodels, and semantic object models

  • Tips for understanding the different types of databases,including relational databases, flat files, spreadsheets, XML andobject databases

  • How to refine and tune the design to improve databaseperformance

  • Techniques for understanding the relationship between goodapplication design and database design

  • Methods for designing flexible and robust databases that canadapt to business change and growth

  • Ways to design for ease of maintenance and support

  • How to avoid common database design mistakes

Who this book is for

This book is for anyone interested in learning to design, build,analyze, and understand databases. No previous experience withdatabases or programs is required.

Wrox Beginning guides are crafted to make learning programminglanguages and technologies easier than you think, providing astructured, tutorial format that will guide you through all thetechniques involved.

About the Author:

Rod Stephens is a professional software developer who has built a wide variety of software and database applications in his 20-year career. He is the author of 18 books and more than 250 articles, and is a regular contributor to DevX.com (www.devx.com). Rod's clear, compelling writing makes it easy for less experienced readers to master new material. His current position as an adjunct instructor for ITT Technical institute has given him additional insight into the kinds of discussion, examples, and exercises that students find most helpful.

"About this title" may belong to another edition of this title.

Other Popular Editions of the Same Title

9788126519170: Beginning Database Design Solutions

Featured Edition

ISBN 10:  8126519177 ISBN 13:  9788126519170
Publisher: Wiley India Private Limited, 2008
Softcover

Top Search Results from the AbeBooks Marketplace

International Edition
International Edition

1.

Rod Stephens
ISBN 10: 0470385499 ISBN 13: 9780470385494
New Softcover First Edition Quantity Available: > 20
International Edition
Seller:
LowPriceBookDeals
(Wilmington, DE, U.S.A.)
Rating
[?]

Book Description Softcover. Condition: New. 1st edition. Brand NEW, Paperback International Edition. Black & White or color, Cover and ISBN may be different but similar contents as US editions. Standard delivery takes 5-9 business days by USPS/DHL with tracking number. Choose expedited shipping for superfast delivery 3-5 business days by UPS/DHL/FEDEX. We also ship to PO Box addresses but by Standard delivery and shipping charges will be extra. International Edition Textbooks may bear a label -Not for sale in the U.S. or Canada- etc. printed only to discourage U.S. students from obtaining an affordable copy. Legal to use despite any disclaimer on cover as per US court. No access code or CD included unless specified. In some instances, the international textbooks may have different exercises at the end of the chapters. Printed in English. We may ship the books from multiple warehouses across the globe, including India depending upon the availability of inventory storage. In case of orders from Europe, custom charges may comply by the relevant government authority and we are not liable for it. 100% Customer satisfaction guaranteed! Please feel free to contact us for any queries. Seller Inventory # AB_US_1424131

More information about this seller | Contact this seller

Buy New
US$ 14.52
Convert currency

Add to Basket

Shipping: US$ 3.95
Within U.S.A.
Destination, rates & speeds
International Edition
International Edition

2.

Stephens
ISBN 10: 0470385499 ISBN 13: 9780470385494
New Paperback Quantity Available: 1
International Edition
Seller:
Nick Book House
(Fresno, CA, U.S.A.)
Rating
[?]

Book Description Paperback. Condition: New. New, Softcover International Edition, Printed in Black and White, Only USPS Media mail Shipping ONLY, Different ISBN, Same Content As US edition, Book Cover may be Different, in English Language. Seller Inventory # 4600

More information about this seller | Contact this seller

Buy New
US$ 18.65
Convert currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, rates & speeds

3.

Rod Stephens
Published by John Wiley and Sons
ISBN 10: 0470385499 ISBN 13: 9780470385494
New Quantity Available: > 20
Seller:
INDOO
(Avenel, NJ, U.S.A.)
Rating
[?]

Book Description John Wiley and Sons. Condition: New. Brand New. Seller Inventory # 0470385499

More information about this seller | Contact this seller

Buy New
US$ 24.93
Convert currency

Add to Basket

Shipping: US$ 3.60
Within U.S.A.
Destination, rates & speeds

4.

Stephens, Rod
Published by Wrox Press 11/1/2008 (2008)
ISBN 10: 0470385499 ISBN 13: 9780470385494
New Paperback or Softback Quantity Available: 5
Seller:
BargainBookStores
(Grand Rapids, MI, U.S.A.)
Rating
[?]

Book Description Wrox Press 11/1/2008, 2008. Paperback or Softback. Condition: New. Beginning Database Design Solutions. Book. Seller Inventory # BBS-9780470385494

More information about this seller | Contact this seller

Buy New
US$ 30.82
Convert currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, rates & speeds

5.

Stephens, Rod
ISBN 10: 0470385499 ISBN 13: 9780470385494
New Quantity Available: > 20
Seller:
Paperbackshop-US
(Wood Dale, IL, U.S.A.)
Rating
[?]

Book Description 2008. PAP. Condition: New. New Book. Shipped from US within 10 to 14 business days. Established seller since 2000. Seller Inventory # IB-9780470385494

More information about this seller | Contact this seller

Buy New
US$ 26.94
Convert currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, rates & speeds

6.

Stephens, Rod
Published by Wrox
ISBN 10: 0470385499 ISBN 13: 9780470385494
New PAPERBACK Quantity Available: > 20
Seller:
Mediaoutlet12345
(Springfield, VA, U.S.A.)
Rating
[?]

Book Description Wrox. PAPERBACK. Condition: New. 0470385499 *BRAND NEW* Ships Same Day or Next!. Seller Inventory # NATARAJB1FI934504

More information about this seller | Contact this seller

Buy New
US$ 27.70
Convert currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, rates & speeds

7.

Rod Stephens
Published by John Wiley & Sons Inc, United States (2008)
ISBN 10: 0470385499 ISBN 13: 9780470385494
New Paperback First Edition Quantity Available: 10
Seller:
Book Depository International
(London, United Kingdom)
Rating
[?]

Book Description John Wiley & Sons Inc, United States, 2008. Paperback. Condition: New. 1. Auflage. Language: English. Brand new Book. 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 on deciding which kind of database might be best for a particular project.* "Relational Dat. Seller Inventory # AAH9780470385494

More information about this seller | Contact this seller

Buy New
US$ 32.89
Convert currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, rates & speeds

8.

Rod Stephens
Published by John Wiley & Sons Inc, United States (2008)
ISBN 10: 0470385499 ISBN 13: 9780470385494
New Paperback First Edition Quantity Available: 10
Seller:
The Book Depository
(London, United Kingdom)
Rating
[?]

Book Description John Wiley & Sons Inc, United States, 2008. Paperback. Condition: New. 1. Auflage. Language: English. Brand new Book. 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. 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. Seller Inventory # AAH9780470385494

More information about this seller | Contact this seller

Buy New
US$ 33.88
Convert currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, rates & speeds

9.

Stephens, Rod
Published by Wrox
ISBN 10: 0470385499 ISBN 13: 9780470385494
New PAPERBACK Quantity Available: 1
Seller:
Qwestbooks COM LLC
(Bensalem, PA, U.S.A.)
Rating
[?]

Book Description Wrox. PAPERBACK. Condition: New. 0470385499. Seller Inventory # Z0470385499ZN

More information about this seller | Contact this seller

Buy New
US$ 34.08
Convert currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, rates & speeds

10.

Stephens, Rod
Published by Wrox
ISBN 10: 0470385499 ISBN 13: 9780470385494
New PAPERBACK Quantity Available: 1
Seller:
Best Bates
(Bensalem, PA, U.S.A.)
Rating
[?]

Book Description Wrox. PAPERBACK. Condition: New. 0470385499. Seller Inventory # Z0470385499ZN

More information about this seller | Contact this seller

Buy New
US$ 34.08
Convert currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, rates & speeds

There are more copies of this book

View all search results for this book