Database Systems
Spring 2019
http://www.cs.iusb.edu/~raman/db

Last Updated: Apr 18, 2019

nstructor Information
Course Information

Dr. Raman Adaikkalavan

NS 329, CS & Informatics

IU South Bend

Email: Canvas Message

CSCI C442, CSCI C690, INFO I451

Lectures               : NS 225, TR 6-7:15pm

Office Hours          : TR 4:00-5:00 PM

Online Appointment : Skype & Zoom

 

Resources
Announcements (also see oncourse announcements)
  • Tools             : Data Modeler, Developer, draw.io yEd, Dia, WorkBench,
  • Oracle            : LiveSQL, LiveSQL Intro, Connect, 18c Doc, Ask Tom KB, Others
  • SQL               : Book, Comparison, Std 2016, Intro [1] [2], Oracle SQL 1, 2, 3
  • RDB Classics    : E.F. Codd (IU access), System R, RDBMS List
  • Rel Algebra DB : LEAP
  • Research        : VLDB, SIGMOD, TKDE, TODS
  • Magazines, etc.: ITPro, IBM
  •  

     

     

     
    Tentative Schedule
    Date
    Tests
    Topics Discussed
    Assignment Due Dates
    1/8   - IUSB Academic Calendar
    - Text Book (Link)
    - Syllabus (pdf)
    - Student Survey
    - Basics - Ch1 (pptx)
     
    1/10
    - Arch - Ch2 (pptx)
    1/15   - Arch - Ch2 (pptx)

    1/17  
    - ER - Ch3 (pptx)
    1/22 Quiz 1
    Ch1 and Ch2
    - ER - Ch3 (pptx)
    1/24   Campus Closed
    1/29
     
    Campus Closed
    1/31

    Campus Closed
    - Chapter 3 & Problem solving Videos in Canvas

    2/5
    - ER - Ch4 (pptx) Project Phase 1
    2/7   - ER - Ch4

    2/12
    - Relational - Ch5 (pptx)
    2/14 Exam 1 - Samples (pdf) (pdf) Exam 1
    2/19   - Relational - Ch5
    - Conversion - Ch9 (pptx)

    2/21
    - Conversion - Ch9 (pptx)
    Project Phase 2
    2/26
    - Conversion - Ch9
    2/28 Quiz 2 - Algebra - Ch8 (pptx)
    3/5
    - Algebra - Ch8
    3/7
    - Algebra - Ch8
    3/12
    3/14

    Spring break; No classes;

    3/19
    - Phase 3
    - Ch 8

    3/21
    - Presentation

    3/26 Exam Sample (see under Exam 1 date) Exam 2 - Chapter 5, 9, and 8.

    3/28
    - Ch 6-7 DDL (pptx)(video)(zip)

    4/2
    - Ch 6-7 DDL
    - Ch 6-7 DML (video)(zip)
    Project Phase 3
    Presentation Topic Selection
    4/4
    - Ch 6-7 DML
    4/9
    - Ch 6-7 DML
    - Phase 4

    4/11 Quiz 3 SQL DDL & First 20 Queries

    Homework SQL
    4/16
    Student Presentations
    - Ch14 FD & Normalization (video)(pptx)

    - Bob - Block Chain Analytics
    - Careers and Certifications - Daniel and Andres
    Upload the presentations by 5.30 pm
    4/18
    Student Presentations
    - Authorization and Auditing - Ross and Josh
    - Data Warehousing - Connor
    - Data Mining - Jordan and Austin
    - Big Data - Stuart and Skylar
    - NoSQL DB - Jakob and Camden
    - In-memory and Embedded - Joshua and Aziz
    - Block Chain Databases - Ian and Kyle
    - James
    - Clarifying Trust in Social Internet of Things - Aditya
    - Course Overview, evaluation
    Upload the presentations by 5.30 pm
    4/23
    No Class - Work on Project Phase 4
    4/25
    No classes
    Project Phase 4 (Apr 28 @ 11.55 PM)
    Graduate Paper 4/30 before finals
    4/30 Final Exam (@ 5.30 pm) Chapters FD/Normalization, DML, DDL, Algebra, Conversion, Relational, ER, and EER.