MIS 4200 Systems and Database Analysis, Design, and Development

1
MIS 4200 Systems and Database Analysis, Design,
and Development
School of Business Eastern Illinois University
(Monday 8/25/2014)

• Abdou Illia, Ph.D
• aillia_at_eiu.edu

2
Objectives

• Class overview (course syllabus)
• Explain How class will be organized

3
Why a Systems and Database class?

• Information systems and databases are at the core
  of what makes todays organizations work
• Need for employees trained to effectively use,
  design, and manage systems and databases

4
What will be the focus?

• Learning principles of systems design
• Leaning how to use Oracle to create and manage
  database objects
• Use SQL and PL/SQL
• Develop basic database applications

• Note The class covers general principles of
  systems and DB design. It is designed to provide
  hands-on experience on creating and managing
  database objects. It doesnt give you the
  rigorous treatment that would make you an expert
  on the subject.

5
Course objectives
Knowledge

• Understand and apply the activities of the
  systems development life cycle (SDLC) including
  the analysis and design of user requirements

6
Course objectives
Skills

• Create appropriate systems diagrams and
  documentation to support the systems development
  life cycle.
• Create SQL data definition (DDL) and data
  manipulation (DML) code
• Apply relational and object-oriented database
  structures and schemas
• Develop and implement an integrated application
  using a client/server database in a team setting

7
Required Text
Valacich, George and Hoffer, Essentials of
Systems Analysis and Design, 10th edition,
Pearson Prentice Hall, 2012
Morrison, Morrison and Conrad, Guide to ORACLE
10g, Course Technology, 2006
8
Teaching Methods

• Lectures
• Discussions
• Hands-on
• Exercises

9
Grading
Points
Systems Questions 4 _at_ 15 points 60
Oracle assignments 8 _at_ 20 points 160
Systems/Database project 100
Final Exam 150
Quizzes To be determined ?
10
Grade calculation
Grades calculated by dividing amassed points by
MAX
11
Makeup

• Makeup in case of excused absence
• Excused absence
• Absence due to illness
• Absence due to an official University activity
• Absence due to emergency
• Students required to notify instructor in advance
• Late assignments subject to 25deduction. Note
  late assignment not accepted after a week.

12
Due dates

• Responsible to make sure assignments are turned
  on time
• Take-home exercise due at beginning of next class
• Lab hands-on due at end of lab session or (in
  some cases) at the beginning of next session

13
Website / E-mail address

• http//www.eiu.edu/a_illia/
• Syllabus
• Class Notes
• Assignments
• Your E-mail address
• Required to receive class-related notices
• Send me an e-mail (aillia_at_eiu.edu)
• Subject MIS 4200 email list
• Content Your-First-Name Your-Last-Name

14
Instructor Assistance

• E-mail aillia_at_eiu.edu
• Phone [phone]
• Office Hours
• T R 1000-1230
• and by appointment