Introduction to Database

Syllabus

Course Hand out (or) Lesson Plan

MID - I MARKS - THEORY   

MID - II MARKS - THEORY - QUIZ - ASSIGNMENT MARKS

Descriptive QUESTIONS

Academic Calendar ( Revised & New )

External link for Textbook

 Unit - I

1. Database System vs File System - Video
2. video2 - Unit -1 - outline
3. ppt for notes - click here

Objective Questions - Unit I

Unit - II

1. ppt for notes - click here

        Objective Questions - Unit II

Mid - I Question Paper

Mid - I Quiz Question Paper

Assignment - Answer all questions from Mid I Descriptive Question Paper

Unit - III

1. Relational Data Model Concepts
2. Integrity Constraints, Relational Algebra, SQL- Tables, Views, Index, Query, Sub Query, Aggregate Functions, DML Operations, Set Operations and Cursors. 

Unit - IV

1. Functional Dependencies
2. Normalization - 1NF,2NF,3NF,BCNF, MVD & 4NF, Lossless Join decomposition, JD & 5NF, ID-Inclusion dependency.

Unit - V

1. Transaction System - Desirable properties of transaction
2. Testing of Serializability
3. Serializability of schedules
4. Conflict & View Serializable Schedule
5. recoverability
6. Log based recovery - external link
7. Check Points
8. ARIES algorithm - external link
9. Deadlock handling - external link

EXTERNAL QUESTION PAPER

Android Programming R17 IT LBRCE

 Android Programming Syllabus

Course Handout

Academic Calendar

Descriptive Questions

MID - I Question Paper  - Theory - Quiz

MID -II Question Paper - Theory - Quiz

Mid I -MARKS  

Mid II Marks

Quiz Marks

Previous Question Paper Nov 2017

Previous Question Paper Nov 2018

Unit - I  Introduction to Android platform

1. Android Architecture
2. Android Features
3. Various Versions of Android ( with Features)
4. Dalvik Virtual Machine, Emulator, Android App Components
5. Android Manifest File
1. Video for Manifest file
6. Android App Resources
7. Android Activity

Unit - II  Android User Interface

1. video - Android Studio Basics and sample android project creation 
2. Layouts
3. Basic Android UI -- External link
4. Android UI
5. Styles and Themes
6. Measurements
7. Fragments

Unit - III Intents and Broadcasts

1. ppt on Intents
2. ppt on BroadcastReceivers
3. ppt on Notifications
4. Intents - External Link
1. Youtube video on Intents
2. youtube video - practical - implicit intent
3. youtube video - practical - explicit intent
5. Broadcast Receivers 
   
1. Youtube video on BroadcastReceivers

Unit - IV     Data Storage

1. PPT for Files, Shared Preferences, SQLite & Content Providers
2. Youtube Video for SQLite Theory
3. Youtube Video for Content Providers Theory

Unit - V Advanced Topics

1. Location based Services - old
2. Location based Services - New
3. Alarms
4. RSS Feed(external link)
5. Using Camera(external link)
6. Gestures(external link)
7. Integrating PHP/MYSQL.(external link) - notes
8. Using Internet Resources – Connecting to internet resource, (external link) - Notes
1. using download manager. - notes
9. Publishing android app(external link)