Lecture Essay

8114 Words Jun 30th, 2014 33 Pages
Database Modeling and Design: Logical Design

4th Edition

Toby Teorey, Sam Lightstone, Tom Nadeau

Lecture Notes

Contents

I. Introduction ................................................................………...……2 Relational database life cycle 3 Characteristics of a good database design process 6

II. The Entity-Relationship (ER) Model …………...……………….7 Basic ER concepts 7 Ternary relationships 11

III. The Unified Modeling Language (UML)………...…………….13 Class diagrams 13 Activity diagrams 19 Rules of thumb for UML 21

IV. Requirements Analysis and Conceptual Data Modeling….…..22 Requirements analysis 22 Conceptual data modeling 24 View integration methods 25 Entity
…show more content…
database management system (DBMS) -- a generalized software system for storing and manipulating databases. Includes logical view (schema, sub-schema), physical view (access methods, clustering), data manipulation language, data definition language, utilities - security, recovery, integrity, etc.

database administrator (DBA) -- person or group responsible for the effective use of database technology in an organization or enterprise.

Objectives of Database Management

1. Data availability—make an integrated collection of data available to a wide variety of users * at reasonable cost—performance in query update, eliminate or control data redundancy * in meaningful format—data definition language, data dictionary * easy access—query language (4GL, SQL, forms, windows, menus); embedded SQL, etc.; utilities for editing, report generation, sorting

2. Data integrity—insure correctness and validity * checkpoint/restart/recovery * concurrency control and multi-user updates * accounting, audit trail (financial, legal)

3. Privacy (the goal) and security (the means) * schema/sub-schema, passwords

4. Management control—DBA: lifecycle control, training, maintenance

5. Data independence (a relative term) -- avoids reprogramming of applications, allows easier conversion and reorganization

*

Related Documents