spacer
rule
spacer
Relational Databases
spacer
rule
spacer

Edgar F. Codd invented the relational database. In his article "A Relational Model of Data for Large Shared Data Banks," which first appeared in Communications of the ACM, Vol. 13, No. 6, June 1970, Codd describes the 12 characteristics of a relational database system. Search the Intelligent Enterprise site (www.intelligententerprise.com) for commentary and discussion on the original 1970 article as well as on other articles by Codd. For additional insight into relational databases, refer to Codd's classic reference book, The Relational Model for Database Management (Addison-Wesley, 1990) in which he expands on his earlier work and defines 333 characteristics of a "pure" relational database system.

In "Overview of the Relational Model" at www.utexas.edu/cc/dbms/utinfo/relmod/index.html from the University of Texas at Austin's Database Management Services, you can find a simple explanation of the relational model and reasons why you might need to understand it. The Web-based document discusses the relational data structure, including notation, properties of relational tables, relational keys, and data integrity; manipulation of relational data; and normalization. There are also a brief reading list and links to other database resources on the Internet.

C. J. Date is one of the most prolific writers on the topic of databases. Through his extensive teaching, training, and writing activities, Date has explained the relational model to thousands of software engineers, software designers, educators, students, journalists, and end users. In a 1994 interview, Date talked about the future of the database industry and integrating object-oriented database concepts with relational concepts. Date's classic book on databases is now in its sixth edition: An Introduction to Database Systems (Addison-Wesley, 1999).


spacer
spacer
Additional Links

Jose's Database Programming Corner: The Relational Database Model   This web page presents an easy-to-follow introduction to relational database systems. It reviews key concepts including primary and foreign keys, queries, structured query language (SQL), referential integrity, and normalization.

Fundamentals of Relational Database Design   This introduction to relational database design includes good descriptions of database relationships--one-to-one, one-to-many, and many-to-many--and normalization. It also includes a 20-step approach to sound database design and examples from Microsoft Access.

Intelligent Enterprise: Database   In a series of articles, C. J. Date, one of the premier database experts, explores the world of relational databases and its impact on the business enterprise. The first article in the series is "The Birth of the Relational Model - Thirty Years of Relational." You can find all of the articles in the series listed in the sidebar at the right side of the page.


spacer
rule
spacer spacer spacer spacer spacer spacer spacer
Computer Concepts 4e spacer Computer Concepts and Computers, Technology, and Society spacer Return to the CD spacer Computer Concepts Illustrated
dotclear.gif (42 bytes)
spacer spacer spacer
spacer
Course Technology HomeAbout Course TechnologyCourse Technology
spacer
spacer