Database Systems Design, Implementation & Management, 13th-Carlos Coronel(2018)

所需积分/C币:50 2018-07-20 53.11MB PDF
评分

这本书是最新的第十三版,要的小伙伴赶紧拉。 高清全彩的pdf
Data Modeling Checklist BUSINESS RULES Properly document and verify all business rules with the end users y Ensure that all business rules are written precisely, clearly, and simply. The business rules must help identify entities, attributes, relationships, and constraints M Identify the source of all business rules, and ensure that each business rule is justified, dated, and signed off by an approving author ty DATA MODELING Naming Conventions: All names should be limited in length(database-dependent size) ENTITY NAMES: Should be nouns that are familiar to business and should be short and meaningfu Should document abbreviations, synonyms, and aliases for each entity y Should be unique within the model M For composite entities, may include a combination of abbreviated names of the entities inked through the composite entity ATTRIBUTE NAMES: M Should be unique within the entity y Should use the entity abbreviation as a prefix M Should be descriptive of the characleristic v Should use suffixes such as ID, NUM, or CODE for the PK attribute Should not be a reserved word M Should not contain spaces or special characters such as @ 1, or RELATIONSHIP NAMES Should be active or passive verbs that clearly indicate the nature of the relationship Entities. M Each entity should represent a single subject Each entity should represent a set of distinguishable entity instances M All entities should be in 3NF Or higher. Any entities below 3NF Shculd be justified a The granularity of the entity instance should be clearly defined y The pk is clearly defined and supports the selected data granularity Attributes. y Should be simple and single-valued (atomic cata Should document default values, constraints, synonyms, and aliases Derived attributes should be clearly identified and include sourceis y Should not be redundant unless they are justifed for transaction accuracy performance, or maintaining a history M Nonkey attributes must be fully dependent on the pk attribu Relationships: Should clearly identify relationship participants M Should clearly define participation, connectivity, and document cardinality ER Model Should be validated against expected processes: inserts, updates, and deletes Should evaluate where, when, and how to maintain a history Should not contain redundant relationships except as required (see Attributes a Should minimize data redundancy to ensure single-place updates Should conform to the minimal data rule: All that is needed is there and that is there is needed MINDTAP From Cengage Fit your coursework into your hectic life Make the most of your time by learning your way Access the resources you need to succeed wherever, whenever Get more from your time online with an easy-to-follow five-Step learning path Stay focused with an all- in-one-place, integrated presentation of course content Get the free MindI ap Mobile App and learn wherever you are Break limitations. Create your own potential, and be unstoppable with MindMap MINDIAP POWERED BY YOU cengage. com/mindtap Cepyight2019Cengagc Lcaming-All Righs Rescrved May not >e copied, scanned, or duplicated, in whole or in port Duc to electronic nights, some third party ccntent may bs suppressed e Book and/or chaps动ns) Editorial review has deemed that any suPpressed content docs not materially affect the overal learning experience. Cengage Leaming reserves the night tc renove additional content at any time if sul DATABASE SYSTEMS Design, Implementation, and management 13e Carlos Coronel Steven Morris ◆ CENGAG Australia· Brazil! Mexico· Singapore, United Kingdom· Un ited states Ccpy ight 2012 Cengage Lcaming. All Rights Reserved. May not oc copied, scanned, o: duplicated. in wholc or in part. Duc to clcctronie rights, some third party ccntent may ba suppressed from the eBook and/or c Chapte Editorial review has deemed that any suPpressed content does not materially affect the overall learning experience. Cengage Learning reserves the right tc remove additional content at any time if subsequent rights restriction: require it This is an electronic version of the print textbook. Due to electronic rights restrictions some third party content may be suppressed. Editorial review has deemed that any suppressed content does not materially affect the overall learning experience. The publisher reserves the right to remove content from this title at any time if subsequent rights restrictions require it. For valuable information on pricing, previous editions, changes to current editions, and alternate formatspleasevisitwww.cengage.com/higheredtosearchbyIsBn#,authortitleorkeywordfor materials in your areas of interest mportant Notice: Media content referenced within the product description or the product text may not be available in the e book version Ccpy ight 2012 Cengage Lcaming. All Rights Reserved. May not oc copied, scanned, o: duplicated. in wholc or in part. Duc to clcctronie rights, some third party ccntent may ba suppressed from the eBook and/or c Chapte Editorial review has deemed that any suPpressed content does not materially affect the overall learning experience. Cengage Learning reserves the right tc remove additional content at any time if subsequent rights restriction: require it ◆ CENGAGE Database Systems: Design, Implementation, C 2019, 2015 Cengage Learning, Inc and Management, 13th Edition Carlos coronel and steven morris ALL RIGHTS RESERVED. No part of this work covered by the copyright herein may be reproduced or distributed in any form or by any means, except as permitted by U.S. co pyright law, without the prior written permission of the SVP, GM Skills: Jonathan Lau copyright owner. Product Director: Lauren Murphy Product Team Manager: Kirstin MCNary For product infor ma tion and technology assistance, contact us at Cengage Learning Customer Sales Support, 1-800-354-9706 Associate product manager: Kate Mason Executive Director of deve lo oment: marah For permission to use material from this text or product, submit all requestsonlineatwww.cengage.com/permissions Furthe sions ques can be emailed to Senior Content Development Manager: Leigh permissionrequest@cengage.com Content developer: Maria garguilo Screenshots for this book were created using Microsoft Access@, ExceI R and visio(B and were used with permission from Microsoft. microsoft and Product Assistant: Jake Toth the office logo are either registered trademarks or trademarks of Microsoft VP, Marketing for Science, Technology, Math Corporation in the United States and/or other countries Jason sakos Oracle is a registered trademark, and Oracle12 c and MySQL are trademarks of Oracle Corporation Marketing Director: Michele McTighe Marketing Manager: Stephanie Albracht i Phone, iPad, iTunes, and iPod are registered trademarks of Apple Inc Library of Congress Control Number: 2015955694 Production Director: Patty Step han Content Project Manager: Michele Stulga Student edition isbn: 978-1-337-62790-c Loose leaf edition isbn 978-1-337-68882-6 Art Director: Diana graham Cover Designer: Roycroft Design Cengage (roycroftdesign. com) 20 Channel Center Street Boston, MA 02210 CoverImageisTock.com/liuzishan USA Cengage Learning is a leading provider of customized learning solutions with employees residing in nearly 40 different countries and sales in more than 125 countries around the world. Find your local representative at Www.cengage.com Cengage Learning products are represented in Canada by Nelson Education, Ltd. TolearnmoreaboutCengagevisitwww.cengage.com Purchase any of our products at your local college store or at our preferredonlinestorewww.cengagebrain.com Printed in the United States of america Print number: o1 Print Year: 2017 Ccpy ight 2012 Cengage Lcaming. All Rights Reserved. May not oc copied, scanned, o: duplicated. in wholc or in part. Duc to clcctronie rights, some third party ccntent may ba suppressed from the eBook and/or c Chapte Editorial review has deemed that any suPpressed content does not materially affect the overall learning experience. Cengage Learning reserves the right tc remove additional content at any time if subsequent rights restriction: require it Dedicatⅰon To the treasures in my life To Victoria, for 28 wonderful years. Thank you for your unending support and for being my angel, my sweetie, and, most importantly, my best friend. To Carlos Anthony, who has become a remarkable man, pride of his father, and husband to our beautiful, sweet, and smart daughter-in-law, jered Thank you for your words of wisdom, hard-working attitude, and for giving us reasons to be happy. You are still young; your best times are still to come. To Gabriela Victoria, who is the image of brilliance, beauty, and faithfulness. The way you give your time and talents in the service of others is an inspiration to all of us. Thank you for being my sunshine on cloudy days Your future is bright and endless. To Christian Javier, who is smarter than of all of us Thank you for being the youthful reminder of life's simple beauties. Keep challenging yourself to new highs and keep working hard to achieve your dreams. To my parents, Sarah and Carlos, thank you for your sacrifice and example. To all of you, you are all m inspiration. TQTATA Carlos Coronel To Pamela, from high school sweetheart through nearly 30 years of marriage, you are the beautiful love of my life who has supported, encouraged, and inspired me. More than anyone else, you are responsible for whatever successes i have achieved. To my son, Alexander Logan, your depth of character is without measure. You are my pride and joy To my daughter, Lauren Elizabeth, your beauty and intensity take my breath away. You are my heart and soul. Thank you all for the sacrifices you have made that enabled me to pursue this dream. I love you so much more than I can express. To my mother, Flor- ence Maryann, and to the memory of my father, Alton Lamar, together they instilled in me the desire to learn and the passion to achieve. To my mother-in-law, Connie Duke, and to the memory of my father-in-law, Wayne Duke, they taught me to find joy in all things. To all of you, with all my love, I dedicate this book Steven morris For peter To longtime colleague and friend, Peter rob: Your drive and dedication to your students started this book. Your depth of knowledge, atlention lo detail, and pursuit of excellence made it succeed. Your patience and guidance continue to light our path. It is our sincere hope that, as we move forward, we can continue to live up to your standard. Enjoy your retirement my friend; you have surely earned it Carlos Coronel and Steven morris Ccpy ight 2012 Cengage Lcaming. All Rights Reserved. May not oc copied, scanned, o: duplicated. in wholc or in part. Duc to clcctronie rights, some third party ccntent may ba suppressed from the eBook and/or c Chapte Editorial review has deemed that any suPpressed content does not materially affect the overall learning experience. Cengage Learning reserves the right tc remove additional content at any time if subsequent rights restriction: require it Brⅰ ef contents Preface, xy Text Features, xx Additional Features, xXii Acknowledgments, xxiv Part 1: Database Concepts 1. Data base Systems,2 2. Data Models, 34 Part 2: Design Concepts 67 3. The Relational Database Model, 68 4. Entity Relationship(ER)Modeling,113 5. Advanced Data Modeling, 167 6. Normalization of database Tables, 199 Part 3: Advanced Design and Implementation 243 7. Introduction to Structured Query Language(SQL), 244 8. Advanced SQL, 359 9. Database Design, 439 Part 4: Advanced Database Concepts 481 10. Transaction Management and concurrency Control, 482 11. Database Performance Tuning and Query Optimization, 515 12. Distributed Database Management Systems, 553 13. Business Intelligence and Data Warehouses, 589 14. Big Data and NosQl, 657 Part 5: Databases and the internet 691 15. Database Connectivity and Web Technologies, 692 Part 6: Database administration 733 16. Data base administration and security 734 Glossary,782 Index, 793 Ccpy ight 2012 Cengage Lcaming. All Rights Reserved. May not oc copied, scanned, o: duplicated. in wholc or in part. Duc to clcctronie rights, some third party ccntent may ba suppressed from the eBook and/or c Chapte Editorial review has deemed that any suPpressed content does not materially affect the overall learning experience. Cengage Learning reserves the right tc remove additional content at any time if subsequent rights restriction: require it ThefollowingappendicesareincludedontheInstructorandStudentCompanionSitesatwww.cengagebrain.com Appendix Al: Designing Databases with Visio Professional 2010 A Tutorial Appendix A2: Designing Databases with Visio 2013: A Tutorial ppendix B: The University Lab: Conceptual Design Appendix C: The University Lab: Conceptual Design Verification, Logical Design and Implementation Appendix D: Converting an ER Model into a Database Structure Appendix E: Comparison of ER Modeling Notations Appendix F: Client/Server Systems Appendix G: Object-Oriented Databases Appendix H: Unified Modeling Language(UML Appendix I: Databases in Electronic Commerce Appendix J: Web Database Development with ColdFusion Appendix K: The Hierarchical Database Model Appendix L: The Network Database Model Appendix M: MS Access Tutorial Appendix N: Creating a New Database Using Oracle 12C Appendix O: Data Warehouse Implementation Factors Appendix P: Working with MongoDB Appendix Q: Working with Neo4j Brief contents v Ccpy ight 2012 Cengage Lcaming. All Rights Reserved. May not oc copied, scanned, o: duplicated. in wholc or in part. Duc to clcctronie rights, some third party ccntent may ba suppressed from the eBook and/or c Chapte Editorial review has deemed that any suPpressed content does not materially affect the overall learning experience. Cengage Learning reserves the right tc remove additional content at any time if subsequent rights restriction: require it

...展开详情
立即下载 最低0.43元/次 身份认证VIP会员低至7折
举报 举报 收藏 收藏 (13)
分享

评论 下载该资源后可以进行评论 11

weixin_38747087 感谢分享,很齐全很清晰,还是彩色版的。
2020-03-25
回复
zhmzmh9751 很不错,是我们这节课需要的的教材,完全一致
2020-02-13
回复
cdming 不错,就是分越来越少了。
2019-10-22
回复
往哪游 good! i like it
2019-06-24
回复
a4720663 文档质量高
2019-03-30
回复
img

关注 私信 TA的资源

上传资源赚积分,得勋章
相关内容推荐