Data Modeling and Database Design

by Narayan S. Umanath, Richard W. Scamell

Overview

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.

Product Details

ISBN-13:	9781285085258
Publisher:	Cengage Learning
Publication date:	06/13/2014
Edition description:	New Edition
Pages:	720
Product dimensions:	17.70(w) x 21.70(h) x 1.40(d)

About the Author

Narayan S. Umanath is Professor [Emeritus] of Information Systems at the University of Cincinnati (UC) in Cincinnati, Ohio, USA. He has been at UC since 1996 and served as the department head of Information Systems (IS) for 7 years. Before that, he has been a faculty member at the Pennsylvania State University at the main (University Park) campus and the University of Tulsa. Umanath also serves as a member of the faculty in the Department of Mathematics & Computer Science (DMACS) at the Sri Sathya Sai Institute of Higher Learning (SSSIHL) in Prashanti Nilayam, India in the capacity of Visiting Professor since 2003. Entering academia after 17 years of technical and managerial experience in software development, he received his Ph.D. in Business Administration from the University of Houston in 1987. His undergraduate and graduate educations are in mechanical engineering and industrial engineering, respectively. Umanath has research publications in the domains of data visualization for decision support, agency theory applications in the design of compensation contracts, organizational computing, and electronic integration in supply channels; his current research interests are in the domains of knowledge exchange in supply-chain relationships, and data modeling & data warehousing. His research publications have appeared in Management Science, Decision Sciences, Journal of MIS, Communications of the ACM, International Journal of Information Management, Information & Management, Information Resources Management Journal, Journal of Managerial Issues and National Academy Science Letters. Umanath has also co-authored a text book titled "Data Modeling & Database Design".

Richard W. Scamell serves as Associate Dean for Student Affairs and 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, three of which have been focused 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.

Table of Contents

1. Database Systems: Architecture and Components. Part I: CONCEPTUAL DATA MODELING. 2. Foundation Concepts. 3. Entity-Relationship Modeling. 4. Enhanced Entity-Relationship (EER) Modeling. 5. Modeling Complex Relationships. Part II: LOGICAL DATA MODELING. 6. The Relational Data Model. Part III: NORMALIZATION. 7. Functional Dependencies. 8. Normal Forms Based on Functional Dependencies. 9. Higher Normal Forms. Part IV: DATABASE IMPLEMENTATION USING THE RELATIONAL DATA MODEL. 10. Database Creation. 11. Relational Algebra. 12. Structured Query Language (SQL). 13. Advanced Data Manipulation Using SQL. Appendix A. Appendix B.