programme : diploma in computer engineering programme code ... · the course 40 13 theory answer...

Programme : Diploma in Computer Engineering

Programme Code : 06/26

Name of Course : Terminal Equipment APP Development Using Android Framework

Course Code : CM581

Teaching Scheme:

Hours /Week Total HoursTheory 02 32Practical 04 64

Evaluation:

Progressive Assessment Semester End ExaminationTheory Practical Oral Term work

Duration Two class testseach of 60 minutes. 02 Hrs. – – –

Marks 10 40 50 50

Course Rationale:

Mobiles, tablets and electronic gadgets are very popular and widely used as a requisite to run our life

smoothly. And this is the reason Terminal Equipment App Development Environments like Android OS,

Symbian OS etc are popular and fastest growing environments which are widely used by Smartphone,

Tablets, and equipments. This course is designed to introduce and familiarize students of computer

engineering with such a popular environment so that respective skills on these environments help them

as skill development and enhancement, placement assistance, and for their career growth.

Course Outcomes:

Students should be able to

1. Configure Android Application Integrated Development Environme.

2. Use different Android application components using IDE.

3. Create UI for Android applications using UI controls.

4. Create and use Android database using SQLite.

5. Create and deploy Android applications using APIs with proper security features.

Course Contents:A. Theory

Specific LearningOutcomes (Cognitive,Domain) Topics and subtopics Hrs.

Section IUnits 1 : Overview Of Android Operating System

1.Overview Of Android OperatingSystem.2. Draw and explain Androidarchitecture.

1.1 What is Android Operating System?Identify key features for variousversions of Android. Identify the varioustools and software required fordeveloping an Android Application1.2. Android Architecture1.3 install android SDK,install Eclipse IDE development tool,create Android virtual devices,identifying the component of an Android,create simple program Hello world.

04

Unit 2: Configuration Of Andriod Environment

1. Install, configure, and operatedifferent IDEs2. Differentiate between JVM and DVM

2.1 Operating System, Java JDK,Andriod SDK2.2 Andriod Development Tools(ADT)2.3 Andriod Virtual Devices(AVDs)2.4 Emulators 2.5Dalvik Virtual Machine,Difference between JVM and DVM2.6 Steps to install and configure Eclipseand SDK

04

Unit 3: Android Components and Layouts

1.create Android components ,2. Describe Directory Structure.3. Identify different types of Layout.

3.1 Activities, Services, BroadcastReceivers, Content Provider,Fragments, Intents And Filter.3.2 Control Flow, Directory Structure,Understanding componentsof a screen, Fundamental UI Design,3.3 Linear Layout,Absolute Layout,Frame Layout,Table Layout,Relative Layout

06

Section IIUnit 4: Creating Android User Interface Elements

1. Use Android user interface Elements.2. Create an Android Application forSending Email ,Sending SMS, PhoneCalls.3. 3. Develop an Android Applicationfor Sending Email ,SendingSMS, Phone Calls.

4.1 Text View, Button, Image Button,EditTextCheckbox, ToggleButton,RadioButton And RadioGroup,ProgressBar, ListView, GridView,Image View, Scroll View, CustomToast Alert, Time And Date Picker.4.2 Creating Android Applicationfor Sending Email ,Sending SMS,Phone Calls.4.3Android Alert Dialog,Audio Capture, Bluetooth.

06

Unit 5: Android Databases1. Recognize android database SQLiteof operating system.2. Demonstrate different databasetransactions using thesedatabases.

5.1 SQLite, , Creating Database,Creating Tables, Databasehandling Different transaction withdatabase

06

Unit 6: Security and permission Application Deployment

1. Understand android security model.2. Demonstrate different permissionsand customizing permissions.3.Publish android applications

6.1 Understanding the Android SecurityModel, Declaring and UsingPermissions, Understanding andUsing Custom Permission.6.2 Application Deployment: CreatingSmall Application, Signing ofapplication, Deploying app on GooglePlay Store, Become a Publisher,Developer Console

06

Total Hrs 32

B. List of Practicals/Laboratory Experiences/Assignments:

PracticalNo.

Specific Learning Outcomes (PsychomotorDomain)

Units Hrs.

1 Introduction To Android OS and Setup Android De-velopment Environment

Configuration OfAndriod Environ-ment

02

2 Develop a program to Display Hello World OnScreen.

Configuration OfAndriod Environ-ment

02

3 Write a Program to create an activity Android Compo-nents and Layouts

02

4 Write a Program to create Service Android Compo-nents and Layouts

02

5 Write a Program to create BroadCast Receiver Android Compo-nents and Layouts

02

6 Write Program(s) for Explicit Intent and Implicit In-tent

Android Compo-nents and Layouts

04

7 Write A Program to create fragments. Android Compo-nents and Layouts

02

8 Write program(s) using Linear Layout,Absolute Lay-out„Frame Layout,Table Layout andRelative Lay-out.


06

9 Write a Program Using UI Control( Text View ,EditText , Auto Complete Text View)

Creating AndroidUser InterfaceElements

02

10 Write a Program Using UI Control( Button , ImageButton, Toggle Button )


02

11 Write a Program Using UI Control( Check Box , Ra-dio Button )


02

12 Write a Program Using ProgressBar. Android Compo-nents and Layouts

02

13 Write program to create List View andGrid View. Android Compo-nents and Layouts

04

14 Write a Program Using Time And Date Picker. Android Compo-nents and Layouts

02

15 Write programs to send email and SMS. Android Compo-nents and Layouts

04

16 Write a Program Using ProgressBar.Write pro-gram(s) for Alert dialog box, Android, Audio cap-ture


04

17 Write program(s) for Bluetooth, Camera Android Compo-nents and Layouts

04

18 Write program(s) for database transactions with An-droid OS.

Android Databases 06

19 Develop a mini project to create Android App, De-ploy and publish the App using Google Play Store.

Security and Per-missions, Applica-tion Deployment

10

Total Hrs 64

Instructional Strategy:Sr.No Topic Instructional Strategy1 Overview Of Android Operating System Explanation of Android Operating Sys-

tem and its development environment.Demonstration of Android environmentsetup.

2 Configuration Of Andriod Environment Explanation of Andriod SDKAndriodDevelopment Tools(ADT)Andriod Vir-tual Devices(AVDs)Emulators DalvikVirtual Machine,

3 Android Components and Layouts Demonstration of Android Componentsand Layouts

4 Creating Android User InterfaceElements Explanation of UI elements. Demon-

stration and hands-on practices on UIControls.

5 Android Databases Explanation of UI elements. Demon-stration and hands-on practices onUI Controls.Explanation of androiddatabases. Hands-on practices ondatabase transactions.

6 Security and Permissions, ApplicationDeployment Explanation on security and App devel-

opment and deployment. DemonstrateApp deployment and publishing App.Hands-on practice on App deployment.

Specification Table for Theory Paper:

Sr.No. Topic Cognitive Levels Total

Knowledge Comprehension Application1 Overview Of Android Operating System 02 02 – 042 Configuration Of Andriod Environment 02 04 02 083 Android Components and Layouts 02 02 04 084 Creating Android User Interface Elements 02 02 04 085 Android Databases 02 02 02 06

6 SecurityPermissions, Application Deployment 02 02 02 06

Total 12 12 16 40

Assessment and Evaluation Scheme:

What ToWhom Frequency Max

MarksMinMarks

EvidenceCollected

CourseOutcomes

DirectAssessmentTheory

ContinuousAssesment ST Students

TwoPT(averageoftwo tests)

10 –TestAnswersheets

1,2,3,4

– 1,2,3TOTAL – =

(TermEndExamination)

EndExam

End Ofthe Course 40 13

TheoryAnswersheets 1,2,3,4

DirectAssessmentPractical

