Search Books
Javaâ„¢ Developers Almanac … Oracle SQL and PL/SQL Handb…

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

Author Michael J. Hernandez
Publisher Addison-Wesley Professional
Category Computers
📄 Viewing lite version Full site ›
🌎 Shop on Amazon — choose country
54.53 74.99 USD
🛒 Buy New on Amazon 🇺🇸 🏷 Buy Used — $0.01

✓ Usually ships in 24 hours

Share:
Book Details
ISBN / ASIN0201752840
ISBN-139780201752847
AvailabilityUsually ships in 24 hours
Sales Rank721,213
CategoryComputers
MarketplaceUnited States 🇺🇸

Description

Programmers and software architects don't really make a conscious decision to design an application (particularly one with online exposure) around the three-tier model-view-controller design pattern anymore. Three-tier, largely because of its adaptability and stability, is the norm. All of which means you need a database to underpin each of your applications. Designing your databases correctly can make the difference between slow-running, complicated code and software that's speedy, modular, and easy to work with. Database Design for Mere Mortals prepares someone with only a passing familiarity with databases for the important job of building the persistence layer (also called the data model) for software.

Michael Hernandez explains database design in tradesman's terms. That is, he shows his readers how to identify the business problems that have to be satisfied by a database, then proceeds to explain how to build a solid solution to them. Hernandez's approach combines procedural guidelines (first identify critical facts, then apply a certain logic to yield tables, then establish cross-references, and so on) with practical definitions that clear up much of the rich trove of jargon surrounding databases. He walks through numerous examples, and doesn't shy away from the complexities that always exist in real customers' requirements. If you're not familiar with database design, and want to be, this is the book you need. --David Wall

Topics covered: How to design databases that fit business requirements and make software construction easier. In addition to explaining relational database concepts, the author explains data integrity, null values, keys, table relationships (one-to-one, one-to-many, and many-to-many), and data types. He emphasizes processes designers should follow in building a new database or improving an existing one.

Joomla! 3 Boot Camp: 30-Minute Lessons to Joomla! 3 Ma…
View
Administering Apache
View
Build Your Own Gaming PC: The step-by-step manual to b…
View
Mike Meyers' CISSP(R) Certification Passport
View
TCP/IP Illustrated: v. 3: TCP for Transactions, HTTP, …
View
Information Systems for Managers: Texts and Cases
View
New Perspectives on Microsoft Word 2013, Introductory
View
Digital Design Principles and Practices: Onekey Course…
View