Muutke küpsiste eelistusi

Database Concepts 8th edition [Pehme köide]

  • Formaat: Paperback / softback, 576 pages, kõrgus x laius x paksus: 272x218x18 mm, kaal: 1170 g
  • Ilmumisaeg: 16-May-2019
  • Kirjastus: Pearson
  • ISBN-10: 013460153X
  • ISBN-13: 9780134601533
  • Formaat: Paperback / softback, 576 pages, kõrgus x laius x paksus: 272x218x18 mm, kaal: 1170 g
  • Ilmumisaeg: 16-May-2019
  • Kirjastus: Pearson
  • ISBN-10: 013460153X
  • ISBN-13: 9780134601533

For undergraduate database management students or business professionals

 

Here’s practical help for understanding, creating, and managing small databases—from two of the world’s leading database authorities. Database Concepts gives undergraduate database management students and business professionals alike a firm understanding of the concepts behind the software, using Access 2016 to illustrate the concepts and techniques. Three projects run throughout the text, to show students how to apply the concepts to real-life business situations. The text provides flexibility for choosing the software instructors want to use in class; allows students to work with new, complete databases, including Wedgewood Pacific, Heather Sweeney Designs, and Wallingford Motors; and includes coverage for some of the latest information on databases available.

 

Teaching and Learning Experience
This text will provide a better teaching and learning experience–for you and your students. Here's how:

  • Provides a firm understanding of the concepts behind the software

  • Uses Access 2013 to illustrate the concepts and techniques while also providing flexibility to choose the software used in class

  • Allows students to work with new, complete databases

  • Includes coverage of some of the latest information available

