Basic Computer Notions Databases

Next Collections of data Reasons for a DBMS Reasons for a DBMS (cont'd) Database organization Flat databases Hierarchical databases Hierarchical example Hierarchical example (cont'd) Hierarchical example (cont'd) Hierarchical example (cont'd) Hierarchical example (cont'd) Hierarchical example (cont'd) Hierarchical example (cont'd) Hierarchical example (cont'd) Hierarchical example (cont'd) Hierarchical example (cont'd) Hierarchical example (cont'd) Hierarchical example (cont'd) Relational databases Operations on tables Relational examples Relational examples (cont'd) Relational examples (cont'd) Relational examples (cont'd) Relational examples (cont'd) Relational examples (cont'd) 27 of 46 Relational implementation Relational software Object-oriented databases Abstraction Encapsulation Modularity Hierarchy Examples of class hierarchies Example of object hierarchy Events Object-oriented implementation Centralized databases Centralized databases (cont'd) Electronic Medical Records Electronic Medical Records (cont'd) Current efforts Current efforts (cont'd) Oacis DRG system

Relational examples (cont'd)

Example relational tables

Question #2: How many babies with birth weights > 2.5 kg have been delivered by each physician?

Results of Join with Table 2
B# BWt M# MHt MBirth Ph#
941830 3.6 392382177 4912 220
743920 3.4 392382177 4912 220
840238 2.7 238427162 5204 123
230484 3.4 123456150 4605 123
749200 2.9 649308174 5409 123
530284 3.7 123456150 4605 123
638201 3.1 649308174 5409 123

Now we can count the babies for each physician.

We've done 3 relational operations.

Start Next
Bacon home page
R. Funnell
Last modified: Wed, 2007 Mar 21 17:29:21

Slide show generated from dbms.html by Weasel 2007 Mar 21