database - Lecture Notes on Analysis & Design of...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
Lecture Notes on Analysis & Design of Accounting Databases Jagdish S. Gangolly 1 Department of Accounting & Law State University of New York at Albany September 24, 2003 1 c ± Jagdish S. Gangolly, 2003
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
2 PREFACE The main object of teaching is not to give explanations, but to knock at the doors of the mind. If any boy is asked to give an account of what is awakened in him by such knocking, he will probably say something silly. For what happens within is much bigger than what comes out in words. Those who pin their faith on university examinations as the test of education take no account of this. Rabindranath Tagore These notes are prepared exclusively for the beneFt of the students in the course Acc 682 Analysis & Design of Accounting Databases in the Depart- ment of Accounting & Law at the State University of New York at Albany, and are not to be used by others for any purpose without the express per- mission of the author. In these notes, I consider only Relational and Object-Relational Database Management Systems, and therefore do not deal with other DBMSes such as Hierarchical, Network, or pure Object databases. This should not be a major drawback in as much as the bulk of DBMSes used for accounting in the real world today are relational. I make use of much of the materials in the text for the course without explicit reference. The text is, A First Course in Database Systems, 2nd. ed by Je±rey D. Ullman and Jennifer Widom (Prentice Hall, 2002) Programming in Prolog, 4th ed. by W.². Clocksin and C.S. Mellish (Springer-Verlag, 1994) I shall be adding to these notes as we go along. You can download the Fle and print the pages that you need. You will Fnd the instructions for viewing postscript Fles on the course homepage at http://www.albany.edu/acc/courses/acc682.fall2003/ Jagdish S. Gangolly Albany, NY 12222
Background image of page 2
Contents 1 Introduction 5 1 . 1 F i l e -O r i en t edA c c oun t in gSy s t em s................ 5 1 . 2 D a t ab a s e s ............................. 8 1 . 2 . 1 C on c ep tu a lv i ew . .................... 9 1 . 2 . 2 A r ch i t e c r a lV i ................... 1 0 1.3 Database Integrity & ACID Properties . . . . . . . . . . . . . 11 2 Modeling of Databases 13 2 . 1 In t r odu c t i on. ........................... 1 3 2 . a t a s eM od e l g........................ 1 3 2 . 3 Ob j e c tD efn i t i onL an gu a g e(ODL. ............... 1 5 2 . 3 . 1 T yp e sinODL. ...................... 1 9 2 . 4 En t i t y -R e l a t i sh ipM e l.................... 1 9 2.4.1 Binary and Multiway Relationships . . . . . . . . . . . 20 2 . 4 . 2 W e akEn t i t yS e t s..................... 2 1 2 . 4 . 3 AS a l e sIn v o i c eEx amp l e................. 2 1 3 The Relational Model & Database Design 25 3 . t r c t i 2 5 3 . 2 Th eR e l a t i a lM e l....................... 2 6 3 . 2 . 1 AnEx l e :In v o i c eL e ................ 2 6 3 . 3 ODLT oR e l a t i a lD e s i gn s ................... 2 8 3.3.1 ODL To Relation Schema: Attributes . . . . . . . . . . 28 3.3.2 ODL to Relation Schema: Relationships . . . . . . . . 31 3 . 4 F r omERD st e l a t i a e s i 3 2 3.5 Relational Database Design Theory . . . . . . . . . . . . . . . 33 3 . 5 . un c t i a end c i e s................. 3 3 3 . 5 . 2 F ind gR e l a t i onK ey s .................. 3 6
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
4 CONTENTS 3.5.3 Reasoning about Functional Dependencies . . . . . . . 41 3.5.4 Relational Database Design Criteria . . . . . . . . . . . 42 3 . 5 .
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 48

database - Lecture Notes on Analysis & Design of...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online