fundamentals of relational databases n.
Skip this Video
Loading SlideShow in 5 Seconds..
Fundamentals of Relational Databases PowerPoint Presentation
Download Presentation
Fundamentals of Relational Databases

Loading in 2 Seconds...

play fullscreen
1 / 5

Fundamentals of Relational Databases - PowerPoint PPT Presentation

  • Uploaded on

Fundamentals of Relational Databases. Hugh Darwen CS252.HACD: Relational Database Theory (focussing on its application to computer language design) Section 0: Preface. Why?. Why study relational theory?.

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

Fundamentals of Relational Databases

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
fundamentals of relational databases
Fundamentals of Relational Databases

Hugh Darwen

CS252.HACD: Relational Database Theory(focussing on its application to computer language design)Section 0: Preface


Why study relational theory?

  • To understand the technology that is based on it, and how to use that technology.
  • To provide a basis for evaluating the current state of the art.
  • You’ll need it if you wish to bring about improvement in the database technology!
  • And on the way we learn something about how to distinguish between good and bad language design in general.

6 topics, 9 lecture slots:

1. Introduction

2. Values, Types, Variables, Operators

3. Predicates and Propositions

4-6. Relational Algebra

7. Constraints and Updating

8-9. Database Design Issues

  • Attend HD’s lectures and study the handouts.
  • Learn a relational database language, Tutorial D.(Devised for teaching purposes by C.J. Date and HD)
  • Do Tutorial D exercises on-line, using Rel.(Rel is Open Source software developed by Dave Voorhis, University of Derby)
  • Textbook (free download): An Introduction to Relational Database Theory by HD (based closely on CS252)
  • Further reading: Database In Depth by C.J. Date
important bit of admin
  • Are you:
  • an overseas student visiting for just one year, or
  • doing a degree that is completely outside the CS department? (In which case you should complete an Unusual Option Form, obtainable from your dept secretary)

If so, on exit from this lecture:

Write your name, ITS userid, and course code on the sheet of paper provided.

Otherwise you won’t get access to the software needed for the Worksheets!