Information modeling is a critical process in content management. This book provides basic concepts of information models and explains how to design
database based on data analysis and SQL models. It also provides case studies of
database design based on information modeling techniques.
Number of pages: 510
Size: 8.5 x 11in (21.6 x 27.9cm)
Author: David Edmond
This book provides basic concepts and framework of information modeling. It is also an introduction to the specification and implementation of organizational information systems. It aims to combine and integrate these traditionally compartmentalized activities. This unity is achieved through the use of a relational specification language Z in conjunction with the relational database language SQL. Both these languages have their roots in predicate logic and set theory. Features of the book include:
The book suggests that we should take a knowledge-based approach to the development of information systems, with the knowledge first being represented using Z and then re-stated as application programs that use SQL to process a database. Thus the book will be of interest to computing professionals who work in the areas of systems analysis, database design and application programming. It will also provide an integrated introduction to these topics for students of information systems and computer science.
- An introduction to sets, functions and relations which provide the essential foundations for understanding information systems.
- A thorough coverage of SQL.
- An introduction to database design through two contrasting graphical notations -- conceptual schema and entity-relationship diagrams.
- An introduction to the essential components of the Z notation and to the conventions regarding its use.
- A discussion of the relationship that must be established between an information system as implemented and its original specification.
- Case studies.
- End-of-chapter exercises, many of which are answered thus allowing students to pace themselves through the book.
Pricing and Order
Information Modeling (eBook)
Table of Contents
1. Introduction (brief intro to Z and to SQL)
2. Specific facts (relations and functions in Z)
3. Sets (set extension, comprehension, power sets, product sets)
4. Relations (database relations - Z style)
5. Introducing SQL
6. SQL retrieval (select from where)
7. SQL modularization (group by, views)
8. Facts and relations (conceptual schema modelling)
9. Uncovering facts (brief methodology)
10. Fact-based analysis (case-study)
11. Entity-relationship modeling
12. Knowledge (predicate calculus, quantification)
13. The knowledge base (intro to schemas in Z)
14. From specification to implementation (specifying in Z, implementing in SQL)
15. Database definition in SQL (create table, index, view)
16. Database manipulation in SQL (insert, update, delete)
17. Application programming
18. Case studies