ContinuousAssesment ST

Students

One skilltest at endof term

50 20PracticalAnswersheets

JournalWriting

Journal 4,5,6,


EndExam

End Of theCourse 50 20

PracticalAnswerSheets

4,5,6

IndirectAssessment

Student Feedbackon course Students

AfterFirstPT

Student Feedback Form 1,2,34,5,6

End exam End OfThe Course Questionnaires

Scheme Of Practical Evaluation:

S.N. Description Max. Marks1 Observations, 102 Practical Performance 203 Viva voce 20

TOTAL 25

Mapping Course Outcomes With Program Outcomes:

Course Outcomes Program Outcomes (POs)1 2 3 4 5 6 7 8 9 10

1 - 1 3 32 - 1 3 33 - 2 3 34 - 3 3 3

1: Slight (Low) 2: Moderate (Medium) 3: Substantial (High)

Reference & Text Books:

Text Book

Sr.No

Author Title Publication

1 Pradeep Kothari Android Application De-velopment

Kogent Learning Solu-tions

2 Timothy O’Leary &xLinda O’Leary

Computing Essential 2015 McGraw Hill

E-References:www.howstuffworks.com1. https://www.tutorialspoint.com/android2. https://www.tutorialspoint.com/android/androidadvancedtutorial.pdf



Name of Course : Windows Programming

Course Code : CM582

Teaching Scheme:

Hours /Week Total HoursTheory 02 32Practical 02 32Tutorial 02 32

Evaluation:



Marks 10 40 50 - 50

Course Rationale:

Today’s workplace is constantly changing and adopting new technologies. In this era of Visual Program-

ming it has become necessary to be able to develop GUI programs. As the industries rely on Visual C++

for its power and efficiency, VC++ has been used as the Windows Programming Tool. In this course

the students will get the most out of Windows Programming.

Course Outcomes:


1. Create Dialog Boxes.

2. Draw different object using GDI.

3. Interface I/O devices like keyboard and mouse using controls.

4. Distinguish between device coordinate and windows coordinate.

5. Use timer and apply child window control for windows application..



Section IUnits 1 : Overview of MS-Windows

1. Explain history of character set2. Define wild characters in windows.3.Describe basic windows program.4. Recognize windows message.

1.1 The Windows Environment, WindowsProgramming Options, YourFirst Windows Program,1.2. A brief History of Character Sets,Wide Characters And C, WideCharacters And Windows,1.3 Windows and Messages

4

Unit 2:An Exercise in Text Output:

1. Explain GDI.2. Describe device context.3. Use string and various stringfunctions.Draw different geometricobject using Line Function.4.Discuss GDI mapping mode.5. Define regions and clipping.

2.1 Introduction to GDI2.2 Scroll bars, Building a better Scroll2.3 The Structure of GDI, The DeviceContext2.4 Drawing Dots and Lines, DrawingFilled Areas2.5 The GDI Mapping Mode2.6 Rectangles, Regions and Clipping.

12

Section IIUnit 3:The Keyboard and Mouse

1. Define key-stroke messages.2. Classify client area mouse messagesand non-client area mouse messages.3.Describe hit-testing.4. Define capturing mouse.

3.1 Keyboard Basics3.2 Changing Attribute Va]luesDynamicallyKey-stroke Messages,Character Messages, Keyboard Messagesand Character Sets3.3 3Mouse Basics,3.4 Client- Area Mouse Messages,Non-Client- Area Mouse Messages,Hit-Testing in your Programs,Capturing the Mouse

08

Unit 4:The Timer

1. Memorize timer basics.2. Describe the methods for timer use.3. Explain different child windowcontrols.

4.1 Timer Basics4.2 Using the Timer: Three Methods,Using the Timer for a Clock,Using the Timer for a Status Report4.3 Child Window Controls4.4 The Button Class, Controls andColors, The Static Class,The Scroll Bar Class, The EditClass, The List Box Class

08

Total Hrs 32


PracticalNo.


Units TutorialHrs

Hrs

1 Getting Familiar with VC++, parts of a VC++ Pro-gram

Overview of MS-Windows

02 02

2 Writing Simple Programs using VC++. Overview of MS-Windows

04 04

3 Programs on drawing dots, lines An Exercise in TextOutput:

02 02

4 Programs on drawing filled areas, rectangles. An Exercise in TextOutput

02 02

5 Programs using Timer methods The Timer 04 046 Programs for implementing Child Window Controls The Time4 04 047 Programs for implementing Button class and con-

trolsThe Timer 02 04

8 Programs on Reading Keystrokes from the Key-board, Displaying Our Text, Finding the size of thewindow

The Keyboard andMouse

04 04

9 Programs for handling the Mouse. The Keyboard andMouse

04 04

10 Creating Check Boxes, Radio buttons, List Boxes,Combo Box, Scroll Bar

The Timer 04 04

Total Hrs 32 32

Instructional Strategy:Sr.No Topic Instructional Strategy1 Overview of MS-Windows Lecture method, Demonstration2 An Exercise in Text Output Lecture method, Demonstration3 The Keyboard and Mouse Lecture method, Implementation4 The Timer Lecture method, Implementation



Knowledge Comprehension Application1 Overview of MS-Windows 02 02 02 062 ArAn Exercise in Text Output 02 02 06 103 The Keyboard and Mouse 02 04 06 124 The Timer 02 04 06 12

Total 08 12 20 40



MarksMinMarks

EvidenceCollected

CourseOutcomes





1,2,3,4,5

– 1,2,3,4,5TOTAL 10 =


EndExam


TheoryAnswersheets 1,2,3,4,5



Students


– –PracticalAnswersheets

JournalWriting

Assignments 50 20 Journal 1,2,3,4,5TOTAL 50 20


EndExam



4,5,6

IndirectAssessment


AfterFirstPT




S.N. Description Max. Marks1 Demonstration 202 Result 103 Viva voce 20

TOTAL 50



1 2 1 12 - 2 1 13 - 2 1 14 - 3 1 1



Text Book

Sr. No Author Title Publication1 AchyutGodbole Demystifying computer —2 Timothy O’Leary &x Linda O’Leary Computing Essential 2015 McGraw Hill

3 Kadar Seema Principles of Programminglanguage Technical Publications

E-References:www.howstuffworks.com1. http://www.tutorialspoint.com/computer fundamentals2. http://ecomputernotes.com/fundamental/introduction-to-computer/what-are-characteristic-of-a-computer3. https://www.tutorialspoint.com/data structures algorithms/algorithms basics.htm4. http://www.officetutorials.com



Name of Course : Web Technology Using JavaScript

Course Code : CM583

Teaching Scheme:


Evaluation:



Marks 10 40 50 - 50

Course Rationale:

In the current era, Web Sites are one of the important component in Business success. People need

classy websites with catchy features and features which makes the website smart enough to help the

surfer enter appropriate information and perform tasks correctly. JavaScript is one such limited feature

programming language used to build dynamic Web Pages and respond to events. Helps create highly

interactive Webpages.

Course Outcomes:


1. Build dynamic web pages.

2. Display alert boxes.

3. Write messages to the Browser status bar.

4. Customize browsers.

5. Validate information on forms.

6. Create interactive forms.



Section IUnits 1 : An Inside Look At JavaScript Programming

1. Enlist various advantages anddisadvantages of using javascript.2. Create a javascript page usingvarious control and looping structure.

1.1 Getting Down To JavaScript1.2. Values and Variables1.3 Operators and Expressions1.4 if Statement1.5 switch. . . case Statement1.6 Loop Statement

4

Unit 2: Arrays ,Functions and String

1. Install, configure, and operatedifferent IDEs2. Use functions in the javascript.3. Use string and various string functions.

