Almost every organization seeks a simple means of managing, publishing and/or providing searchable web access to information. Written by a knowledgeable web developer, this book demonstrates the simplicity, cost-effectiveness and versatility of designing database driven web applications with Open Source resources. Case studies of 'real world' implementations address both theoretical aspects and practical considerations of developing applications with the easy-to-use PHP scripting language and powerful MySQL relational database. Project organization and design issues are considered along with basic coding examples, accessibility standards and implementation advice.
Database Systems is ideal for a one- or two-term course in database management or database design in an undergraduate or graduate level course. With its comprehensive coverage, this book can also be used as a reference for IT professionals.
Teaching and Learning Experience
This program presents a better teaching and learning experience-for you and your students. It provides:
This new book aims to provide both beginners and experts with a completely algorithmic approach to data analysis and conceptual modeling, database design, implementation, and tuning, starting from vague and incomplete customer requests and ending with IBM DB/2, Oracle, MySQL, MS SQL Server, or Access based software applications. A rich panoply of solutions to actual useful data sub-universes (e.g. business, university, public and home library, geography, history, etc.) is provided, constituting a powerful library of examples.
Four data models are presented and used: the graphical Entity-Relationship, the mathematical EMDM, the physical Relational, and the logical deterministic deductive Datalog ones. For each one of them, best practice rules, algorithms, and the theory beneath are clearly separated. Four case studies, from a simple public library example, to a complex geographical study are fully presented, on all needed levels.
Several dozens of real-life exercises are proposed, out of which at least one per chapter is completely solved. Both major historical and up-to-date references are provided for each of the four data models considered.
The book provides a library of useful solutions to real-life problems and provides valuable knowledge on data analysis and modeling, database design, implementation, and fine tuning.
Website Hosting Articles
Website Hosting Books