Concepts of Database Management 8th Edition Pratt Solutions Manual

Roll over image to zoom in
Click to open expanded view

$26.99$50.00 (-46%)

In stock

Concepts of Database Management 8th Edition Pratt Solutions Manual.

Download sample

Categories: , Tags: , , , ,

You may also like

Concepts of Database Management 8th Edition Pratt Solutions Manual

Product Details:

  • ISBN-10 ‏ : ‎ 1285427106
  • ISBN-13 ‏ : ‎ 978-1285427102
  • Author:  Philip J. Pratt, Mary Z. Last

Delivering concise, cutting-edge coverage, CONCEPTS OF DATABASE MANAGEMENT, 8e uses real-world cases, examples, and illustrations to give students a thorough understanding of such critical issues as database design, data integrity, concurrent updates, data security, and more. Completely updated to Microsoft Access 2013 standards, the text presents SQL in a database-neutral environment and covers all major topics, including E-R diagrams, normalization, and database design. It provides detailed coverage of the relational model (including QBE and SQL), normalization and views, database administration and management, and more. Advanced topics covered include distributed databases, data warehouses, stored procedures, triggers, data macros, and Web Apps. Ideal for an introductory database course in an information systems, business, or CIS program, CONCEPTS OF DATABASE MANAGEMENT, 8e can be used in varying disciplines by instructors who want database coverage without using a trade book or a large academic book.

 