2.1 Array : Declaring, DefiningLoopingThe Array, Adding Array Element,2.2 Sorting Array Elements2.3 Making a New Array from anExisting Array, Combining ArrayElements into a String, ChangingElements of the Array2.4 Function : Defining, The Scope ofVariables and Arguments, Calling aFunction, Function Calling AnotherFunction, Returning Values from aFunction.2.5 String : Joining Strings,Dividing Text, Converting Numbers andStrings, Changing the Case of theStrings,Strings and Unicode

8

Unit 3: Forms and Event Handling

1. Use event handling to handlevarious user initiated eventsat runtime.2. Write javasript to handle formsusing intrinsic function.

3.1 Building Block of a Form,Responding to Form Events,Form Objects and Elements3.2 Changing Attribute Va]luesDynamically3.3 Changing Option List Dynamically3.4 Evaluating Check Box Selections,Manipulating Elements Before the Form,Disabling Elements, Read-Only Elements3.5 Using Intrinsic JavaScript Functions3.6 Changing Labels Dynamically

10

Section IIUnit 4: Cookies and Browser Windows

1. Use cookies in javascript pagesto make user experience moreinteractive.2. Managing multiple windows in anweb application.

4.1 Cookie Basics, Creating, Reading,Setting the Expiration Date,Deleting4.2 Personalizing and ExperienceUsing a Cookie4.3Giving the New Window Focus4.4 Placing an Window into Positionon the Screen4.5 Changing the Contents of a Window4.6 Closing the Window4.7“Magically” Scrolling a Web Page4.8 “Magically” Scrolling a Web Page4.9 Creating a Web Page in a NewWindow

10

Unit 5: Regular Expressions, JavaScript and Frames

1. Use regular expressions to validatethe forms.2. Use frame to structure the webpage, and managing frames.

5.1 Regular Expression: The Languageof a Regular Expression, ReplaceText , Return the Matched Characters5.2 Using a Regular Expression5.3Invisible Borders5.4Calling a Child Windows JavaScriptFunction5.5 Changing the Content of a ChildWindow5.6 Changing the Focus of a ChildWindow5.7 Writing to a Child Window from aJavaScript5.8 Accessing Elements of Another ChildWindow

8

Unit 6: Rollovers, Status Bar, Banners, Slideshow, Protecting Your Webpage

1.Implement banners slideshow androllovers to make website comealive.2.Protect the web page fromeavesdropping.

6.1 Setting the Stage6.2 Creating a Rollover6.3Text Rollovers6.4 Multiple Actions for a Rollover6.5 More Efficient Rollovers6.6 Making Magic Using the Status Bar6.7 Banner Advertisements6.8Creating a Slideshow6.9Hiding Your Code6.10 Concealing Your E-mail Address

8

Total Hrs 48


PracticalNo.


Units Hrs.

1 Executing Programs based on decision making state-ment and looping statement

An Inside LookAt JavaScriptProgramming

04

2 Executing Programs based on arrays functions and Ar-rays ,Functions andString

04

3 Executing Programs based on strings functions and Ar-rays ,Functions andString

04

4 Program using Form Objects Forms and EventHandling

04

5 Program using Form Elements Forms and EventHandling

04

6 Program using Form Events Forms and EventHandling

04

7 Program using Intrinsic Java Functions Forms and EventHandling

04

8 Programs for Using and Personalizing cookies Cookies andBrowser Windows

04

9 Programs for placing the Window on the screen. Cookies andBrowser Windows

04

10 Programs for accessing child Window. Regular Expres-sions, JavaScriptand Frames

04

11 Programs for implementing regular Expression Regular Expres-sions, JavaScriptand Frames

04

12 Programs for implementing Rollovers Rollovers, StatusBar, Banners,Slideshow, Protect-ing Your Webpage

04

13 Programs for implementing Status bars and WebPage Protection

Rollovers, StatusBar, Banners,Slideshow, Protect-ing Your Webpage

04

14 Programs for implementing Banners, Slideshow Rollovers, StatusBar, Banners,Slideshow, Protect-ing Your Webpage

04

15 Programs for implementing Banners, Slideshow Rollovers, StatusBar, Banners,Slideshow, Protect-ing Your Webpage

04

16 Mini Project implementing features of JavaScript. 08Total Hrs 64

Instructional Strategy:Sr.No Topic Instructional Strategy1 An Inside Look At JavaScript ProgrammingClass room teaching, laboratory work2 Arrays ,Functions and String Class room teaching, laboratory work3 Forms and Event Handling Class room teaching, laboratory work4 Regular Expressions, JavaScript and

FramesClass room teaching, laboratory work

5 Rollovers, Status Bar, Banners,Slideshow, Protecting Your Webpage

Class room teaching, laboratory work

6 Cookies and Browser Windows Class room teaching, laboratory work



Knowledge Comprehension Application

1Classification and Componentsof ComputerAn Inside Look At

JavaScript Programming02 02 - 04

2 Arrays ,Functions and String 02 - 06 083 Forms and Event Handling 02 - 06 084 Cookies and Browser Windows 02 - 05 07

5 Regular Expressions, JavaScriptand Frames 02 - 05 07

6 Rollovers, Status Bar, Banners,Slideshow, Protecting Your Webpage 02 - 04 06

Total 12 02 26 40



MarksMinMarks

EvidenceCollected

CourseOutcomes




10 03TestAnswersheets

1,2,3

– 1,2,3TOTAL 10 03


EndExam


TheoryAnswersheets 1,2,3



Students


20 –PracticalAnswersheets

JournalWriting

Assignments 30 – Journal 4,5,6,TOTAL 50 20


EndExam



4,5,6

IndirectAssessment


AfterFirstPT




S.N. Description Max. Marks1 Demonstration 202 Result 103 Viva voce 20

TOTAL 50



1 3 3 3 1 12 3 3 3 13 3 2 34 3 2 35 3 2 26 3 3 3



Text Book

Sr. No Author Title Publication1 Jim Keogh Javascript Demystified Tata McGraw Hill2 Michael Moncur Javascript in 24 hours(SAMS teach yourself) TechMedia

E-References:www.howstuffworks.com1. http://www.tutorialspoint.com/2. https://www.javascript.com/3. ://javascript.info/4. https://www.codeschool.com/learn/javascript

Programme : Diploma in Computer Engineering/Information technology

Programme Code : 06/26/07

Name of Course : Multimedia Techniques

Course Code : CM584

Teaching Scheme:


Evaluation:



Marks 10 40 50 – 50

Course Rationale:

Animation has given a boost to various areas like film production, e-learning animated web-site etc.

This subject will enable the students to implement their creative imagination to produce animated text

images. It is a practical oriented subject which deals with various fonts, audio video formats, and basic

shapes, images to the controls, tools animation. Students will develop the skill for using the basic

shapes, text, images apply controls, Colors to create final animated multimedia object.

Course Outcomes:


1. Identify multimedia files and devices.

2. Use images, audio, video files for multimedia systems.

3. Develop multimedia applications in distributed environment.

4. Create Animation and Integrate Audio and Video

5. Integrate Multimedia in Web Pages.



Section IUnits 1 : Introduction To Multimedia

1.Define Multimedia2. Signify need of multimedia invarious fields of live3.Determine different basic tools andstorage used for developing multimedia.

1.1 Definitions -Where to use Multimedia,Multimedia in Business, Multimedia in Schools,Multimedia in Home, Multimedia in Public Places,Virtual Reality1.2Basic Tools- I/P, O/P devices, PaintingDrawing Tools, OCR Software, Digital v/s Analog,CRT display System, Display Terminology, FlatPanel Display1.3 Magnetic Media Technology, Hard diskTechnology, RAID, Criteria for Selection ofRAID, Use of Magnetic Storage in Multimedia,Optical Media, Magneto Optical

06

