Dr. Alireza Ebrahimi

Welcome aboard to Database Application for Managers

1) What is a database?

2) What is database applications?

3) What is database applications for managers?

4) Database assignment: Design a DB interface, 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

5) what is the main function of database in Access?

6) Compare the existing relational database systems of, IBM I, Microsoft SQL Server 7/2000, Oracle DBMS, Informix, DB2, mySQL, Microsoft Access, dBase, Paradox, FoxPro, Visual FoxPro?

Access : relational Database management system (Jeffs' class contribution)

Oracle : relational Database management system (Pedros' class contribution)

IBM Informix :

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.