Review of last class

Welcome aboard to Database Application for Managers.

How many ways can you abbreviate database?  DB, Dbase..

For next class, answer the following questions.  You can use the textbook or any online website.

1) What is a database?

2) What is database applications?

 3) What is database applications for managers?

4) Database assignment: Design a DB interface for a manager of a sample company, be unique: from simplest ATM, or payroll examples, to a complex DB interface such as school registration system.

    a) Using any programming language such as C++, Java, Visual Basic, or    JavaScript

    b) HTML form

    c) Existing databases

Today's Work:  1/28/2007

1) What is a database?  A base for data.   What does this mean?  This is the location for data to be stored and retrieved.  For a database to be effective, it must be retrieved in a method that is efficient, accurate and useful. 

Another characteristic of a database is that data can be manipulated (this is usually done through the application or a database language like Transact SQL). 

Example of Data Manipulation\Reporting in a Payroll\Bank Database

    a)  Overtime pay report

    b) Reports based on transaction amounts for a bank (Over $10K)

    c) Computations- the calculation of average payroll across departments or the sum of total payroll liabilities.

Efficient databases and data manipulation are often used in making business decisions.

Who uses databases?

  a)  The entire company!!

   b)  Registrar and other college offices use databases to manage financial resources, facilities, staff allocations and assignments and student records/registration information.

Think of all the variables that could occur in just the student records database- In OW we have:

Full time students, part time students and non-matriculated students.  All of these data types must be managed and stored through a database and the application. 

2) What is a database application?  An interface and/or executable that allows access to the database in a method that is user friendly and efficient.

 3) What is database applications for managers?  A database application that allows decisions to be made about operations within a company.  It usually includes higher level functions over a standard user level application.

4) Database assignment: Design a DB interface for a manager of a sample company. Be unique: from simplest ATM, or payroll examples, to a complex DB interface such as school registration system or government database.

    What do we mean by an interface?  Take a look at chapter 2, there is an ATM machine example.

the program is on page# 31there is one written in C, and one written in C++:

INTERFACE = Between you and machine

( could be text and graphic) the most important is the content. usually graphics make it more friendly.

Question? can the information be trusted.

Use the example on page 31....

Part of the application should identify the name of the company/application.

With an ATM program on page 31 we have the following display:

Purpose:  cout<<< "Ebrahimi Bank of New York" <<endl;

  Functions: 

                    cout<< "\t 1. Deposit \t\t 2.Withdraw"<<endl;

                    cout<< "\t 3. Transfer \t\t 4.Loan"<<endl;

                    cout<< "\t 5. Balance \t\t  6.Help"<<endl;

Why do we focus on C++?   C++ is the foundation for the most popular database application on the Internet.

    Please review the syllabus. Click here to go to the Syllabus

Any contributions to class discussion will get you at least 2 points.

Look over the syllabus and bring any related materials to class for extra points toward classroom participation.

to do the WCM first make six pages (view example)

      1-open six pages

      2-copy this and fix the hyperlink to fit your page, then paste to all the pages.

3-  3-save as and name them home, syllabus, journal, project, exam, research, gallery