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.