ENGLISH

Database concepts

By David M. Kroenke; David J. Auer; Robert C. Yoder; Scott L. Vandenberg (eds.)

Book information

Publisher
Pearson
Year
2017
ISBN
9780134601533, 013460153X
Language
english
Format
PDF
Filesize
54 MB (56228794 bytes)
Edition
8
Pages
\579
Library
RuTracker
Time added
2022-02-28 17:24:43

Description

Cover Title Page Copyright Page Brief Contents Contents Preface About the Authors Part 1: Database Fundamentals Chapter 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 Summary Key Terms Review Questions Exercises Access Workbench Key Terms Exercises San Juan Sailboat Charters Case Questions Garden Glory Project Questions James River Jewelry Project Questions The Queen Anne Curiosity Shop Project Questions Chapter 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 Summary Key Terms Review Questions Exercises Access Workbench Key Terms Exercises Regional Labs Case Questions Garden Glory Project Questions James River Jewelry Project Questions The Queen Anne Curiosity Shop Project Questions Chapter 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 Summary Key Terms Review Questions Exercises Access Workbench Key Terms Exercises Heather Sweeney Designs Case Questions Garden Glory Project Questions James River Jewelry Project Questions The Queen Anne Curiosity Shop Project Questions Part 2: Database Design Chapter 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 Summary Key Terms Review Questions Exercises Access Workbench Key Terms Exercises Highline University Mentor Program Case Questions Writer’s Patrol Case Questions Garden Glory Project Questions James River Jewelry Project Questions The Queen Anne Curiosity Shop Project Questions Chapter 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 Database Design at Heather Sweeney Designs The Access Workbench: Section 5: Relationships in Microsoft Access Summary Key Terms Review Questions Exercises Access Workbench Key Term Exercises San Juan Sailboat Charters Case Questions Writer’s Patrol Case Questions Garden Glory Project Questions James River Jewelry Project Questions The Queen Anne Curiosity Shop Project Questions Part 3: Database Management Chapter 6: Database Administration The Heather Sweeney Designs Database 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 Summary Key Terms Review Questions Exercises Access Workbench Key Terms Exercises Marcia’s Dry Cleaning Case Questions Garden Glory Project Questions James River Jewelry Project Questions The Queen Anne Curiosity Shop Project Questions Chapter 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 Summary Key Terms Review Questions Exercises Access Workbench Exercises Marcia’s Dry Cleaning Case Questions Garden Glory Project Questions James River Jewelry Project Questions The Queen Anne Curiosity Shop Project Questions Chapter 8: Data Warehouses, Business Intelligence Systems, and Big Data Business Intelligence Systems The Relationship Between Operational and BI Systems Reporting Systems and Data Mining Applications Data Warehouses and Data Marts OLAP Distributed Database Processing Object-Relational Databases Virtualization Cloud Computing Big Data and the not only SQL Movement The Access Workbench: Section 8: Business Intelligence Systems Using Microsoft Access Summary Key Terms Review Questions Exercises Access Workbench Exercises Marcia’s Dry Cleaning Case Questions Garden Glory Project Questions James River Jewelry Project Questions The Queen Anne Curiosity Shop Project Questions Online Appendices Glossary Index Back Cover

Similar books

Session C11: Ancient Cultural Landscapes in South Europe – their Ecological Setting and Evolution, Session C22: Gardeners from South America, Session S04: Agro-Pastoralism and Early Metallurgy Sessions, Session WS29: The Idea of Enclosure in Recent Iberian Prehistory, Session C88: Rhytmes et causalites des dynamiques de l'anthropisation en Europe entre 6500 ET 500 BC: Hypotheses socio-culturelles et/ou climatiques: Proceedings of the XV UISPP World Congress (Lisbon 4-9 September 2006) / Actes du XV Congrès Mondial (Lisbonne 4-9 Septembre 2006) Vol.36

Session C11: Ancient Cultural Landscapes in South Europe – their Ecological Setting and Evolution, Session C22: Gardeners from South America, Session S04: Agro-Pastoralism and Early Metallurgy Sessions, Session WS29: The Idea of Enclosure in Recent Iberian Prehistory, Session C88: Rhytmes et causalites des dynamiques de l'anthropisation en Europe entre 6500 ET 500 BC: Hypotheses socio-culturelles et/ou climatiques: Proceedings of the XV UISPP World Congress (Lisbon 4-9 September 2006) / Actes du XV Congrès Mondial (Lisbonne 4-9 Septembre 2006) Vol.36

2010 · PDF

THE BRITISH ARMY IN INDIA: ITS PRESERVATION BY AN APPROPRIATE CLOTHING, HOUSING, LOCATING, RECREATIVE EMPLOYMENT, AND HOPEFUL ENCOURAGEMENT OF THE TROOPS. with AN APPENDIX ON INDIA : THE CLIMATE OP ITS HILLS ; THE DEVELOPMENT OF ITS RESODRCBS, INDUSTRY, AND ARTS ; THE ADMINISTRATION OF JUSTICE ; THE BLACK ACT ; THE PROGRESS OF CHRISTIANITY ; THE TRAFFIC IN OPIUM ; THE VALUE OF INDIA ; PERMANENT CAUSES OF DISAFFECTION, AND OF THE RECENT REBELLION ; THE TRADITIONARY POLICY; MISGOVERNMENT BY NATIVE RULERS ; ANNEXATIONS OF THEIR TERRITORY, ETC.

