Database Solutions: A Step By Step Guide To Building Databases, 2nd edition

Are you responsible for designing and creating the databases that keep your business running? Or are you studying for a module in database design? If so, Database Solutions is for you! This fully revised and updated edition will make the database design and build process smoother, quicker and more reliable.

• Take one RDMS – any of the major commercial products will do: Oracle, Informix, SQL Server, Access, Paradox
• Add one thorough reading of Database Solutions if you are an inexperienced database designer, or one recap of the methodology if you are an old hand
• Use the design and implementation frameworks to plan your timetable, use a common data model that fits your requirements and adapt as necessary

• Includes hints and tips for success with comprehensive guidance on avoiding pitfalls and traps.
• Shows how to create data models using the UML design notation.
• Includes two full-length coded example databases written on Microsoft Access 2002 and Oracle 9i, plus 15 sample data models to adapt to your needs, chosen from seven common business areas.

• New chapters on SQL (Structured Query Language) and QBE (Query by Example), plus a chapter on database administration and security. A new chapter on current and emerging trends in the area ensures that the book is up to date.
• The database design methodology has been improved and simplified.
• A companion website contains an implementation of the StayHome database that runs throughout the book, plus SQL scripts for 15 sample data models, lecture slides, sample solutions for all exercises from the book plus suggested exam questions and answers, and a variety of possible courseworks.