Ebook Free Database Concepts (5th Edition), by David M. Kroenke, David J. Auer
If you ally need such a referred Database Concepts (5th Edition), By David M. Kroenke, David J. Auer book that will provide you value, get the very best seller from us now from lots of preferred publishers. If you wish to entertaining publications, lots of novels, tale, jokes, and also much more fictions compilations are likewise launched, from best seller to one of the most recent released. You may not be puzzled to enjoy all book collections Database Concepts (5th Edition), By David M. Kroenke, David J. Auer that we will certainly offer. It is not regarding the prices. It's about exactly what you require currently. This Database Concepts (5th Edition), By David M. Kroenke, David J. Auer, as one of the very best vendors right here will be one of the best selections to review.
Database Concepts (5th Edition), by David M. Kroenke, David J. Auer
Ebook Free Database Concepts (5th Edition), by David M. Kroenke, David J. Auer
New updated! The Database Concepts (5th Edition), By David M. Kroenke, David J. Auer from the best author and also publisher is currently available right here. This is guide Database Concepts (5th Edition), By David M. Kroenke, David J. Auer that will make your day checking out ends up being completed. When you are looking for the published book Database Concepts (5th Edition), By David M. Kroenke, David J. Auer of this title in guide establishment, you may not find it. The issues can be the minimal editions Database Concepts (5th Edition), By David M. Kroenke, David J. Auer that are given up guide store.
When some individuals looking at you while checking out Database Concepts (5th Edition), By David M. Kroenke, David J. Auer, you could really feel so pleased. But, instead of other individuals feels you must instil in on your own that you are reading Database Concepts (5th Edition), By David M. Kroenke, David J. Auer not due to that factors. Reading this Database Concepts (5th Edition), By David M. Kroenke, David J. Auer will certainly provide you greater than people admire. It will guide to understand more than individuals looking at you. Even now, there are lots of resources to learning, checking out a book Database Concepts (5th Edition), By David M. Kroenke, David J. Auer still ends up being the front runner as a wonderful way.
Why should be reading Database Concepts (5th Edition), By David M. Kroenke, David J. Auer Once more, it will certainly rely on just how you really feel as well as think about it. It is certainly that of the advantage to take when reading this Database Concepts (5th Edition), By David M. Kroenke, David J. Auer; you can take a lot more lessons straight. Even you have actually not undertaken it in your life; you could obtain the experience by reading Database Concepts (5th Edition), By David M. Kroenke, David J. Auer As well as currently, we will introduce you with the on the internet publication Database Concepts (5th Edition), By David M. Kroenke, David J. Auer in this internet site.
What kind of book Database Concepts (5th Edition), By David M. Kroenke, David J. Auer you will like to? Now, you will not take the published book. It is your time to obtain soft documents publication Database Concepts (5th Edition), By David M. Kroenke, David J. Auer rather the published files. You can appreciate this soft documents Database Concepts (5th Edition), By David M. Kroenke, David J. Auer in at any time you anticipate. Also it remains in anticipated location as the other do, you could read guide Database Concepts (5th Edition), By David M. Kroenke, David J. Auer in your gadget. Or if you want a lot more, you could keep reading your computer or laptop to obtain full screen leading. Juts locate it right here by downloading and install the soft documents Database Concepts (5th Edition), By David M. Kroenke, David J. Auer in link web page.
Understand, create, and manage small databases.
Written by two of the world's leading database authorities, Database Concepts introduces the essential concepts readers need to create and use small databases.
The fifth edition has been thoroughly revised to reflect the changes in Microsoft® Access 2010, as well as other database management software.
- Sales Rank: #722282 in Books
- Published on: 2010-08-04
- Original language: English
- Number of items: 1
- Dimensions: 10.74" h x .64" w x 8.62" l, 1.90 pounds
- Binding: Paperback
- 480 pages
From the Back Cover
A Database text that all beginning students can use
At some point in business—or for a personal project...
You will need more than just a spreadsheet to do your job
You will want to run detailed reports
You will need to understand how to use one of many database programs
Are you ready?
With Database Concepts, by David M. Kronke, you will be.
You will learn:
Fundamentals of the relational model
Structured Query Language (SQL)
Data modeling
Database design
Database administration
...to do your job well.
Learn it here,
with Database Concepts, by David M. Kroenke www.prenhall.com/kroenke.
For further exploration and reinforcement.
About the Author
David M. Kroenke is one of the pioneers of database technology In 1971, while working at the Pentagon, he programmed one of the world's first database management system (DBMS) products. In 1974 Grace Hopper appointed him to the CODAYSL EUF committee, and in 1977 he worked as ,a consultant for Fred Brooks at IBM. Kroenke helped to start the Microrim Corporation, where he led the development of the R:base family of DBMS products. In a 1991 article, Wayne Ratliff credited one of Kroenke's textbooks for giving him the idea for the development of d:base. In 1989 Kroenke consulted Microsoft on the project that led to the development of Microsoft Access. He is also the father of the semantic object model, a data model that many believe is superior to the entity-relationship model.
Kroenke is the author of five computer textbooks; his text Database Processing was first published in 1977 and is currently in its eighth edition. In 1990 and 1991 he was the Hanson Professor of Management Science at the University of Washington. In that same year the International Association for Computer Information Systems named him Computer Educator of the Year. He holds a B.S. in economics from the U.S. Air Force Academy, an M.S. in management science from the University of Southern California, and a Ph.D. from Colorado State University where he studied linear models under Franklin Graybill.
Excerpt. © Reprinted by permission. All rights reserved.
Colin Johnson is a production supervisor for a small manufacturer in Seattle. Several years ago Colin wanted to build a database to keep track of components in product packages. At the time he was using a spreadsheet to perform this task, but he could not get the reports that he needed from the spreadsheet. Colin had heard about Microsoft Access, and he tried to use it to solve his problem. After several days of frustration, he bought several popular Access books and attempted to learn from them. Ultimately, he gave up and hired a consultant who built an application that more or less met Colin's needs. Over time Colin wanted to change his application, but he did not dare try.
Colin was a successful businessperson who was highly motivated to achieve his goals. A seasoned Windows user, he had been able to teach himself how to use Excel, PowerPoint, and a numl7er of production-oriented application packages. He was flummoxed at his inability to use Access to solve his problem. "I'm sure I could do it, but I just don't have any more time to invest:" This story is even more remarkable because it has occurred tens of thousands of times over the last decade.
Microsoft Corporation, Oracle Corporation, and other database management system (DBMS) vendors are aware of such scenarios and have invested millions of dollars in creating better graphical interfaces, hundreds of multi-panel wizards, and many sample applications. Unfortunately such efforts treat the symptom and not the cause. In fact, most users have no clear idea of what wizards are doing on their behalf. As soon as these users require changes to database structure or to components such as forms and queries, they drown in a sea of complexity for which they are unprepared. With little understanding of the underlying fundamentals, these users grab at any straw that appears to lead in the direction they want. The consequence is poorly designed databases and applications that fail to meet the users' requirements.
Why can people like Colin learn a word processor or a spreadsheet product, yet fail when trying to learn to use a DBMS product? For one, the underlying database concepts are unnatural to most people. Whereas everyone knows what paragraphs and margins are, no one knows what a relation is. Also, it seems like using a DBMS product ought to be easier than it is. "All I want to do is keep track of something. Why is it so hard?" Without knowledge of the relational model, breaking a sales invoice into five separate tables before storing the data is mystifying to business users.
The Need for Essential ConceptsThe truth is that with today's technology it is impossible to successfully utilize a DBMS without learning fundamental concepts. After years of developing databases with business users, I believe that the following database concepts are essential:
- Fundamentals of the relational model
- Structured Query Language (SQL)
- Data modeling
- Database design
- Database administration
Users like Colin—and students who will accept jobs similar to his—need not learn these topics to the same depth as do future information systems professionals. Consequently, this textbook presents only essential concepts—those that are necessary for users like Colin to create and use small databases. I have rewritten, simplified, and omitted topics that you will find in my in-depth book on the subject, Database Processing. In this process, however, I have endeavored to ensure that the discussions remain accurate and do not mislead. There is nothing here that students will need to unlearn if they take more advanced database courses.
Teaching Concepts Independent of DBMS ProductsThis book does not assume that any particular DBMS product will be used by students. Access is introduced in the Appendix, but all of the concepts are presented in a DBMS-agnostic manner. When learned this way, students come to understand that the fundamentals pertain to any database—from the smallest Access database to the largest Oracle or DB2 database.
Moreover, this approach avoids a common pitfall. When concepts and products are taught at the same time, students frequently confound concepts with product features and functions. For example, consider referential integrity constraints. When taught from a conceptual standpoint, students learn that there are times when the values of a column in one table must always be present as values of a column in a second table. Students will also learn how this constraint arises in the context of relationship definition and how either the DBMS or the application must enforce this constraint. If taught in the context of a DBMS—say in the context of Access—students will only learn that in some cases you check a check box, and in other cases you don't. There is a danger that the underlying concept will be lost in the product feature.
All of this is not to say, however, that a DBMS should not be used in this class. On the contrary, students can best master these concepts by applying them using a commercial DBMS product. This book was written assuming that you will use a second book or other materials to teach the features and functions of the DBMS that you select for your class. Prentice-Hall provides a number of companion workbooks for Microsoft Access 2002 that may be packaged with this text. These include Essentials: Access 2002, Level 1, by Dawn Parrish Wood; Exploring Microsoft Access 2002, Comprehensive, by Robert Grauer and Mary Ann Barber; Learn Access 2002, Volume 1, by John Preston, Sally Preston, and Robert Ferrett; and Select: Microsoft Access 2002, Volume 1, by Pamela R. Toliver.
Review Questions, Exercises, and ProjectsBecause it is so important for students to apply the concepts that they learn, each chapter is concluded with sets of review questions, exercises, and two projects that run throughout the book. Students should be able to answer the review questions if they have read and understood the chapter material. The exercises require the students to apply the chapter concepts to a small problem or task.
The first of the projects, Garden Glory, concerns the development and use of a database for a partnership that provides gardening and yard maintenance services to individuals and organizations. The second project, James River jewelry addresses the need for a database to support a frequent buyer program for a retail store. Both of these projects appear in all of the book's chapters and the Appendix. In each instance, students are asked to apply concepts from the chapter to the project. Instructors will find more information on the use of these projects in the instructor's manual and can obtain databases and data from the instructor's portion of our Web site (www.prenhall.com/kroenke).
Book OverviewThis textbook consists of six chapters and an appendix. The purpose of Chapter 1 is to explain why databases are used, what their components are, and how they are developed. Students will learn the purpose of databases and their applications and how databases differ from and improve on keeping lists in spreadsheets. Chapter 2 introduces the relational model and defines basic relational terminology It also introduces the fundamental ideas that underlie normalization and sets the stage for further discussion ,of this important topic in Chapter 5.
Chapter 3 presents fundamental SQL statements. Basic SQL statements for data definition are described, as are SQL SELECT and data modification statements. No attempt is made to present advanced SQL statements; only the essential statements are described.
The next three chapters consider database design and management. Chapter 4 addresses data modeling using the entity-relationship (E-R) model. The need for data modeling is described, basic E-R terms and concepts are introduced, and a short case application of E-R modeling is presented. Chapter 5 describes database design and explains the essentials of normalization. The data model from the case example in Chapter 4 is transformed into a relational design in Chapter 5.
Finally in Chapter 6 database administration is discussed. This chapter describes the need for database administration and surveys concurrency control, security, and backup and recovery techniques. I believe this topic is important for all databases, even for personal, single-user databases. In fact, in some ways this topic is more important for such databases because there will be no professional database administrator to ensure that critical tasks are performed.
Finally Microsoft Access is introduced in the Appendix. This brief introduction can be used in conjunction with Access documentation to help students create simple databases and application components.
Most helpful customer reviews
16 of 19 people found the following review helpful.
This book fills a crucial gap
By jasonlovesjazz
So you know how to use your database software, but do you know how to design a good database?
I got lucky when I found this book. I'd been building a database myself after taking a class on MS Access at my local community college. MS Access is so easy to use that I was comfortable and confident. I'd built many related tables and built several queries, forms and reports. No problems. Everything was working fine.
But with each element I added, I got less confident about the DESIGN of my ever-growing database. It was working fine, but were the tables and relationships optimal? As it grew more complex, was I going to make a mistake? Or find a fundamental flaw in my early assumptions? Classes and tutorials on database programs cover design concepts so briefly because they need to cover a lot of details about how to use the program. This book does the exact opposite. It glosses over how to use your software and focuses on design concepts. In the preface, the author says:
"This book does not assume that any particular DBMS [database management system] product will be used [... so ...] all of the concepts are presented in a DBMS-agnostic manner. When learned this way, students come to understand that the fundamentals pertain to any database [...]"
This is why it's shorter than some reviewers seem to think it should be. It isn't "too short." It's "focused." There are plenty of other books that cover the other stuff. This book is clear, concise and accessible. I'm glad it didn't go into more technical details.
It focuses on database fundamentals, design and administration by explaining what each of the following concepts mean and why they're so important: the relational model, normalization, functional dependencies, data modeling, entity-relation model, client-server model, DBA, concurrency control, security, backup and recovery, and even a bit about SQL (the computer language behind your DBMS). You can skip the SQL chapter if you want. I did.
Final word: This book is a quick read and easy to understand. It is a bit pricey, but if it fills a crucial gap in your knowledge, like it did for me, it's well worth the price.
17 of 21 people found the following review helpful.
Great introductory book, horrible price
By A. Taylor
This is by far the best introductory database book I have ever read or used.
Pro
It is written in very clear English.
It covers the basics of database design very well.
It is not overly technical.
One of the best treatments of normalization I have ever seen.
The exercises at the end of each chapter are well thought out.
Con
The book cost way too much ($60) for an introductory textbook.
The use of the term "theme" was changed to "topic" in the 2nd edition. The editing was faulty and the book only defines topic but used both theme and topic. Not a big deal if you used the first edition and know they mean the same thing but it is confusing to students when the book uses the terms interchangably without defining theme.
This is not a reference for database programmers. If you already understand ERD's and normalization don't buy this book it is meant to be an introduction to database basics not a shelf reference.
I like that the does not cover a lot of history. If you want to know a lot about Codd and the evolution of the different normal forms this is not the book for you. If you want a good introduction to databases for a non-technical class this is the best book you will find in my opinion.
4 of 4 people found the following review helpful.
Disorganized and Inconvenient
By Tyler T. Vidricksen
The book has useful information in it, but, as a learning and reference tool, it is very poorly structured. If you know absolutely nothing about databases and plan on completing all the end of chapter exercises from chapter 1 until the very last chapter, then this book is worth 3 stars (average at best). However, if you are taking a college course which doesn't follow this linear structure and have the need to jump around the textbook to complete your homework, this book is a nightmare. It is a nightmare because all of the end of chapter exercises require that you have a partially built Access 2010 or SQL Server database from a previous chapters' exercise. So if you need to learn a specific topic from a specific chapter, you are required to have completed nearly every chapter exercise prior to the lesson of interest. (In case you are wondering, no there aren't online resources which allow you download the needed exercise files).
As I use this book, I consistently find myself being frustrated with how much time I am wasting in order to just begin my homework assignments. Until an edition of this textbook develops a modular, standalone chapter structure, avoid it.
Database Concepts (5th Edition), by David M. Kroenke, David J. Auer PDF
Database Concepts (5th Edition), by David M. Kroenke, David J. Auer EPub
Database Concepts (5th Edition), by David M. Kroenke, David J. Auer Doc
Database Concepts (5th Edition), by David M. Kroenke, David J. Auer iBooks
Database Concepts (5th Edition), by David M. Kroenke, David J. Auer rtf
Database Concepts (5th Edition), by David M. Kroenke, David J. Auer Mobipocket
Database Concepts (5th Edition), by David M. Kroenke, David J. Auer Kindle
Tidak ada komentar:
Posting Komentar