Table of Content:

  1. Ch 1: Introduction to Database Management
  2. TAL Distributors Background
  3. Database Background
  4. Database Management Systems
  5. Advantages of Database Processing
  6. Disadvantages of Database Processing
  7. Introduction to the Colonial Adventure Tours Database Case
  8. Introduction to the Solmaris Condominium Group Database Case
  9. Summary
  10. Key Terms
  11. Review Questions
  12. TAL Distributors Exercises
  13. Colonial Adventure Tours Case
  14. Solmaris Condominium Group Case
  15. Ch 2: The Relational Model 1: Introduction, QBE, and Relational Algebra
  16. Relational Databases
  17. Query-By-Example (QBE)
  18. Simple Queries
  19. Simple Criteria
  20. Compound Criteria
  21. Computed Fields
  22. Functions
  23. Grouping
  24. Sorting
  25. Joining Tables
  26. Using an Update Query
  27. Using a Delete Query
  28. Using a Make-Table Query
  29. Relational Algebra
  30. Summary
  31. Key Terms
  32. Review Questions
  33. TAL Distributors Exercises: QBE
  34. TAL Distributors Exercises: Relational Algebra
  35. Colonial Adventure Tours Case
  36. Solmaris Condominium Group Case
  37. Ch 3: The Relational Model 2: SQL
  38. Getting Started with SQL
  39. Table Creation
  40. Simple Retrieval
  41. Compound Conditions
  42. Computed Fields
  43. Using Special Operators (LIKE and IN)
  44. Sorting
  45. Built-In Functions
  46. Subqueries
  47. Grouping
  48. Joining Tables
  49. Union
  50. Updating Tables
  51. Creating a Table from a Query
  52. Summary of SQL Commands
  53. Summary
  54. Key Terms
  55. Review Questions
  56. TAL Distributors Exercises
  57. Colonial Adventure Tours Case
  58. Solmaris Condominium Group Case
  59. Ch 4: The Relational Model 3: Advanced Topics
  60. Views
  61. Indexes
  62. Security
  63. Integrity Rules
  64. Structure Changes
  65. System Catalog
  66. Stored Procedures
  67. Triggers
  68. Summary
  69. Key Terms
  70. Review Questions
  71. TAL Distributors Exercises
  72. Colonial Adventure Tours Case
  73. Solmaris Condominium Group Case
  74. Ch 5: Database Design 1: Normalization
  75. Functional Dependence
  76. Keys
  77. First Normal Form
  78. Second Normal Form
  79. Third Normal Form
  80. Incorrect Decompositions
  81. Multivalued Dependencies and Fourth Normal Form
  82. Avoiding the Problem with Multivalued Dependencies
  83. Application to Database Design
  84. Summary
  85. Key Terms
  86. Review Questions
  87. TAL Distributors Exercises
  88. Colonial Adventure Tours Case
  89. Solmaris Condominium Group Case
  90. Ch 6: Database Design 2: Design Method
  91. User Views
  92. Information-Level Design Method
  93. Database Design Examples
  94. Physical-Level Design
  95. Top-Down versus Bottom-Up Design
  96. Survey Form
  97. Obtaining Information from Existing Documents
  98. One-to-One Relationship Considerations
  99. Many-to-Many Relationship Considerations
  100. Nulls and Entity Subtypes
  101. Avoiding Problems with Third Normal Form When Merging Tables
  102. The Entity-Relationship Model
  103. Summary
  104. Key Terms
  105. Review Questions
  106. TAL Distributors Exercises
  107. Colonial Adventure Tours Case
  108. Solmaris Condominium Group Case
  109. Ch 7: DBMS Functions
  110. Update and Retrieve Data
  111. Provide Catalog Services
  112. Support Concurrent Update
  113. Recover Data
  114. Provide Security Services
  115. Provide Data Integrity Features
  116. Support Data Independence
  117. Support Data Replication
  118. Provide Utility Services
  119. Key Terms
  120. Review Questions
  121. TAL Distributors Exercises
  122. Colonial Adventure Tours Case
  123. Solmaris Condominium Group Case
  124. Ch 8: Database Administration
  125. Database Policy Formulation and Enforcement
  126. Other Database Administrative Functions
  127. Technical Functions
  128. Summary
  129. Key Terms
  130. Review Questions
  131. TAL Distributors Exercises
  132. Colonial Adventure Tours Case
  133. Solmaris Condominium Group Case
  134. Ch 9: Database Management Approaches
  135. Distributed Databases
  136. Characteristics of Distributed DBMSs
  137. Disadvantages of Distributed Databases
  138. Rules for Distributed Databases
  139. Client/Server Systems
  140. Web Access to Databases
  141. XML
  142. Data Warehouses
  143. Object-Oriented DBMSs
  144. Summary
  145. Key Terms
  146. Review Questions
  147. TAL Distributors Exercises
  148. Colonial Adventure Tours Case
  149. Solmaris Condominium Group Case
  150. Appendix A: Comprehensive Design Example: Marvel College
  151. Marvel College Requirements
  152. Marvel College Information-Level Design
  153. Final Information-Level Design
  154. Exercises
  155. Appendix B: SQL Reference
  156. Alter Table
  157. Column or Expression List (SELECT Clause)
  158. Conditions
  159. Create Index
  160. Create Table
  161. Create View
  162. Data Types
  163. Delete Rows
  164. Drop Index
  165. Drop Table
  166. Grant
  167. Insert
  168. Integrity
  169. Join
  170. Revoke
  171. Select
  172. Select Into
  173. Subqueries
  174. Union
  175. Update
  176. Appendix C: “How Do I” Reference
  177. Appendix D: Answers to Odd-Numbered Review Questions
  178. Chapter 1-Introduction to Database Management
  179. Chapter 2-The Relational Model 1: Introduction, QBE, and Relational Algebra
  180. Chapter 3-The Relational Model 2: SQL
  181. Chapter 4-The Relational Model 3: Advanced Topics
  182. Chapter 5-Database Design 1: Normalization
  183. Chapter 6-Database Design 2: Design Method
  184. Chapter 7-DBMS Functions
  185. Chapter 8-Database Administration
  186. Chapter 9-Database Management Approaches
  187. Appendix E: Using Access to Create a Web App
  188. Examining a Web App
  189. Table Restrictions for Web Apps
  190. Creating a Web App
  191. Creating a Table for a Web App
  192. Using Views in a Web App
  193. Viewing Data in a Web App
  194. Creating a New View for a Web App
  195. Creating a New Object in a Web App
  196. Running a Web App
  197. Showing a Relationship in List View
  198. Running a Web App from a Browser
  199. Creating a Summary View in a Web App
  200. Key Terms
  201. TAL Distributors Exercises
  202. Appendix F: A Systems Analysis Approach to Information-Level Requirements
  203. Information Systems
  204. System Requirement Categories
  205. Determining System Requirements
  206. Transitioning from Systems Analysis to Systems Design
  207. Key Terms
  208. Exercises
  209. Glossary
  210. Index

 

People Also Search:

concepts of database management pratt

concepts of database management 8th edition pratt

concepts of database management

concepts of database management 8th edition

concepts of database management 8th edition download scribd

concepts of database management 8th edition testbank download pdf

Concepts of Database Management 8th Edition Pratt Test Bank

Instant download after Payment is complete

Related products

Main Menu