STATE UNIVERSITY OF NEW YORK

COLLEGE AT OLD WESTBURY

 

BU 5010                                                                      Dr. A. Ebrahimi

Database Appl. For Managers                                 Office:   D222 AV
Spring 2005  (Tues/Thurs 8:00pm-9:40pm)               ( MW 2:30-3:30 and 8:00 – 8:30)

                                                                                   other time by appointment M/W/F)

                  

Phone: (516) 876-8594

E-mail: ebrahimi@juno.com, 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:
Tues Jan 25, Thurs Jan 27	Introduction to Database: What is a Database? What should managers know about Databases? What is the role of a DBA?
Tues Feb 1, Thurs Feb 3	Different kinds of Databases: MySQL, Informix, Sybase, Oracle
Tues Feb 8, Thurs Feb 10	Building a Database from scratch: journey from bit to byte to field ... Creating a DB using sequential files
Tues Feb 15, Thurs Feb 17	Databases and Web Technology, E-Commerce: DB using HTML tables, XML
Tues Feb 22, Thurs Feb 24	Making your Database Web-Oriented: DB host on server Connecting DB to Web using - CGI, PHP, Perl, ASP, JSP
Tues Mar 1, Thurs Mar 3	Object-Oriented Database
Tues Mar 8, Thurs Mar 10	Midterm and Project Presentations Part 1
Tues Mar 15, Thurs Mar 17	Database Integration to VB, C++, Perl, Java, C#, and others
Mar 20-27 Spring Recess	Oracle Database and connection to VB .Net
Tues Mar 29, Thurs Apr 31	Database security: What a manager should know about DB security? data validation, encryption, decryption
Tues Apr 12, Thurs Apr 14	Databases and search engines DB efficiency
Tues Apr 19, Thurs Apr 21	Generation of DB Reports (Crystal Reports and others)
Tues Apr 26, Thurs Apr 28	Project Presentations Part 2
Tues May 3, Thurs May 5	Review
May 9 - May 14 Exams Week	Final