Syllabus 3rd Sem
Syllabus 3rd Sem
Semester - 3
Internal Marks External Marks PassingMarks PassingMarks Total
(Theory+ CE) (Practical) Marks
Code Subject Credit Lect Lab Tut T P CE T P Int. + Ext. Int. + Ext.
Total 22 15 10 2 800
Lect - Lecture, Tut - Tutorial, Lab - Lab, T - Theory, P - Practical, CE - CE, T - Theory, P - Practical
Theory Passing %: 40 Practical Passing %: 50
27 |P a g e
SubjectSyllabus
303105201 - DesignofDataStructures
Course:BTech Semester: 3
Prerequisite:ComputerProgrammingand Basic Syntaxes
Course Objective: Data structureis a subject of primary importance in Information and Communication Technology. Organizing or
structuring data is important for implementation of efficient algorithms and program development. Efficient problem solving needs
the application of appropriate data structureduring programdevelopment.
Teachingand ExaminationScheme
TeachingScheme Examination Scheme
Lecture Tutorial Lab InternalMarks ExternalMarks Total
Credit
Hrs/Week Hrs/Week Hrs/Week Hrs/Week T CE P T P
3 0 0 0 3 20 20 - 60 - 100
SEE - Semester End Examination, T - Theory, P- Practical
28 |P a g e
SubjectSyllabus
303105201 - DesignofDataStructures
Reference Books
1. FundamentalsofDataStructuresin C, 2ND eDITION, E.Horowitz,S,.SahniandSusanAnderson-Freed,UniversitiesPress
(TextBook)
CourseOutcomes
At the endof thiscourseStudentsWillbe ableto:
1 Understandthe conceptof Dynamicmemorymanagement,data types, algorithms,BigO notation
2 Understandbasicdatastructuressuch as arrays,linkedlists,stacksand queues
3 Describethehash functionandconceptsof collisionanditsresolutionmethods
4 Solve probleminvolvinggraphs,treesand heaps
5 ApplyAlgorithmfor solvingproblemslikesorting,searching,insertionand deletionof data
CourseOutcome
AfterLearningtheCoursethestudentsshall be able to:
AfterLearningthecoursethe students shallbeableto:
1. Use differenttypesof datastructures,operationsand algorithms
2. Applysearchingand sortingoperationson files
3. Use stack, Queue,Lists,Treesand Graphsinproblemsolving
4. Implementalldatastructuresina high-levellanguagefor problemsolving.
Miscellaneous
Exam Requirement
It consists of Assignments/Seminars/Presentations/Quizzes/Surprise Tests (Summative/MCQ)etc
29 |P a g e
SubjectSyllabus
303105202 -DesignofDataStructuresLaboratory
Course:BTech Semester: 3
Prerequisite:Basicknowledgeof Data Structures
CourseObjective: Thiscourseprovidesa broadintroductiontoData StructuresThe variousData structuresandits analysisof
working design and development.
Teachingand ExaminationScheme
TeachingScheme Examination Scheme
Lecture Tutorial Lab InternalMarks ExternalMarks Total
Credit
Hrs/Week Hrs/Week Hrs/Week Hrs/Week T CE P T P
0 0 4 0 2 - - 20 - 30 50
SEE - Semester End Examination, T - Theory, P- Practical
CourseOutcome
AfterLearningtheCoursethestudentsshall be able to:
AfterLearningthecoursethe students shallbeableto:
1. Use differenttypesof data structures,operationsand algorithms
2. Applysearchingand sortingoperationson files
3. Use stack, Queue,Lists,Treesand Graphsinproblemsolving
4. Implementalldatastructuresina high-levellanguagefor problemsolving
ListofPractical
1. ImplementStackand its operationslike (creationpushpoptraversepeeksearch)usinglineardatastructure
2. ImplementInfix to PostfixExpressionConversionusingStack
3. Implement PostfixevaluationusingStack.
4. Implement Towersof Hanoiusing Stack.
5. Implementqueueandits operationslike enqueue,dequeue,traverse,search.
6. ImplementSingleLinkedlists andits operations(creationinsertiondeletiontraversalsearchreverse)
7. Implement DoubleLinkedlists and its operations(creationinsertiondeletiontraversalsearchreverse)
8. Implementbinarysearchand interpolationsearch.
9. Implement Bubblesort,selectionsort, Insertionsort,quick sort,mergesort.
10. ImplementBinarysearchTreeand its operations(creation,insertion,deletion).
11. Implement Traversals PreorderInorderPostorderon BST.
Implement Graphsandrepresentusingadjacenylist and adjacencymatrixand implementbasicoperationswithtraversals
12.
(BFS and DFS).
30 |P a g e
SubjectSyllabus
303105203 - DatabaseManagementSystem
Course:BTech Semester: 3
Prerequisite:Basic ComputerKnowledge
CourseObjective:The coursewillenablestudentsto understand the differentissuesinvolvedin the designand implementationof
a database system as well executevarious database queries using SQL.
Teachingand ExaminationScheme
TeachingScheme Examination Scheme
Lecture Tutorial Lab InternalMarks ExternalMarks Total
Credit
Hrs/Week Hrs/Week Hrs/Week Hrs/Week T CE P T P
3 0 0 0 3 20 20 - 60 - 100
SEE - Semester End Examination, T - Theory, P- Practical
31 |P a g e
SubjectSyllabus
303105203 - DatabaseManagementSystem
Reference Books
1. DatabaseSystemConcepts(TextBook)
By AbrahamSilberschatz,HenryKorth,S. Sudarshan| McGrawHillInternational|6thEdition
2. An IntroductiontoDatabaseSystems
By C. J. Date, A. Kannan,S.Swamynathan|PearsonEducation|8thEdition
3. SQL, PL/SQL– TheProgrammingLanguage
By IvanBayross| BPBPublications
CourseOutcome
AfterLearningtheCoursethestudentsshall be able to:
AfterLearningthe Coursethe students shallbe able to:
1. Understandbasicconceptsof Database.
2. UnderstandRelationalModelsandits importance.
3. Buildproperstructureddatabasefora givenproblemor application.
4. Learnhow varioustransactionsaremanagedin real-timescenarios.
5. Understandtheevaluationparametersof a queryaswell as securityparametersofdatabase.
6. ImplementSQL conceptsto builddynamicdatabase applications.
Miscellaneous
Exam Requirement
It consistsof Assignments/Seminars/Presentations/Quizzes/Surprise Tests (Summative/MCQ)etc.
32 |P a g e
SubjectSyllabus
303105204 - DatabaseManagementSystemLaboratory
Course:BTech Semester: 3
Prerequisite:Basic ComputerKnowledge
CourseObjective:The coursewillenablestudentsto understand the differentissuesinvolvedin the designandimplementationof
a database system as well executevarious database queries using SQL.
Teachingand ExaminationScheme
TeachingScheme Examination Scheme
Lecture Tutorial Lab InternalMarks ExternalMarks Total
Credit
Hrs/Week Hrs/Week Hrs/Week Hrs/Week T CE P T P
0 0 2 0 1 - - 20 - 30 50
SEE - Semester End Examination, T - Theory, P- Practical
CourseOutcome
AfterLearningtheCoursethestudentsshall be able to:
AfterLearningthe Coursethe students shallbe able to:
1. Understandbasicconceptsof Database.
2. UnderstandRelationalModelsand its importance.
3. Buildproperstructureddatabasefora givenproblemor application.
4. Learnhow varioustransactionsaremanagedin real-timescenarios.
5. Understandtheevaluationparametersof a queryas wellas securityparametersofdatabase.
6. ImplementSQL conceptsto builddynamicdatabaseapplications.
Listof Practical
1.
1. WhatisDBMS?Explainadvantagesof DBMSover FPS.
2. List15 applicationsofDatabase.Explainany2 howDatabasecanbe helpfulinmanagingthatapplication?
3. Createthe Databasefor the following:
1. StudentDetailsusing Excel.
2. EmployeesDetailsusing MS Access
3. Facebookusing Excel
2.
Createfollowing Tables:
Important Instructions:
33 |P a g e
SubjectSyllabus
303105204 - DatabaseManagementSystemLaboratory
3. SimpleQueries:
1. Describedeposit, branch.
2. Describeborrow,customers.
3. Listalldata fromtable DEPOSIT.
4. Listalldata fromtableBORROW.
5. Listalldata fromtable CUSTOMERS.
6. Listalldata fromtable BRANCH.
7. Giveaccountnoand amountof depositors.
8. Listall data fromSAILORS.
9. ListBoatName anditscolor.
10. List Employeenameandits city.
11. List allthedetailsof Clients.
12. Describevariousproductsandits price.
13. Describesailor’sname,age and itsrating.
14. Describethemanagersof variousemployees
15. DescribethedetailsofLoanfor customers.
16. Describethedateof travelof varioussailors.
4. SimpleQueries:
(1) Givenameof depositorshavingamountgreaterthan 4000.
(2) Listthe employeeshavingsalarylessthan 22000.
(3) List the sailorshavingagemorethan 25.
(4) Listtheboatstravellingon 10-oct-98
(5) Listthe detailsof boat“Interlake”.
(6) Listthe detailsof thered coloredboat.
(7) List the detailsofclientswhosecityisMumbai
(8) List ClientName,due balanceandcityof the clientshavingbalancegreaterthan 1500.
(9) Describethe detailsof productshavingsellingpriceless than500.
(10) Listthe productsforwhichquantityorderedislessthan 120 and costpriceisgreaterthan 250.
(11) Displayaccount detailshavingamount greater 2200.
(12) Displayallthe customersstayingin Nagpur
(13) Displaythenamesof sailorshavingratinggreaterthan 7
(14) Displaythe ordersmadein the monthof June
(15) Listall the accountscreatedinthemonthof March
5. “Like”Queries:
1. Displayallcustomerswhosename startwith ‘M’.
2. Displayallthe customerswhose nameendswith ‘L’.
3. Displayallloan detailswhose branchstartswith ‘A’.
4. Displaythe detailsof sailorswhose nameis minimum6characterslong.
5. Displaythe detailsofEmployeeswhoseaddressstartswith ‘S’.
6. Listthe detailsofthe boat endingwith‘e’.
7. Listthedetailsof clientshaving ‘h’ as a 3rdcharacterinhis/her name.
8. ListClientName,duebalanceandcitywhosepincode startswith 4.
9. Listall customerswhosecitycontains‘a’ as secondcharacter.
10. Listclientnamesandcitywhosestate has ‘a’ as fourthor fifthcharacter.
34 |P a g e
SubjectSyllabus
303105204 - DatabaseManagementSystemLaboratory
8. “Join”Queries:
1. Displayallthe employeenameandthe citywheretheywork.
2. Displaytheemployeenameand company’snamehavingsalarymorethan 15000.
3. Findtheaverageratingandage of allsailors.
4. List variousproductsavailable.
5. Displaythe namesofsalesmanwhohave salarymorethan2850.
6. Changethe costpriceof Trousersto 950
7. Listall the clientshaving“a”as a secondcharacterintheirnames.
8. Listall the productswhose QtyonHandislessthan Reorderlvl.
9. Printthedescriptionandtotal qty soldforeach product.
10. Findout all the productswhichhavebeensold to “IvanBayross”.
11. Findthe namesofall clientswhohavepurchased Trousers.
12. Findtheproductsandtheirquantitiesfor the ordersplacedbyclientC00001and C00002.
13. Listthe clientdetailswhoplaceorderno. O19001.
14. Listthe nameofclientswhohaveplacedordersworthRs. 10000 or more.
15. Findthetotal of Qty orderedfor eachOrder.
9. “Miscellaneous” Queries:
1. Find the averagerateforeachOrder.
2. Givethe loandetailsofall the customers.
3. Listthecustomernamehavingloanaccountinthe same branchcitytheylivein.
4. Providetheloandetailsof all the customerswhohave openedtheiraccountsafterAugust’95.
5. ListtheorderinformationforclientC00001 and C00002.
6. Listall the informationfortheorderplacedinthemonth of june.
35 |P a g e
SubjectSyllabus
303105204 - DatabaseManagementSystemLaboratory
10. PL/SQLBlock:
1. Writea PL/SQLBlocktoAdd 2 Numbers
2. WriteaPL/SQLBlockto findAreaof Rectangle,Triangleand Square.
3. Writea PL/SQLBlocktofindMaximumof3 numbers
4. WriteaPL/SQLBlocktoprintsumof N NumbersusingFor Loop.
5. WriteaPL/SQLBlock to generateFibonacciseriesof N numbers
Miscellaneous
Exam Requirement
It consistsof Assignments/Seminars/Presentations/Quizzes/Surprise Tests (Summative/MCQ)etc
36 |P a g e
SubjectSyllabus
303105205 - ObjectOrientedProgrammingwithJAVA
Course:BTech Semester: 3
Prerequisite:Basicknowledgeof software applications
CourseObjective: This course providesa broad introductionto softwareengineering.The variousprocessmodelsrequiredto
develop software is also being described.Moreover the functionaland non-functionalrequirementsare also described.
Teachingand ExaminationScheme
TeachingScheme Examination Scheme
Lecture Tutorial Lab InternalMarks ExternalMarks Total
Credit
Hrs/Week Hrs/Week Hrs/Week Hrs/Week T CE P T P
2 0 0 0 2 20 20 - 60 - 100
SEE - Semester End Examination, T - Theory, P- Practical
Reference Books
1. IntroductiontoJava Programming(ComprehensiveVersion)Daniel Liang; Pearson(TextBook)
3. CompleteReferenceJava2 HerbertSchildt;TMH
37|P a g e
SubjectSyllabus
303105205 - ObjectOrientedProgrammingwithJAVA
CourseOutcomes
At the endof thiscourseStudentsWillbe ableto:
1 Describethe proceduralandobject orientedparadigmwithconceptsof streams,classes,functions,data and objects
2 Understanddynamicmemorymanagementtechniquesusing pointers,constructors,destructors, etc
3 Describetheconceptof functionoverloading,operator overloading,virtualfunctionsand polymorphism
4 Classifyinheritancewiththe understandingofearlyandlate binding,usage of exceptionhandling,genericprogramming.
5 Demonstratetheuse of variousOOPsconceptswiththe helpof programs
CourseOutcome
AfterLearningtheCoursethestudentsshall be able to:
Afterlearningthecoursethe students shallbeableto:
1. Understandthe principlesandpracticeof objectorientedprogramming.
2. Write, compileanddebugprogramswith Java compiler.
3. Createarobust applicationusingexceptionhandling.
4. Understandthe principlesof synchronizationand designapplicationusing multi-threading.
38 |P a g e
SubjectSyllabus
303105206 - ObjectOrientedProgrammingwithJAVA
Laboratory
Course:BTech Semester: 3
Prerequisite:Basicknowledgeof software applications
CourseObjective: This course providesa broadintroductionto softwareengineering.The variousprocessmodelsrequiredto
develop software is also being described.Moreover the functional and non-functionalrequirementsare also described.
Teachingand ExaminationScheme
TeachingScheme Examination Scheme
Lecture Tutorial Lab InternalMarks ExternalMarks Total
Credit
Hrs/Week Hrs/Week Hrs/Week Hrs/Week T CE P T P
0 0 2 0 1 - - 20 - 30 50
SEE - Semester End Examination, T - Theory, P- Practical
CourseOutcome
AfterLearningtheCoursethestudentsshall be able to:
Afterlearningthecoursethe students shallbeableto:
1. Understandthe principlesandpracticeof objectorientedprogramming.
2. Write, compileanddebugprogramswith Java compiler.
3. Createarobust applicationusingexceptionhandling.
4. Understandthe principlesof synchronizationand designapplicationusing multi-threading.
39 |P a g e
SubjectSyllabus
303105206 - ObjectOrientedProgrammingwithJAVA
Laboratory
ListofPractical
1. writea programtodisplayHelloWorldmessagein consolewindow.
2. Writea programtoperformarithmeticandbitwiseoperationsin a singlesourceprogramwithoutobjectcreation.
Write a programto performarithmeticandbitwiseoperationsby creatingindividualmethods andclassesthan createan
3.
object to execute the individualmethods of each operation.
4. Writea javaprogramtodisplaytheemployeedetailsusing Scannerclass.
Miscellaneous
Exam Requirement
It consistsof Assignments/Seminars/Presentations/Quizzes/Surprise Tests (Summative/MCQ)etc.
40 |P a g e
SubjectSyllabus
303191202 - DiscreteMathematics
Course:BTech Semester: 3
Prerequisite:BasicConceptsofSet Theory,Function
CourseObjective:The courseprovidesamathematicalbackgroundrelatedto Computerengineering.
Teachingand ExaminationScheme
TeachingScheme Examination Scheme
Lecture Tutorial Lab InternalMarks ExternalMarks Total
Hrs/Week Hrs/Week Hrs/Week Hrs/Week Credit T CE P T P
4 - - - 4 20 20 - 60 - 100
SEE - Semester End Examination, T - Theory, P- Practical
Reference Books
1. DiscreteMathematicsandits Applications(TextBook)
By KennethH.Rosen|Tata McGraw–Hill
2. Discrete Mathematics
By NormanL.Biggs| OxfordUniversityPress| 2nd Edition
3. DiscreteMathematicalStructureswith Applicationsto ComputerScience(TextBook)
By J.P.TremblayandR.Manohar| Tata McGraw-Hill
4. DiscreteMathematicswith Applications(TextBook)
By SusannaS. Epp| WadsworthPublishingCo.Inc.| 4
5. Elementsof DiscreteMathematicsA ComputerOriented Approach(TextBook)
By C. L. Liu and D P Mohapatra|TataMcGraw–Hill|3
41 |P a g e
SubjectSyllabus
303191202 - DiscreteMathematics
CourseOutcome
AfterLearningtheCoursethestudentsshall be able to:
Equivalence relation.
• Apply principlesof mathematicalinductionand basic countingtechniquesto solveproblemsinvolvingprimenumbers,divisibility,
and combinatorial analysis.
• Evaluatepropositionallogic statementsand prooftechniquesto constructvalidarguments,identifylogical equivalences,and
apply quantifiers effectively in proofs.
• Differentiatealgebraicstructuresand applycongruencerelationsto solve problemsinabstract algebra,includinggroups, rings,
and Booleanalgebras.
• Analyzegraph propertiesand algorithms(Evaluationlevelof Bloom's Taxonomy)to solveproblemsrelatedto connectivity,
shortest paths, and tree structuresefficiently.
42 |P a g e
SubjectSyllabus
303193203 - ProfessionalCommunicationSkills
Course:BTech Semester: 3
Prerequisite:KnowledgeofEnglishlanguagein practicallife
CourseObjective:Knowledgeand applicationofEnglish,Aptitudeand Management Skillsarecrucialfor better employabilityas
well as professionalism
Teachingand ExaminationScheme
TeachingScheme Examination Scheme
Lecture Tutorial Lab InternalMarks ExternalMarks Total
Credit
Hrs/Week Hrs/Week Hrs/Week Hrs/Week T CE P T P
- 2 - - 2 100 100 - - - 100
SEE - Semester End Examination, T - Theory, P- Practical
43 |P a g e
SubjectSyllabus
303193203 - ProfessionalCommunicationSkills
Reference Books
1. BusinessCorrespondenceand ReportWriting
By SHARMA,R.ANDMOHAN,K.
2. CommunicationSkills 2011
By KumarS andLataP | OxfordUniversityPress
3. PracticalEnglish Usage
By MICHAELSWAN
4. A RemedialEnglishGrammarforForeignStudent
By F.T. WOOD
5. On WritingWell
By WilliamZinsser|HarperPaperbacks,2006| 30th anniversaryedition
6. Oxford PracticeGrammar,
By JohnEastwood|OxfordUniversityPress
7. QuantitativeAptitudefor Competitive Examinations
By Dr.R.S.Aggarwal
CourseOutcome
AfterLearningtheCoursethestudentsshall be able to:
AfterLearningthecoursethe students shallbeableto:
1. Write,readandunderstand workplaceEnglish
2. Speakand participateinoral organizationalcommunication
3. Useverbal& non-verbalcommunicationfordeliveringabusinesspresentation
4. EnhanceManagementskills.
5. Learntheprocessof negotiation.
44 |P a g e
SubjectSyllabus
303105220 - DigitalElectronics
Course:BTech Semester: 3
Prerequisite:: BasicElectronics
CourseObjective:This courseis design to providebasic ideasof computerarchitecture.Thiscourse alsomakeshelp to understand
organizationandarchitectureofcomputer.It will help to develop their logical abilities.
Teachingand ExaminationScheme
TeachingScheme Examination Scheme
Lecture Tutorial Lab InternalMarks ExternalMarks Total
Credit
Hrs/Week Hrs/Week Hrs/Week Hrs/Week T CE P T P
3 0 0 0 3 20 20 - 60 - 100
SEE - Semester End Examination, T - Theory, P- Practical
Reference Books
1. ModernDigitalElectronics (TextBook)
By R.P.Jain| Tata McGraw-HillEducation
2. DigitalLogicand ComputerDesign
By MorrisMano| PHI
Page1 of 2
3. Fundamentalsof Digital Circuits
By AnandKumar | Prentice-HallofIndiaPrivateLimited,NewDelhi(2006)
45 |P a g e
SubjectSyllabus
303105221 - DigitalElectronicsLaboratory
Course:BTech Semester: 3
Prerequisite:Basic Electronics
Teachingand ExaminationScheme
TeachingScheme Examination Scheme
CourseOutcome
AfterLearningtheCoursethestudentsshall be able to:
AfterLearningthecoursethe students shallbeableto:
1. IdentifyandExplainthe digitalnumbersystemand alsoableto justifythe practicalapplicationofnumbersystem.
2. UnderstandandExplaindifferentlogicgatesandcodesandalso how to use theminrealwordapplication.
3. Realizetheminimizationtechniquesof digitalCircuits.
4. Designdifferent Adders, Subtracters, Multiplexers,decodersandmanymore circuits
5. Applythe theoreticalknowledge to designflip-flops,countersandmanymoresequentialcircuits.
6. Identifyandillustratespecificationsof differentlogicfamiliesand memoriesandanalyzethem in criticalway.
46 |P a g e
SubjectSyllabus
303105221 - DigitalElectronicsLaboratory
ListofPractical
1. To StudyandTestingofvariousLogicGatesICs.
To Study and TestingofvariousLogicGatesICs.
47 |P a g e