THE BRITISH ARMY IN INDIA: ITS PRESERVATION BY AN APPROPRIATE CLOTHING, HOUSING, LOCATING, RECREATIVE EMPLOYMENT, AND HOPEFUL ENCOURAGEMENT OF THE TROOPS. with AN APPENDIX ON INDIA : THE CLIMATE OP ITS HILLS ; THE DEVELOPMENT OF ITS RESODRCBS, INDUSTRY, AND ARTS ; THE ADMINISTRATION OF JUSTICE ; THE BLACK ACT ; THE PROGRESS OF CHRISTIANITY ; THE TRAFFIC IN OPIUM ; THE VALUE OF INDIA ; PERMANENT CAUSES OF DISAFFECTION, AND OF THE RECENT REBELLION ; THE TRADITIONARY POLICY; MISGOVERNMENT BY NATIVE RULERS ; ANNEXATIONS OF THEIR TERRITORY, ETC.

1858 · PDF

Idries Shah 27 Books Collection : A Perfumed Scorpion, A Veiled Gazelle, Caravan of Dreams, Darkest England, Destination Mecca, Evenings with Idries Shah, Knowing How to Know, Learning How to Learn, Letters and Lectures of Idries Shah, Neglected aspects of Sufi study, Observations, Oriental Magic, Reflections, Seeker after Truth, Special Illumination, Special Problems in the study of Sufi ideas, Sufi thought and action, Tales of the Dervishes, The Dermis Probe, The Elephant in the Dark, The Englishman Handbook, Idries Shah Antology, The Magic Monastery, The natives are restless, wisdom of the Idiots PDF.

Idries Shah 27 Books Collection : A Perfumed Scorpion, A Veiled Gazelle, Caravan of Dreams, Darkest England, Destination Mecca, Evenings with Idries Shah, Knowing How to Know, Learning How to Learn, Letters and Lectures of Idries Shah, Neglected aspects of Sufi study, Observations, Oriental Magic, Reflections, Seeker after Truth, Special Illumination, Special Problems in the study of Sufi ideas, Sufi thought and action, Tales of the Dervishes, The Dermis Probe, The Elephant in the Dark, The Englishman Handbook, Idries Shah Antology, The Magic Monastery, The natives are restless, wisdom of the Idiots PDF.

2022 · PDF

The travels of Capts. Lewis and Clarke from St. Louis, by way of the Missouri and Columbia rivers, to the Pacific ocean; performed in the years 1804, 1805 & 1806, by order of the government of the United States. Containing delineations of the manners, customs, religion, &c. of the Indians, comp. from various authentic sources, and original documents, and a summary of the Statistical view of the Indian nations, from the official communication of Meriwether Lewis. Illustrated with a map of the country, inhabited by the western tribes of Indians

The travels of Capts. Lewis and Clarke from St. Louis, by way of the Missouri and Columbia rivers, to the Pacific ocean; performed in the years 1804, 1805 & 1806, by order of the government of the United States. Containing delineations of the manners, customs, religion, &c. of the Indians, comp. from various authentic sources, and original documents, and a summary of the Statistical view of the Indian nations, from the official communication of Meriwether Lewis. Illustrated with a map of the country, inhabited by the western tribes of Indians

1809 · PDF

Professional Linux kernel architecture ''Wrox programmer to programmer''--Cover. - ''What you are reading right now is the result of an evolution over more than seven years: After two years of writing, the first edition was published in German by Carl Hanser Verlag in 2003. It then described kernel 2.6.0. The test was used as a basis for the low-level design documentation for the EAL4+ security evaluation of Red Hat Enterprise Linux 5, requiring to update it to kernel 2.6.18 (if the EAL acronym does not mean anything to you, then Wikipedia is once more your friend). Hewlett-Packard sponsored the translation into English and has, thankfully, granted the rights to publish the result. Updates to kernel 2.6.24 were then performed specifically for this book''--P. ix

Professional Linux kernel architecture ''Wrox programmer to programmer''--Cover. - ''What you are reading right now is the result of an evolution over more than seven years: After two years of writing, the first edition was published in German by Carl Hanser Verlag in 2003. It then described kernel 2.6.0. The test was used as a basis for the low-level design documentation for the EAL4+ security evaluation of Red Hat Enterprise Linux 5, requiring to update it to kernel 2.6.18 (if the EAL acronym does not mean anything to you, then Wikipedia is once more your friend). Hewlett-Packard sponsored the translation into English and has, thankfully, granted the rights to publish the result. Updates to kernel 2.6.24 were then performed specifically for this book''--P. ix

2008 · PDF