Data Modeling and Database Design (07 Edition)

Data Modeling and Database Design presents a conceptually complete coverage of indispensable topics that each MIS student should learn if that student takes only one database course. Database design and data modeling encompass the minimal set of topics addressing the core competency of knowledge students should acquire in the database area. The text, rich examples, and figures work together to cover material with a depth and precision that is not available in more introductory database books.

Dr. Richard W. Scamell serves as Professor of Decision and Information Sciences in the C. T. Bauer College of Business at the University of Houston. He received his Ph.D. degree from The University of Texas at Austin. Since joining the faculty at Houston in 1972, he has taught more than two dozen different courses at the undergraduate, masters, and doctoral levels, including several in the database area. His publications have appeared in journals such as Management Science, MIS Quarterly, Academy of Management Journal, Decision Sciences, IEEE Transactions on Software Engineering, Communications of the ACM, Omega, and Information and Management. Dr. Narayan S. Umanath is Professor of Information Systems at the University of Cincinnati, Ohio. Entering academia after fifteen years of technical and managerial experience in the software development industry, Umanath received his Ph.D in Business Administration from the University of Houston in 1987. His current research interests include electronic integration in supply chain relationships, data modeling and data warehousing and organizational issues pertaining to Information Systems. His research publications have appeared in Communications of the ACM, Decision Sciences, Information and Management, Information Resources Management Journal, Journal of MIS, Journal of Managerial Issues and Management Science.

1. Database Systems: Architecture and Components 2. Foundation Concepts 3. Entity-Relationship Modeling 4. Enhanced Entity-Relationship (EER) Modeling 5. Modeling Complex Relationships 6. The Relational Data Model 7. Functional Dependencies 8. Normal Forms Based on Functional Dependencies 9. Higher Normal Forms 10. Database Creation 11. Data Manipulation: Relational Algebra and SQL 12. Advanced Data Manipulation Using SQL Appendix A: Data Modeling Architectures Based on the Inverted Tree and Network Data Structures Appendix B: Object-Oriented Data Modeling Architectures Appendix C: Overview of SQL Reserved Words