| Description |
1 online resource (xviii, 275 pages) : illustrations |
|
text file |
| Series |
Morgan Kaufmann series in data management systems |
|
Morgan Kaufmann series in data management systems.
|
| Bibliography |
Includes bibliographical references and index. |
| Contents |
The entity-relationship model -- The unified modeling language (UML) -- Requirements analysis and conceptual data modeling -- Transforming the conceptual data model to SQL -- Normalization -- An example of logical database design -- Business intelligence -- CASE tools for logical database design. |
| Summary |
Database systems and database design technology have undergone significant evolution in recent years. The relational data model and relational database systems dominate business applications; in turn, they are extended by other technologies like data warehousing, OLAP, and data mining. How do you model and design your database application in consideration of new technology or new business needs? In the extensively revised fourth edition, you'll get clear explanations, lots of terrific examples and an illustrative case, and the really practical advice you have come to count on--with design rules that are applicable to any SQL-based system. But you'll also get plenty to help you grow from a new database designer to an experienced designer developing industrial-sized systems: a detailed look at the Unified Modeling Language (UML-2) as well as the entity-relationship (ER) approach for data requirements specification and conceptual modeling--with examples throughout the book in both approaches; the details and examples of how to use data modeling concepts in logical database design, and the transformation of the conceptual model to the relational model and to SQL syntax; the fundamentals of database normalization through the fifth normal form; practical coverage of the major issues in business intelligence--data warehousing, OLAP for decision support systems, and data mining; examples for how to use the most popular CASE tools to handle complex data modeling problems; exercises that test understanding of all material, plus solutions for many exercises. |
| Language |
English. |
| Subject |
Relational databases.
|
|
Database design.
|
|
Database design -- Problems, exercises, etc.
|
|
Distributed databases.
|
|
Data structures (Computer science)
|
|
Bases de données relationnelles. |
|
Bases de données -- Conception. |
|
Bases de données -- Conception -- Problèmes et exercices. |
|
Bases de données réparties. |
|
Structures de données (Informatique) |
|
Relational databases. |
|
Database design. |
|
Distributed databases |
|
Data structures (Computer science) |
|
Database design |
|
Relational databases |
|
Banco de dados (projeto) |
|
Modelagem de dados. |
| Genre |
exercise books.
|
|
Problems and exercises
|
|
Problems and exercises.
|
|
Problèmes et exercices.
|
| Added Author |
Lightstone, Sam.
|
|
Nadeau, Tom, 1958-
|
| Added Title |
Database modeling and design |
| Other Form: |
Print version: Teorey, Toby J. Database modeling & design. 4th ed. Amsterdam : Elsevier ; Boston : Morgan Kaufmann Publishers, 2005 0126853525 9780126853520 (DLC) 2005052013 (OCoLC)61169898 |
| ISBN |
9780080470771 (electronic bk.) |
|
0080470777 (electronic bk.) |
|
1280961503 |
|
9781280961502 |
|
9786610961504 |
|
6610961506 |
|
More Resources