Unit 2: Multimedia Building Blocks and Compression/Decompression with File Formats

1.Describe various file formats.2.State need of compression andadvantages of compression3.Describe audio file formats and QOSArchitecture.

2.1 Images- Introduction to RIFF, AVI, JPEG,Bitmap file Format, Index Chunk and Boundary,condition handling for AVI files. Design Elements2.2Compression and Decompression-Types ofcompression ,Need of Data Compression ,Color GrayScale and Still Video Image , Color CharacteristicsColor Model2.3 Sound-Digital audio, Audio file format, MIDIVersus Digital Audio, Synchronization,Orchestration and QOS Architecture

08

Unit 3: Architecture and Issues For Distributed Multimedia System1.Explore and Describe MultimediaSystem Architecture.2. Define term Distributed Multimediaand specify its need3. Design framework for multimedia

3.1 Multimedia System Architecture.3.2 Distributed Multimedia3.3 Synchronization, Orchestration andQOS Architecture3.4 Framework for Multimedia System

06

Section IIUnit 4: Distributed Multimedia Systems1.Describe Distributed multimediaand transformation techniques2. Apply various operation on clientserver3. Describe various terms likeClient Server Operation, object Serverand Multimedia Databases

4.1Components of Distributed MultimediaSystems engineering tasks4.2 Distributed Client Server Operation.4.3 Multimedia Object Server4.4 Multi Server Network topologies4.5Distributed Multimedia Databases

04

Unit 5: Animation and Video1.Define Animation and stateprinciple of Animation2. Discover working of Video.3.Deal with Digital Video

5.1 The Power of motion, Principles of Animation5.2 How Video Works, and Broadcast VideoStandards5.3 Digital video, Study of story board.

04

Unit 6:Multimedia Authoring Tools

1. Use various Authoring Tools.2. Design Animation using various

6.1 Types of Authoring Tools-Different .6.2 Card- and Page-Based Authoring tools6.3 Icon-and Object Based Authoring toolsTime Based Authoring tools.

04

Total Hrs 32


PracticalNo.


Units PracticalHrs.

1 Installation of Adobe Flash, Photoshop and Coreldraw software

Units 1 :Introduc-tion ToMultimedia

04

2 Creating any simple video in Movie maker usingTimeline and Sound.

Units 1 : An-imation andVideo

02

3 Corel Draw Assignments Implementing and Study ofall tools in Corel Draw software Implementing differ-ent fonts of text on the screen Creating Wallpaperusing multiple tools of Corel draw Applying DropShadow effect or vignette effect or mirror, reflectioneffect etc. to text Merging photographs and rotateand change rotation center in CorelDraw Interfac-ing of sound, editing, mixing sound, cropping, crossfading and effect Creating Banner effect etc

Units 1 : An-imation andVideo

15

4 Photoshop Assignments Implementing and Study ofall tools in Photoshop software Creating or AddingRainy Season effect in image Creating funny imageCreating water drop effect in image Designing posterby using different Text effect (Ketchup, rope, Fire,fruit) Create broken mirror effect, Flaming ball ef-fects Interfacing of images, Resolution, Editing, colormodes. Setting current and background colors.

Unit 2:An-imation anVideo

15

5 Adobe Flash Assignments Implementing and Studyof all tools in Adobe Flash software Study andImplementing Shape and Motion Tweening inflash.Example for Implementation of types of sym-bols Creating Animation using Motion guide layerCreating Animation using Masking Creating Bounc-ing and Rolling ball down etc examples Controllingwindows to load URL, Creating advanced/animatedbuttons Creating Roll Over/Roll Out effect on but-tons Rotating ball using scripting and other Script-ing Animation etc Create Animation for Start/StopButton for Animation using Script Create AnimationUsing Progress Bar preloaded Action Script LoadingSound into Animation Clip

Unit 2: An-imation andVideo

20

6 Mini project -Create a movie of minimum 15 min-utes.

Unit 3: An-imation andVideo

08

Total Hrs 64

Instructional Strategy:

Sr.No Topic Instructional Strategy1 Introduction To Multimedia Classroom teaching2 Multimedia Building Blocks and Com-

pression/Decompression with File For-mats

Classroom teaching, laboratory demon-stration

3 Architecture and Issues For DistributedMultimedia System

Classroom teaching

4 Distributed Multimedia Systems Class room teaching, laboratory work5 Animation and Video Class room teaching, laboratory work6 Multimedia Authoring Tools Class room teaching, laboratory work



Knowledge Comprehension Application1 Introduction To Multimedia 02 02 03 07

2 Multimedia Building Blocks andCompression/Decompression with File Formats 02 02 03 07

3 Architecture and Issues ForDistributed Multimedia System 02 02 02 06

4 Distributed Multimedia Systems 02 02 03 075 Animation and Video 02 02 02 066 Multimedia Authoring Tools 02 02 02 06

Total 18 14 08 40



MarksMinMarks

EvidenceCollected

CourseOutcomes


ContinuousAssesment PT Students

TwoPT(averageof two testswill becomputed)


1,2,3

Assignment – AssignmentBook

1,2,3

TOTAL 10 =(TermEndExamination)

EndExam


TheoryAnswersheets 1,2,3



Students


20 –PracticalAnswersheets

JournalWriting

Assignments 30 – Journal 4,5,6,TOTAL 50 20


EndExam



4,5,6

IndirectAssessment


AfterFirstPT




S.N. Description Max. Marks1 Evaluation 152 Practical Execution 153 Viva voce 20

TOTAL 50



1 2 2 2 3 1 1 1 1 2 22 2 3 2 2 2 – 1 1 3 33 2 3 2 2 1 – 2 1 2 34 2 3 2 3 2 2 2 1 3 35 3 2 3 3 3 2 1 2 3 36 2 3 3 2 3 2 2 2 2 1



Text Book

Sr.No

Author Title,Publisher, Year of publica-tion

ISBN Number

1 Tay Vaughan Multimedia Making it Work 3th edition TMH2 Prabhat k. Andheigh Multimedia Systems Design Prentice Hall of India3 Koegel Buford Multimedia Systems Pearson Education

4 Katherine Ulrich Micromedia Flash for Windowsand Macintosh Pearson Education

5 Free Halshall Multimedia Communication Pearson Education

6 R. Steimnetz, K. Nahrst-edt

Multimedia Computing,Communication and Application Pearson Education

7 J.D. Gibson Multimedia CommunicationDirections and Innovations Pearson Education

8 J.F. Kurose, K. W.Rose Computer Networking Pearson Education

E-References:1. http://www.coreldrawtips.com/site/basic-tutorials2. http://design.tutsplus.com/categories/text-effects3. http://www.freeadobeflashtutorials.com/4. http://www.techiwarehouse.com/engine/65eeb3b5/Flash-Tutorial-For-Beginners



Name of Course : Scripting Technology Using JSP

Course Code : CM585

Teaching Scheme:


Evaluation:



Marks 20 80 – 25 25

Course Rationale:

JSP is widely used server side scripting language. This course aims at providing in-depth knowledge of

sever side scripting through JSP.

Course Outcomes:


1. Create and deploy HTTP Servlet using Java.

2. Write and execute scripts using JSP for managing threads, sessions, events, and filters..

3. Access and manage database through web pages.

4. Test, Debug and deploy web applications

5. Create CMS portal and interactive web sites.



Section IUnit 1: Introduction to Web Programming Environment

1.Describe HTTP request model2. Create a servlet program.3. Enlist servlet lifecycle events.4. Enlist components of JSP page.

1.1 Evolution of the Web Application1.2 Overview of the Hypertext TransferProtocol(HTTP): The HTTPSpecification, HTTP Request Model.1.3 Introduction to Servlets:Servlet LifeCycle, servlet Classes,Threading Models,HTTP sessions1.4 A Simple Servlet, The Servlet API,The Javax.Servlet Package, ReadingServlet Parameters,Reading Initialization Parameters

