Database design for mere mortals: a hands-on guide to by Michael J. Hernandez

By Michael J. Hernandez


The number 1 effortless, common-sense consultant to Database layout! Michael J. Hernandez’s best-selling Database layout for Mere Mortals® has earned world wide appreciate because the clearest, easiest way to profit relational database layout. Now, he’s made this hands-on, software-independent educational even more straightforward, whereas making sure that his layout technique remains to be appropriate to the newest databases, functions, and top practices. Step by means of step, Database layout for Mere Mortals ® , 3rd Edition, exhibits you the way to layout databases which are soundly established, trustworthy, and versatile, even in sleek internet purposes. Hernandez publications you thru every little thing from database making plans to defining tables, fields, keys, desk relationships, enterprise ideas, and perspectives. You’ll study functional how you can enhance facts integrity, how you can keep away from universal blunders, and whilst to wreck the rules.


Coverage includes

Understanding database kinds, versions, and layout terminology

Discovering what strong database layout can do for you—and why undesirable layout could make your lifestyles miserable

Setting goals on your database, and remodeling these pursuits into genuine designs

Analyzing a present database so that you can establish how you can increase it

Establishing desk buildings and relationships, assigning basic keys, environment box requirements, and developing views

Ensuring the proper point of information integrity for every application

Identifying and constructing company rules

Whatever relational database platforms you utilize, Hernandez might help you layout databases which are powerful and reliable. by no means designed a database earlier than? Settling for insufficient commonplace designs? operating latest databases that desire development? commence here.

Show description

Read or Download Database design for mere mortals: a hands-on guide to relational database design PDF

Similar data modeling & design books

Developing Quality Complex Database Systems: Practices, Techniques and Technologies

The target of constructing caliber advanced Database structures is to supply possibilities for bettering trendy database platforms utilizing leading edge improvement practices, instruments and strategies. every one bankruptcy of this publication will offer perception into the powerful use of database know-how via versions, case reports or adventure studies.

Mapping Scientific Frontiers: The Quest for Knowledge Visualization

This can be an exam of the heritage and the cutting-edge of the search for visualizing clinical wisdom and the dynamics of its improvement. via an interdisciplinary viewpoint this e-book provides profound visions, pivotal advances, and insightful contributions made by means of generations of researchers and execs, which portrays a holistic view of the underlying ideas and mechanisms of the advance of technology.

Pentaho for Big Data Analytics

Increase your wisdom of massive info and leverage the ability of Pentaho to extract its treasures evaluate A consultant to utilizing Pentaho enterprise Analytics for large info research examine Pentaho’s visualization and reporting instruments with functional examples and counsel designated insights into churning vast information into significant wisdom with Pentaho intimately Pentaho speeds up the belief of worth from huge facts with the main whole answer for giant information analytics and knowledge integration.

Mastering Data Mining with Python

Key FeaturesDive deeper into facts mining with Python – do not be complacent, sharpen your talents! From the most typical components of knowledge mining to state of the art options, we have you lined for any data-related challengeBecome a extra fluent and assured Python data-analyst, in complete keep an eye on of its huge variety of librariesBook DescriptionData mining is an essential component of the knowledge technological know-how pipeline.

Additional info for Database design for mere mortals: a hands-on guide to relational database design

Sample text

Part III: Other Database Design Issues This section deals with topics such as avoiding bad design and bending the rules set forth in the design process. Chapter 14, “Bad Design—What Not to Do,” covers the types of designs you should avoid, such as a flat-file design and a spreadsheet design. Chapter 15, “Bending or Breaking the Rules,” discusses those rare instances in which it may be necessary to stray from the techniques and concepts of the design process. This chapter tells you when you should consider bending the rules, as well as how it should be done.

1 shows a diagram of a typical hierarchical database structure. 1. 1, an agent books several entertainers, and each entertainer has his own schedule. An agent also maintains a number of clients whose entertainment needs are met by the agent. A client books engagements through the agent and makes payments to him for his services. A relationship in a hierarchical database is represented by the term parent/child. In this type of relationship, a parent table can be associated with one or more child tables, but a single child table can be associated with only one parent table.

Many of the database design books on the market are highly technical and can be difficult to assimilate. I think most of these books can be confusing and overwhelming if you are not a computer science major, database theorist, or experienced database developer. The design principles you’ll learn within these pages are easy to understand and remember, and the examples are common and generic enough to be relevant to a wide variety of situations. Most people I’ve met in my travels around the country have told me that they just want to learn how to create a sound database structure without having to learn about normal forms or advanced mathematical theories.

Download PDF sample

Rated 4.06 of 5 – based on 8 votes