fundamentals of relational databases n.
Download
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


  • 122 Views
  • Uploaded on

Fundamentals of Relational Databases. Hugh Darwen hugh@dcs.warwick.ac.uk www.dcs.warwick.ac.uk/~hugh. CS252.HACD: Relational Database Theory (focussing on its application to computer language design) Section 0: Preface. Why?. Why study relational theory?.

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

PowerPoint Slideshow about 'Fundamentals of Relational Databases' - griffith


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

hugh@dcs.warwick.ac.ukwww.dcs.warwick.ac.uk/~hugh

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

slide2
Why?

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.
slide3
What?

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

slide4
How?
  • 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
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!