10

Unit 2: Elements of JSP

1. Describe working of JSP2. Identify Correct JSP Syntax.3. Explain Different components of JSP.

2.1 JSP Overview: How JSP works,A basic example.2.2 JSP Syntax and Semantics:The JSPDevelopment Model ,Components of JSPpage, Complete example.2.3 Expressions, Scriplets andDeclarations: Expressions, Scriplets,Declarations.

12

Unit 3: Request Dispatching and Session and JDBC

1.Include different resources in JSP page.2. Use session in JSP page.3. Create JSP page to connect database.4. Enlist different drivers

3.1 Request Dispatching: Anatomyof Request processing, Including OtherRecourses.3.2 Session and Thread Management:Session Tracking , The SessionAPI, Thread Management, ServletThreading Models.3.3 Database Access With JDBC:Overview of JDBC,JDBC Drivers,Connecting to a Database WithDriver manager,

12

Section IIUnit 4: Application Event Listeners and Filters:

1. Create Event listeners for JSP Page2. Create and deploy filter.

4.1 Application Event Listeners: BeyondSession Binding Listeners, EventScope, Event Listener Interfaces,Examples. 4.2 Filters: Filter overview,Developing and deploying a Filter.

10

Unit 5: JSP Tag Extensions:

1. Create and Use custom tag in JSP.2. Enlist components of tag library.3. Use EL in JSP page.4. Use JSTL Library in JSP Page.5. Enlist different tags in JSTL.6. Write syntax of tags of JSTL.

5.1 Introduction to Custom Tags: WhyCustom Tags, Developing your firstCustom Tag, How Tag handlers Works,tag Libraries, The Tag HandlerApathy Tag Handler Life Cycle,Defining Tag Attributes, the iterationof Tag interface, The Bodytag Handler API.5.2 Expression Language: What is EL?EL syntax, Functions.5.3 The JSP Standard Tag Library(JSTL):Getting started with JSTL,Core Tags,XML Tags,SQL Tags,Formatting Tags.

12

5.4 Simple Tag Extenstions,tag Files,and JSP Fragments: JSP Fragments,The Simple Tag Interface, Tag Files.

Unit 6: Testing and Deploying web application

1. Use different approaches to testJSP page.2. Create web archive of web project.

6.1 JSP Testing and Debugging:Building a Mental Model,Tesingin Isolation, Debugging Tools.6.2 Deploying Web application:The web application environment,The web archive (war) file,The deployment Descriptor.

10

Total Hrs 64


PracticalNo.


Units Hrs.

1 Installation of Web Server. Introduction toWeb ProgrammingEnvironment

01

2 Write a program for demonstration of Genericservlets.

Introduction toWeb ProgrammingEnvironment

02

3 Write a program for demonstration of HTTPServlets.


02

4 Write a simple JSP program and monitor the corre-sponding servlet class.


01

5 Write a simple JSP program program for Demon-strating use of all basic elements.

Elements of JSP 03

6 Write a simple JSP program program for Demon-strating use of expressions, declarations.

Elements of JSP 03

7 Write a JSP program program for Demonstrating useof request dispatching.

Request Dispatch-ing and Session andJDBC

02

8 Write a simple JSP program program for Demon-stration of Session Management .


02

9 Write a simple JSP program program for Demon-stration of Thread Management .


02

10 Write a JSP program for Demonstration of connect-ing to database using JDBC.


04

11 Write a JSP program program for Demonstration ofEvent Listeners.

Application EventListeners and Fil-ters

02

12 Write a JSP program program for Demonstration ofFilters.

Application EventListeners and Fil-ters

02

13 Write a JSP programs for Demonstration of all tagscovered in chapter.

JSP Tag Exten-sions

04

14 Creating Web archive and writing Deployment de-scriptor.

Testing and De-ploying web appli-cation

02

Total Hrs 32

Instructional Strategy:Sr.No Topic Instructional Strategy

1 Introduction to WebProgramming Environment Classroom teaching, PPT presentation,

Laboratory Work2 Elements of JSP Classroom teaching, PPT presentation,

Laboratory Work

3 Request Dispatching and Sessionand JDBC Classroom teaching, PPT presentation,

Laboratory Work

4 Application Event Listenersand Filters Classroom teaching, PPT presentation,

Laboratory Work5 JSP Tag Extensions Classroom teaching, PPT presentation,

Laboratory Work6 Testing and Deploying web application Classroom teaching, PPT presentation,

Laboratory Work


Sr.No. Units

Levels from CognitionProcess Dimension Total

R U A1 Introduction to Web Programming Environment 05 05 02 122 Elements of JSP 02 04 06 123 Request Dispatching and Session and JDBC 06 04 06 164 Application Event Listeners and Filters 04 02 06 125 JSP Tag Extensions 06 04 06 166 Testing and Deploying web application 02 04 06 12

Total 25 23 32 80



MarksMinMarks

EvidenceCollected

CourseOutcomes


ContinuousAssesment(CA)

PT Students



1,2,3,4,5,6

– – – – – – – –TOTAL 20 =

Term EndExamination(TEE)

EndExam


TheoryAnswersheets 1,2,3,4,5,6



–

Students

– – – –

JournalWriting

Assignments 25 – Journal 1,2,3,4,5,6,TOTAL 25 10


EndExam

End Of theCourse 25 10 Oral 1,2,3,4,5,6

IndirectAssessment


AfterFirstPT


End Exam End OfThe Course Questionnaires


S.N. Description Max. Marks1 Observations 102 Calculations and Result 053 Viva 10

TOTAL 25



1 3 3 3 1 12 3 3 3 2 1 13 3 2 24 3 2 25 2 3 26 3 2 2



Text Book

Sr. No Title Author Publication1 The Complete Refernce: JSP 2.0 Phill Hanna Tata-McGraw Hill

Reference Books

Sr. No Title Author Publication1 Java Server Pages Hans Bergsten O’Reilly2 Java Database Programming Mathew Siple Tata Mc-Graw Hill

E-References:1. http://www.howstuffworks.com2. https://www.javatpoint.com/jsp-tutorial3. https://www.tutorialspoint.com/jsp/4. https://www.guru99.com/jsp-tutorial.html5. https://www.javatpoint.com/



Name of Course : Network Management and Administration

Course Code : CM586

Teaching Scheme:


Evaluation:



Marks 20 80 – 25 25

Course Rationale:

This course is aimed at providing the students with hands on Experience over Network Operating Sys-

tem: Windows 2008 Server, Configuring Server for Network Environment. It would expose students to

administration and security issues in Network Environment.

Course Outcomes:


1. Install and configure Windows server 2008 .

2. Manage group policies.

3. Apply NTFS permissions to files and folders.

4. Create subnet and configure TCP/IP properties.

5. Configure DNS and DHCP Server.

6. Manage storage and backup for various user.



SECTION-IUnit 1: The Windows Server 2008 Environment

1.Install Windows Server 2008operating system.2. Configure administrative tools.3. Manage Users and Groups .

1.1 The Windows Server 2008 family andkey features, Hardware requirements,Installation of Windows Server 2008.Architecture of windows server 2008.1.2. Installing Device Driver, SigningOptions, Installing, configuringAdministrative Tools.1.3 Implementing User, Group, andComputer Accounts : Creating UserAccounts, Creating Computer Accounts,Modifying User and Computer AccountProperties.1.4 Creating User Account Template,Managing User and Computeraccount Accounts1.5 Managing Groups : Creating groups,Managing group membership,Strategies for using groups,Using default groups,Creating Global and Domain Local Groups.

12

Unit 2: Managing Access to Resources and Managing User Environment

