Database Solutions : A step by step guide to building databases (2ND)

Database Solutions : A step by step guide to building databases (2ND)

  • ただいまウェブストアではご注文を受け付けておりません。 ⇒古書を探す
  • 製本 Paperback:紙装版/ペーパーバック版/ページ数 552 p.
  • 言語 ENG
  • 商品コード 9780321173508
  • DDC分類 005.74

Full Description

Are you responsible for designing and creating the databases that keep your business running? Or are you studying for a module in database design? If so, Database Solutions is for you! This fully revised and updated edition will make the database design and build process smoother, quicker and more reliable.

Recipe for database success



Take one RDMS - any of the major commercial products will do: Oracle, Informix, SQL Server, Access, Paradox
Add one thorough reading of Database Solutions if you are an inexperienced database designer, or one recap of the methodology if you are an old hand
Use the design and implementation frameworks to plan your timetable, use a common data model that fits your requirements and adapt as necessary

Contents

Part 1 Background
1 Introduction
2 The relational model
3 SQL and QBE
4 The database system development lifecycle
5 Database administration and security Part 2 Database analysis and design techniques
6 Fact-finding
7 Entity-Relationship modeling
8 Normalization Part 3 Logical database design
9 Logical database design - Step 1
10 Logical database design - Step 2
11 Enhanced ER modeling techniquesPart 4 Physical database design
12 Physical database design - Step 3
13 Physical database design - Step 4
14 Physical database design - Steps 5 and 6
15 Physical database design - Step 7
16 Physical database design - Step 8 Part 5 Second worked example
17 PerfectPets - Logical database design
18 PerfectPets - Physical database design Part 6 Current and emerging trends
19 Current and emerging trends Appendices
A Alternative data modeling notations
B Summary of the database design methodology
C Advanced logical database design
D File organizations and indexes
E Common data models Glossary References Index