IS
333: Information Systems Development
Credits:
3(3,1,0), Prerequisite: IS 325
Short Description:
Information systems physical design and implementation within a database management system environment. Students design and construct a physical system using database software. Topics include data models and modeling tools/techniques, structured and object design approaches; Models for databases: relational, hierarchical, networked and object-oriented design; Graphical user Interface (GUI) coding and implementation; and client-server planning, testing, and installation. Students work in small teams applying previously learned knowledge. Students complete a major development project and are expected to present work they have accomplished to other students in the class using audio-visual tools.
Objectives:
This course is intended to
1. Provide students with an introduction to database programming and database application development using Oracle DBMS.
2. Guide students in analyzing, designing, implementing, and testing an information system using the client/server environment of Oracle 10g.
3. Provide students with an opportunity to apply the knowledge and skills they have acquired in the other system development courses, including systems analysis and design (IS 201, IS225, IS 325), interface design (IS 330), and database management systems (IS 223), and programming courses (CS 101, CS 102).
Learning Outcomes:
After completing this course, the student is expected to be able to:
1. Describe the fundamentals of the client/server approach and differentiate between various Client/server architectures.
2. Apply the systems life cycle and object-oriented and database development techniques for capturing requirements, and designing the database application.
3. Write correct and meaningful SQL programming code for.
· Creating database tables and populating them with values.
· Writing code for searching and retrieving data.
· Updating tables by insertion, deletion, and change.
4. Create database forms and reports using a specific database environment (Oracle 10g).
5. Develop an integrated database application and with interface components using a specific database environment (Oracle 10g ).
Topics Covered:
Part I: Introducing
Database Environment
1.
Introduction 1
week
1.1 Review of
Relational Database Design Concepts and Models
1.2 Review of
Client/Server Architectures
1.3 Personal and Client/Server Database Management Systems
1.4 The Oracle 10g Client/Server Database Management System
2.
Creating
and Modifying Database Tables (Chapter 2) 1
week
3.
Using
SQL Queries to Insert, Update, Delete, and View Data (Chapter 3) 1.5 weeks
4.
Introduction
to PL/SQL 1.5
weeks
CH4-Datafiles
5.
Creating Database
Forms (Chapter 5 + Chapter 6)) 3
weeks
6.
Creating Database
Reports (Chapter 7 ) 1.5
weeks
Ch7-Datafiles
7.
Creating an
Integrated Database Application (Chapter 8) 1.5
weeks
Ch8-Datafiles
Part II: System
Development
1. Presenting the
Business Case (Project Phase 1) 3
weeks
1.1
Description of the business under consideration
1.2
Capturing business requirements and business rules
1.3
Describing how the data flows in the business
1.4
Capturing user views (reports, forms, screens)
2. System
Requirements (Project Phase 2) 1.5
weeks
2.1 Objectives of
the system under development
2.2 Specifying
functional requirements
2.3 Specifying
nonfunctional requirements
2.4 Modeling
requirements using use-case diagrams
2.5 Writing and
modeling scenarios
3. Modeling Data (Project
Phase 3) 2
weeks
3.1 Identifying
entities and relationships
3.2 Identifying
attributes and identifiers
3.3 Constructing ER
diagrams
4. System Design (Project
Phase 4) 2
weeks
4.1 Logical database
design
4.2 Physical
database design
4.3 Interface design
4.4 Input and output
design
5. System
Implementation (Project Phase 5) 4
weeks
5.1 Database
environment
5.2 Creating
database tables (SQL coding)
5.3 Creating data entry
forms (Oracle 10g Forms Developer)
5.4 Populating
tables with values (SQL Insert or using Oracle Forms)
5.5 Coding user
views (SQL coding)
5.6 Creating table
indexes (SQL coding)
5.7 Creating reports
(Oracle 10g Reports Builder)
5.8 Creating an
integrated environment (Oracle 10g)
6. System Testing (Project
Phase 6) 1.5
weeks
6.1 Testing approach
6.2 Testing set
6.3 Testing results
Assessment:
Major exam 20% (week
7)
Team Project & Participation 40% (10% for class participation,
homework, and attendance)
Final 40%
Textbook:
·
Joline
Morrison, Mike Morrison, and Rocky Conrad. Guide to Oracle 10g.
Cambridge, MA: Course Technology a
division of Thomson Learning, 2006
Project:
·
Hotel Reservation System