Dr. Alireza Ebrahimi

Cell Phone-917-279-4432  First Fifteen Minutes are free.

E-mail: ebrahimia@oldwestbury.edu

Site: www.drebrahimi.com

Class NOTES

Sample Test 1

Sample Test 2

TEST 3

Text: Manager's Guide to Database Technology, A: Building and Purchasing Better Applications
by Michael R. Blaha

 Reference Supplement: C++ Programming Easy Ways (Volume 1 & 2) Dr. A. Ebrahimi, American Press

A.1. Course Description: This course will focus on fundamentals of database design and applications from a management perspective. Topics will include database applications in business organizations and non-profits, user needs analysis, database design, database security, and database extensions.

A.2. Intended Audience:    MIS majors and interested business and other majors.

C. Mode of Instruction:

The class consists of both lecture and lab. During the lab, there will be demonstrations using Internet and web technologies.

D. Student Responsibilities:

1. Each student will be expected to complete project
2. There will be a test, midterm and final exam.
3. Students must plan to spend a minimum of two (2) hours per week outside of the class working with computer.

E. Grading:

Course grades will be assigned according to the following scale:

Course Policies:                                                              

Four or more absences may lead to failure                                                     
All work submitted for grading must be the student's own.
Student is responsible to obtain missing works
Each assignment is due one week (2 classes) later.                                          
The assignment will not be accepted after it has been solved.                        
Each week a late assignment will be divided by 2.

Project:

Part 1: Compare two existing databases according to their efficiency, friendliness, compatibility, and web-orientation. For each database, explain how it is integrated 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.

Each presentation is worth 5 points.

 

Date:	Topic:	Ref:
Wed Jan 23	Introduction to Database: What is a Database? What should managers know about Databases? What is the role of a DBA?
Mon Jan 28, Wed Jan 30	Different kinds of Databases: MySQL, Informix, Sybase, Oracle
Mon Feb 4, Wed Feb 6	Building a Database from scratch: journey from bit to byte to field ... Creating a DB using sequential files
Mon Feb 11, Wed Feb 13	Databases and Web Technology, E-Commerce: DB using HTML tables, XML
Mon Feb 18, Wed Feb 28	Making your Database Web-Oriented: DB host on server Connecting DB to Web using - CGI, PHP, Perl, ASP, JSP
Mon Feb 25, Wed Feb 27	Object-Oriented Database
Mon Mar 3, Wed Mar 5	Midterm and Project Presentations Part 1
Mon Mar 10, Wed Mar 12	Database Integration to VB, C++, Perl, Java, C#, and others
Mon Mar 24, Wed Mar 26	Oracle Database and connection to VB .Net
Mon Mar 31, Wed Apr 2	Database security: What a manager should know about DB security? data validation, encryption, decryption
Mon Apr 7, Wed Apr 9	Databases and search engines DB efficiency
Mon Apr 14, Wed Apr 16	Generation of DB Reports (Crystal Reports and others)
Mon Apr 21, Wed Apr 23	Project Presentations Part 2
Mon Apr 28, Wed Apr 30	Review
May 5 - May 7 Exams Week	Review

May 15 Exams Week

Final