Database Design – 2nd Edition

Livro digital

Título:
Database Design – 2nd Edition

Autor:
Adrienne Watt, Nelson Eng

Categoria:
Tecnologia > Dados

Doador:
Raffaello D. N.

Sinopse:
Good database design begins before the first SQL statement. Adrienne Watt and Nelson Eng start with the weaknesses of file-based systems, then build toward database concepts, data models, the relational model, and entity-relationship design. That sequence makes redundancy, isolation, integrity, security, and concurrency concrete problems that a well-designed database must solve. The chapters develop ER modelling, integrity rules and constraints, functional dependencies, normalization, the database development process, and the roles of different users before turning to SQL and data manipulation. Practical appendices add a university registration model, ERD exercises, and a complete SQL lab with solutions, giving readers material they can model, query, and check rather than merely memorize. Designed as an introductory open textbook, the book combines definitions, examples, highlighted key terms, review questions, and hands-on practice. It gives students and self-taught developers a disciplined route from requirements to a relational schema, while helping working programmers recognize the design mistakes that later become duplicated data, fragile queries, and expensive application logic.