MIS 3500 Database Systems

1
MIS 3500 Database Systems

• Course Summary

Updated 2015
2
What We Have done

• Explored Database Systems (Database, Database
  Management System)

• Class Diagram (continuing on systems design
• analysis course)

• Schema (normalized tables diagram, 3NF) - new
• - in depth look at data modeling
• - data normalization, primary key design,
• PK-FK relationship

3
Databases are the kingin the IS world!
MESSAGES/TOPICS
4
Get normal!
MESSAGES/TOPICS

• Topic 1 Normalization
• What it is
• Normal Forms
• How to use in data modeling
• Educational goals
• A) Being able to read/improve schemas
• B) Create normalized schema from system
• requirements

5
MESSAGES/TOPICS
Know your data!

• Topic 2 Querying
• Read/Write SQL
• Exercise class, homework, labs
• Use Project on system development

6
TOPICS

• Other specific topics
• Database Transactions Integrity
• File Types and Access Methods
• Forms and Reports
• Transactions, Concurrent Access
• DB System Security
• OLAP, Data Warehousing, Business
• Intelligence with SAP

7
STUDY METHODS

• Class exercises (Read/Write, Analyze/Create)
• Class Diagram Schema
• Indexes

• Hands-on study (4 labs)
• Normalization, Querying
• System development
• SAP Lumira (Business Intelligence/Analytics)

8
GUEST SPEAKERS

• Terry Bunio, DB/system expert from Protegra
• Comparison of relational DB and non-structured
  technologies (dimensional)
• Addressed almost all tech. we mentioned in the
  class
• Chuck Cohen, CIO from Richardson
• Relational DB is the king
• Analytics (Cognos) as help for casual.
  SQL-ignorant users
• Both speakers stressed the lasting importance of
  relations DB and that OLAP/Analytics is useful.

9
With MIS 3500 completed, you should have a
solid basis for various IS-related jobs, to
build on and expand in specific directions as
your job will demand.
Good luck with your further study and career
(and on the final exam ?)!