1.Compare various file systems.2. Apply NTFS permissions to filesand folders.3. Configure Active directory.4. Manage group policies.

2.1 File systems – FAT, Fat32, NTFS,Features of NTFS, Creating and SharingFolders, Configuring NTFS Permissions,Publishing Shared Folders, TestingPermissions, Determine effectivepermissions.2.2 The active directory’s logicalstructure, Benefits of active directory,Components and mechanisms in activedirectory – datastore, Schema, Globalcatalog, replication. Overview of Activedirectory domains, transitive two waytrust relationships, using multipledomains, active directory forest, activedirectory object names, active directory’sphysical structure, accessing activedirectory through LDAP2.3 Managing Group Policy :ConfiguringGroup Policy Settings, Assigning Scriptswith Group Policy, Restricting GroupMembership and Access to SoftwarePlanning group policy strategy

12

Unit 3: Administrative Templates and Audit Policy

1. Manage Group policies.2. Use Account policy.3. Provide and maintain security toServer.

3.1 Group Policy Objects GPOs Grouppolicy inheritance,Managing GPOs,Delegating Administrative control toGPOs Redirecting folders using grouppolicy3.2 Using Account policy – passwordpolicy, logon policy, disk quota policy,account lockout policy, audit policy,Configuring Auditing3.3 Overview of Security in WindowsServer 2008, Using Security templates to

08

Secure Computers, Testing ComputerSecurity Policy, Managing Security Logs,

SECTION-IIUnit 4: Windows Server 2008 networking and IP Routing

1. Describe network infrastructures.2. Describe various protocols.

4.1 Defining a network infrastructure, basicterms – workgroup, domain, multipledomains, trust relationship .Activedirectory, remote access, name resolution,TCP/IP networkinfrastructure – network protocols4.2 IP address – the hierarchical addressing scheme,classification of IP address, Subnetting network,subnetting concepts – information hiding, subnettingTCP/IP networks, calculating number of subnets4.3 Timesharing Environment , Logging , NetworkVirtual Terminal. Embedding, File TransferProtocol , Communication over Control Connection,Communication over data connection, AnonymousFTP.4.4 Architecture, User agent, Message transfer agent(SMTP), Message Access agent(POP and IMAP),Email Privacy.

10

Unit 5: DHCP and Domain Naming Systems

1. Install and Configure DNSand DHCP server.2. Manage Remote accessservices.

5.1 Overview of DHCP, the DHCP lease process,Understanding scope details, Advantagesand disadvantages of DHCP. Installing DHCP,authorizing DHCP for active directory, creating andmanaging DHCP scopes,managing reservations andexclusions,super scope, multicast scopes.5.2 Understanding DNS, Domain naming, DNSand the internet, DNS andWindows Server 2008, Dynamic DNS, DNSTerminology , Working of DNS5.3 Installation and configuration of DNS server,Creating DNS zones – forward lookup and reverselookup zone5.4 Overview of Dial-up networking (DUN) andVirtual private networks (VPN) , Installing theremote access services, configuring RAS server.Managing RAS, Remote access security – userauthentication, connection security, access control,Using remote access policies, Using remote accessprofiles.

8

Unit 6: Backup and Recovery Strategy and Cloud Computing

1. Implement different backupand recovery strategies.2. Explain cloud computing technology.

6.1 Backup and Recovery Strategy :Planning backupand recovery strategy, using windows backup,Scheduling backup jobs, Backing up system statedata, Using volume shadow copy, automated systemrecovery .6.2 Cloud Computing : Evolution of CloudComputing, Introduction to Cloud Computing:Cloud Computing model(NIST), Properties andCharacteristics.Introduction to ComputingArchitecture : Cloud Computing Stack, Servicemodels , Deployment Models.6.3 Introduction to Cloud computing, Types of cloud,Desired features of cloud, Cloud Infrastructuremanagement, Infrastructure as service providers,Platform as service providers.

8

Total Hrs 64


PracticalNo.


Units Hrs.

1

a. Installation of Windows Server 2008/Windows2000 Server/ Windows 2008 Serverb. Creation and Management of local users .c. Creation and Management of group andimplementation of its properties.d. Installation of Device Drivers.e. System Performance Monitoring throughWindows Performance Monitoring.

01 06

2a. Installation and implementation of RemoteDesktop.b. Sharing and managing Resources.

02 04

3a. Creating login screen, Configuration of logonpolicies, password policy.b. Testing,creating and importing security templates.

03 04

4

a. Configuration of TCP/IP networki) Assign IP Addressii) Verify IP Communicationb. Implementation of local, roaming, hardware profile.

04 06

5

a. Installation and verification of Active Directoryi. Domain Controller ii) NetBIOS Domain Nameiii)Permissions iv) Verifying the Installation.b. Event Viewer, Event Logc. Installation of Domain Name Systemi. DNS Namespace ii)DNS Zones..

05 04

6

a. Installation and implementation of DHCPi) Authorizing DHCP for Active Directory.ii) Creating and managing DHCP Scopesb. Writing batch scripts for administrative purpose.

05 04

7 a. Case Study on any one Open source and commer-cial Cloud-Microsoft Azure , Eucalyptus , AmazonEC2

06 04

Total Hrs 32

Instructional Strategy:Sr.No Topic Instructional Strategy

1 The Windows Server 2003Environment Classroom teaching, PPT presentation, Laboratory

Work

2 Managing Access to Resourcesand Managing User Environment Classroom teaching, PPT presentation, Laboratory

Work

3 Administrative Templatesand Audit Policy Classroom teaching, PPT presentation, Laboratory

Work

4 Windows Server 2008 networkingand IP Routing Classroom teaching, PPT presentation, Laboratory

Work

5 DHCP and Domain NamingSystems Classroom teaching, PPT presentation, Laboratory

Work

6 Backup and Recovery Strategyand Cloud Computing Classroom teaching, PPT presentation, Laboratory

Work


Sr.No. Units Levels from Cognition Process Dimension Total

R U A

1 The Windows Server 2003Environment 02 02 08 12

2 Managing Access to ResourcesManaging User Environment 04 02 10 16

3 Administrative Templatesand Audit Policy 02 02 08 12

4 Windows Server 2008 networkingand IP Routing 02 02 08 12

5 DHCP and DomainNaming Systems 04 02 10 16

6 Backup and RecoveryStrategy and Cloud Computing 04 02 06 12

Total 18 12 50 80



MarksMinMarks

EvidenceCollected

CourseOutcomes



PT Students



1,2,3,4,5,6

– – – – – – – –TOTAL 20 =


EndExam





–

Students

– – – –

JournalWriting



EndExam

End Of theCourse 25 10 Oral 1,2,3,4,5,6

IndirectAssessment


AfterFirstPT




S.N. Description Max. Marks1 Practical Performance 152 Viva 10

TOTAL 25



1 3 3 3 3 1 – – – – 22 3 3 3 3 1 – – 1 – –3 1 3 3 3 1 – – – 1 14 3 3 2 3 1 – – – 1 15 3 3 2 3 1 – – – 1 –6 1 3 1 3 1 – – – 1 1



Text Book

Sr. No TitleAuthor, Publisher,Edition and Year ofpublication

ISBN number

1 MCITP Guide to Microsoft WindowsServer 2008 Administration

Michael Palmer,CENGAGE learning.

ISBN 10: 1423902823ISBN 13: 9781423902829

2 MCITP Windows server 2008server Administrator Study Guide Darril Gibson,

Wiley Publishing, Inc

ISBN 10: 0470293152ISBN 13: 9780470293157

3 70-646Windows serverAdministration Training kit

Ian Mclean and Orin Thomas,Microsoft Press

ISBN 10: 0735625107ISBN 13: 9780735625105

4 Data Communicationand Networking

