BU5010 DATABASE APPLICATION FOR MANAGERS

Back To Main Menu.

February 1, 2005


Project

Part 1 Compare two existing databases according to their efficiency, friendliness, compatibility and web
orientation. For each database, explain how it is integated with VB.net, PHP, PERL, JAVA, C++, C# and other languages. Each student should specialize on one particular database.

Part 2 For a manager to do his job, build two databases using different tools for each. Specify the differences and similarities and explain which one is better and why.

Chapter 9 and 20 has full details of the database structure

File Handling - A Database, create own database will consurve on space.

Different types of Files - Sequential File, Random Access File (faster then Sequentail File), Array File

Random Access - Modification of file is easy

Array File - Fastest search method

Modification of File - easier on Sequential File

Search is the heart of all Databases

Microsoft .net or Borland are the IDE environment for C++

IDE - Intregrated Development Environment

C++ program is listed below

#include (fstream)
#include (iostream)
using namespace std;
main(){
long int empid;
int hoursworked;
double hourlyrate, grosspay;
ifstream fin ("employee.txt");
fin))empid))hoursworked))hourlyrate;
grosspay= hoursworked * hourlyrate;
cout (("EMPLOYEE'S ID IS "((empid((endl;
cout (("THE GROSS PAY IS "((grosspay((endl;
return 0; }//MAIN

This program returns only one record - program needs a loop to retrieve more records.