PART 1 DATABASE FUNDAMENTALS
1(262)
1 Getting Started
3(67)
The Importance Of Databases In The Internet And Mobile App World
4(3)
Why Use A Database?
7(1)
What Are The Problems With Using Lists?
7(3)
Using Relational Database Tables
10(6)
How Do I Process Relational Tables'
16(2)
What Is A Database System?
18(5)
Personal Versus Enterprise-Class Database Systems
23(6)
What Is A Web Database Application?
29(1)
What Are Data Warehouses And Business Intelligence (BI) Systems?
29(1)
What Is Big Data?
30(1)
What Is Cloud Computing?
30(1)
The Access Workbench Section 1 Getting Started With Microsoft Access
31(39)
Summary
61(1)
Key Terms
62(1)
Review Questions
62(2)
Exercises
64(1)
Access Workbench Key Terms
65(1)
Access Workbench Exercises
65(2)
San Juan Sailboat Charters Case Questions
67(1)
Garden Glory Project Questions
68(1)
James River Jewelry Project Questions
69(1)
The Queen Anne Curiosity Shop Project Questions
69(1)
2 The Relational Model
70(63)
Relations
70(4)
Types Of Keys
74(9)
The Problem Of Null Values
83(1)
To Key Or Not To Key---that Is The Question!
84(1)
Functional Dependencies And Normalization
85(16)
The Access Workbench Section 2 Working With Multiple Tables In Microsoft Access
101(32)
Summary
119(1)
Key Terms
120(1)
Review Questions
120(2)
Exercises
122(2)
Access Workbench Key Terms
124(1)
Access Workbench Exercises
124(4)
Regional Labs Case Questions
128(1)
Garden Glory Project Questions
129(1)
James River Jewelry Project Questions
130(1)
The Queen Anne Curiosity Shop Project Questions
130(3)
3 Structured Query Language
133(130)
Wedgewood Pacific
134(7)
SQL For Data Definition (DDL)---Creating Tables And Relationships
141(14)
SQL For Data Manipulation (DML)---Inserting Data
155(4)
SQL For Data Manipulation (DML)---Single Table Queries
159(3)
Submitting SQL Statements To The DBMS
162(2)
SQL Enhancements For Single Table Queries
164(12)
SQL Queries That Perform Calculations
176(4)
Grouping Rows Using SQL Select Statements
180(3)
SQL For Data Manipulation (DML)---multiple Table Queries
183(14)
SQL For Data Manipulation (DML)---data Modification And Deletion
197(3)
SQL For Data Definition (DDL)---Table And Constraint Modification And Deletion
200(2)
SQL Views
202(1)
The Access Workbench Section 3 Working With Queries In Microsoft Access
202(40)
Summary
231(2)
Key Terms
233(1)
Review Questions
233(5)
Exercises
238(1)
Access Workbench Key Terms
239(1)
Access Workbench Exercises
239(3)
Heather Sweeney Designs Case Questions
242(21)
Garden Glory Project Questions
253(3)
James River Jewelry Project Questions
256(1)
The Queen Anne Curiosity Shop Project Questions
256(7)
PART 2 DATABASE DESIGN
263(100)
4 Data Modeling And The Entity-Relationship Model
265(52)
Requirements Analysis
266(1)
The Entity-Relationship Data Model
267(5)
Entity-Relationship Diagrams
272(10)
Developing An Example E-R Diagram
282(8)
The Access Workbench Section 4 Prototyping Using Microsoft Access
290(22)
Summary
308(1)
Key Terms
309(1)
Review Questions
309(2)
Exercises
311(1)
Access Workbench Key Terms
311(1)
Access Workbench Exercises
311(1)
High Line University Mentor Program Case Questions
312(2)
Writer's Patrol Case Questions
314(3)
Garden Glory Project Questions
315(1)
James River Jewelry Project Questions
315(1)
The Queen Anne Curiosity Shop Project Questions
315(2)
5 Database Design
317(46)
The Purpose Of A Database Design
318(1)
Transforming A Data Model Into A Database Design
318(1)
Representing Entities With The Relational Model
319(8)
Representing Relationships
327(13)
Database Design At Heather Sweeney Designs
340(8)
The Access Workbench Section 5 Relationships In Microsoft Access
348(12)
Summary
354(1)
Key Terms
355(1)
Review Questions
355(1)
Exercises
356(1)
Access Workbench Key Terms
357(1)
Access Workbench Exercises
357(1)
San Juan Sailboat Charters Case Questions
358(2)
Writer's Patrol Case Questions
360(3)
Garden Glory Project Questions
360(1)
James River Jewelry Project Questions
360(1)
The Queen Anne Curiosity Shop Project Questions
360(3)
PART 3 DATABASE MANAGEMENT
363(179)
6 Database Administration
365(57)
The Heather Sweeney Designs Database
366(1)
The Need For Control, Security, And Reliability
366(2)
Concurrency Control
368(6)
SQL Transaction Control Language And Declaring Lock Characteristics
374(4)
Cursor Types
378(2)
Database Security
380(7)
Database Backup And Recovery
387(4)
Additional DBA Responsibilities
391(1)
The Access Workbench Section 6 Database Administration In Microsoft Access
392(30)
Summary
412(1)
Key Terms
413(1)
Review Questions
414(1)
Exercises
415(1)
Access Workbench Key Terms
416(1)
Access Workbench Exercises
416(1)
Marcia's Dry Cleaning Case Questions
417(1)
Garden Glory Project Questions
418(1)
James River Jewelry Project Questions
419(1)
The Queen Anne Curiosity Shop Project Questions
420(2)
7 Database Processing Applications
422(66)
A Web Database Application For Heather Sweeney Designs
425(1)
The Web Database Processing Environment
425(4)
Database Server Access Standards
429(29)
Database Processing, XML And JSON
458(4)
The Access Workbench Section 7 Web Database Processing Using Microsoft Access
462(26)
Summary
478(1)
Key Terms
479(1)
Review Questions
479(2)
Exercises
481(2)
Access Workbench Exercises
483(1)
Marcia's Dry Cleaning Case Questions
483(2)
Garden Glory Project Questions
485(2)
James River Jewelry Project Questions
487(1)
The Queen Anne Curiosity Shop Project Questions
487(1)
8 Data Warehouses, Business Intelligence Systems, And Big Data
488(54)
Business Intelligence Systems
491(1)
The Relationship Between Operational And BL Systems
491(1)
Reporting Systems And Data Mining Applications
491(1)
Data Warehouses And Data Marts
492(11)
OLAP
503(4)
Distributed Database Processing
507(3)
Object-Relational Databases
510(1)
Virtulization
511(1)
Cloud Computing
511(2)
Big Data And The Not Only SQL Movement
513(5)
The Access Workbench Section 8 Business Intelligence Systems Using Microsoft ACCESS
518(24)
Summary
531(2)
Key Terms
533(1)
Review Questions
533(2)
Exercises
535(2)
Access Workbench Exercises
537(1)
Marcia's Dry Cleaning Case Questions
537(1)
Garden Glory Project Questions
538(1)
James River Jewelry Project Questions
539(1)
The Queen Anne Curiosity Shop Project Questions
539(3)
Glossary 542(11)
Index 553
David M. Kroenke entered  the computing profession as a summer intern at the RAND Corporation  in 1967. Since then, his career has spanned  education,  industry, consulting, and publishing.