Behrouz Forouzan,Osborne Publishing

ISBN 10: 0072322047ISBN 13: 9780072322040

5 Cloud Computing: Principles and paradigms

Rajkumar Buyya,James Broberg 2011,Wiley Publication

ISBN 10: 0470887990ISBN 13: 9780470887998

E-References:1. http://www.4shared.net2. http://www.technet.microsoft.com3. http://www.msdn.microsoft.com



Name of Course : System Programming

Course Code : CM587

Teaching Scheme:


Evaluation:



Marks 20 80 – 25 25

Course Rationale:

System Programs are the set of software which aids in effective communication with the system and

makes the user interface more friendly. This course is aimed in developing the knowledge about design

aspects of such system software.

Course Outcomes:


1. Create and deploy HTTP Servlet using Java.

2. Recognize various phases of assembler design.

3. Recognize various phases of macro processor design.

4. Illustrate functions of loaders.

5. Demonstrate various compilation and parsing techniques.


Specific LearningOutcomes (Cognitive,Domain) Topics and subtopics Hrs. Marks

SECTION I: Unit 1: Introduction

1.1 Recognize components of systemprogramming1.2 Identify different system softwares.1.3 Describe general machine structure.

1.1 Background, machine structure,Components of programming.1.2 System: Assemblers, loaders, Macros,Compilers, formal system.1.3 Evolution of Operating System.1.4 General Machine Structure:Machine Structure IBM 360 and 370,Machine Language

10 12

Unit 2: Assemblers

1. Recognize assembler and itsdesign components.2. Classify data structures ofassembler.3. Demonstrate searching algorithms.

2.1 General design procedure,Design of the assembler, Statementof the problem2.2 Data Structure, Format of databases,Algorithm (Detailed PASS 1 andPASS 2 Flowchart), Look for modularity,Table Processing.Searching: Linear Search, Binary search

10 14

Unit 3: Macro Language and Macro Processors

1. Define macro.2. Recognize macro call and macroexpansion3. Demonstrate single pass and twopass macro processors algorithm4. Demonstrate assembly process

3.1 Macro Instructions, Features of aMacro facility, Macro InstructionArguments.3.2 Conditional macro expansion, Macrocalls within Macros, Macro Instruction,defining macros, Implementationof restricted facility.3.3 A two Pass algorithm, A single passalgorithm, Implementation of macrocalls within Macros, Implementationwithin an assembler.

12 14

SECTION IIUnit 4: Loaders

1. Recognize loading process2. Differentiate different loaders3. Recognize binding and linkingprocess

4.1 Introduction, Loader Schemes,“Compile and go” loaders, GeneralLoader Scheme, Absolute Loaders,Subroutine linkages4.2 Relocating loaders, Direct-linkingloaders, Other loader schemes:Binders, linking loaders, Overlays4.3 Dynamic Binders, Design ofan Absolute loader, Design of DirectLinking Loader.4.4 Specification Problem, Specificationof data structures, Formatof databases. Algorithm

12 12

Unit 5: Compilers

1. Recognize compilation process2. Describe phases of compiler3. Demonstrate phases of compiler

5.1 Statement of a problem, recognizingbasic elements, Recognizing Syntacticunits and Interpreting meaning.5.2 Intermediate form: - Arithmeticstatements, non-arithmetic statement,non-executable statements.5.3 Storage Allocation, Code Generation:Optimization (M/c independent),Optimization (M/c dependent).

10 12

5.4 Assembly Phase, General Model ofCompiler, Phases of a Compiler: LexicalPhase Tasks, databases, algorithm,Syntax Phase: Databases, Algorithm.Interpretation Phase:Databases,Algorithm. Optimization: Databases,Algorithm. Storage Assignment:Databases,Algorithm.Code Generation:Databases, Algorithm. Assembly Phase:Databases, Algorithm.Passes of aCompiler

14 16

Unit 6: Parsing

1. Describe parsing techniques2. Demonstrate parsing techniques.3. Describe software tools.4. Classify different software tools.

6.1 Parse tree and abstract syntaxtree Parsing Techniques: Top downparsing Implementing Top down parsing.6.2 Comment on Top down parsing,Top down parsing Without backtracking,Practical Top down parsing Bottom upparsing, LALR parsing.6.3 Software Tools: Software toolsfor program Development, Editors,Debug monitors, Programmingenvironments, User interfaces.

10 12

Total Hrs 64 80


PracticalNo.


Units Hrs.

1 Implement a symbol table with functions to create,insert, modify, search, and display using ‘C’.

Assemblers 04

2 Implement programs on sorting techniques withinSymbol Table using ‘C’.

Assemblers 02

3 Implement programs on searching techniques withinSymbol Table using ‘C’.

Assemblers 02

4 Simulation and Study of the Assembler using Simu-lation Tool (e.g. Reads51)

Assemblers 02

5 Implement a single pass macro processor Macro Languageand Macro Proces-sors

04

6 Simulation of loaders using Simulation Tool Loaders 047 Design of various phases of Compiler. Compilers 068 Demonstrating use of parsing techniques on given

string.Parsing 04

9 Study of different Software Tools. Parsing 04Total Hrs 32

Instructional Strategy:Sr.No Topic Instructional Strategy1 Introduction Explanation of components of programming, expla-

nation of general machine, explanation of systemsoftwares using chalk – board and/or projector

2 Assemblers Explanation of assembly process using chalk – boardand/or projector, Simulation and demonstration ofOne pass and Two pass assembler algorithms throughproblem-solving with using chalk – board and/orprojector.

3 Macro Language and Macro Processors Explanation of macro language, Explanation ofmacro, macro call, macro expansion using chalk –board and/or projector, demonstration of macro pro-cessor.

4 Loaders Explanation of loading process and different types ofloaders

5 Compilers Explanation of compiling a program, Demonstratephases of compiler

6 Parsing Explanation of parsing, explanation of parsing tech-niques, explanation of software tools


Sr.No. Units

Levels from CognitionProcess Dimension Total

R U A1 Introduction 08 02 02 122 Assemblers 08 02 04 143 Macro Language and Macro Processors 08 02 04 144 Loaders 08 02 02 125 Compilers 10 02 04 166 Parsing 06 02 04 12

Total 48 12 20 80



MarksMinMarks

EvidenceCollected

CourseOutcomes



PT Students



1,2,3,4,5,6

– – – – – – – –TOTAL 20 =


EndExam





–

Students

– – – –

JournalWriting



EndExam



1,2,3,4,5,6

IndirectAssessment


AfterFirstPT




S.N. Description Max. Marks1 Observations 102 Practical Performance 203 Viva - voice 20

TOTAL 50



1 3 2 1 2 1 – – – – 12 3 2 1 2 1 – – – – 13 3 2 1 2 1 – – – – 14 3 2 1 2 1 – – – – 15 3 2 1 2 1 – – – – 16 3 2 1 2 1 – – – – 1



Sr. No Title Author PUBLISHER1 Systems Programming John J. Donovan Tata McGraw Hills

2 Systems Programming and Operating systems Dhamdhere Tata McGraw Hills

E-References:1. http://www.nptel.ac.in2. http://www.tutorialspoint.com3. http://www.techopedia.com

Programme : Diploma in Computer Engineering/Information technology


Name of Course : Advanced Database Management System

Course Code : CM588

Teaching Scheme:


Evaluation:



Marks 20 80 25 – 25

Course Rationale:

In the present era, it is very essential to develop and arrange data in such a way that it solves a complex

problem efficiently. Advanced database management is a subject which gives emphasis on managing

the data which is available on internet. The students will be able to handle, manage and transform

online data in a secure environment and gain the knowledge of emerging database technology such as

multimedia database, digital library database and mobile database.

Course Outcomes:


1. Develop ER model for a given case study.

