Python Material

1. Cheat Sheet for Regular Expression ( Courtesy: www.dataquest.io )
2. python ppt for keywords, Data Types, Literals , print() & input(), Operators
3. Order of Programs in Neopat
1. Branching and Looping - Practice Test
4. Lists in python - external link
5. Dictionaries in python - external link

Introduction to Database 2021-22 ECE VII LBRCE

• Academic Calendar

• Roll List

• Time Table

  Day	Time	Class room
  Thursday	3:10-4:10	ECE IV year B Section
  Friday	3:10-4:10	ECE III year C Section
  Saturday	3:10-4:10	ECE III year B Section

• Syllabus

• Course Hand out / Lesson Plan

• Descriptive Questions ( Unit Wise)

• External Question Paper

• Objective Questions ( Unit Wise)

• Unit - I ( click for notes)

• Unit - II ( click for notes)

• Mid-I Question papers 

• Descriptive

• Objective

• Mid-I Marks

                             DESCRIPTIVE

                             OBJECTIVE

• Unit - III(ppt)( click for notes)

  • Notes for Relational Algebra and SQL (pdf)

    Video on Set Operations like Union, Join, Intersect and Minus - youtube

    Video on Cursors in SQL - youtube 
    

• Unit - IV

                       Functional Dependency (ppt)
                      Video Lecture on Functional Dependency(video)

                        Notes for Normalization(ppt)
                        Notes for Normalization(pdf)
                        Videos

                            1NF & 2NF

                                      3NF & BCNF 

 Unit - V 

                    Transaction System

                    Serializability of Schedules

                   Log based Recovery

                   Testing of Serializability

                   Check Point

                   ARIES Algorithm

                   Deadlock Handling

Mid-II Question Papers

                    DESCRIPTIVE

MID-II MARKS

                    DESCRIPTIVE

                    OBJECTIVE

CONSOLIDATED MID MARKS 

                     A SECTION

                     B SECTION

                     C SECTION

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