{"product_id":"9781430242109","title":"Beginning Database Design: From Novice to Professional","description":"\u003cbr\u003e    \u003cp\u003e\u003cbr\u003e   \u003cem\u003eBeginning Database Design, Second Edition\u003c\/em\u003e provides short, easy-to-read explanations of how to get database design right the first time. This book offers numerous examples to help you avoid the many pitfalls that entrap new and not-so-new database designers. Through the help of use cases and class diagrams modeled in the UML, you’ll learn to discover and represent the details and scope of any design problem you choose to attack.\u003c\/p\u003e\u003cp\u003e\u003cbr\u003e\u003cbr\u003e\u003c\/p\u003e\u003cp\u003e\u003cbr\u003e\u003cbr\u003eDatabase design is not an exact science. Many are surprised to find that problems with their databases are caused by poor design rather than by difficulties in using the database management software. \u003cem\u003eBeginning Database Design, Second Edition\u003c\/em\u003e helps you ask and answer important questions about your data so you can understand the problem you are trying to solve and create a pragmatic design capturing the essentials while leaving the door open for refinements and extension at a later stage. Solid database design principles and examples help demonstrate the consequences of simplifications and pragmatic decisions. The rationale is to try to keep a design simple, but allow room for development as situations change or resources permit.\u003c\/p\u003e\u003cp\u003e\u003cbr\u003e\u003cbr\u003e\u003c\/p\u003e\u003cp\u003e\u003cbr\u003e\u003cbr\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cbr\u003e\u003cbr\u003e  \u003cli\u003eProvides solid design principles by which to avoid pitfalls and support changing needs  \u003c\/li\u003e\n\u003cbr\u003e\u003cbr\u003e  \u003cli\u003eIncludes numerous examples of good and bad design decisions and their consequences \u003c\/li\u003e\n\u003cbr\u003e\u003cbr\u003e  \u003cli\u003eShows a modern method for documenting design using the Unified Modeling Language \u003c\/li\u003e\n\u003cbr\u003e\u003cbr\u003e\n\u003c\/ul\u003e\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e    \u003cbr\u003e   What you’ll learn\u003cul\u003e\n\u003cbr\u003e\u003cbr\u003e  \u003cli\u003eAvoid the most common pitfalls in database design. \u003c\/li\u003e\n\u003cbr\u003e\u003cbr\u003e  \u003cli\u003eCreate clear use cases from project requirements. \u003c\/li\u003e\n\u003cbr\u003e\u003cbr\u003e  \u003cli\u003eDesign a data model to support the use cases. \u003c\/li\u003e\n\u003cbr\u003e\u003cbr\u003e  \u003cli\u003eApply generalization and specialization appropriately. \u003c\/li\u003e\n\u003cbr\u003e\u003cbr\u003e  \u003cli\u003eSecure future flexibility through a normalized design. \u003c\/li\u003e\n\u003cbr\u003e\u003cbr\u003e  \u003cli\u003eEnsure integrity through relationships, keys, and constraints. \u003c\/li\u003e\n\u003cbr\u003e\u003cbr\u003e  \u003cli\u003eSuccessfully implement your data model as a relational schema. \u003c\/li\u003e\n\u003cbr\u003e\u003cbr\u003e\n\u003c\/ul\u003e\u003cbr\u003e\u003cbr\u003eWho this book is for\u003cbr\u003e     \u003cp\u003e\u003cbr\u003e    \u003cem\u003eBeginning Database Design, Second Edition\u003c\/em\u003e is aimed at desktop power users, developers, database administrators, and others who are charged with caring for data and storing it in ways that preserve its meaning and integrity. Desktop users will appreciate the coverage of Excel as a plausible “database” for research systems and lab environments. Developers and database designers will find insight from the clear discussions of design approaches and their pitfalls and benefits. All readers will benefit from learning a modern notation for documenting designs that is based upon the widely used and accepted Universal Modeling Language. \u003cbr\u003e\u003cbr\u003e\u003cbr\u003e     \u003c\/p\u003e\u003cbr\u003e    Table of Contents\u003col\u003e\n\u003cbr\u003e\u003cbr\u003e  \u003cli\u003eWhat Can Go Wrong? \u003c\/li\u003e\n\u003cbr\u003e\u003cbr\u003e  \u003cli\u003eGuided Tour of the Development Process \u003c\/li\u003e\n\u003cbr\u003e\u003cbr\u003e  \u003cli\u003eInitial Requirements and Use Cases \u003c\/li\u003e\n\u003cbr\u003e\u003cbr\u003e  \u003cli\u003eLearning from the Data Model \u003c\/li\u003e\n\u003cbr\u003e\u003cbr\u003e  \u003cli\u003eDeveloping a Data Model \u003c\/li\u003e\n\u003cbr\u003e\u003cbr\u003e  \u003cli\u003eGeneralization and Specialization \u003c\/li\u003e\n\u003cbr\u003e\u003cbr\u003e  \u003cli\u003eFrom Data Model to Relational Schema \u003c\/li\u003e\n\u003cbr\u003e\u003cbr\u003e  \u003cli\u003eNormalization \u003c\/li\u003e\n\u003cbr\u003e\u003cbr\u003e  \u003cli\u003eMore on Keys and Constraints \u003c\/li\u003e\n\u003cbr\u003e\u003cbr\u003e  \u003cli\u003eQueries \u003c\/li\u003e\n\u003cbr\u003e\u003cbr\u003e  \u003cli\u003eUser Interface \u003c\/li\u003e\n\u003cbr\u003e\u003cbr\u003e  \u003cli\u003eOther Implementations \u003c\/li\u003e\n\u003cbr\u003e\u003cbr\u003e\n\u003c\/ol\u003e\u003cbr\u003e\u003cbr\u003e","brand":"Apress","offers":[{"title":"Default Title","offer_id":47300811260144,"sku":"9781430242109","price":27.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9781430242109_p0.jpg?v=1763750279","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9781430242109","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}