Items to do research on:

1- What are the main functions of a database: will be on the exam  The main functions common to all databases are Create, Read, Update, Delete.

From http://apollo.saultc.on.ca/~fturco/courses/csd304/fall2002/ch10.htm

2- Why management should know about database.

3- What are the errors in database.

On the Department of Health and Human Services website-  The very critical issues of medical errors and patient safety have received a great deal of attention. In November 1999, the Institute of Medicine (IOM) released a report estimating that as many as 98,000 patients die as the result of medical errors in hospitals each year.  (http://www.ahrq.gov/qual/errorsix.htm) 

A) how do you add a record to Access?

The Google File System
Sanjay Ghemawat, Howard Gobioff, and Shun-Tak Leung
Google∗
ABSTRACT
We have designed and implemented the Google File System,
a scalable distributed file system for large distributed
data-intensive applications. It provides fault tolerance while
running on inexpensive commodity hardware, and it delivers
high aggregate performance to a large number of clients.
While sharing many of the same goals as previous distributed
file systems, our design has been driven by observations
of our application workloads and technological environment,
both current and anticipated, that reflect a marked
departure from some earlier file system assumptions. This
has led us to reexamine traditional choices and explore radically
different design points.
The file system has successfully met our storage needs.
It is widely deployed within Google as the storage platform
for the generation and processing of data used by our service
as well as research and development efforts that require
large data sets. The largest cluster to date provides hundreds
of terabytes of storage across thousands of disks on
over a thousand machines, and it is concurrently accessed
by hundreds of clients.
In this paper, we present file system interface extensions
designed to support distributed applications, discuss many
aspects of our design, and report measurements from both
micro-benchmarks and real world use.
(http://209.85.163.132/papers/gfs-sosp2003.pdf)

#include <fstream>
#include<iostream>
using namespace std;
main(){
int empid,hoursworked;
float hourlyrate, grosspay;
ofstream fout ("salary.txt"); //associating fout with salary.txt
for (int i=1; i<=5; i++){ //loop for 5 employees
cout<<" ENTER THE EMPLOYEE'S ID "; //interactive data entries
cin>>empid;
cout<<" ENTER HOURS WORKED ";
cin>>hoursworked;
cout<<" ENTER THE HOURLY RATE ";
cin>>hourlyrate;
grosspay= hoursworked * hourlyrate; //compute grosspay
fout<<empid<<" "<<hoursworked <<" "<<hourlyrate<<" "
<<grosspay<<endl; //writing to a file
}//FOR
fout.close( );
return 0; }//MAIN
 

(notes from last year class) Database Bu5010
Class notes
020507

Menu:

1. Review last class

2. Assignment:

part a:

            Database selection; create menu.

part b:

            Menu with prototype

part c:

            Insertion component
            Search component

3. Demo employee database

 Employee. C++ Database

menu and submenu prototype.

4. Textbook discussion

( Mon First vol. and Wed Second Vol.)

5. Research

    a) name 3 databases
           i. Access
           ii.Oracle
           iii. SQL

   b) How are they different?
   c) Are they intelligent?
   d) Temporal Database

6. Exam
            True/False( make 10 Ques.)

7. Building class Web

How the database is made?

• file
• record
• field
• character
• bit
   
     
     
        

8. Error, obstacle, problem discussion. 

" Each time you demo you recieve 5pts."