Database Management: With Website Development Applications
以前，同じようなタイトルの書評を書きました。
ソフトウェアとの対応が書かれているデータベース教科書 | オブジェクト脳@kcg
今度もKCGI図書室で見つけた書籍です。RDB(リレーショナルデータベース）あるいは関係データベースの書籍というのは，SQLの具体例は書かれているのですが，ソフトウェアつまり，Oracle, MS SQL Server, Accessなどに即した記述をした教科書は日本にはほとんどありません。このAccess 2000をつかって，ウェブデータベースを作っていきます。
内容は，関係データベースモデル，構造化問い合わせ言語（SQL），データモデリングとE-R対応，データベース設計，データベース管理となっています。
本書には中文版が存在して，KCGI図書室にもあります。中文版には第７章がありません。
【目次】
I. INTRODUCTION TO INFORMATION TECHNOLOGY AND THE WORLD WIDE WEB.
1. Introduction to Information Systems.
What Are Information Systems and Databases?
Why Are Databases Important?
How Do Databases Represent Information?
Who Works with Database Systems?
How Do Databases Support the World Wide Web?
What Database Concepts and Terms Do You Need to Know?
2. An overview of Internet Architecture and Tools.
The Web: What Does It Consist Of?
Web Pages and HTML.
Web and Information Servers.
A Close Look at a Sample Web Site.
II. DESIGNING AND SPECIFYING INFORMATION SYSTEMS.
3. Representing Information with Data Models.
Data Models.
Discovering and Specifying Information Requirements and Terminology.
Organizing Information.
Relationships and Relationship Types.
Case in Point: Determining entity classes, attributes and relationship types for video sales.
4. Designing Entity-Relationship Models.
Entity-Relationship Modeling.
Entity-Relationship Diagrams.
Modeling Video Rentals.
Roles in Relationship Types.
An E-R Model for BigHit Video.
Object-Oriented Data Models.
Case in Point: E-R model for video sales for BigHit Video.
III. DESIGNING AND CREATING RELATIONAL DATABASES.
5. Developing Relational Data Models.
Introduction to the Relational Model.
A Closer Look at Relation Schemas and Keys.
Translating E-R Diagrams to Relation Schemas.
Representing Entity Classes as Relation Schemas.
Representing composite, multi-valued, and derived attributes.
Composite Attributes.
Multi-valued Attributes.
Derived Attributes.
Representing Relationship Types as Attributes.
One-to-many Relationship types.
One-to-one Relationship types.
Representing One-to-One Relationships by Merging Entities.
Representing Many-to-Many Relationships as Tables.
Representing Weak Entity Classes.
Representing Inheritance as Tables.
Case in Point: Relational model for video sales for BigHit Video.
6. Defining Relational Databases with Microsoft Access.
Creating an Access Database.
Creating Tables in Access.
Creating Forms from Tables.
Configuring Access for Multiple Users.
Specifying Relationship Types in Access.
Case in Point: Creating an Access database for Bighit Online Video Sales.
7. Improving Relational Schemas and Normalization.
Redundancy and Anomalies in Relation Schemas.
Functional Dependencies Between Attributes.
Superkeys and Keys.
Inferring Additional Functional Dependencies.
Determining Keys from Functional Dependencies.
Normalization.
Third Normal Form (3NF).
Boyce-Codd Normal Form (BCNF).
Case in Point: Normalization of a Car Registration.
IV. MANIPULATING RELATIONAL INFORMATION.
8. Manipulating Database Content with Relational Algebra and Microsoft Access.
Manipulating Information in Relational Databases.
Projection Queries.
Selection Queries.
Product Queries.
Queries with multiple join.
Combining Relational Operations.
Defining Complex Queries with Microsoft Access.
Applying Set Operators to Tables.
Creating User Interfaces in Access.
Case in Point: A Video Rental Checkout Form.
9. Using SQL to Manipulate Database Content and Structure.
Using SQL Select Statements for Queries.
Modifying Database Content with SQL.
Creating and Manipulating Schemas with SQL.
Case in Point: Manipulating BigHit Online Information with SQL.
V. CREATING INTERACTIVE WEB SITES.
10. Presenting Information on the Web with HTML.
Introduction to HTML.
Example of an HTML Document.
Anchor tags, URLs, and references to other documents.
Presenting information in tables.
Controlling format with style sheets.
Using external style sheets and style classes.
Case in Point: Design of the BigHit Online Web Site.
11. Creating Interaction between Users and Servers with ASP and JavaScript.
Active URLs and Forms in HTML.
Server-side scripting with ASP.
Processing forms with ASP and JavaScript.
Using objects and functions to improve code.
Case in Point: Forms and Interaction for BigHit Online.
12. Developing Database Applications for the Web.
Connecting to databases with ASP.
Executing select queries with ASP.
Creating objects from queries.
A general purpose query execution script.
Inserting new customer information.
Handling quote marks in SQL statements.
Case in Point: BigHit Online Web-Database Application.
VI. DEVELOPING AND MANAGING WEB-DATABASE INTERACTION.
13. Designing an Interactive Web Site.
Components of the BigHit Online Web site.
Data modeling for BigHit Online.
Relational Model for BigHit Online.
Creating a SQL Server Database.
Web Site Design, Pages, and Flow.
comments