2. Apply query optimization techniques for processing a given database efficiently.

3. Write SQL queries for concurrent control over a given database.

4. Apply different methods and techniques of distributed query processing.

5. Write and execute queries on Object – oriented, multimedia, mobile databases

6. Use XML for representing the database in web environment.



Section IUnits 1 : Introduction to Database Management system

1. Explain in detail DBMS architecture2. Construct E-R model from givenspecification and transform intorelational model.

1.1Introduction: Definition of DBMSBenefits of DBMS1.2 Database-System Architectures :Centralized and client–server architectures,Server system architectures, Parallel systems,Distributed systems, Network typesSpecial-Purpose Systems, Open-SourceOperating Systems.1.3Extended ER : E-R model revisited Specializationand Generalization Extended E-R , Subclass superclass Constraints and characteristics of specializationGeneralization, Relationship types of degree Higherthan two , Aggregation, Union and categories ,EER – To Relation Models Mapping

12

Unit 2: Advanced SQL and Query processing.

1. Explain in detail query processingand techniques involved in queryoptimization2. Implement advanced queries usingStructured Query Language.3.Translations of SQL Queriesinto relational algebra.

2.1 Advanced SQL : SQL Data typesSchemas , Queries based on SQL 3 standards(outer join, multi join , left, right, a full outer join,equal join, natural join , Aggregate, functions,Null values etc. EXIST and NOT EXIST, any / all,pattern matching Dynamic SQL2.2 Query Processing: Overview Measures of Querycost, Selection operation ,Sorting ,Join OperationsOther Operations Evaluation of Expression.2.3Query Optimization: Translations of SQLQueries into relational algebra, Heuristic approachcost base optimization

14

Unit 3: Transaction and Concurrency control

1. Analyze and apply ConcurrencyControl and Reliability Techniques.2. Write a program to simulatelock-based concurrency control protocol.

3.1 Transaction: Transaction concept, Transactionstate, Implementation of atomicity and durability,Concurrent executions, Serializability,Recoverability, Implementation of isolation,Testing for serializability.3.2 Concurrency control: Lock-based protocols,Timestamp-based protocols, Validation-basedprotocols, Multiple granularity, Multiversion schemes,Deadlock handling, Insert and delete operations,Weak levels of consistency, Concurrency in indexstructures

10

Section IIUnit 4: Parallel Databases AND Distributed Databases

1. Characterize Parallel Databases andDistributed Object Databases2.Apply different methods andtechniques of distributed queryprocessing.

4.1 Parallel Databases Parallel databases, I/Oparallelism, Interquery parallelism, Intraoperationparallelism, Design of parallel systems .4.2 Distributed Databases :Homogeneous andheterogeneous databases, Distributed data storage,Distributed transactions, Commit protocols,Concurrency control in distributed databases,Availability, Distributed query processing,Heterogeneous distributed databases,Directory systems.

12

Unit 5: Emerging Database Technologies

1. Analyze, design and evaluatethe construct of various advanceddatabases such as object-Based,Multimedia and Mobile Database.2. Discuss issues regarding emergingdatabase technologies3. Write an SQL to store and retrievemultimedia objects.

5.1 1Object-Based Databases Overview ofobject-based databases, Complex data types,Structured types and inheritance in SQL,Table inheritance, Array and multiset types in SQL,Introduction of object-identity and reference typesin SQL, Object-oriented versus object-relational .5.2 Multimedia Database: Multimedia Sources,Multimedia database Queries, multimedia Databaseapplication5.3 Architecture of mobile databases ,Characteristics of mobile,computing Mobile DBMS, commercialmobile database

10

Unit 6: XML and Internet Databases:

6.1. Create XML Schema6.2.Describe structure of XML data.

6.1 Structure of XML data,XML document schema,Querying and transformation,Application program interfaces to XML,Storage of XML data,XML applications

06


PracticalNo.

Specific Learning Outcomes (Psychomo-tor Domain)

Units PracticalHrs.

1 Demonstration of Installation of OracleDatabase Softwares.

Unit 1:Introductionto Database Man-agement system

02

2 Write Queries using outer join, multi join ,left, right, a full outer join, equal join, naturaljoin, Aggregate function

Unit 2:AdvancedSQL and Queryprocessing.

04

3 Translations of SQL Queries into relational al-gebra

Unit 2:AdvancedSQL and Queryprocessing.

04

4 Write Query using pattern matching DynamicSQL

Unit 2:AdvancedSQL and Queryprocessing

04

5 Write a program to simulate lock-based con-currency control protocol.

Unit 3:Transactionand Concurrencycontrol

02

6 Write a program to simulate timestamp-basedconcurrency control protocol.


02

7 Write a program to simulate validation-basedconcurrency control protocol.


02

8 Write an SQL to store and retrieve multimediaobjects (Image, Audio or Video). in OracleDatabases.

Unit 5:EmergingDatabase Tech-nologies

04

9 Study of XML Unit 6:XML andInternet Databases

02

10 Creating XML Schema Unit 6:XML andInternet Databases

02

11 Implementation of accessing database from ajava/any programming language.

Unit 1,2,3,4,5,6 04

Total Hrs 32

Instructional Strategy:

Sr.No Topic Instructional Strategy

1 Introduction to Database Managementsystem Explanations of basic concepts

2 Advanced SQL and Query processing Explanation and Practical implementa-tion

3 Transaction and Concurrency control Explanation of transaction and concur-rency control and Practical implemen-tation

4 Parallel Databases AND DistributedDatabases Explanation and Practical implementa-

tion5 Emerging Database Technologies Explanation and Practical implementa-

tion6 XML and Internet Databases Explanation and Practical implementa-

tion



Knowledge Comprehension Application1 Introduction to DBMS 06 06 00 122 Advanced SQL and Query processing 04 04 06 143 Transaction and Concurrency controls 04 04 06 144 Parallel Databases AND Distributed Databases 04 04 06 145 Emerging Database Technologies 04 04 06 146 XML and Internet Databases 06 04 02 12

Total 28 26 26 80



MarksMinMarks

EvidenceCollected

CourseOutcomes


ContinuousAssesment PT Students

TwoPT(averageof two testswill becomputed)


1,2,3,4,5,6

Assignment – AssignmentBook

1,2,3,4,5,6

TOTAL 20 =(TermEndExamination)

EndExam





Students


– –

JournalWriting

Assignments – – Journal 1,2,3,4,5,6TOTAL 25 10


EndExam



1,2,3,4,5,6

IndirectAssessment


AfterFirstPT




S.N. Description Max. Marks1 Evaluation 52 Practical Execution 103 Viva voce 10

TOTAL 25



1 – 1 1 2 – – – – – –2 – 2 3 2 – – – – – –3 – 2 3 3 – – – – –4 – 2 3 3 – – – – – –5 – 3 3 3 – – – – – –6 – 3 1 – – – – – – –



Text Book

Sr.No

Author Title,Publisher, Year of pub-lication

ISBN Number

1 Abraham Silber-schtz,Henry Korth andS.Sudharshan

Database system concepts(3rd edition) McGraw Hill

2 Elmasri R., Navathe S Fundamentals of Database Sys-tems 4’ th Edition

Pearson Education

3 Raghu Ramkrishnan andJohannes Gehrke

Database system concepts(3rdedition)

Tata McGraw Hill.

4 Stefano Ceri, Hillseppe ,pelagatti

Distributed Databases, Princi-ples and Systems

Tata McGraw Hill.

5 Dr. P.S. Deshpande SQL and PL/SQL for Oracle log Black Books DreamtechPress

6 Mark L. Gillenson,Paulraj Ponniah

Fundamentals of Database Sys-tems

WILEY

programme : diploma in computer engineering programme code ... · the course 40 13 theory answer...

Documents