SHAWNEE STATE UNIVERSITY

COURSE SYLLABUS

BUIS4300

Microsoft Visual Basic 2005 .Net and Advanced Database Applications

Instructor	Jean P Houser, Professor	Phone	351-3670
Office	227 Kricker	E-mail	jhouser@shawnee.edu
Office Hours	To be determined	Dept.	Business Dept. Management Information Systems

Credit Hours:

3

Class Location and Meeting Times:

To be determined at a later date

Materials Needed:

Doke, E, Satzinger, John, Williams, Susan, Douglas, David, (2003) Object-Oriented Application Development Using Microsoft Visual Basic .Net Thomson Course Technology

Course Description:

This course covers three-tier object-oriented application development using Microsoft Visual Basic .Net and the Visual Studio .Net integrated development environment (IDE). The course emphasizes developing business information systems for MIS students.

(Prerequisites: BUIS1010 Introduction to Computer Information Systems, BUIS 3100 Database Management, VB1, VB2)

Goals and Objectives:

The goals of this course are as follows:

n To provide the student with an understanding of OO Development

n To introduce the student to data access classes and persistence.

n To provide the student with a firm foundation for the entire OO development process. The three-tier design approach is emphasized so that user interface classes, problem domain classes, and data access classes will remain distinct from the beginning. UML will be used to show a model of every example.

The objectives of this course are as follows:

· Recognize the benefits of OO development

· Use three-tier design in OO development

· The student will make objects persistent

· Design a data access class.

· Communicate with a data access class.

· Use a relational database with VB .Net

· Implement a one-to-one association in a database application.

· Implement a one-to-many association in a database application.

· Apply parent-child (hierarchical) dataset relationships.

· Implement an association class in a database application.

· Combine a problem domain class, a data access class, and a GUI

· Use multiple GUI’s and add an instance to a database

· Use GUIs with multiple problem domain classes to interact with a database.

Student Expectations

Gain an understanding and ability of how to code in Visual Basic, a high-level programming language, using object-oriented programming approach for a three-tier database application.

University Disability Statement

For students who have a specific physical, psychiatric, or learning disability and require accommodations, please let me know early in the quarter so that your learning needs may be appropriately met. By law, it is your responsibility to provide documentation of your disability to the Office of Disability Services, located in the Student Success Center, Massie Hall, (Ph) 351-3594, PRIOR to receiving services.

Evaluation:

Program assignments, chapter tests, and final exam.

Instructional Delivery Method:

Lecture, class discussions, lab assignments

Licensure or Accreditation Statement

N/A

Tentative Topics Of Study:

Sequential File Processing

General Format for Stream Writer and Stream Reader

Making Objects Persistent

Designing a Data Access Class

Communicating with a Data Access Class

Using Relational Database with VB 2005 .Net

Implementing a One-to-one association in a database application

Implementing a one-to-many association in a database application

Applying parent-child dataset relationships

Implementing an association class in a database application

Combining a PD class, a DA class, and a GUI

Using Multiple GUIs and adding an instance to the database

Using GUIs with multiple problem domain classes

Deploying the Three-Tier Application