عنوان

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