CS3380: Database Applications

1
CS3380 Database Applications Information
Systems
Spring 2008

• Syllabus
• Technologies
• Course Overview

2
Instructor

• Jason Green
• Office 238 EBW
• Hours
• Mondays and Wednesdays, 34 pm
• Available by appointment
• jmg00d_at_mizzou.edu
• With Email Subject
• CS3380 __________

3
Teaching Assistant

• Peer Learning Assistant
• Daniel Lynn
• 242 EBW (TA lab)
• Office Hours
• Tuesdays and Thursdays, 1230 130 pm
• Also available by appointment
• ddlr25_at_mizzou.edu
• With email subject
• CS3380 __________

4
Introductions

• Name
• Major
• Year

5
Meeting Schedule

• Lecture Mondays and Wednesdays
• 1200 1250 pm,
• W0010 EBE (Lafferre)
• Lab Fridays
• 1200 1250 pm,
• 120 EBW

6
Course Prerequisite

• CS2050, or an equivalent Algorithms Data
  Structures Course
• Why do you need this prereq?
• Ensure knowledge of basic programming language
  constructs and data structures
• Gateway to getting credit for more advanced CS
  courses

7
Course Website

• Currently
• http//diglib1.cecs.missouri.edu/cs3380
• Will be moving to Babbage soon

8
Grading Grades

• 5 Participation
• 15 Lab Work
• 25 Computer Projects Homework
• 20 Midterm Exam
• 15 Final Group Project
• 20 Final Exam
• Grades will be assigned per the standard
  90/80/70/60 cut-offs, /- will be used.

9
Technologies and Languages Used in this Class

• Optional Use
• Perl
• C/C
• JAVA

• Required for Projects
• Linux OS
• SQL
• PL/SQL
• HTML
• PHP

10
Projects Homeworks

• Typically, 1-3 weeks to complete
• Data Modeling and/or MySQL (2-3)
• Oracle and/or PL/SQL (2-3)
• Group Project involving combination of
  technologies and topics covered over the semester

11
Demonstrating your knowledge

• There will be a few quizzes
• Lecture quizzes will be part of the participation
  grade (5 minutes)
• Quizzes in lab will be implementation/programming
  quizzes and part of the lab work grade
• Midterm 20 of Grade
• Final 20 of Grade

12
Databases and Languages

• Databases
• MySQL, first eight weeks
• Oracle, second half of semester
• Database Interface Languages
• SQL, Structured Query Language
• PHP, for web application development
• PL/SQL, for internal DB procedural tasks

13
Why Multiple DB and Languages?

• Each technology plays an important role in
  different levels of todays complex information
  systems hierarchy. No single technology is ever
  sufficient for all solutions!
• In this course, we may use HTML, PHP, Java, C,
  SQL, PL/SQL and Unix/Linux as needed.

14
Computer Languages

• Common in the information systems of today is the
  n-tier architecture instead of the stand-alone or
  even client-server model of computing.
• Often, systems are a blend of languages such as
  Java, C, or SQL and others, each comprising the
  implementation of various layers of the system.
• Projects will require you to interface with your
  database. Sometimes, you will be given a choice
  of languages to implement various components of
  your project.

15
Course Overview

• History of secondary storage and DBMS
• Conceptual, Logical, and Physical organization of
  data i.e. storing information not just data!
• Secondary Storage Systems and File I/O
• File Organization Schemes
• Survey of IS architectures

16
Course Overview cont

• Relational Data Modeling
• SQL
• ODBC JDBC
• MySQL database
• Oracle database, PL/SQL
• DBMS Applications Maintenance

17
Lab Topics

• Configuration
• Using Linux
• Basic HTML/PHP
• SQL
• Web Applications
• PL/SQL
• ODBC/JDBC

18
To Keep you busy

• Before Friday Lab
• Ensure that you can log in and use the Babbage
  system and IATS lab machines.see IATS HelpDesk
  to resolve problems prior to lab on Friday.
• babbage.cs.missouri.edu
• Read Chapter 1 in the text.
• First project will be posted Monday