Course Organization

1
Introduction

• Course Organization
• System Engineering
• Software Engineering

2
Course OrganizationCourse Material and
Communication

• Course material at ww2.cis.temple.edu/cis580
• Use WebBoard/E-mail for class communicationcours
  einfo.temple.edu/courses/lefkovitzd_cis
• Asynchronous WebBoard BulletinBoard- multilateral
• Asyncrhronous WebBoard E-Mail - bilateral
• Synchronous WebBoard Chat - multilateral

3
Course OrganizationTexts and Documentation

• Required Textbook
• Oracle Developer/2000 FormsThe Practitioners
  Guide, Albert Lulushi, Prentice Hall, 1999.This
  book focuses on Developer, with introductory
  material on SQL, PL/SQL and Designer. It has a
  CD for the exercises.

4
Course OrganizationTexts and Documentation

• Optional Textbook
• Modern Systems Analysis Design, Hoffer, et al,
  Addison Wesley, 1998.This book introduces the
  specification and design methods of Structured
  Analysis and Object Oriented Analysis. It
  teaches the techniques of dataflow diagrams, UML
  and Use Cases. However, a major reason to
  acquire this book for this course is that for an
  additional 8.95 you get CDs for Oracle Designer,
  Developer and Database Server 7.3 that can be run
  on your own PC under Windows 95, 98 or NT.

5
Course OrganizationTexts and Documentation

• Recommended Textbook for Oracle Designer
• Oracle Designer/2000 The Practictioners Guide,
  Albert Lulushi, Prentice Hall, 1999.This book
  focuses on Oracle Designer. Those who wish to
  experiment with the design of modules and forms
  using Designer might want to get this book.

6
Course OrganizationTexts and Documentation

• Recommended Reference Manual for SQL
• The SQL Guide to Oracle, Rick F. van der Lans,
  Addison Wesley, 1996.This book has a
  comprehensive and clear explanation of SQL
  commands and appendices with the complete
  language syntax and the Built-in functions.

7
Course OrganizationTexts and Documentation

• OnLine Oracle Documentation at http//oracle2.cis.
  temple.edu/oradoc
• SQL
• PL/SQL
• SQLPlus
• Help Documentation within
• Designer
• Developer

8
Course OrganizationSoftware

• Client Software available in lab 209
• Oracle Designer 2.1
• Oracle Developer 2.1 and 6.0
• SQLPlus
• NotePad
• Word and Access 97
• System Architect
• Oracle ODBC
• Database Server Software
• Oracle 8i

9
Course OrganizationSoftware

• Access to Database
• Account your NT account name
• Password your NT password (initially)
• Database Name
• For Textbook Exercises c580text
• For Term Project c580proj

10
Course OrganizationAccess to Database - The
Password

• The password assigned to you on your Class
  Account form is a six character, randomized
  string. The symbols "1" and "o" in this string
  are interpreted as the letters l and o, not
  numbers.
• Oracle does not accept initial numerics in the
  username, password or database fields therefore,
  if your assigned password starts with a number,
  prefix it with the letter "t". If it already
  starts with a letter do not prefix it with the
  "t".

11
Course OrganizationAccess to Database - The
Password

• You may want to change it both in NT and the two
  databases. In NT, either use the Ctrl-alt-del
  keys or select StartProgramsAdministrative
  ToolsUser Manager.
• To change it in the two databases, log onto each
  database under the old password using SQLPlus.
  Then enter the SQL command
• Alter User ltUser Namegt Identified By ltNew
  Passwordgt
• Remember to start your new password with a letter.

12
SQLPlus and file editing
13
SQLPlus and file editing
14
Login and use SQLPlus

• 1. Run SQLPlus (3.3)
• 2. Enter your username, password and the database
  c580text.
• 3. At the SQL prompt enter the alter
  commandAlter User ltUser Namegt Identified By
  ltNew Passwordgt

15
Login and use SQLPlus

• 4. Use NotePad to create a new subdirectory in
  your own device space and then create the
  following 2 files Tables.sqlselect table_name
  from user_tables Test.sqlcreate table my_table
  (ID number, NAME char(30))insert into my_table
  values (1, yourname)
• 5. Return to SQLPlus and use the FileOpen to
  position yourself to this new subdirectory.

16
Login and use SQLPlus

• 6. Run each of these files from the SQL prompt
  by
• SQL gt _at_Tables
• SQL gt _at_Test
• SQLgt _at_Tables

17
Login and use SQLPlus

• 7. Now try the following
• SQL gt desc my_table
• SQL gt select from my_table
• SQL drop table my_table
• SQL gt Edit Test

18
Course OrganizationSoftware

• Client and Server Software Available for PC
• With Addison Wesley book (Optional)
• Oracle Designer 2.1
• Oracle Developer 2.1
• Oracle Database Server V 7.3
• With Textbook
• Textbook exercises

19
Course OrganizationApproach to learning the
Oracle development tools and Course Grading
20
Course Organization Approach to learning the
Oracle development tools and Course Grading
21
Course Organization

