1 / 9

Database Systems Course Summary 2019

Explore database systems, schema design, normalization, querying, transactions, security, OLAP, and non-relational databases. Prepare for IS-related jobs with practical exercises and a guest speaker session.

handrade
Download Presentation

Database Systems Course Summary 2019

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. MIS 3500 Database Systems Course Summary Updated 2019

  2. What We Have done • Explored Database Systems (Database, Data Base 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. MESSAGES/TOPICS Databases are the kingin the IS world!

  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) Being able 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. OTHER TOPICS • Database Transactions & Integrity • File Types and Access Methods • Forms and Reports • Transactions, Concurrent Access • DB System Recovery & Security • OLAP, Data Warehousing, Cubing • A look at non-relational/Big Data DB

  7. STUDY METHODS • Class exercises (Read/Write, Analyze/Create): • Class Diagram & Schema • Indexes • Hands-on study (4 labs): • Normalization, Querying • MySQL – expanded SQL use beyond querying • System development with MS Access • SQL Server (self-study materials)

  8. GUEST SPEAKER • Lazar Belos, Cybex Systems owner, developer: Analytics with latest Microsoft technologies

  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. See ya at the final exam on April 12, 9-1:30 am, 106 Drake

More Related