Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design (3rd Edition)

Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design (3rd Edition)

Michael J. Hernandez

Language: English

Pages: 672

ISBN: 0321884493

Format: PDF / Kindle (mobi) / ePub


The #1 Easy, Commonsense Guide to Database Design! Michael J. Hernandez’s best-selling Database Design for Mere Mortals® has earned worldwide respect as the clearest, simplest way to learn relational database design. Now, he’s made this hands-on, software-independent tutorial even easier, while ensuring that his design methodology is still relevant to the latest databases, applications, and best practices. Step by step, Database Design for Mere Mortals ® , Third Edition, shows you how to design databases that are soundly structured, reliable, and flexible, even in modern web applications. Hernandez guides you through everything from database planning to defining tables, fields, keys, table relationships, business rules, and views. You’ll learn practical ways to improve data integrity, how to avoid common mistakes, and when to break the rules.


Coverage includes

Understanding database types, models, and design terminology

Discovering what good database design can do for you—and why bad design can make your life miserable

Setting objectives for your database, and transforming those objectives into real designs

Analyzing a current database so you can identify ways to improve it

Establishing table structures and relationships, assigning primary keys, setting field specifications, and setting up views

Ensuring the appropriate level of data integrity for each application

Identifying and establishing business rules

Whatever relational database systems you use, Hernandez will help you design databases that are robust and trustworthy. Never designed a database before? Settling for inadequate generic designs? Running existing databases that need improvement? Start here.

A Concise Introduction to Languages and Machines (Undergraduate Topics in Computer Science)

Practical Text Mining with Perl (Wiley Series on Methods and Applications in Data Mining)

Practical Perforce

The C Programming Language (2nd Edition)

Artificial Intelligence: The Basics

Automatic Design of Decision-Tree Induction Algorithms (Springer Briefs in Computer Science)














determine whether a table has a self-referencing relationship by making two minor modifications to the question itself: Can a single (singular form of the table name) be associated with one or more (plural form of the table name)? For example, here’s a question you might pose for the STAFF table: Can a single staff member be associated with one or more other staff members? 2. Contextual: This type of question contrasts a single instance of the subject represented by the first table against

Information Is Presented Conducting Interviews Interviewing Users Interviewing Management Compiling a Complete List of Fields Case Study Summary Review Questions Getting to Know the Current Database To determine where you should go, you must first understand where you are. This maxim defines the entire philosophy behind this phase of the database design process. You must devote some time to gaining a clear understanding of your organization’s database so that you can • Determine

data. Finally, Kira tries to identify the source of the remaining data by asking Joan if she knows from where the data originates. In this case, it takes only two well-phrased questions to find the answer. If Joan could not answer the last two questions, Kira would need to continue her investigation with other participants. You’re sure to obtain all the information you need about your report samples if your discussions progress in the same manner as the preceding dialogue. Remember: Follow-up

Field List. For example, say you’re working with the data collection sample shown in Figure 6.14. Figure 6.14. An example of a data collection sample Highlight each characteristic you find on the sample, as shown in Figure 6.15. Figure 6.15. A sample with highlighted characteristics You’re likely to find multiple occurrences of various characteristics in some of the samples. As you can see, both “Name” and “Phone No.” appear twice on this particular sample. You can cross out the

initially defined. Review Questions 1. State two major reasons why field specifications are important. 2. What do you gain by establishing field-level integrity? 3. What are the three categories of elements in a field specification? 4. Name the three types of specifications. 5. Why is it beneficial for you to compose a proper field description? 6. What does the Data Type element indicate? 7. What does the Character Support element indicate? 8. What is the purpose of the Display

Download sample