• This course is about
• Engineering
• System Engineering
• Software Engineering
• Use of Oracle Development Tools in the practice
  of Software Engineering Methodologies

22
Introduction

• Course Organization
• System Engineering
• Software Engineering

23
System Engineering Engineering

• A standardized or commonly understood process
  whereby a set of conceptual requirements can be
  implemented as an operational system that
  satisfies these requirements
• The Objective of this process is to assure an
  implementation that is
• feasible and economic
• operationally reliable
• operationally efficient in terms of cost, ease of
  use, and effectiveness

24
System Engineering System

• A system is a combination of four components
• Equipment or hardware
• People
• Procedures
• Reference information
• System Engineering is the process by which an
  optimum combination of the four components is
  specified, designed and implemented in order to
  satisfy the requirements.

25
System Engineering Development Process

• Specification
• Design
• Implementation

26
System Engineering Development Process

• Specification
• A restatement of the requirements in terms that
  are contractually complete, unambiguous and
  consistent. Specification is a statement of
  functional requirements and of what is to be
  built.

27
System Engineering Development Process

• Design
• A complete implementation plan of the
  specification. Design is a statement of how the
  system is to be built. Design is responsible for
  the above stated engineering optimization
  objectives
• feasible and economic
• operationally reliable
• operationally efficient in terms of cost, ease of
  use, and effectiveness

28
System Engineering Development Process

• Implementation
• Physical construction of the system based upon
  the design.

29
Introduction

• Course Organization
• System Engineering
• Software Engineering

30
Software Engineering

• Process Models
• Methodologies
• Architectures
• Tools

31
Software Engineering Process Models

• Build and Fix
• Waterfall (Conventional)
• Rapid Prototype
• Incremental
• Spiral
• Modified Waterfall for Visual and Event Driven
  Programming

32
Software Engineering Process Models - Build and
Fix

• Build first version
• Modify until client is satisfied
• Operation and maintenance

33
Software Engineering Process Models - Waterfall

• Requirements statement
• Specification
• Design
• Implementation
• Integration and test
• Operation and maintenance

34
Software Engineering Process Models - Rapid
Prototype

• Requirements statement
• Build rapid prototype
• Waterfall or
• Harden prototype into operational system

35
Software Engineering Process Models - Incremental

• Requirements statement
• Specification
• Architectural design
• Define a set of builds (subsystems)
• Define the interfaces among builds
• For each Build, in time phases
• Detailed design
• Implementation
• Integration and test
• Operation and maintenance

36
Software Engineering Process Models - Spiral

• Requirements statement
• For each development phase Requirements,
  Specification, Design
• Cycle through 5 processes
• Planning
• Risk analysis
• Prototyping
• Engineering
• Customer evaluation
• Implementation, Integration and test, Operation

37
Software Engineering Process Models - Modified
Waterfall

• Requirements statement
• Specification (Uses DFD, ERD, Use Case, Object
  Model)
• Design/Implementation (Uses DB Design, GUI
  Builder, Report Builder, Visual Programming)
• Integration and Test
• Operation and maintenance

38
Software Engineering Boehm Relative Cost Model
39
Software Engineering

• Process Models
• Methodologies
• Architectures
• Tools

40
Software Engineering Methodologies

• Structured Analysis and Design
• DeMarco
• Yourdan
• Object Oriented Analysis and Design
• Rumbaugh
• Object Modeling Technique (OMT)
• Booch and Rumbaugh
• Unified Modeling Language (UML)
• Jacobson
• Use Cases

41
Software Engineering Structured Analysis and
Design

• Business Process Diagrams (In Designer)
• Dataflow Diagrams (In Designer)
• State Transition Diagrams
• Module Hierarchy Diagrams (In Designer)
• Entity Relation Diagram (In Designer)

42
Software Engineering Object Oriented Analysis
and Design

• Use Cases
• Object Model
• Dynamic Model
• State diagram
• Object Interaction diagram
• Entity Relation diagram
• Functional Model (DataFlow diagram)

43
Software Engineering

• Process Models
• Methodologies
• Architectures
• Tools

44
Software EngineeringArchitectures

• Standalone
• Networked
• Centralized
• Distributed (LAN, Internet, Intranet)
• Client/Server (2-Tier)
• Client/MultiServer (N-Tier)

45
Software Engineering

• Process Models
• Methodologies
• Architectures
• Tools

46
Software EngineeringTools - Specification/Design

• Graphical tools for diagramming
• Structured Analysis and Design
• System Architect
• Designer
• Select
• Object Oriented Analysis and Design
• System Architect
• Textual tools for editing
• Built into the Graphical systems
• Word, Notepad, etc.

47
Software EngineeringTools - Design/Implementation

• Visual Programming tools
• Form Builder
• Report Builder
• Query by Example
• Visual coding aids
• Standard Compilers (C, C, Java, etc.)
• Debuggers (built into VP tools and Compilers
• Generation and Deployment of executables
• Standalone
• Network deployed
• Internet deployed

48
Oracle Development Tools Specification/Design
49
Oracle Development Tools Design/Implementation