عنوان

Database concepts /

013460153X

9780134601533

Database concepts /

[Book]

David M. Kroenke, David J. Auer, Western Washington University, Scott L. Vandenberg, Siena College, Robert C. Yoder, Siena College.

Eighth edition.

NY, NY :

Pearson,

[2017]

©2017

xvi, 560 pages :

color illustrations ;

28 cm

Includes index.

Includes bibliographical references and index.

PART 1 DATABASE FUNDAMENTALS -- 1 Getting Started -- The Importance Of Databases In The Internet And Mobile App World -- Why Use A Database? -- What Are The Problems With Using Lists? -- Using Relational Database Tables -- How Do I Process Relational Tables' -- What Is A Database System? Personal Versus Enterprise-Class Database Systems -- What Is A Web Database Application? -- What Are Data Warehouses And Business Intelligence (BI) Systems? -- What Is Big Data? -- What Is Cloud Computing? -- The Access Workbench Section 1 Getting Started With Microsoft Access -- 2 The Relational Model -- Relations -- Types Of Keys -- The Problem Of Null Values -- To Key Or Not To Key---that Is The Question! -- Functional Dependencies And Normalization -- The Access Workbench Section 2 Working With Multiple Tables In Microsoft Access -- Regional Labs Case Questions -- 3 Structured Query Language -- Wedgewood Pacific -- SQL For Data Definition (DDL)---Creating Tables And Relationships -- SQL For Data Manipulation (DML)---Inserting Data -- SQL For Data Manipulation (DML)---Single Table Queries -- Submitting SQL Statements To The DBMS -- SQL Enhancements For Single Table Queries -- SQL Queries That Perform Calculations -- Grouping Rows Using SQL Select Statements -- SQL For Data Manipulation (DML)---multiple Table Queries -- SQL For Data Manipulation (DML)---data Modification And Deletion -- SQL For Data Definition (DDL)---Table And Constraint Modification And Deletion -- SQL Views -- The Access Workbench Section 3 Working With Queries In Microsoft Access -- PART 2 DATABASE DESIGN -- 4 Data Modeling And The Entity-Relationship Model -- Requirements Analysis -- The Entity-Relationship Data Model -- Entity-Relationship Diagrams -- Developing An Example E-R Diagram -- The Access Workbench Section 4 Prototyping Using Microsoft Access -- 5 Database Design -- The Purpose Of A Database Design -- Transforming A Data Model Into A Database Design -- Representing Entities With The Relational Model -- Representing Relationships -- The Access Workbench Section 5 Relationships In Microsoft Access -- PART 3 DATABASE MANAGEMENT -- 6 Database Administration --The Need For Control, Security, And Reliability -- Concurrency Control -- SQL Transaction Control Language And Declaring Lock Characteristics -- Cursor Types -- Database Security -- Database Backup And Recovery -- Additional DBA Responsibilities -- The Access Workbench Section 6 Database Administration In Microsoft Access -- 7 Database Processing Applications -- A Web Database Application For Heather Sweeney Designs -- The Web Database -- Processing Environment -- Database Server Access Standards -- Database Processing, XML And JSON -- The Access Workbench Section 7 Web Database Processing Using Microsoft Access -- 8 Data Warehouses, Business Intelligence Systems, And Big Data -- Business Intelligence Systems -- The Relationship Between Operational And BL Systems -- Reporting Systems And Data Mining Applications -- Data Warehouses And Data Marts -- OLAP -- Distributed Database Processing -- Object-Relational Databases -- Virtulization -- Cloud Computing -- Big Data And The Not Only SQL Movement -- The Access Workbench Section 8 Business Intelligence Systems Using Microsoft ACCESS.

0

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. -- Provided by publisher.

Database management.

Relational databases.

Database management.

Relational databases.

Kroenke, David M.,1946-

Auer, David J.

Vandenberg, Scott L.

Yoder, Robert C.

20200822085857.0

rda

[Book]

Y