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)

WEB TECHNOLOGIES ECE VIII SEM section- A

Syllabus
Descriptive Questions
( FIND OUT WHETHER YOU CAN ANSWER ALL THESE QUESTIONS OR NOT)
Assignment Marks

External Exam Question Paper

External Exam Key

Unit - I

• HTML - VIDEO

• Notes
• Links & Tables

• CSS - VIDEO

• Notes

• Java Script - VIDEO

• Notes

Unit - II

• XML - good doc
• XML VIDEO 1
• XML VIDEO 2

• DTD - explanation about each tag in DTD
• XML Schema - explanation
• XML SCHEMA examples
• XSLT
• plain xml document
• XSLT document
• xml document with xml
• output for above program
• DOM & SAX Parsers
• Example program
• Java Beans
• ppt
• Example

Unit - III

• Servlet Introduction  - Video

• ServletRequest & ServletResponse
• web.xml for Servlet
• RequestDispatcher
• Session Management
• ServletConfig and ServletContext

Unit - IV

• JSP Introdction
• Components of JSP
• Conditional Processing
• Displaying Values using Expression
• Using expression to set an attribute
• Declaring variables and methods
• Error handling and Debugging
• JDBC THEORY

Unit - V

• Swings PPT - Lecture Notes - NEW
• Struts ppt - Under construction

• Youtube video for Swings introduction - click here 

  Youtube video for JApplet - click here 

• JLabel program 
• JButton Program
• JTextField Program
•   Youtube video for JLabel, JTextField & JButton - click here
• JCheckbox Program
• Youtube video for JCheckbox - click here
• JRadioButton Program 
• youtube video - click here
• JCombobox Program
• JTabbedpane Program
• JScrollpane Program
• youtube video - click here
• JFrame Program1
• JFrame Program2
•  youtube video - click here
• JTree Program
• youtube video - click here

17PD04 - Mini Project - 17Batch - V SEM - BTECH - IT

• Final Review Schedule
• Report Contents
• Rubrics

• Mini Project Guidelines
• Mini Project Assessment Committee
• Mini Project Schedule - I for Review on Project Title

Android Applications Lab

• Lab Syllabus
• Android Applications Lab Lesson Plan

Sample Experiments

0. How to create an android project in Android Studio

• Sample Android Code
• Youtube Video -How to create a new android application in Android Studio 

1. Experiment to handle Button Events

      1.1 Button Event handling within MainActivity ( like Adapter classes in java)

                                                 

 1.2 Button Event handling by using separate Listener Class (click on below link)

• Steps to follow

1.3 How to create an acitivity in Android Studio

• Sample Program on Layouts by using Explicit Intents
• 
  
• Implicit Intents And Actions ( To send sms, email and pick a contact)
• Document for GRIDVIEW,ARRAYADAPTER,IMAGES sample code

Programming skills

C language Outline
printf() and scanf()  

Questions on if, if-else and switch\

Questions on loops

Questions on Arrays ( GeeksforGeeks)

Questions on Functions

Test for V SEM IT STUDENTS for e-box training


Codevita Practise Test

R14 - Android Application Development - S130

R14 - Android Application Development - S130

• Syllabus - AAD
• Lesson Plan
• Previous Question Paper - Nov 2017
• Previous Question Paper - Nov 2018
• Descriptive Questions
• Assignment Questions

Lecture Notes

Unit - I

• Structure / Architecture of Android
• Historical Development of Cell Phones and Operating Systems
• Various Versions of Android
• Features of Android
• Android vs Symbian vs Windows Mobile

Unit - II

• Android software stack
• Activity
• Activity Life Cycle explanation through example(video)
• 
  
• Android App Resources
• Android User Interfaces --- > external link
• Android Layouts
• Intents - Click here for ppt --> external link
• Explicit Intents
• Implicit Intents
• YoutubeVideo Link
• Broadcast Intents- Event Broadcasting with Intents, Event Reception with Broadcast Receivers
• Adapters and DataBinding --- > External Link
• youtube link - to fill listview by using ArrayAdapter

Unit - III

• Configuring Android Manifest File
• Applying Menus and showing popup menus
• video for options menu
•   
• Video for Context menu
• code for context menu
• video for Popup Menu
• Dealing with Threads
• Location based services
• code for obtaining current location

Unit - IV 

TextBook to study - "Beginning Android 4 "   by Grant Allen, publishers-APress

Chapters to study - Chapter 32,33,34

• Classes and interfaces which are required to access SQLite database in android
• Example to access fill ListView from a Database

Unit - V

Notifications

• Broadcast Receiver
• Notifications,Services and Toast
• Alarm   ----> External internet link

Custom Components

• Custom Toast     ----> External Internet link
• Custom Toast and Custom Dialog Theory
• Custom Dialog Example     --->   External Internet Link
• How to use TabLayout        --->   External Internet Link
• Text Book for 
  • Topics- Adding Basic Network Support, Adding additional Network features, Adding Social Features, Creating a Home Screen App Widget.
• "Sams Teach Yourself Android Application Development in 24 Hours "
• please study these chapters- Hour 15, Hour 16, Hour 17 and Hour 18
•