Most database products include free editions that you can use for smaller projects. You can apply the techniques described here equally to whatever database tool you use whether it’s Access, SQL Server, Oracle, MySQL, or some other database product. The details of database construction are different for different database tools so, to remain as generally as useful as possible, this book doesn’t concentrate on any particular database system. This book does not focus on actually creating the database. It tells how to determine what should go in a database and how the database should be structured to give the best results. The book finishes by describing some of the topics you need to understand to keep a database running effectively such as database maintenance and security. Later chapters explain how to actually build databases using two common database products: Access 2007 and MySQL. The book solidifies these concepts by working through a detailed example that designs a realistic database.

It explains how to discover database requirements, build data models to study data needs, and refine those models to improve the database’s effectiveness. It tells how to plan a database’s structure so the database will be robust, resistant to errors, and flexible enough to accommodate a reasonable amount of future change. All you really need is a willingness and desire to learn. It doesn’t even assume that you have experience with computers. It does not assume that you have any previous experience with databases or programs that use them.

This book is aimed at IT professionals and students of all experience levels. In many projects, these roles overlap so the same person may be responsible for working on the proposal, managing part of the project, and designing and creating the database. The material will also benefit those who will actually design, build, and work with databases such as database designers, database administrators, and programmers. The material will benefit those who want a better high-level understanding of databases such as proposal managers, architects, project managers, and even customers. This book is intended for IT professionals and students who want to learn how to design, analyze, and understand databases. TITLE : Beginning Database Design Solutions (Wrox Programmer to Programmer) Beginning Database Design Solutions, Wrox

EditPlus 5.7.4506 free downloads