Text and Websites
Readings for Database Design and Management


Home
References
In the News
Cyber-Briefcase
Learning Pyramid
Photos of Students
CIS100 Comp. Apps
The Internet - CIS120
Web Page Development
Tips and Tricks
Job Search
Fall '08  Schedule
Tutorial Sites
Hints for Printing
About M.L.G.
Disclaimer


 

This is not a textbook class.  This is a doing class.  You will learn by reading material in your textbook and recommended sites on the web and then applying the concepts.  

"I hear it and I forget, I see it and I remember it, I do it and I learn it."
 --- Old Chinese proverb

You will do a database design and implementation from beginning to end.  You will post your ork on the Message Board.  At each stage, you will get feedback from the prof and fellow students on how to improve it. With approximately a dozen students in the class, you will see good designs and poor ones.  You will study several designs of other students carefully and offer suggestions on improvement based on what you have learned from the text and websites.  

You will see the advice from me and other students on how to improve poor ones.   You will see your designs and your classmates' designs improve as each student incorporates the advice given. 

The text is

Database Systems: Design, Implementation, and Management, Fifth Edition

Database Systems: Design, Implementation, and Management, Fifth Edition

Author: Peter Rob, Carlos Coronel
Format: Paperback 850 pages
Publisher Course Technology/Thomson Learning
Publication Date: December 18, 2001
ISBN: 061906269x
List Price:  $ 73.95

Shopbots help you find the cheapest place to purchased books :

CourseDirectCourse Direct gives you at least 10% off ($66.55)  and they provide a  complete Chapter 1  so you can start reading before the book arrives.

Thus the publisher, Course seems to beat the prices at  or  Best Book Buys or

I have added very little additional reading.  Most of what I have to say is in the 

bulletassignments 
bulletthe glossary 
bulletthe FAQs
bulletand the posts that I will make to the bulletin board as the term progresses.  

Without a lecture, how will you know where to get started?  Reading.  Much of the subject mater is discussed on websites.  Database design is foreign to most people, even computer science students.  Rather than reading the same explanation over and over trying to understand it, read the same topic as explained by different authors, with different examples.  Each author will explain it from a different point of view.  Your time will be more effectively used by reading several sources and you will be more  successfully. Read not to memorize the text, but to be able to do the the assignments.

In addition to data base design, the web has lots of information on UML and diagramming.

Plan to read to text so that you can apply the concepts.   There will be NO quizzes where you simply have to memorize the material and parrot it back.  All quizzes are open book, open internet, open notes.  Quizzes will require that you demonstrate mastery of the design skills practices in the previous weeks.

If you would like to use another textbook (in addition) to read different explanations of the same material, several other excellent books that have been used in prior terms are available at the Union County College Library (check at the reserved desk), as well as at used book stores and online (try Half.com, which has an extensive inventory and great prices.)

Database Solutions : A Step-by-Step Guide to Building Databases by Thomas Connolly, Carolyn Begg was used for Fall 2001.  It was chosen because it does such a good job explaining the steps in database design.  
ISBN:
0-201-67476-9
Copyright: 2000
Price: $ 49.99
Binding: Paper Bound w/CD-ROM
Pages: 448
Includes:Includes CD-ROM
Database Systems: Design, Implementation, and Management, Fourth Edition
Note his earlier edition (3rd, 1997) looks pretty much the same except it lacks the chapter on the Internet

Database Systems: Design, Implementation, and Management, Fourth Edition by Peter Rob and Carlos Coronel ISBN: 0-7600-1090-0 ©2000 776 pages
The material in the following chapters are the basis of the assignments in the course:
1: File Systems and Databases
2: The Relational Database Model
3: An Introduction to Structured Query Language (SQL)
4: Entity Relationship (ER) Modeling
5: Normalization of Database Tables
6: Database Design
7: The University Lab: Conceptual Design
8: The University Lab: Conceptual Design Verification, Logical Design, and Implementation

Database Processing: Fundamentals, Design & Implementation, 7th Ed, by David M. Kroenke, copyright 2000, Prentice Hall, ISBN 0130848166 In the face-to-lace lecture version of this course the text has been: Database Processing: Fundamentals, Design & Implementation, 7th Ed, by David M. Kroenke, copyright 2000, Prentice Hall, ISBN 0130848166 601 pages.  It has a companion web site: http://cw.prenhall.com/kroenke2/. The material in the following chapters are the basis of the assignments in the course:
1. Introduction to Database Processing.
2. Introduction to Database Development.
3. The Entity-Relationship Model.
5. The Relational Model and Normalization.
6. Database Design Using Entity-Relationship Models.
8. Foundations of Relational Implementation.
9. Structured Query Language.
10. Database Application Design.
The 8th edition is out now so this can be gotten cheap.

You may purchase one of more of these texts or you may also get them from a college library.  

You may purchase them at UCC bookstore in Cranford or online.  Or you can use a shopbot:

or  Best Book Buys or

 to find the lowest price.  Don't forget Half.com

Remember that database design and the Entry-Relationship modeling has been around pretty much unchanged for 20 years.

[Site Map ] Home ] References ] In the News ] Cyber-Briefcase ] Learning Pyramid ] Photos of Students ] CIS100 Comp. Apps ] The Internet - CIS120 ] Web Page Development ] Tips and Tricks ] Job Search ] Fall '08  Schedule ] Tutorial Sites ] Hints for Printing ] About M.L.G. ] Disclaimer ]

 

This page was created by Professor Maureen Greenbaum and was last updated on 02/04/06 .
Page Name:  Text and Websites
URL:             http://faculty.ucc.edu/business-greenbaum/DB/Readings.htm
Disclaimer:   http://www.ucc.edu/professional_disclaimer.htm
Copyright:     
ã Maureen Greenbaum 2001,2002.  All rights reserved.