You d be up to your neck in normal forms before you even had a chance to wade. When Michael J. Hernandez needed a database design book to teach mere mortals like himself, there were none. So he began a personal quest to learn enough to write one. And he did.Now in its Second Edition, Database Design for Mere Mortals is a miracle for today s generation of database users who don t have the background -- or the time -- to learn database design the hard way. It s also a secret pleasure for working pros who are occasionally still trying to figure out what they were taught.Drawing on 13 years of database teaching experience, Hernandez has organized database design into several key principles that are surprisingly easy to understand and remember. He illuminates those principles using examples that are generic enough to help you with virtually any application.Hernandez s goals are simple. You ll learn how to create a sound database structure as easily as possible. You ll learn how to optimize your structure for efficiency and data integrity. You ll learn how to avoid problems like missing, incorrect, mismatched, or inaccurate data. You ll learn how to relate tables together to make it possible to get whatever answers you need in the future -- even if you haven t thought of the questions yet.If -- as is often the case -- you already have a database, Hernandez explains how to analyze it -- and leverage it. You ll learn how to identify new information requirements, determine new business rules that need to be applied, and apply them.Hernandez starts with an introduction to databases, relational databases, and the idea and objectives of database design. Next, you ll walk through the key elements of the database design process: establishing table structures and relationships, assigning primary keys, setting field specifications, and setting up views. Hernandez s extensive coverage of data integrity includes a full chapter on establishing business rules and using validation tables.Hernandez surveys bad design techniques in a chapter on what not to do -- and finally, helps you identify those rare instances when it makes sense to bend or even break the conventional rules of database design.There s plenty that s new in this edition. Hernandez has gone over his text and illustrations with a fine-tooth comb to improve their already impressive clarity. You ll find updates to reflect new advances in technology, including web database applications. There are expanded and improved discussions of nulls and many-to-many relationships; multivalued fields; primary keys; and SQL data type fields. There s a new Quick Reference database design flowchart. A new glossary. New review questions at the end of every chapter.Finally, it s worth mentioning what this book isn t. It isn t a guide to any specific database platform -- so you can use it whether you re running Access, SQL Server, or Oracle, MySQL or PostgreSQL. And it isn t an SQL guide. (If that s what you need, Michael J. Hernandez has also coauthored the superb SQL Queries for Mere Mortals). But if database design is what you need to learn, this book s worth its weight in gold. Bill CamardaBill Camarda is a consultant, writer, and web/multimedia content developer. His 15 books include Special Edition Using Word 2000 and Upgrading & Fixing Networks for Dummies, Second Edition.

    Ironically, I must recommend that you read her every word so that you can find out why your customers won't read very many words on your website -- and what to do about it.-- Jakob Nielsen, Principal, Nielsen Norman Group"There are at least twelve billion web pages out there. Twelve billion voices talking, but saying mostly nothing. If just 1% of those pages followed Ginny's practical, clear advice, the world would be a better place. Fortunately, you can follow her advice for 100% of your own site's pages, so pick up a copy of Letting Go of the Words and start communicating effectively today."--Lou Rosenfeld, co-author, Information Architecture for the World Wide WebOn the web, whether on the job or at home, we usually want to grab information and use it quickly. We go to the web to get answers to questions or to complete tasks - to gather information, reading only what we need. We are all too busy to read much on the web.This book helps you write successfully for web users. It offers strategy, process, and tactics for creating or revising content for the web. It helps you plan, organize, write, design, and test web content that will make web users come back again and again to your site.Learn how to create usable and useful content for the web from the master - Ginny Redish. Ginny has taught and mentored hundreds of writers, information designers, and content owners in the principles and secrets of creating web information that is easy to scan, easy to read, and easy to use.This practical, informative book will help anyone creating web content do it better.Features* Clearly-explained guidelines with full color illustrations and examples from actual web sites throughout the book. * Written in easy-to-read style with many befores and afters.* Specific guidelines for web-based press releases, legal notices, and other documents.* Tips on making web content accessible for people with special needs.Janice (Ginny) Redish has been helping clients and colleagues communicate clearly for more than 20 years. For the past ten years, her focus has been helping people create usable and useful web sites. She is co-author of two classic books on usability: A Practical Guide to Usability Testing (with Joseph Dumas), and User and Task Analysis for Interface Design (with JoAnn Hackos), and is the recipient of many awards.

    The R language provides everything you need to do statistical work, but its structure can be difficult to master. This collection of concise, task-oriented recipes makes you productive with R immediately, with solutions ranging from basic tasks to input and output, general statistics, graphics, and linear regression.Each recipe addresses a specific problem, with a discussion that explains the solution and offers insight into how it works. If you're a beginner, R Cookbook will help get you started. If you're an experienced data programmer, it will jog your memory and expand your horizons. You'll get the job done faster and learn more about R in the process.Create vectors, handle variables, and perform other basic functionsInput and output dataTackle data structures such as matrices, lists, factors, and data framesWork with probability, probability distributions, and random variablesCalculate statistics and confidence intervals, and perform statistical testsCreate a variety of graphic displaysBuild statistical models with linear regressions and analysis of variance (ANOVA)Explore advanced statistical techniques, such as finding clusters in your dataWonderfully readable, R Cookbook serves not only as a solutions manual of sorts, but as a truly enjoyable way to explore the R language--one practical example at a time.--Jeffrey Ryan, software consultant and R package author

    You'll learn about styles like Art Deco, Modernism, and High-Tech, and find inspiration in galleries of LEGO models. Then take your turn building 12 models in a variety of styles. Snap together some bricks and learn architecture the fun way!

    Learn how to design beautiful user interfaces by yourself using specific tactics explained from a developer's point-of-view.

    Everyone wants them, whether to sell more products, spread good ideas, or win more funding. In our busy digital world, the way to results is influencing people on the web. But how?An ad campaign won't cut it. A Twitter account doesn't guarantee it. Manipulative tricks will backfire. Instead, you need quality, compelling web content that attracts people and engages them for the long haul.Clout explains the key principles of influence and how to apply them to web content. Along the way, those principles come to life with lots of practical examples. With this book, you'll: Discover why a technology feature, marketing campaign, SEO effort, or redesign aren't enough to influence online. Understand the business value of compelling web content. Learn 8 principles for influence from the art of rhetoric and the science of psychology. Find out what context is and why it's so important to influence. Jump start your planning for content over time with patterns and diagrams. Learn the basics of evaluation to determine whether your web content is making a difference.

    Anderson takes a fresh approach to designing sites and interactions based on the stages of seduction. This beautifully designed book examines what motivates people to act.Topics include: AESTHETICS, BEAUTY, AND BEHAVIOR: Why do striking visuals grab our attention? And how do emotions affect judgment and behavior? PLAYFUL SEDUCTION: How do you create playful engagements during the moment? Why are serendipity, arousal, rewards, and other delights critical to a good experience? THE SUBTLE ART OF SEDUCTION: How do you put people at ease through clear and suggestive language? What are some subtle ways to influence behavior and get people to move from intent to action? THE GAME OF SEDUCTION: How do you continue motivating people long after the first encounter? Are there lessons to be gained from learning theories or game design? Principles from psychology are found throughout the book, along with dozens of examples showing how these techniques have been applied with great success. In addition, each section includes interviews with influential web and interaction designers.

    This volume highlights the research and findings of this natural scientist. Powerful modern microscopes have confirmed the accuracy of Haeckel's prints, which even in their day, became world famous. Haeckel's portfolio, first published between 1899 and 1904 in separate installments, is described in the opening essays. The plates illustrate Haeckel's fundamental monistic notion of the -unity of all living things- and the wide variety of forms are executed with utmost delicacy. Incipient microscopic organisms are juxtaposed with highly developed plants and animals. The pages, ordered according to geometric and -constructive- aspects, document the oness of the world in its most diversified forms. This collection of plates was not only well-received by scientists, but by artists and architects as well. Rene Binet, a pioneer of glass and iron constructions, Emile Galle, a renowned Art Nouveau designer, and the photographer Karl Blossfeld all make explicit reference to Haeckel in their work.

    Exercises range from creating a typeface in an hour to designing a paper robot in an afternoon to designing web pages and other interactive experiences. Each exercise includes compelling visual solutions from other designers and background stories to help you increase your capacity to innovate.Creative Workshop also includes useful brainstorming techniques and wisdom from some of today's top designers. By road-testing these techniques as you attempt each challenge, you'll find new and more effective ways to solve tough design problems and bring your solutions to vibrant life.

    Instead of giving you the most broadly popular result, Google now tries to predict what you are most likely to click on. According to MoveOn.org board president Eli Pariser, Google's change in policy is symptomatic of the most significant shift to take place on the Web in recent years - the rise of personalization. In this groundbreaking investigation of the new hidden Web, Pariser uncovers how this growing trend threatens to control how we consume and share information as a society-and reveals what we can do about it.Though the phenomenon has gone largely undetected until now, personalized filters are sweeping the Web, creating individual universes of information for each of us. Facebook - the primary news source for an increasing number of Americans - prioritizes the links it believes will appeal to you so that if you are a liberal, you can expect to see only progressive links. Even an old-media bastion like "The Washington Post" devotes the top of its home page to a news feed with the links your Facebook friends are sharing. Behind the scenes a burgeoning industry of data companies is tracking your personal information to sell to advertisers, from your political leanings to the color you painted your living room to the hiking boots you just browsed on Zappos.In a personalized world, we will increasingly be typed and fed only news that is pleasant, familiar, and confirms our beliefs - and because these filters are invisible, we won't know what is being hidden from us. Our past interests will determine what we are exposed to in the future, leaving less room for the unexpected encounters that spark creativity, innovation, and the democratic exchange of ideas.While we all worry that the Internet is eroding privacy or shrinking our attention spans, Pariser uncovers a more pernicious and far-reaching trend on the Internet and shows how we can - and must - change course. With vivid detail and remarkable scope, The Filter Bubble reveals how personalization undermines the Internet's original purpose as an open platform for the spread of ideas and could leave us all in an isolated, echoing world.

    These fundamentals of design, once the exclusive domain of professional typographers, have become an essential starting point for anyone looking for a fresh way to communicate. Practical information about creating letters and type often amounts to a series of guidelines for executing a particular process, font program, or style. But what makes lettering and type endlessly fascinating is the flexibility to interpret and sometimes even break these rules. Lettering & Type is a smart-but- not-dense guide to creating and bending letters to one's will. More than just another pretty survey, it is a powerful how-to book full of relevant theory, history, explanatory diagrams, and exercises. While other type design books get hung up on the technical and technological issues of type design and lettering, Lettering & Type features the context and creativity that shape letters and make them interesting. Authors and designers Bruce Willen and Nolen Strals examine classic design examples as well as exciting contemporary lettering of all stripes—from editorial illustrations to concert posters to radical conceptual alphabets. Lettering & Type is ideal for anyone looking to move beyond existing typography and fonts to create, explore, and use original or customized letterforms. This latest addition to our best-selling Design Briefs seriesfeatures a foreword by Ellen Lupton and hundreds of images and examples of work by historical and contemporary designers, artists, and illustrators, including Marian Bantjes, Stefan Sagmeister, Matthew Carter, Christoph Niemann, Steve Powers (ESPO), House Industries, Christian Schwartz, Margaret Kilgallen, James Victore, Abbott Miller, Sibylle Hagmann, Ed Fella, and many more. Throughout the book interviews with type designers, artists, and graphic designers provide real-world perspective from contemporary practitioners.

    This is a practical, hands-on guide for anyone trying to design systems that reflect the way customers want to do their work. The authors developed Contextual Design, the method discussed here, through their work with teams struggling to design products and internal systems. In this book, you'll find the underlying principles of the method and how to apply them to different problems, constraints, and organizational situations.Contextual Design enables you to+ gather detailed data about how people work and use systems + develop a coherent picture of a whole customer population + generate systems designs from a knowledge of customer work+ diagram a set of existing systems, showing their relationships, inconsistencies, redundancies, and omissions

    It is the product of preparation and effort, and it's within reach of everyone who wants to achieve it. All it takes is the willingness to make creativity a habit, an integral part of your life: In order to be creative, you have to know how to prepare to be creative. In The Creative Habit, Tharp takes the lessons she has learned in her remarkable thirty-five-year career and shares them with you, whatever creative impulses you follow -- whether you are a painter, composer, writer, director, choreographer, or, for that matter, a businessperson working on a deal, a chef developing a new dish, a mother wanting her child to see the world anew. When Tharp is at a creative dead end, she relies on a lifetime of exercises to help her get out of the rut, and The Creative Habit contains more than thirty of them to ease the fears of anyone facing a blank beginning and to open the mind to new possibilities. Tharp's exercises are practical and immediately doable -- for the novice or expert. In "Where's Your Pencil?" she reminds us to observe the world -- and get it down on paper. In "Coins and Chaos," she provides the simplest of mental games to restore order and peace. In "Do a Verb," she turns your mind and body into coworkers. In "Build a Bridge to the Next Day," she shows how to clean your cluttered mind overnight. To Tharp, sustained creativity begins with rituals, self-knowledge, harnessing your memories, and organizing your materials (so no insight is ever lost). Along the way she leads you by the hand through the painful first steps of scratching for ideas, finding the spine of your work, and getting out of ruts into productive grooves. In her creative realm, optimism rules. An empty room, a bare desk, a blank canvas can be energizing, not demoralizing. And in this inventive, encouraging book, Twyla Tharp shows us how to take a deep breath and begin!

    With simple, creative guidance, this book teaches readers how to learn what they want to learn from the media and other communication sources.

    It describes the genre's origins and development, showcasing the most important artists.