MIS 3500 Database Systems Course Summary Updated 2020

MIS 3500 Database Systems Course Summary Updated 2020 1

D B S Y S T E M S What We Have done Explored Database Systems (Database, Data Base Management System) Class Diagram (continuing on systems design & analysis course) Schema (normalized tables diagram, 3 NF) - new - in depth look at data modeling - data normalization, primary key design, PK-FK relationship

MESSAGES/TOPICS D B Databases are the king in the IS world! S Y S T E M S 3

MESSAGES/TOPICS D B S Y S T E M S Topic #1: Normalization What it is Normal Forms How to use in data modeling Educational goals: A) Being able to read/improve schemas B) Being able create normalized schema from system requirements 4

MESSAGES/TOPICS D B S Y S T E M S Know your data! Topic #2: Querying Read/Write SQL Exercise: class, homeworks, labs Use: Project on system development 5

OTHER TOPICS D B Database Transactions & Integrity File Types and Access Methods S Y S T E M S Forms and Reports Transactions, Concurrent Access DB System Recovery & Security OLAP, Data Warehousing, Cubing A look at non-relational/Big Data DB 6

STUDY METHODS D B S Y S T E M S Class exercises (Read/Write, Analyze/Create): Class Diagram & Schema Indexes Hands-on study (4 labs): Normalization, Querying My. SQL – expanded SQL use beyond querying System development with MS Access SQL Server (self-study materials due to inaccessibility of the Asper lab) 7

GUEST SPEAKER - canceled D B • Lazar Belos, Cybex Systems owner, developer: Analytics with latest Microsoft technologies S Y S T E M S 8

D B S Y S T E M S 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. 9