He has taught at the University of Washington, Colorado State University, and Seattle University. Over the years, he has led dozens of teaching seminars for college professors. In 1991 the International Association of Information Systems named him Computer Educator of the Year.

In  industry,  Kroenke  has  worked  for  the  U.S. Air  Force  and  Boeing Computer Services, and he was a principal in the startup of three companies. He was also vice presi- dent of product  marketing and development for the Microrim Corporation  and was chief technologist for the database division of Wall Data, Inc. He is the father of the semantic object data model. Kroenkes consulting clients include IBM Corporation,  Microsoft, Computer Sciences Corporation,  and numerous other companies and organizations.

His text Database Processing: Fundamentals, Design, and Implementation,  first pub- lished in 1977, is now in its 14th edition (coauthored  with David Auer for the 11th, 12th, 13th, and 14th editions). He introduced  Database Concepts (now in the eighth edition that you are reading) in 2003. Kroenke has published many other textbooks, including the clas- sic Business Computer Systems (1981). Recently, he has authored  Using MIS (8th edition), Experiencing MIS  (6th  edition),  MIS  Essentials (4th  edition),  Processes, Systems  and Information: An Introduction to MIS (2nd edition) (coauthored  with Earl McKinney), and Essentials of Processes, Systems and Information (coauthored with Earl McKinney).

An avid sailor, Kroenke also wrote Know Your Boat: The Guide to Everything That Makes Your Boat Work. Kroenke lives in Seattle, Washington. He is married and has two children and three grandchildren.













David J. Auer is a Senior Instructor Emeritus at the College of Business (CBE) of Western Washington  University in  Bellingham, WA.  He  served  as the  director  of Information Systems and Technology Services at CBE from 1994 to 2014 and taught in CBEs Department  of Decision Sciences from 1981 to 2015. He has taught CBE courses in quan- titative methods, production  and operations management, statistics, finance, and manage- ment information systems. Besides managing CBEs computer,  network, and other technology resources, he also teaches management information  systems courses. He has taught the Principles of Management Information  Systems and Business Database Development courses, and he was responsible for developing CBEs network infrastructure courses, including Computer Hardware and Operating Systems, Telecommunications, and Network Administration.

 He  has  coauthored  several MIS-related  textbooks,  including  Database Processing: Fundamentals, Design, and Implementation, first published in 1977, is now in its 14th edi- tion (coauthored with David Kroenke for the 11th, 12th, 13th, and 14th editions), and Database Concepts, now  in  the  eighth  edition  that  you  are  reading  (coauthored  with David Kroenke for the 3rd, 4th, 5th, 6th, and 7th editions).

 Auer holds a bachelors degree in English literature from the University of Washington, a bachelors degree in mathematics  and economics from Western  Washington  University, a masters degree in economics from Western Washington University, and a masters degree in counseling psychology from Western Washington University. He served as a commissioned officer in the U.S. Air Force, and he has also worked as an organizational development specialist and therapist for an employee assistance program (EAP).

Auer and his wife, Donna, live in Bellingham, Washington. He has two children and four grandchildren.













Scott L. Vandenberg has been on the Computer Science faculty at Siena College since 1993, where he regularly teaches three different database courses at several levels to both computer science and business majors. Prior to arriving at Siena, he taught undergraduate and  graduate  courses in database  systems at the  University of MassachusettsAmherst. Since arriving at Siena, he also taught graduate and undergraduate  database courses at the University of WashingtonSeattle. He has developed five different database courses over this time. His other teaching experience includes introductory computer science, introduc- tory programming, data structures, management information systems, and three years teaching Sienas required interdisciplinary freshman writing course.

 Vandenbergs recent research publications are mainly in the areas of computer science education and data science applications, with earlier work on query optimization and alge- braic query languages. He holds a bachelors degree in mathematics and computer science from Cornell University and masters and PhD degrees in computer science from the University of WisconsinMadison. Medieval history and playing hockey are two things that can tear him away from a database. Vandenberg lives in Averill Park, NY, with his wife, Kristin, and two children.







Robert C. Yoder began his professional career at the University at Albany as a systems pro-grammer managing mainframes and Unix servers. He has two years of research experience working on 3-D solid modeling systems. Robert holds BS and MS degrees in computer science and a PhD in information science, all from the University at Albany.

 Yoder joined the Computer Science department at Siena College in 2001 and teaches Business Database, Management Information  Systems, Geographic  Information  Systems, Data Structures, Networks, and Operating Systems courses. Yoder lives in Niskayuna, NY, with his wife, Diane, and two children and enjoys traveling, hiking, and walking his dog.