C21 - CS - Iv Sem
C21 - CS - Iv Sem
C21 - CS - Iv Sem
OFFERED BY
Advanced Engineering
1 SC-401 4 1 0 75 3 20 20 20 40 14 100 35
Mathematics
Relational Database 14 35
2 CS-402 4 1 0 75 3 20 20 20 40 100
Management Systems
Relational Database
6 CS-406 Management Systems 1 0 2 45 1.5 20 20 20 40 20 100 50
Lab
Computer Hardware
8 CS-408 1 0 2 45 1.5 20 20 20 40 20 100 50
& Networking Lab
Employability Skills
10 HU-410 1 0 2 45 1.5 20 20 20 40 20 100 50
Lab
Advanced Engineering
Course Title Course Code SC-401
Mathematics
SEMESTER IV Course Group Foundation
Teaching Scheme in
4:1:0 Credits 3
periods ( L : T : P )
Total Contact
Methodology Lecture + Tutorial 75
Periods
CIE 60 Marks SEE 40 Marks
Pre requisites:
This course requires the knowledge of Engineering Mathematics at Diploma first year level
and Applied Engineering Mathematics at Diploma 3rd Semester level.
Course Outcomes:
At the end of the course, the student will have the ability to:
Course Contents:
Unit – I
Duration: 07 Periods (L: 5 – T: 2 )
Homogeneous Linear Differential equations with constant coefficients
Homogenous linear differential equations with constant coefficients of order two and
higher with emphasis on second order.
Unit – II
Duration: 16 Periods (L: 13 – T: 3)
Non-Homogeneous Linear Differential equations with constant coefficients
Non-homogenous linear differential equations with constant coefficients of the form (D)y
= X, where X is in the form k(a constant ) eax, sin(ax), cos( ax), xn, (n= 1,2,3) Complimentary
Function (CF), Particular Integral (PI) and General Solution (GS).
Unit-III
Duration: 14 Periods (L: 11 – T: 3)
Fourier series
Orthogonality of trigonometric functions, Representation of a function in Fourier series over
the interval c , c 2 , Euler’s formulae, sufficient conditions for existence of Fourier
series for a function f(x). Even, Odd functions and Fourier series over the Interval (0, 2 )
and (- )
Unit – IV
Duration: 08 Periods (L: 7 – T:1 )
Fourier Half-range series
Representation of a function f(x) as a Fourier Half-range Sine series and Cosine series over
the interval (0, π)
Unit – V
Duration: 14 Periods (L: 11 – T: 3)
Laplace Transformations:
Definition, sufficient conditions for existence of Laplace Transform, Laplace Transform of
elementary functions, linearity property, Change of scale property, First shifting theorem ,
multiplication by tn, division by t, Laplace Transform of derivatives and integrals, unit
step function, Laplace Transform of second shifting theorem
Unit – VI
Duration: 16 Periods (L: 13 – T: 3)
Inverse Laplace transforms:
Inverse Laplace transforms- shifting theorems and change of scale property,
multiplication by sn and division by s –Inverse Laplace Transform using partial fractions
– convolution theorem (no proof) – application of Laplace Transformations to solve
ordinary differential equations of second order with initial conditions.
Recommended Books:
1. www.freebookcentre.net/mathematics/introductory-mathematics-books.html
2. E-books:www.mathebook.net
Suggested Learning Outcomes
At the end of the course, the student will have the ability to:
Unit-I
1.1 Solve Differential equations of the type (aD2 +bD + c) y = 0 when the roots of the
Auxiliary Equation (A.E) are real & different, real & repeated and complex.
1.2 Solve the higher order homogeneous linear differential equations with constant
coefficients.
Unit-II
2.1 Apply the concept of complementary function, particular Integral to get general
solution of a differential equation.
2.2 Solve nth order differential equation of the type f(D) y = X where f(D) is a
polynomial of second order and X is a function of the form k, eax ,Sin(ax),
Cos(ax), xn.
2.3 Solve simple problems on the above types of 2.2
Unit-III
Unit-V
5.1 Apply the definition of Laplace Transform and find Laplace transform of standard
functions
5.2 Identify the sufficient conditions for existence of Laplace Transform.
5.3 Use the properties of Laplace Transform – Linearity property, First shifting theorem,
Change of Scale property in solving simple problems.
6.0 Use Laplace transforms and Inverse Laplace transforms to solve differential
equation in engineering problems
6.1 Define inverse Laplace Transform and write inverse Laplace Transforms of standard
functions.
6.2 Solve simple problems on Inverse Laplace Transforms.
6.3 Write Shifting theorems and Change of scale property of inverse Laplace Transform.
6.4 Solve simple problems on 6.2
6.5 Write inverse Laplace Transforms corresponding to Laplace Transform of the
functions
CO PO 1 PO 2 PO 3 PO 4 PO 5 PO 6 PO 7 Mapped POs
CO1 3 2 3 1,2, 7
CO2 3 2 3 1,2, 7
CO3 3 2 3 1,2, 7
CO4 3 2 3 1,2, 7
CO5 3 2 3 1,2, 7
CO6 3 2 3 1,2, 7
The length of answer for each question framed in respect of Part-A, B&C shall not exceed ¼
of a page,1page and 2 pages respectively
Questions to be set for SEE
Unit No
R U A
I
Q1 Q9(a) Q13(a)
II
III
Q2 Q10(a) Q14(a)
IV Q4
Q9(b), Q13(b),
V Q5,Q6
Q11(a), Q11(b) Q15(a), Q15(b)
Q3
Q10(b), Q14(b),
VI Q7,Q8
Q12(a), Q12(b) Q16(a), Q16(b)
Total Questions 8 8 8
BOARD DIPLOMA EXAMINATIONS (C21)
MID SEM –I, IV SEMESTER
SC-401- ADVANCED ENGINEERING MATHEMATICS
TIME: 1: 00 Hour Max. Marks: 20
PART-A
PART-B
OR
6 a) Solve =
OR
PART- C
OR
8 a) Solve =
OR
8 b) Solve =
BOARD DIPLOMA EXAMINATIONS (C21)
MID SEM –II, IV SEMESTER
SC-401- ADVANCED ENGINEERING MATHEMATICS
TIME: 1: 00 Hour Max. Marks: 20
PART-A
PART-B
OR
6 a).Find the value of an in half-range Cosine series for the function f(x) = ex in (0,
OR
PART- C
OR
7 b) Find the Fourier series for f(x) = ( in the interval (- . Hence show that
- + - + ……….+ =
OR
8 b) Find the half –range cosine series for the function f(x) = in the interval (0,
BOARD DIPLOMA EXAMINATION, (C-21)
IV SEMESTER END EXAMINATION
SC-401- ADVANCED ENGINEERING MATHEMATICS
Time: 2 hours [Total Marks: 40]
PART-A
7. Find
8. Find
PART-B
Instructions: 1. Answer ALL questions 04 X 03 = 12
OR
9 b) Find
10 b) Find
PART- C
OR
14 b) Find
15 a) Find
OR
t sin t
15 b) Evaluate L dt
0 t
16 a) Find using Convolution theorem.
OR
16 b) Solve the differential equation y//– 2y /– 8y = Sin t, when y (0) = 3, y / (0) = 6 by
Laplace Transform method.
CS-402-RELATIONAL DATABASE MANAGEMENT SYSTEMS
Relational Database
Course Title Course Code CS-402
Management Systems
SEMESTER IV Course Group Core
Teaching Scheme in
4:1:0 Credits 3
periods ( L : T : P )
Total Contact
Methodology Lecture + Tutorial 75
Periods
CIE 60 Marks SEE 40 Marks
Prerequisites
Course Outcomes
Upon completion of the course the student shall be able to
Course Outcome
CO1 Describe the characteristics of database, architecture and languages of
Database system
CO2 Implement Entity-Relationship diagrams
CO3 Apply relational model concepts and constraints, Apply normalization
techniques for relational databases and familiarize with data base transaction
processing
CO4 Use Structured Query Language (SQL), frame queries to any database
CO5 Frame queries to any database, managing schema objects and familiarize
with PL/SQL
CO6 Develop programs using PL/SQL
Course Contents
1. Concepts of Databases:
Duration: 10 Periods
Introduction - An Example - Characteristics of the database approach - Advantages of using
the DBMS Approach - A Brief History of Database Applications.
Database System Concepts and Architecture - Data Models – Schemas and Instances - Three-
Schema Architecture and Data Independence - Database Languages and Interfaces - The
Database System Environment - Centralized and Client /Server Architectures for DBMSs -
Classification of database Management System.
2. Data Modeling Using the Entity-Relationship(ER) Model
Duration: 10 Periods
Using High Level Conceptual Data Models for Database Design - An example Database
Application - Entity Types - Entity Sets - attributes and keys - Relation Types - Relationship
Sets - roles and structural constraints - ER Diagrams, naming conventions and design issues -
Relationship Types of Degree Higher than Two.
Relational Model concepts - Relational Model Constraints and relational database schemas -
Update operation and Dealing with constraints violations – Informal Design guidelines for
relation schemas - Functional dependencies - Normal forms based on primary keys - General
Definition of first, second and third normal forms, Boyce-codd Normal form - Introduction to
transaction processing - transaction and system concepts - desirable properties of transactions
– Serializability - States of Transactions.
4. Concept of SQL
Duration: 15 Periods
Familiarize with SQL - pseudo columns - Data Definition and data types – DDL statements
in SQL - DML statements in SQL – Basic queries in SQL - various operators in SQL-
specifying constraints in SQL - various functions in SQL
6. PL/SQL
Duration: 15 Periods
Records - Subprograms – Procedures –Functions - RETURN statement– Recursion - Stored
Procedures - Exceptions – Cursors - Triggers – Packages.
Specific Learning Outcomes:
Upon completion of the course the student shall be able to
1. Concepts of Databases
1.1 Familiarize with Database.
1.2 Illustrate the evolution of DBMS.
1.3 Describe the characteristics of the database approach.
1.4 Discuss about the applications of DBMS.
1.5 Explain different types of Data Models.
1.6 Define Schemas, instances.
1.7 Demonstrate Three-Schema Architecture.
1.8 Define Data Independence.
1.9 Familiarize Database Languages and Interfaces.
1.10 Illustrate Database System Environment.
1.11 Explain Centralized and Client /Server Architectures for DBMSs.
1.12 Classify different types of Database Management System.
6. Advanced PL/SQL
6.1 Familiarize with PL/SQL records.
6.2 Define subprograms.
6.3 Develop PL/SQL programs using procedures.
6.4 Develop PL/SQL programs using functions.
6.5 Define recursion and explain recursion with example.
6.6 Describe about Stored Procedures.
6.7 Develop PL/SQL programs to handle exceptions.
6.8 Define Cursor and explain Cursors with examples.
6.9 Define Triggers and explain Triggers with examples.
6.10 Define Package and explain Packages with examples.
Note: The following activities or similar activities for assessing 2.5 credits (Any one)
Student activity like mini-project, surveys, quizzes, etc. should be done in group of 3-5 students.
Each group should do any one of the following type activity or any other similar
activity related to the course and before conduction, get it approved from concerned
course coordinator and programme co-coordinator.
Each group should conduct different activity and no repeating should occur.
1. https://www.w3schools.in/.
2. https://www.tutorialspoint.com/dbms
3. https://beginner-sql-tutorial.com/sql.htm.
4. www.nptel.ac.in .
5. http://www.sql-tutorial.net/
5(a) 7(a)
1 Unit-I 1, 2
5(b) 7(b)
6(a) 8(a)
2 Unit-II 3, 4
6(b) 8(b)
Total Questions 4 4 4
5(a) 7(a)
1 Unit-I 1, 2
5(b) 7(b)
6(a) 8(a)
2 Unit-II 3, 4
6(b) 8(b)
Total Questions 4 4 4
1 Unit-I
1 9(a) 13(a)
2 Unit-II
3 Unit-III
2 10(a) 14(a)
4 Unit-IV
4 9(b) 13(b)
5 Unit-V 5,6 11(a) 15(a)
11(b) 15(b)
3
10(b) 14(b)
6 Unit-VI 7,8 11(a) 16(a)
11(b) 16(b)
Total Questions 8 8 8
6. (A) Describe how to use High-Level Conceptual Data Models for Database Design.
or
(B) Explain the Centralized and Client /Server Architectures for DBMSs.
313
MODEL QUESTION PAPER
BOARD DIPLOMA SEMESTER END EXAMINATION (C-21)
CS-402 – RELATIONAL DATABASE MANAGEMENT SYSTEMS
NOTE: 1. Answer any one question from 9, 10, 11 and 12. MARKS: 4 X 3=12
313
PART-C
NOTE: 1. Answer any one question from 13, 14, 15 and 16 MARKS: 4 X 5=20
15. (A) Implement the aggregate functions and string functions in SQL.
or
(B) Illustrate the creation of views from multiple tables with examples.
16. (A) Develop the concept of handling exceptions in PL/SQL with example program.
or
(B) Explain about numeric and date functions in PL/SQL with examples.
313
CS-403-JAVA PROGRAMMING
Prerequisites
Knowledge of OOPs concepts and C, C++ Programming language concepts.
Course Outcomes
Upon completion of the course the student shall be able to
Course Outcome
Understand the basics of java programming concepts and develop
CO1
simple console based applications.
CO2 Develop java programs using Inheritance and interfaces.
Create user-defined packages and explore classes and interfaces
CO3
within io, util packages.
Develop Applet programs and Handle events generated by AWT
CO4
controls to perform various actions.
Interpret different types of Exceptions and Handle Exceptions and
CO5
multi threading concept
Develop database applications to interact with different types of
CO6 databases using JDBC and Develop server side programs using
Servlets.
Course Contents
1. Introduction of Java:
Duration:10 Periods
Fundamentals of Object Oriented Programming- Introduction - Object oriented
Paradigm - Basic Concepts of OOP - Java history - Java Features - How Java Differs from
C and C++- Java Program Structure - Simple Java Program - Java Tokens – Java data types
– variables - type casting- arrays - operators - selection statements – iteration statements –
jump, break, and continue statements -classes and objects-constructors - method
313
overloading- ‘this’ pointer-static and final members-string classes and methods-
command-line arguments.
313
Recommended Books
1. Programming with Java, 6th edition, Balagurusamy, Mc Graw Hill, ISBN 13-
9789351343202 ISB 10- 9351343200
2. Complete Reference Java J2se, Herbert Schildt, Tata McGraw Hill, ISBN
9780070598782
3. Java 6 Programming – Black Book Wiley India Pvt ltd
4. Programming in JAVA2 – Dr. K. Somasundaram Jaico Publish
5. Programming in JAVA – S.S. Khandare – S. Chand Publish
6. “Head First Java”, Kathy Sierra, Bert Bates, O’Reilly.
7. ‘Effective Java: A Programming Language Guide’ (Java Series) 2nd Edition, by Joshua
Bloch Sun copyright.
8. Mastering Java Machine Learning Paperback -Uday Kamath,Krishna Choppella, Packt
publishers.
9. Core Java Volume I--Fundamentals Eleventh Edition by Cay S. Horstmann Pearson
publications.
10. Java: A Beginner's Guide, Seventh Edition Paperback – by Herbert Schildt -Oracle press
11. “The Complete Reference Java2 (Third Edition)”, Patrick Naughton-Herbert Sheild, Tata
McGraw hill.
12. “Advance JAVA”, Kogent learning Solution, DreamTech Press.
13. “Java2 Unleased”, Jawroski, Techmedia.
14. “Java2 Programming”, Keyur Shah, Tata McGraw.
15. “Java EE6 for Beginners”, Sharnam Shah &Vaishali Shah, SPD.
16. “Java Server Programming Black book” , Kogent learning Solution, DreamTech Press.
17. “Java Database Programming with JDBC” by Pratik Patel - The Coriolis Group.
Specific Learning Outcomes:
Upon completion of the course the student shall be able to
1 Introduction of Java
1.1 Explain the basic concepts of OOP
1.2 Write about Java History
1.3 Explain the features of Java
1.4 Compare Java with C and C++.
1.5 Write the structure of Java program with an example program.
1.6 Describe java tokens -white space, literals, separators, keywords.
1.7 Explain java datatypes
1.8 Write about declaration and initialization of variables.
1.9 Perform type conversion and casting features.
1.10 Use one-dimensional and two–dimensional arrays.
1.11 Explain various types of operators.
1.12 Explain about selection and iteration statements of Java.
1.13 Write the syntax of jump, break, and continue statements.
1.14 Create classes and objects.
1.15 Explain about constructors.
1.16 Explain method overloading.
1.17 Use of ‘this’ pointer.
1.18 Explain the working of static and final members.
1.19 Explain string classes and methods.
1.20 Describe the use of command-line arguments.
2 Inheritance and Interfaces
2.1 Define Inheritance and its types.
2.2 Explain different types of inheritance with examples.
2.3 Use of super keyword.
2.4 Explain method overriding and how to avoid overriding using ‘final’.
2.5 Define an Interface and explain the concept of Interfaces.
2.6 Compare class and interface.
2.7 Explain about extending interfaces.
2.8 Explain the concept of implementing interfaces.
2.9 Explain the scope of variables in interfaces.
2.10 Explain multiple inheritance using the concept of interface.
3 Packages
3.1 Define a package.
3.2 Explain about java API packages.
3.3 Describe the concept of class path.
3.4 Describe the concept of Access specifiers.
3.5 Explain the concept of creating, accessing and using a package and subpackages.
3.6 Appreciate the concept of importing packages.
3.7 Exploring io, util packages.
3.8 Explain various stream classes.
4 Concepts of Applets, AWT and Event handling
4.1 Define Applet and life cycle of an Applet.
4.2 Explain the creation of Applets with example programs.
4.3 List and discuss AWT classes
4.4 Describe AWT controls with example programs
4.5 Explain Event handling mechanism and Delegation Event model.
4.6 Explain sources of Events
4.7 Event Classes and Event Listener interfaces.
4.8 Explain Mouse and Keyboard events.
Note: The following activities or similar activities for assessing 2.5 credits (Any one)
Student activity like mini-project, surveys, quizzes, etc. should be done in group of 3-5 students.
Each group should do any one of the following type activity or any other similar activity
related to the course and before conduction, get it approved from concerned course
coordinator and programme co-coordinator.
Each group should conduct different activity and no repeating should occur.
1. Study different Integrated Development Environments (IDEs) available for executing java
programs and prepare a report.
2. Develop some simple window based applications like notepad, calculator etc using AWT
and Swing components.
3. Visit Library to refer to standard Books on core Java and Advanced java concepts, collect
related material and prepare notes.
4. Refer to online content and videos to get more knowledge on database concepts.
5. Interact with industry people who are working in java and advanced java technologies and
prepare a report.
6. Write assignments given by course coordinator.
7. Read all the course contents and should be able to write slip tests and surprise tests.
8. Prepare a seminar on a specific topic that is related to latest technologies in the java and
advanced java concepts and present a Power Point Presentation (PPT) to all the peers.
9. Study IEEE papers on advanced java topics and submit a report.
10. Prepare quiz on java course related questions and conduct.
11. Participate in state level or national level technical conferences.
12. Participate in various technical coding competitions related to java programming.
13. Develop some projects to design websites like Hotel Management System, E-Bill Board,
Online insurance, Online Mobile, Contributor, Online Restaurant, Public Distribution
System, Secure E-banking security, District medical data centre using JDBC and Servlet
and JSP concepts.
Suggested E-learning references
1. https://www.w3schools.in/java-tutorial/
2. https://www.udemy.com/advanced-java-programming/
3. https://www.roseindia.net/java/Advanced-Java-Tutorials.shtml
4. http://www.javalearner.com/advanced.htm
5. https://www.studytonight.com
6. http://www.Javatpoint.com/Java-tutorial
7. http://www.tutorialspoint.com/Java/
8. http://www.indiabix.com/technical/core-Java/
9. https://www.geeksforgeeks.org/java/
CO3 Create user-defined packages and explore classes and R,U, 1,2,3,4,7 10
interfaces within io, util packages. A
Total Sessions 60
MID SEM – I Exam
5(a) 7(a)
1 Unit-I 1, 2
5(b) 7(b)
6(a) 8(a)
2 Unit-II 3, 4
6(b) 8(b)
Total Questions 4 4 4
5(a) 7(a)
1 Unit-I 1, 2
5(b) 7(b)
6(a) 8(a)
2 Unit-II 3, 4
6(b) 8(b)
Total Questions 4 4 4
1 Unit-I
1 9(a) 13(a)
2 Unit-II
3 Unit-III
2 10(a) 14(a)
4 Unit-IV
4 9(b) 13(b)
5 Unit-V 5,6 11(a) 15(a)
11(b) 15(b)
3
10(b) 14(b)
6 Unit-VI 7,8 11(a) 16(a)
11(b) 16(b)
Total Questions 8 8 8
PART-A
PART-A
1) Define package.
2) Write the syntax to import a package.
3) Define Applet.
4) What is Delegation Event Model?
PART-B 2×3=6 Marks
7(a) Describe the concept of creating and accessing a package with an example program.
(OR)
7(b) Write a java program using to read data from a file using BufferedReader class
PART-A
Instructions: (1) Answer one question each from 9,10,11 and 12.
(2)Each Question is of internal choice type
(3)Each question carries three marks.
Instructions: (1) Answer one question each from 13,14, 15 and 16.
(2)Each Question is of internal choice type
(3)Each question carries five marks.
16(a) Write a java program to insert update and delete data from a database.
(OR)
Prerequisites
Knowledge of PC components
Course Outcomes
Upon completion of the course the student shall be able to
Course Outcome
CO1 Identify the PC components
CO2 Learn different system boards, Processors, Memories and Mass storage devices
COURSE CONTENTS
1. PC hardware and its Components.
PC Hardware and software - Importance of BIOS - BIOS hardware interaction - BIOS
functions (i) POST, (ii) Bootstrap loading - Configuration of a general purpose
computer - Identification of various components on the motherboard.
Memories
RAM - Static and Dynamic RAM - RAM types - SDRAM (Synchronous DRAM),
Asynchronous DRAM, DDR1, DDR2, DDR3 and DDR4 (1-4) RAM, Rambus RAM -
SIMM and DIMM - RAM Slots – Up gradation of RAM – Cache Memory – L1, L2 and L3
Cache
Various input devices used with a general purpose computer -Working principle of
Keyboard (Wired & Wireless Keyboard) - Working principle of Opto-mechanical mouse and
Optical Mouse (Wired & wireless Mouse) - Various scanners - Working of Flat bed scanner
and Hand held scanner – Webcam.
Output Devices
Various Output devices used with a general purpose computer - Working principle of CRT
Monitor - Working principle of LCD/TFT/LED/OLED Monitors - Categories of printers
(Impact and Non-Impact) - Working principle of Dot matrix printer, Inkjet printer, Laser
printer - Multi-Function printer
Recommended Books
1. https://www.tutorialspoint.com/computer_fundamentals/computer_fundamentals_tuto
rial.pdf
2. http://www.garfieldcs.com/wordpress/wordpress/wp-
content/uploads/2011/09/Computer-Hardware-Basics.pdf
3. https://abiiid.files.wordpress.com/2010/12/pc-hardware-a-beginners-guide.pdf
4. https://www.tutorialspoint.com/computer_fundamentals/computer_networking.htm
5. https://www.tutorialspoint.com/communication_technologies/communication_technol
ogies_network_topologies.htm
6. https://www.tutorialspoint.com/ipv4/index.htm
7. https://www.computerhope.com/
5(a) 7(a)
1 Unit-I 1, 2
5(b) 7(b)
6(a) 8(a)
2 Unit-II 3, 4
6(b) 8(b)
Total Questions 4 4 4
5(a) 7(a)
1 Unit-I 1, 2
5(b) 7(b)
6(a) 8(a)
2 Unit-II 3, 4
6(b) 8(b)
Total Questions 4 4 4
1 Unit-I
1 9(a) 13(a)
2 Unit-II
3 Unit-III
2 10(a) 14(a)
4 Unit-IV
4 9(b) 13(b)
5 Unit-V 5,6 11(a) 15(a)
11(b) 15(b)
3
10(b) 14(b)
6 Unit-VI 7,8 11(a) 16(a)
11(b) 16(b)
Total Questions 8 8 8
PART-A
1. What is BIOS?
4. What is SATA?
PART-B
Answer TWO questions out of Four questions. Each carries 3marks. 2X3=6 Marks
6(b). Write any two differences between static RAM and dynamic RAM
PART-C
Answer TWO questions out of four questions. Each carries 5 marks. 2X5 =10Marks
PART-A
1. Define MAN.
PART-B
Answer TWO questions out of Four questions. Each carries 3marks. 2X3=6Marks
5(a) Write any two differences between impact and non impact printers (OR)
6(a) Write any three differences between Switch and Hub (OR)
PART-C
Answer TWO questions out of Four questions. Each carries 5 marks. 2X5=10Marks
PART – A
Instructions: 8 X 1 M = 8 Marks
1. What is POST?
2. What is the need of networking?
3. What is TCP/IP ?
4. Write any two differences between IPV4 and IPV6
5. What is Wi-Fi ?
6. What is HTTPS ?
7. What is SNMP ?
8. What is Bridge in Computer networking ?
PART – B 4X3=12Marks
(OR)
9(b). Define Cache memory and explain how it improves the performance of PC
15(a) Explain about network cables (a) Coaxial Cables (b) Fiber optic Cables (OR)
15(b) Write the procedure for Preparation of straight and cross cable
16(a) Explain about any two Network trouble shooting tools. (OR)
Course Outcome
CO1 Describe operating system functions, operations and structures.
CO2 Manage process with various process scheduling algorithms.
CO3 Recognize Synchronization and handle the deadlocks with various deadlock
management techniques.
CO4 Explain the memory management techniques.
CO5 Implement virtualization of memory.
CO6 Handle files using file Management techniques.
Course Contents
Suggested Activities
Student activity like mini-project, survey, quiz, etc. should be done in group of 3-5 students.
1. Each group should do any one of the following type activity or any other similar
activity related to the course and before conduction, get it approved from concerned
course coordinator and program coordinator.
2. Each group should conduct different activity and no repeating should occur
Activities:
1. Installation and Un-installation of an Operating System on a New Computer
2. Removing of Second Operating System from a PC
3. A Survey of recent Operating System.
4. Case study on real time deadlock situation.
5. A case study on real time process synchronization.
6. Comparison of OS working in single core and multi core environment.
7. Documentation of comparing 32 bits and 64 bits OS.
8. Operating system is responsible for following activities in connection with
management of memory:
Allocation and de-allocation of memory as and when needed.
Keeping track of used and unused memory space.
Deciding what process to be loaded into memory in case space becomes
available.
9. For secondary space management:
Swap space and free space management
Disk scheduling
Allocating space to the data and programs onto the secondary storage device.
10. For process management:
Creation, deletion of both user and system process.
Handling process synchronization.
Deadlock handling.
Total Sessions 60
5(a) 7(a)
1 Unit-I 1, 2
5(b) 7(b)
6(a) 8(a)
2 Unit-II 3, 4
6(b) 8(b)
Total Questions 4 4 4
5(a) 7(a)
1 Unit-I 1, 2
5(b) 7(b)
6(a) 8(a)
2 Unit-II 3, 4
6(b) 8(b)
Total Questions 4 4 4
Semester End Examination
1 Unit-I
1 9(a) 13(a)
2 Unit-II
3 Unit-III
2 10(a) 14(a)
4 Unit-IV
4
9(b) 13(b)
5 Unit-V 5,6 11(a) 15(a)
11(b) 15(b)
3
10(b) 14(b)
6 Unit-VI 7,8 11(a) 16(a)
11(b) 16(b)
Total Questions 8 8 8
2. (A) Give the states of process state diagram and explain it.
Or
(B) Explain the principal of Round Robin scheduling algorithm.
4. (A) How multi threading concept can reduce the execution time of a program.
Or
(B) Explain with an example priority based scheduling algorithm.
MODEL QUESTION PAPER
BOARD DIPLOMA MID-SEMESTER-II EXAMINATION (C-21)
NOTE: 1. Answer any one question from 9, 10, 11 and 12. MARKS: 4 X 3=12
2. Each question carries three marks.
8. (A) Explain how FIFO and LRU page replacement algorithms will work?
Or
(B) Explain the term demand paging.
NOTE: 1. Answer any one question from 13, 14, 15 and 16 MARKS: 4 X 5=20
2. Each question carries five marks.
14. (A) How virtual memory concept will increase the size of the main memory.
Or
(B) How files are copied on disk? Explain in detail.
15. (A) Explain with an example LRU and Optimal page replacement algorithm.
Or
(B) Explain the concept thrashing with a neat sketch.
Prerequisites
Knowledge of basics DBMS theoretical concepts.
Course Content
Course Objectives
1. Use the concepts of database technologies.
2. Prepare queries to interact with database using SQL DML/DDL commands.
3. Implement Database schema objects for a given problem-domain.
4. Develop programs using PL/SQL.
Course Outcome
On successful completion of the course, the students will be able to attain below Course
Outcome(CO):
Experiment Lab
Course Outcome CL Linked PO
Linked Sessions
Program Outcomes
Course
PO1 PO2 PO3 PO4 PO5 PO6 PO7
3
RDBMS LAB 3 3 3 3 - -
References
1. “An Introduction to Database Systems” 8th edition by C J Date.
2. “DATABASE SYSTEM CONCEPTS” 6th edition by Abraham Silberschatz Yale
University, Henry F. Korth Lehigh University, S. Sudarshan Indian Institute of
Technology, Bombay.
3. “Fundamentals of Database Systems” Sixth edition, 2014, RamezElmasri, Shamkan
B. Navathe, Pearson Education, ISBN- 9788131792476.
4. “Database Managemet Systems” Raghu Ramakrishnan and Johannes Gehrke-3rd
Edition, McGraw-Hill, 2003.
5. https://www.w3schools.in/.
6. https://www.tutorialspoint.com/dbms
7. https://beginner-sql-tutorial.com/sql.htm.
8. www.nptel.ac.in.
9. http://www.sql-tutorial.net/
Course Delivery
The course will be delivered through Demonstration and Practices.
List of Exercises:
1. Install Oracle or Mysql database.
2. Prepare queries to create tables.
3. Prepare queries to insert records into tables.
4. Prepare queries to update records in a table.
5. Prepare queries to modify the structure of the table.
6. Prepare queries to retrieve data from database using SELECT command.
7. Prepare queries using clauses like WHERE, ORDER, IN, LIKE, AND,
OR, NOT.
8. Develop queries using numeric functions.
9. Develop queries using string functions.
10. Develop queries using date functions.
11. Develop queries using aggregate functions.
12. Develop queries using scalar functions.
13. Prepare queries using set operators.
14. Develop sub queries.
15. Prepare queries using SQL joins.
16. Create tables using integrity constraints.
17. Implement Sequences.
18. Implement Synonyms.
19. Implement creating and deleting indexes.
20. Implement Clusters.
21. Implement Views.
22. Develop programs using PL/SQL control statements.
23. Develop programs using PL/SQL Procedures.
24. Develop programs using PL/SQL Functions.
25. Develop programs using PL/SQL Recursion.
26. Develop programs using PL/SQL Stored procedures with- in , out , inout
parameters.
27. Develop programs using PL/SQL to handle exceptions.
28. Develop programs using PL/SQL cursors – implicit and explicit.
29. Implement Triggers.
30. Implement Packages.
CS-407-Java Programming Lab
Pre requisites
Knowledge of C++ programming and OOPs Concepts.
Course outcomes
On successful completion of the course, the students will be able to attain below Course
Outcomes (CO):
Course Outcome
Develop basic java console based applications.
CO1
CO2 Develop programs on inheritance and interfaces.
CO3 Develop programs on packages – io, util.
Develop programs on applets, AWT controls and event
CO4
handling.
Develop programs to handle exceptions and multi
CO5
threaded applications.
Develop programs to connect to database and retrieve
CO6
data and Develop server side programs using Servlets.
Course Contents
Unit
Unit Name Periods
Number
1 Introduction of Java 6
2 Inheritance and Interfaces 8
3 Packages. 8
4 Concepts of Applets, AWT and Event 8
handling
5 Exception Handling and Multi threaded 8
programming
6 JDBC and Servlets 7
Total 45
Recommended Books
1. https://www.w3schools.in/java-tutorial/
2. https://www.udemy.com/advanced-java-programming/
3. https://www.roseindia.net/java/Advanced-Java-Tutorials.shtml
4. http://www.javalearner.com/advanced.htm
5. https://www.studytonight.com
6. http://www.Javatpoint.com/Java-tutorial
7. http://www.tutorialspoint.com/Java/
8. http://www.indiabix.com/technical/core-Java/
9. https://www.geeksforgeeks.org/java/
CO-PO Mapping Matrix
CO4 Develop programs on applets, AWT controls and event R,U,A 1,2,3,4,7 8
handling.
CO5 Develop programs to handle exceptions and multi R,U,A 1,2,3,4,7 8
threaded applications.
CO6 Develop programs to connect to database and retrieve R,U,A 1,2,3,4,7 7
data and Develop server side programs using Servlets.
Total Sessions 45
Suggested Student Activities
Note: The following activities or similar activities for assessing 2.5 credits (Any one)
Student activity like mini-project, surveys, quizzes, etc. should be done in group of 3-5 students.
Each group should do any one of the following type activity or any other similar activity
related to the course and before conduction, get it approved from concerned course
coordinator and programme co-coordinator.
Each group should conduct different activity and no repeating should occur.
List of Exercises
1. Write a Java Program to define a class, define instance methods for setting and
retrieving values of instance variables , instantiate its object and operators.
2. Write a Java Program on control and iterative statements.
3. Write a java program to find the transpose, addition, subtraction and multiplication of
a two-dimensional matrix using loops.
4. Write a Java program on command line arguments.
5. Write a Java Program to define a class, describe its constructor, overload the
Constructors and instantiate its object.
6. Write a Java Program to illustrate method overloading
7. Write a java program to demonstrate static variables and static methods.
8. Write a Java program to practice using String class and its methods.
9. Write a Java program using final members.
10. Write a Java Program to sort a list of names in lexicographical order.
11. Write a Java Program to implement single inheritance.
12. Write a Java Program to implement multilevel inheritance by applying various access
controls to its data members and methods.
13. Write a Java program using ‘this’ and ‘super’ keyword.
14. Write a java program to illustrate method overriding
15. Write java program to explain the use of final keyword in avoiding method
overriding.
16. Write a program to demonstrate the use of interface.
17. Write a java program to implement multiple inheritance using the concept of
interface.
18. Write a Java program on hybrid and hierarchical inheritance.
19. Write a Java program to implement the concept of importing classes from user
defined package and creating packages , creating sub packages.
20. Write a Java program on access modifiers.
21. Write a Java program using util package classes.
22. Write a Java program using io package classes .
23. Write a Java program using stream classes.
24. Write a Java program on applet life cycle.
25. Write a Java program on all AWT controls along with Events and its Listeners.
26. Write a Java program on mouse and keyboard events.
27. Write a Java program on inbuilt Exceptions.
28. Write a Java program on Exception handling.
29. Write a program to implement multi-catch statements
30. Write a java program on nested try statements.
31. Write a java program to create user-defined exceptions.
32. Write a program to create thread (i)extending Thread class (ii) implementing
Runnable interface
33. Write a java program to create multiple threads and thread priorities, ThreadGroup.
34. Write a java program to implement thread synchronization.
35. Write a java program on Inter Thread Communication.
36. Write a java program on deadlock.
37. Write a Java program to establish connection with database.
38. Write a Java program on different types of statements.
39. Write a Java program to perform DDL and DML statements using JDBC.
40. Write a Java program on Servlet life cycle.
41. Write a Java program to handle HTTP requests and responses using doGet() and
doPost() methods.
CS-408-Computer Hardware & Networking Lab
Pre requisites
Basic knowledge on working of computer.
Course Outcomes
Upon completion of the course the student shall be able to
Course Outcome
CO1 Identify the PC components
CO2 Learn different system boards, Processors, Memories and Mass storage devices
Course Content
1. Identify the front panel indicators and switches and rear side connector in a computer
system.
2. Identify various motherboards components, connectors, slots, ports (USB, VGA, DVI,
and HDMI), cables and Connectors, ROM, RAM (Memory), CPU (Processor), Hard
Drive Connections, AGP, CD/DVD, Add On Cards, IDE/PCI Slots, Sound Cards.
3. Configure BIOS Setup Program
4. Installation of Hard Disk (a) Install Hard Disk (b) Partition and Format Hard Disk (c)
Disk Defragmentation
5. Installation of additional RAM
6. Installation of operating system software
7. Installation of application software
8. Installation of Printer (Laser/Inkjet/Multifunction Printer) & device driver software
9. Installation of Scanner & Device driver Software
10. Know the precautions to be taken while troubleshooting the hardware and know about
Anti-static Wrist band, Workbench etc.,
11. Trouble shooting Keyboard, Monitor and Printer.
12. Study of various LAN Devices.
13. Install and Configure Wired and Wireless NIC .
14. Preparing the UTP cable (Cat-5 or Cat-6) for cross and straight connections using
crimping tool.
15. Install and configure Network Devices: HUB, Switch.
16. Install and Configure Router (Normal or Wireless).
17. Connect the computers in Local Area Network.
18. Implementation of Wi-Fi Network with the help of Wireless router and Access Point.
CS-409-Microprocessors Lab
Pre requisites
Knowledge of Computer Operation.
Course outcomes
List of Experiments
1. Execute an assembly language program for the addition of two 8 bit Numbers and two
16 bit Numbers.
2. Execute an assembly language program for the Subtraction of two 8 bit Numbers and
two 16 bit Numbers
3. Execute an assembly language program for Multiplication of two 8 bit Numbers and
two 16 bit Numbers
4. Execute an assembly language program for Division of 16 bit Number by 8 bit
Number
5. Execute an assembly language program to add two BCD numbers.
6. Execute an assembly language program to find reverse of a given number.
7. Execute an assembly language program to find the factorial of a number.
8. Execute an assembly language program using AND,OR and NEG instructions.
9. Execute an assembly language program using ROR and ROL instructions.
10. Execute an assembly language program to count number of ones and zeros in a
number.
11. Execute an assembly language program to find sum of ‘N’ numbers given in an array.
12. Execute an assembly language program to find sum of ‘N’ Natural Numbers
13. Execute an assembly language program to find the Smallest among ‘N’ Numbers.
14. Execute an assembly language program to move data from one location to another
location.
15. Execute a program for generating multiplication table for a given number
16. Execute an assembly language program to sort the list of numbers in ascending order.
17. Execute an assembly language program to sort the list of numbers in descending
order.
Rationale:
The course is designed to impart employability skills to make the students of diploma get the
initial employment, maintain the employment and get better employment, if they wish.
Prerequisites:
The course requires the basic knowledge of vocabulary, grammar, four language learning
skills, viz. listening, speaking, reading and writing and life skills.
Course Outcomes
CO1 Comprehend the importance of employability skills and strategies to survive in a job.
Converse fluently and accurately accordingly in JAM sessions. Group Discussions will
CO2 enhance the willingness to take the Initiative, accept adaptability in turn developing
leadership qualities and Communication Skills.
Understand purpose and process of interview in turn knowing how to prepare and succeed
CO3
in interview.
Making effective presentation, Develop Public speaking skills and learn to make visually
CO4
attractive PPTs.
Learn various writing formats useful at workplace and to develop an ability to apply
CO5
technical information in documentation.
Build strong workplace relationships by learning workplace etiquette, professional ethics
CO6
and importance of gender sensitization.
Course Contents
Module 1: Introduction to Employability Skills
Duration: 6 Periods ( L 2 P 4)
a. Filling the Curriculum gaps
i. Attributes and values
ii. Specific and general skills
iii. Academic Knowledge and Aptitude Skills
iv. Analytical skills / Data Analysis
b. How to get into a job?
i. Good personal presentation and attitude
ii. Core generic skills
iii. Technical / Professional skills
iv. Good Communication skills
c. How to survive in a job?
i. Learning skills needed for self-advocacy and networking
ii. Adaptability to cope with the changing circumstances.
iii. Reliability and Integrity
iv. Continuous Learning and Consistency in performance.
Course Outcomes
Comprehend the importance of employability skills and strategies to survive in a
CO1
job.
Converse fluently and accurately accordingly in JAM sessions. Group Discussions
CO2 will enhance the willingness to take the Initiative, accept adaptability in turn
developing leadership qualities and Communication Skills
Understand purpose and process of interview in turn knowing how to prepare and
CO3
succeed in interview.
Making effective presentation, develop public speaking skills and learn to make
CO4
visually attractive PPTs.
Learn various writing formats useful at workplace and to develop an ability to apply
CO5
technical information in documentation.
Build strong workplace relationships by learning workplace etiquette, professional
CO6
ethics and importance of gender sensitization.
CO-PO Matrix
CO PO1 PO2 PO3 PO4 PO5 PO6 PO7 Mapping POs
410.1 - - - - 3 3 5,7
410.2 - - - - 3 2 3 5,6,7
410.3 - - - - 3 3 3 5,6,7
410.4 - - - - 2 2 3 5,6,7
410.5 - - - - 2 2 3 5,6,7
410.6 - -- -- 2 3 5,7
Evaluation Pattern:
I. Continuous Internal Examination: 60 Marks
i. Seminars: 10 marks
ii. Assignments: 5 marks
iii. Lab record submission: 5 marks
E-Learning Resources:
http://www.dailywritingtips.com/
http://www.englishdaily626.com/c-errors.php
http://www.owlnet.rice.edu/~cainproj/
http://www.thehumorsource.com/
http://www.indiabix.com/group-discussion/topics-with-answers/
http://networketiquette.net/
https://public.wsu.edu/~brians/errors
http://www.bbc.co.uk/worldservice/learningenglish/radio/specials/15
Marks
Uni Questions for SEE %Weightage
Unit name Periods weightage
t No
R U A
Introduction to
1. Employability Skills 6 2 2
JAM/ Group
2 9 2 2
Discussions
3 Interview Skills 9 2 2
4. Presentation Skills 9 2 2
Writing skills at work
5. place 6 1 1
6. Workplace awareness 6 1 1
Total 45 10 100
BOARD DIPLOMA EXAMINATION (C-21)
MID SEMESTER EXAMINATION – I
HU-410- EMPLOYABILITY SKILLS LAB
Time: 1 Hour Total Marks: 20
Part – A 10 marks
Instruction: Answer any one of the following questions.
1. Write a paragraph on the importance of employability skills.
2. List out the important employability skills.
3. Mention the different strategies to enhance the employability skills.
Part – B 10 marks
Instruction: Answer any one of the following questions.
4. What are the rules to be implemented in a JAM session?
5. What are the do’s and don’ts of a group discussion.
6. List out the steps involved in a group discussion and mention some phrases
and expressions commonly used.
Part – A 10 marks
Instruction: Answer any one of the following questions.
1. Write a list of frequently asked questions in an interview. Write the
answers for the questions.
2. Mention the instructions to attend a telephonic interview.
3. What are the do’s and don’ts for a formal interview?
Part – B 10 marks
Instruction: Answer any one of the following questions.
4. Write the various steps involved in making presentations effectively.
5. What are the do’s don’ts of body language during a presentation?
6. List out a few audio-visual aids and explain their role in making an
effective presentation.
BOARD DIPLOMA EXAMINATION (C-21)
SEMESTER END EXAMINATION
HU-410- EMPLOYABILITY SKILLS LAB
Time: 3 Hours Total Marks:
40
Part – A 10 marks
Instruction: Pick any one question from the given lot.
1. How are employability skills helpful to secure a good job?
2. Describe the steps involved in JAM and group discussion.
3. Write the guidelines involved in making a good presentation.
4. List few professional ethics useful at workplace.
5. Mention few skills involved in writing at workplace.
Part – B 15 marks
Rationale: This course is introduced for all semesters with a purpose of providing
outside classroom experiences that lead to overall development of the students. One whole day
is allocated for activities.
Course Objective:
1. To create an awareness on Engineering Ethics and Human Values.
2. To instill Moral, Social Values and Loyalty.
3. Create awareness about social responsibilities of Engineers
4. To improve Communication and Participation skills
Course Content and Blue Print of Marks for
CIE
ActivityNo Activity Periods Frequency
Haritha Haram(plantation &Maintenance)/ Waste 7 times in a
1 21 semester
management /Swachh Bharat
6 times in a
2 Mini projects 18 semester
Online Video Tutorials/ MOOCs in SWAYAM 4 times in a
3 16 semester
/NPTEL/ e-Journals
Seminars/Quizzes/ Technical Paper Presentations 6 times in a
4 /Group discussions/ Participate in Tech fests and 24 semester
coding competitions
2 times in a
5 Field Visits/Field Practice(also within the campus) 14 semester
Expert/Guest Lectures
Safety and Responsibilities of an Engineer
Occupational crime/Cyber crimes 27
6 Responsibility of engineers 4 Times in a
Emerging technologies semester
Total Periods 120
Note: in case Expert faculties are not available English faculty may handle the expert
lectures or Video clips on the suggested lectures may be played and the suggested activities
are flexible.
Course Outcomes:
CO Outcome CO/PO
Mapping
CO1 Application of known knowledge on real time 1,2,3,4,5,6,7
problems
CO2 Practice the moral values that ought to guide the 5,6,7
Engineeringprofession.
CO3 Develop the set of justified moral principles of 5,7
obligation, ideals that ought to be endorsed by the
engineers and applythem in real life situations
CO5 Create awareness of saving environment through 3,4,5,7
activities
CO6 Create awareness of Constitution of India 5
COURSE CONTENT:
SAFETY, RESPONSIBILITIES OF ENGINEERS
Safety and risk-definition- - assessment of safety and risk - risk benefit analysis and
reducing risk-–Personal risk- Public risk-Reducing risk-Voluntary Risk-Collegiality and
loyalty–Authority- Types- collective bargaining - occupational crime –Responsibility of
engineers–Types-Social responsibility-Professional responsibility- confidentiality-conflicts
of interest-liability
Evaluation:
The student must maintain a record of all activities conducted on skill upgradtion/
Activities day and prepare a soft copy of report and submit it to their mentor or upload to the
institute website or mail.
The reports shall be evaluated by the mentors though rubrics and accordingly give
the eligibility for 2.5 credits. The student must have participated in at least 75% of
activities to get eligibility.
CO-PO MAPPING MATRIX
Basic & Discipline
Development tools
Lifelong learning
Engineering for
Environment
Management
Engineering
society and
knowledge
Analysis
Problem
Design
Project
Tools
Mapped PO
CO1 ✓ ✓ ✓ ✓ ✓ ✓ ✓ 1,2,3,4,5,6,7
CO2 ✓ ✓ ✓ 5,6,7
CO3 ✓ ✓ 5,7
CO4 ✓ ✓ ✓ ✓ 3,4,5,7
CO5 ✓ 5
FORMAT FOR STUDENT ACTIVITY ASSESSMENT
Performs all
Does not duties of
Fulfill team‟s perform any Performs very Performs nearly Performs all assigned team
roles 4
roles & duties duties assigned littleduties all duties duties
to the team role with
presentation
Always does
Usually does Does the the assigned
Rarely does the
Always relies the assigned assigne d job work without
Shares work assigned work; having to be 2
on others to do work; rarely without
equally often needs
the work needs having to be reminded and
reminding on given time
reminding remind ed.
frame
Listens and
contributes
Usually does Listens and precisely to
Is always most of the
Listens, but contrib utes the relevant
Listen to other talking; never talking; rarely
sometimes talk and 2
team mates allows anyone allows to the relevant topic
too much exhibit
else to speak
others to speak topic
leadership
qualities
10/4=2
TOTAL
.5
*All student activities should be done in a group of 4-5 students with a team leader.