0% found this document useful (0 votes)
214 views64 pages

Untitled

Uploaded by

Shubham Behara
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF or read online on Scribd
0% found this document useful (0 votes)
214 views64 pages

Untitled

Uploaded by

Shubham Behara
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF or read online on Scribd
You are on page 1/ 64
SCHEME OF EXAMINATION 2019-2020 BCA PART Theory Marks | Internal | Teaching Load Subject Subject Paper Marks per Week Code Lor oP Max] Min. | Max. | Min. w | |o© | BCAIOI | Discrete Mathematics [80 2 | 20 8 [4]2/ _ | BCA102 | Computer Fundamentals so | 2 | 2m | 8 |4) 2] - BCA103 | Programming in 'C’ language so | 2 | 2m | 8 |4)2)- BCAL04 | PC Software and Multimedia so | 27 | 2m | 8 | 4)2| - BCAL0S | Web Technology and E-Commerce so | 2 | 20 | 8 |4]2/- catog | Communication skills wo | |» |e fala BCA107_| LAB I: Programming Lab in ‘C” 1oo_| so | 40 | 16 3x2 BCA108 | LAB II: PC Software Lab oo | so | 40 | 16 | - | = | 2x2 | BCA109 | LAB Ill: Web Technology Lab Too | 30 | 20 | 8 ]-|- [re TOTAL 780 | 312 | 220 | 88 GRAND | (PAPER + INTERNAL) (0) (BHD) TOTAL 1000 400 ‘* Student will have to pass individually in all theory, practical and sessional. BEE ye Wait BCA -101 crete Mathematics Max Marks: 80 Min Marks: 27 NOTE : The Question Paper setter is advised to prepare unit-wise question with the provision of internal choice. Only Simple calculator is allowed no scientific calculator is allowed. UNIT-1 Recall of statements and logical connectives, tautologies and contradictions, logical equivalence, algebra of propositions quantifiers, existential quantifiers and universal quantifiers. UNIT~ I Boolean algebra and its properties, algebra of propositions as an example, De Morgan's Laws, partial order relations g.l.b., Lub. Algebra of electric circuits and its applications. Design of simple automatic control system. UNIT - Boolean functions - disjunctive and conjugative normal forms. Boolean’s expansion theorem, fundamental forms. Many terminal Networks. UNIT-1V Arbitrary Cartesian product of sets. Equivalence relations, partition of sets, injective, surjective, bijective maps, binary operations, countable, uncountable sets. UNIT-V Basic Concept of Graph Theory, Sub graphs, Trees and their properties, Binary Trees, Spanning ‘Trees, Directed Trees, Planar graphs, Euler Circuit, Hamiltonian Graph. Chromatic number. TEXT BOOKS: Boolean Algebra and its Application, J.E. Whitesitt, Courier Corporation, Concepts of Modem Mathematics, P.L. Bhatnagar. Discrete Mathematics, B.R-Thakur Graph theory and its applications, Narsingh Deo, Dover publication. ‘A TextBook of Discrete Mathematics, Swapan Kumar Sarkar,S.chand, Discrete Maths, C.L.Liu ,T M Hill. oy & Dial BCA - 102 Computer Fundamentals Max Mart Min Marks: 27 NOTE:- The Question Paper setter is advised to prepare unit-wise question with the provision of internal choice. Unit-I Introduction to Computers ‘Computer system: characteristics and capabilities. Computer Hardware and Software: Block Diagram of a Computer, Different Data Processing: Data, Data Processing System, Storing Data, Processing Dota. Types of Computers: Analogue, Digital, Hybrid, General and Special Purpose Computers. Generations of Computers. Computer Systems: Micros, Minis & Main-frames. Limitations of Micro Computer. Number systems- Decimal Number system, Binary number system, Octal & Hexadecimal number system, I's&2's complement Codes- ASCII, EBCDI Codes, Gray code & BCD. Logie Gates - AND, OR, NOT GATES and their Truth tables, NOR, NAND & XOR gates 1 Computer Peripherals: Introduction to Input Devices : Categorizing Input Hardware, Keyboard, Direct Entry ~ Card Readers, Scanning Devices ~ O.M.R., Character Readers, Thumb Scanner, MICR, Smart Cards, Voice Input Devices, Pointing Devices - Mouse, Light Pen, Touch Screen, Computer Output Output Fundamentals, Hardeopy Output Devices, Impact Printers, Non-Impact Printers, Plotters, Computer output Microfilm/Microfiche(COM) systems, Softcopy Output Devices, Cathode Ray Tube, Flat Sereen Technologies, Projectors, Speakers. Unit-III Basic Components and Storage: Central Processing Unit : The Microprocessor, control unit, A.L.U., Registers, Buses, Main Memory, Main Memory (RAM) for microcomputers, Read Only Memory(ROM). Storage Devices : Storage Fundamentals, Primary and Secondary Storage, Data Storage and Retrieval Methods — Sequential, Direct & Indexed Sequential, Tape Storage and Retrieval Methods Tape storage Devices, characteristics and limitations, Direct access Storage and Microcomputers - Hard Disks, Disk Cartridges, Direct Access Storage Devices for large Computer systems, Mass storage systems and Optical Disks, CD ROM. Unit-IV Computer Software and Languages: System Software: System software Vs. Application Software, Types of System Sofiware, Introduction and Types of Operating Systems. Boot Loader, Diagnostic Programs, BIOS, Utility Programs. Application Software: Microcomputer Software, Interacting with the System, Trends in PC software, Types of Application Software, Difference between Program and Packages. Computer Languages: Definition, Generations of computer languages, Types of Languages, Language Processors: Assembler, Interpreter, Compiler, Linker and Loader. Programming constructs, Algorithm & flowchart. Unit-V Introduction to MS DOS and Windows Introduction to DOS: history and versions of DOS. Fundamentals of DOS: Physical Structure of the Disk, Compatibility of drives, Disks & DOS versions, Preparing Disks for use, Device Names. Getting Started with DOS: Booting Process (DOS, Windows, Unix), System Files and ‘Command.com, Internal DOS Files & Directories, Elementary External DOS Commands, Creating a Batch Files, Additional Commands, Microsoft Windows: Operating system-Definition functions, basics of Windows. Basic components of windows, icons, types of icons, taskbar, activating windows, using desktop, ttle bar, running applications, exploring computer, managing files and folders, copying and moving files and folders. Control panel-display properties, adding and removing software and hardware, setting date and time, sereen saver and appearance. Using windows accessories, Overview of LINUX/UNIX. TEXT BOOKS: 1. Introduction to Information Technology, V. Rajaraman, PHI, Second Edition. 2. Computer Fundamentals, P. K. Sinha, BPB Publications, Sixth Edition. 3. Fundamental of Information Technology: Chetan Shrivastava_Kalyani Publishers 4. Computers Today: Suresh K Basandra, Galgotia Publicat L M JW 5 Zu" av ask rd BCA-103 Programming in *C’ Language Max Marks: 80. Min Marks: 27 NOTE :-The Question Paper setter is advised to prepare unit-wise question with the provision of internal choice. UNIT-I Fundamental of © Overview of C : History of C’, Structure of 'C’ program. Keywords, Tokens, Data types, Constants, Literals and Variables, Operators and Expressions : Arithmetic operators, Relational operator, Logical operators, Expressions, Operator : operator precedence and associativity .Type casting, Console 1/0 formatting, Unformatted VO functions: getch(), getchar, getche(), gete(), pute(), putchar(). UNIT- I Control Constructs If-else, conditional operators, switch and break, nested conditional branching statements, loops: do..while, while, for, Nested loops, break and continue, goto and label, exit function. Functions: definition, function components: Function arguments, return value, function call statement, function prototype. Types of function, Scope and lifetime of variable. Call by value and call by reference. Funetion using arrays, function with command line argument, User defined function: maths and character functions, recursive function. UNIT-IIL Array, String Union and Structure Array: Array declaration, One and Two dimensional numeric and character arrays. Multi arrays. String: String declaration, initialization, string manipulation with/without using library function, Strueture, Union and Enum- Structure: basics, declaring structure and structure variable, typedef statement, array of structure, array within structure, Nested structure; passing structure to function, function returning structure. Union: basics, declaring union and union variable, Enum: declaring enum and enum variable. ensional UNIT- IV Pointer Definition of pointer, pointer declaration, using & and * operators. Void pointer, pointer to pointer, Pointer in math expression, pointer arithmetic, pointer comparison, dynamic memory allocation functions ~ malloc, calloc, realloc and free, pointer vs. Array, Array of pointer, pointer to array, pointers to function, function returning pointer, passing function as argument to funetion, pointer to structure, dynamic array of structure through pointer to structure. UNIT-V File Handling and Preprocessor File handling: file pointer, file accessing functions,:fopen, felose, fpute, fete, fprint, fScanf, fread, fwrite,beof, flush, rewind, fseek, feror. File handling through command line argument. Introductio preprocessor: #include, #define, conditional compilation directives: Hf, #else, #eli #endif, #ifhder etc. ‘TEXT BOOKS: 1. Programming in ANSI C, E Balagurusamy, Tata McGraw-Hill, Third Edition, 2. Let Us C, YashwantKanetkar, Infinity Science Press, Eighth Edition. 3. Mastering C, K R Venugopal, Tata McGraw-Hill, 4, The C Programming Language, Brian W. Kernighan, Dennis M. Ritchie, Prentice Hall, Second Edition. 5. Applications Programming in ANSI C, R. Johnsonbaugh , Martin Kalin, Macmillan, Second edition. 6. The Spirit of C, Mullish Cooper, Jaico publishing House. Fe erecta neg arr . ED ae ke AE Ae wr, Sec 214 BCA-104 PC Software and Multimedia Max Marks: 80 Min Marks: 27 NOTE: ‘The Question Paper setter is advised to prepare unit-wise question with the provision of internal choice. Unit-1 MS-Word Introduction to word processing software and it’s features, creating new document, saving documents, opening and printing documents. Home Tab: setting fonts paragraph settings, various styles(normal, no spacing, headingl, heading2, ttle, strong),find & replace, format painter, copy paste and paste special. Insert Tab: Pages, tables, pictures, clipart, shapes, header & footer, word art, equation and symbols. Page Layout Tab: Page setup, page background, paragraph(indent and spacing). Mailing Tab: create envelops and labels, mail merge. Review Tab spelling and grammar check, new comment, Protect document, View Tab: document views, zoom, window(new window, split, switch window). UNIT — II MS-Exeel Introducing Excel, use of excel sheet, creating new sheet, saving, opening, and printing workbook. Home Tab : Font, alignment, number, styles and cells and editing, conditional formatting. Insert Tab: Table, charts(column chart ,pie chart, bar chart, Tine chart) and texts( header & footer, word art, signature line). Page Layout Tab : page setup options, scale to fit(width, height, scale). Formulas Tab : Autosum (sum, average, min, max).logical(IF, and .or not rue, false).math &trig (sin, cos tan, ceiling, floor, fact, mod, log),watch window. Data Tab : get external data from MS Access, sort and filter options .Data validation, group and ungroup. Review Tab: protect sheet, protect workbook, share workbook. View Tab: page breaks, page layout, freezing panes, split and hide. UNIT — II MS-PowerPoint Introducing power point, use of power point presentation, creating new slides saving, opening, and printing. Home Tab: new slide, layout, reset, delete, setting text direction, align text, convert to smart art, drawing options. Insert Tab: Table, picture, clipart, photo album, smart art, shapes and chart, movie and sound, hyperlink and action ,text box , word art, object. Design Tab: page setup options, slide orientation, applying various themes, selecting background style and formatting it. Animations Tab : custom animation for entrance, exit and emphasis, applying slide transition, setting transition speed and sound, animation on rehears timing. slide show view Tab: start slid show options, setup ‘options. view tab : presentation views, colours and window option. UNIT —1V MS-Access Front end and back end of application , introduction to dbms, features of dbms, Creating blank databases, saving it in acedb format. defining data types in ms access. Home Tab: datasheet view, design vew, pivot chart view, pivot table view, sort and filter options. Create Tab : creating tables, creating reports, query wizard. External Data Tab : importing data from access and excel sheet.exporting data to excel and ms word. Datasheet Tab: Relationships, fields and columns options, datatype and formatting options, UNIT — V Animations and Graphies Definition of multimedia, application of Multimedia, Basie Concept of 2D/3D Animation, Principle of animation, Hardware and software resources requirement for animation, introduction of various file formats (.mpeg, gif, jpeg. mp4, .if, flv ). Creating a new movie in flash :Get set Up, Input Text, ‘Animate Text, drawing and painting with tools, brush,create basic shapes like Oval, Rectangle& Polystar Tools, tools working with object & filing the object, Transformation, object properties dialog box, creating layers motion tweeing, shape tweeing , mask layers, basic action scripts, importing sound through Flash. ‘TEXT BOOKS: Microsoft Office 2007 fundamentals, L Story, D Walls. MS Office, S. S. Shrivastava, Firewall Media. Office 2000 made easy ,Alan Neibauer, Tata McGraw Hill FLASHMX Bible -Robert Reinhart Sams Teach Yourself Macromedia Flash 8 in 24 Hours,Phillip Kerman, How to do everything with Macromedia , Bonnie Blake, Doug Sahlin media Making it works ,Fay Vaughan, Tata McGraw Hills. kc : y ty BX ns / a o\ BCA — 105 Web Technology and E-Commerce Max Marks: 80, Min Marks: 27 NOTE :- The Question Paper setter is advised to prepare unit-wise question with the provision of internal choice. UNIT-I. Basics of Internet History, Evolution, Internet applications, Intranet, WWW, Emergence of Web, Web page, Web Site, client, Web Servers, Web Browser, Web concept, Search Engine, URL, DNS, Internet Connection, Internet Service Provider, Web Design Strategies, OSI and TCP/IP model, various protocols like HTTP, FTP, SMTP, TELNET. Internet services: Email concept, Sending and receiving secure Email, Voice and video Conferencing, web Based chat services, Chat Services, Internet Messaging, Internet Relay Chat, News Group. UNIT-II HTML, Introduction, Html version, HTML tags, Creating headings on a web pages :Aligning the headings, creating list, Working with Links: Creating a Hyperlinks ,Setting the Hyperlink Colors, Linking Different sections of A web page, Creating Paragraph, Working with Images, using Images as Links, Working with Tables, Working with Frames: Creating a Frame, Creating Vertical and Horizontal Frames, Setting the Frame Border Thickness, Applying Hyperlink Targets to a Frame, Creating an HTML Form, Specifying the Action URL and Method to Send the Form, Using the HTML Controls. UNIT-III DHTML and Java Seript DHTML: Introduction, Cascading style sheet (CSS), Inline Style sheet, External Style Sheet, Internal Style Sheets, DHTML document object model, Event handling. Java Script: Introduction, Language elements, Variables, operators, control statement Array and function in JavaScript, Objects of Java script, Client-Side and server side Java script, Benefits of using JavaScript, Embedding JavaScript into HTML Page, Handling Events, overview of VB Script. UNIT-IV Introduction to PHP Features, Advantages of PHP over other scripting languages, Installing, creating and running PHP script, working with variable, constant, operators in PHP, Control statements, Looping constructs, String function, Arrays, User defined “function, Working with forms, Accessing database through PHP. UNIT-V Introduction to E Commerce Definition of E-commerce, The scope of E-commerce, Definition, Internet and its impact on traditional businesses, E-payment System, Security threats with E-commerce. Types of E- commerce: Business-to-Business (B2B), Business-to-Consumer (B2C), Business-to- Business-to-Consumer (B2B2C), Consumer-to-Consumer (C2C), E-market, Future of E- market. TEXT BOOKS: 1, Web Technology, A developer’s Perspective, N.P Gopalan and J. Akilandeswari, PHI publication. 2. Web Technologies: HTML, JAVASCRIPT, PHP, JAVA, JSP, ASP.NET, XML and Ajax, Black Book by Dream Tech Press 3. Internet : The Complete Reference Millennium Edition Margaret Levine Young, Doug Muder. 4. The Complete Reference: HTML and CSS, Thomas A. Powell ,MeGrawHill. 5. JavaScript The Complete Reference, Thomas Powell, Fritz Schenider, McGrawHill, Third Edition 6. Introduction To HTML,Kamlesh N.Agrawal ,O.p,Vyas ,P.A.Agrawal. 7. Web Technology and Design, Xavier.C.New Age Intemational. 8. HTML, DHTML JavaScript,Per! and CGI, Ivan Bayros.BPB Publication. 9. Internet and Web Design, Ramesh Bangia New Age International 10, Business on the net, Kamlesh N. Agarawala, Amit Lal & Deeksha Agarawal, Macmillan India Ltd. : ¥ = Wary a AGO NAR Yow Sa Boe Ae ps BCA -106 Communication Skills Max Marks: 80 Min Marks: 27 NOTE : - The Question Paper setter is advised to prepare unit-wise question with the provision of internal choice. OBJECTIVE This course is designed to enable the students of computer education to speak and write English with a fare degree of grammatical correctness. The inputs in the course contents are designed to let the students develop their communication skills and effectively write and speak in business scenario. UNIT- ‘Structure of sentences- Simple, Complex and Compound. Clauses: Co-ordinate and Subordinate Clause, ‘The tenses and aspects. Modal, Gerund, Participle: Non Finite and Fi Infinitive, UNIT~1 ‘Transformation of sentences:- 1, Interchange of Active and Passive Voice. Interchange of Affirmative and Negative Sentences. Interchange of Explanative and Assertive Sentences. Interchange of interrogative and Assertive Sentences. Direct and Indirect Speech. UNIT - 1 Report writing Applications w Letter writings: Formal (Enquiry letter, Order letter, Complaint letter Sales Letter) and Informal, Description of events, UNIT- IV Precis Writing Reading Comprehension Summarising Paraphrasing Presentation Skills UNIT-V Official Communication- Notice, Circular, Minutes of meeting , Agenda of meeting, Memorandum Moder media of communication- Email(Language of Emails, Format, E-mail writing Strategies, Advantage, Characteristies, Formating) Video conferencing, Fax TEXT BOOK: 1. Living English Structure by W-S. Allen. 2. A Practical English Grammar by Thomson and Martinet. 3. English Grammar and Composition by Wren & Martin 4. Advance Grammar in Use by Martin Hewings 5. 6. Essentials of Business Communication by Rajendra Pal and J.S. Korlahalli Effective Technical Communiegfion by M Ashraf Rizvi Bridge course for BCA (Only For Non mathematics Students) Max Marks: 50 Min Marks: 17 Note : Fundamentals of the topics are to be dealt to enable the students to understand the topics. The Question Paper setter is advised to prepare unit-wise question with the provision of internal choice.. Only Simple calculator is allowed not scientific. UNIT -I Algebra Partial fractions, Arithmetic Progression & Geometric Progression. Determinants and matrices, Inverse matrix. UNIT-II Permutation combination, method of induction, Binomial Theorem for positive integral index, ‘And any index (without proof), Exponential and logarithmic series. UNIT-IIL ‘Trigonometry Measurement of angles, Trigonometric ratios, simple formula, compound angles, Trigonometric ratios of multiple and sub multiple angles. Height and Distance, Inverse Function. UNIT-IV Geometry Locus, Cartesian coordinate system, Distance formula, Section formula, Slope ofa straight line various forms, Angle between two lines, pair of straight lines, parabole, ellipse and hyperbola. UNIT-V Statistics Frequency Distribution, Measures of central tendency, Mean. Median, Mode, G.M., H.M., Inter quartile range, Mean deviation, Standard deviation, ‘TEXT BOOKS: Mathematic (class XI and XI), R.D SHARMA YOUGBODH Mathematics, (class XI and XII) BCA-107 - LAB I: Programming Lab in ‘C” 1 Scheme of Examination: Practical examination will be two programs and a project demonstration. It will be of 3 hours duration. All programs should be with flowchart & algorithms. The distribution of practical marks will be as follows Program 1 - 20 Program 2 - 20 Program 3 - 20 Viva - 28 [Practical Copy + Internal Record] ~ 15 Total - 100 2. Practical file should contain printed programs with name of author, date, path of program, unit no, and printed output. 3. Inevery program there should be comment for each coded line or block of code 4 All the following programs or a similar type of programs should be prepared List of Practical INPUT AND OUTPUT, FORMATTING 1. Write a program in which you declare variable of all data types supported by C language Get input from user and print the value of each variable with alignment left, right and column width 10. For real numbers print their values with two digits right to the decimal Loops, DECISIONS 2. Write program to print all combination of 1 23 3. Write program to generate following pattern a)ABCDEFG co) * ABC EFG m © AB FG ore A G b)1 4) 1 12 121 123 1331 1234 14641 4. Write main function using switch...case, if..else and loops which when called asks pattern type; if user enters 11 then first pattem is generated using for loop. If user enters 12 then first pattern is generated using while loop. If user enters 13 then first pattern is generated using do-while loop. If user enters 21 then a second pattern is generated using for loop and so on. 5. Write program to display number I to 10 in octal, decimal and en aga AGA he eae Vy LR ity Vea 6. Write program to display number from one number system to another number system The program must ask for the number system in which you will input integer value then the program must ask the number system in which you will want output of the input number after that you have to input the number in specified number system and program will give the output according to number system for output you mentioned 7. Write a program to perform following tasks using switch...case, loops, and conditional operator (as and when necessary) a) Find factorial of a number ») Print fibonacci series up to n terms and its sum, ©) Print sin series up to n terms and its sum 4) Print exponential series up to n terms and its sum. 6) Print prime numbers up n terms. 4) Print whether a given year is leap or not. 8. Write program no. 6 but use library function to perform above tasks. ARRAY 9. Create a single program to perform following tasks using switch, if else, loop and single dimension character array without using library function: a) To reverse the string b) To count the number of characters in string. c) To copy the one string to other string, 4) To find whether a given string is palindrome or not. ) To count no. of vowels, consonants in each word of a sentence and no. of punctuation in sentence 4) To arrange the alphabets of a string in ascending order. 10. Create a single program to perform following tasks using switch, if else, loop and single dimension integer array a) Sort the elements. ¢) Search for presence of particular value in array clement using linear search. 4) Search for presence of particular value in array clement using binary search. 11, Write a program that read the afternoon day temperature for each day of the month and then report the month average temperature as well as the days on which hottest and coolest days occurred 12. Create a single program to perform following tasks using switch, if..else, loop and double dimension integer array of size 3x3: a) Addition of two matrix. ‘b) Subtraction of two matrix. ) Multiplication of two matrix. d) Inverse of matrix. ¢) Transpose of matrix f) Sum of diagonal elements 13, Create a single program to perform following tasks using switch, if else, loop and double dimension character array of size 5x40 a) Sorting of string, b) Finding the largest string ) Finding the smallest string. ¢) Searching for presence of a string in_array. FUNCTIONS 14. Write program using the function power (a, b) to calculate the value of a raised to b. 15. Write program to demonstrate difference between static and auto variable 16. Write program to demonstrate difference between local and global variable. 17. Write a program to perform following tasks using switch. ..case, loops and function a) Find factorial of a number b) Print Fibonacci series up to n terms and its sum. ©) Print Sin series up to n terms and its sum, 4) Print exponential series up to n terms and its sum. 18. Write a program to perform following tasks using switch...case, loops and recursive function, a) Find factorial of a number b) Print Fibonacci series up ton terms and its sum. ‘c) Print Sin series up to n terms and its sum. d) Print exponential series up to n terms and its sum, ) Print natural scries up ton terms and its sum 19. Write a function to accept 10 characters and display whether each input character is digit, uppercase letter or lower case letter Array & Function 20. Create a single program to perform following tasks using switch, if-else, loop, function and double dimension integer array of size 3x3: a) Addition of two matrix. +b) Subtraction of two matrix. c) Multiplication of two matrix. d) Inverse of matrix. ) Transpose of matrix. 21. Create a single program to perform following tasks using switch, if.else, loop, user defined function and single dimension character array: a) To reverse the string. b) To count the number of characters in string. ©) To copy the one string to other string 4) To find whether a given string is palindrome or not. ©) To count no. of vowels, consonant in each word of a sentence and no, of punctuations in sentence, 22. Create a single program to perform following tasks using switch, if..else, loop, function and single dimension integer array: a) Sort the elements. b) Find largest element and smallest element. ¢) Search for presence of particular value in array element using linear search. 4) Search for presence of particular value in array clement using binary search 23. Create a single program to perform following tasks using switch, if-else, loop, function and double dimension character array of size 5x40: a) Sorting of string ») Finding the largest string, lexicographically. ©) Finding the smallest string, lexicographically. ) Searching for presence of string in array. Te ay STRUCTURE & UNION be wean wer? Dt EES hoy 24, Create a structure Student having data members to store roll number, name of student, name of three subjects, max marks, min marks, obtained marks. Declare a structure variable of student. Provide facilities to input data in data members and display result of student. 25. Create a structure Date with data member's dd, mm, yy (to store date). Create another structure Employee with data members to hold name of employee, employee id and date of joining (date of joining will be hold by variable of structure Date which appears as data member in Employee Structure), Store data of an employee and print the same. 26. Create a structure Student having data members to store roll number, name of student, name of three subjects, max marks, min marks, obtained marks. Declare array of structure to hold data of 3 students, Provide facilities to display result of all students. Provide facility to display result of specific student whose roll number is given 27. Write program to create structure complex having data members to store real and imaginary part. Provide following facilities a) Add two complex nos. using structure variables. b) Subtract two complex nos. using structure variables. ©) Multiply two complex nos, using structure variables. 4) Divide two complex nos. structure variables. ‘Use structure as argument to fiznction and function returning structure. POINTER 28, Define union Emp having data members:-one integer, one float and one single dimension character array. Declare a union variable in main and test the union variable. 29. Define an enum Days_of Week members of which will be days of week. Declare an enum variable in main and test it 30. Write a program of swapping two numbers and demonstrates call by value and call by reference 31. Write program to sort strings using pointer exchange. 32. Write a program in ¢ using pointer and function to receive a string and a character as argument and return the no, of occurrences of this character in the string, 33. Create a program having pointer to void to store address of integer variable then print value of integer variable using pointer to void. Perform the same operation for float variable. 34. Write program to find biggest number among three numbers using pointer and function. 35. Write program to Create a structure Employee having data members to store name of employee, employee id, salary. Use Pointer to structure to store data of employee and print the stored data-using pointer to structure. 36. Write program to Create a structure Employee having data members to store name of employee, employee id, salary. Use Pointer to structure to simulate dynamic array of structure store data of n employees and print the stored data of n employees using pointer to structure. 37. Write a program to sort a single dimension array of integers of n elements simulated by pointer to integer. Use function for sorting, the dynamic array. 38. Write a program to sum elements of a double dimension array of integers of m rows and n columns simulated by pointer to pointer to integer. Use function for sum the elements of the dynamic array 39. Write program to demonstrate difference between character array and pointer to character. 40. Write program to demonstrate difference between constant pointer and pointer to constant 41. Write program to demonstrate pointer arithmetic. 42. write program to demonstrate function-returning pointer. 43. Write program using self-referential pointer to structure to create and print the linked list, data structure eat & ere Ee ? pe BCA-108 - LAB II: PC Software Lab 1. Scheme of Examination: - Practical examination will be of 3 hours duration. The distribution of practical marks is as follows: Program 1 (MS-Office) - 15 Program 2 (MS-Office) - 1s Program 3. (MS-Office) : 15 Program 4 (Multimedia) - 15 Viva-Voice - 2s [Practical Copy + Internal Record] ~ 15 Total - 100 2 In every program there should be comment for each coded line or block of code. 3 Practical file should contain printed programs with name of author, date, path of program, unit no. and printed output 4 All the following programs or a similar type of programs should be prepared List of Practical MS- WORD File New, Open, Save, Cut, Copy, Paste, Drag Drop, Bullets and Numbering, Undo, Redo, Find, Replace, Paragraph Formatting, Character Formatting and Page Formatting. 1. Open a document. Type the following text and perform the tasks as instructed below:~ Working with Word Processor ‘As already mentioned, a word processor is a package that processes textual matter and creates organized and flawless documents. In addition to it a word processor not only remote all the limitations of typewriter but also offers various useful features that cannot be even dreamt of with typewriter. Also if same textual matter is to be reproduced with minor changes, retyping the only option in typewriters The word processing (and word processor) originated way back in 1964 when special typewriters. Magnetic Tape Selectric typewriters (MIST) were launched by IBM (International Business Machines), (i) Insert the following text after the first paragraph The main components of a word processing system are listed below: a. Computer b. Printer c. A word processing software (ii) Save the document as Word1.doc (iii) Move the second paragraph to the end of the document. Using darg & drop. (iv) Move the second paragraph in the end of the document using cut, paste operations @) (vi) Now use Redo actions (vii) Go to the End of the document ( in one step) (viii) Go to the Beginning of document (in one step) (ix) Insert page break before the third paragraph. (x) Search the word “computer: in your document with options Match case, find whole words only. (xi) Replace the word “typewriters” with “word processor” (xii) Undo the above action (xiii) Remove All page breaks from your document (xiv) Change the magnification of your document to different percentages using zoom features. (xv) Format the above written paragraphs and give the options as follows: © Alignment justified © Indentation: left 0.2 right:0.2 © Spacing: before 6 pt. after:6 pt. ‘© Special: first line by :0.4” © Line spacing 1.5 lines, (xvi) Set the default tab stop to 0.3” (xvii) Set the margins to 1.25 (xviii) Format the page using a. Left margin:0.5, right margin: 0.5 b. Top margin:1.5, bottom margin:0.5 . Gutter Margin: lindentation: left 0.2 right:0.2 d. Header Margin:0.5 (xix) Format the each occurrence of group of words ‘Word Processor’ as bold, italic, under line and small caps using find and replace with formatting options. «Align the heading to Center and make it bold, underlined and italicized. File New, Open, Save, Find, Replace, Paragraph Formatting, Character Formatting and Page Formatting. 2. Type the text as show below and perform the tasks as directed: Computers COMPUTER is an electronic device that processes data and gives meaningful information. Computers are being used in almost all the fields today EXPERT SYSTEMS HUMAN THINKING AND ARTIFICAL INTELLIGENCE Can computer think? Al at work Today: Natural Language programs and Expert Systems ‘THE IMPACT OF COMPUTERS ON PEOPLE The Positive Impact The Potential Dangers ‘THE IMPACT OF COMPUTERS ON ORGANIZATIONS The information Processing Industry The Positive impact on Using Organizations The Potential Dangers for Using Organizations 1, Search for the word ‘Computer’ in the entire document. All the occurrences of the given word are to be searched irrespective of the case ) stn aan SHIA Hew Ley x peo . 2, In the above question note that word also searches ‘computerization and ‘computerisations’. Now make sure that this time Word searches only for the word ‘computer’ in the entire document. 3. Change the entire uppercase letter to lowercase. 4 Give a heading to the above written text ‘COMPUTERS IN TODAY’S WORLD’ 5. Centre aligns the Heading text Computer that appears in first line 6. Apply outside border to entire document 7. Apply outside border to the just heading text 8. Change page setup according to the following specifications Top margin: 1.5”, bottom margin: 1.5” Gutter: 1”, left margin: 1.5” Right margin: 1” Page width: 7.5”, page height: 6.5 Orientation: portrait 9. Give a header ‘Creations’ and footer “The school of computing’. The footer should also consist of page no's, 10, Give appropriate commands for giving different header and footers for first page and odd & even pages 11, Save and close the document. 3. Write the following equations in MS-Word: 4H;PO;=3H3PO.+PH;, — PCLs#CL=PCLs, (xt y)=x"+y7+2xy_ 4, Write the following equations in MS-Word. (CH,OH+PCL.-C:H.CL+POCL;+HCL, a+b#0 5. Write the following in MS-Word: 1. Preheat the oven to 220°C. 2. Copyright = © 3. Registered ® 4, Trademark = ™ 6. Create the following table in MS-Word Name Rahul Roll No. 101 Subject Max Min Obtain Java 100 33 75 [Multimedia 100 33 70 7. Create a document in MS-Word. Set the watermark as Microsoft. Also write the following text as formatted below. ceasuring programming progress by lines of code is like measuring aircraft building progress by weight. —Bill Gates 8, Create the following, 9. Create the following: 10. Create the following table in MS-Word: Admission 2011-2012 Course a OB ‘MBC | SC/ST Total ‘Computer Science 9 18 3 3 37 Commerce 14 25 6 5 50 Mathematics 12 20 4 4 40 11. Create Table as shown Car Price ‘Maruti__[ Omni Van 200000 ‘Maruti 800 242000 Tata___| Sumo 390000 Sierra 447000 12. Insert the following in MS-Word. PC Software 13. Insert the following in MS-Word. 14, Write the following in MS-Word, > This is sentencecase. > this is lowercase. > THIS IS UPPERCASE. > This Is Capitalise Each Word. > tHIS IS tOGGLE cASE, 15. Create the following list in MS-Word: 1. Actors 1. Bruce Willis, 2. Gerard Butler 3. Vin Diesel 2. Actress 1. Julia Roberts, 2. Angelina Jolie 3. Kate Winslet 4. Cameron Diaz 16, Write the following in MS-Word: 1. Cricket Players 3. Batsman 1. Sachin Tendulkar 2. Rahul Dravid 3. Virendra Sehwag 4. Bowler a. Kumble b. Zaheer Khan c. Balaji 5. Spinner a) Harbhajan Raph iy C0 erry on fine b) Kumble 9) Kartik 17. Write a letter to send invitation to your friend inviting on your birthday. 18. Create labels for your friends’ address. MS - EXCEL 1. Create the following worksheet and save the worksheet as wages.xls PACE COMPUTERS (ATC CEDT), Govt. of India Payroll for Employee (Temporary) Today's Pay Rat Worker's Name Hired On days Worked | Gross Wages Kushagra 3-Mar-07 Pradeep 4-Mar-07, Puneet S-Mar-07 Rajeev 6-Mar-07 () Calculate days work and gross wages 2. Create the following worksheet and save the worksheet as wages xls [Name Basic [HRA | DA’ | Total Salary | Bonus | Total | % (Increase) (monthly) of basic) | (Rs.) (1997) (Rs) Salary (Rs) (1998) ‘Shirome5000 10] 430 1200 Somya9000 15 | 800 200 Fanya7000 2] 900 1800 ‘+ Calculate the total salary as sum of Basic salary, HRA ,DA, for each employee for 1997 ‘© Calculate total salary for year 1998 as sum of salary of 1997 and bonus * Calculate % increase in salary from 1997 to 1998 3. Create a worksheet as follows Pace computer (ATC CEDT ) Govt. Of India Payroll for employee (Permanent) Empeode name | doj salary | bonus | net salary E001 ‘Meena | 3-Mar-95 3000 E002 Manoj 4-Mar-06 4000 E003 Preeti 3-Mar-95 4800 E004 Sumita | 6-Mar-07 7300 i. allow bonus 8000 to employee having service >2 year other vise allow bonus 3000 ii, find net salary as sum of bonus and salary 4, create the worksheet as follows Roll No__| Name" English] Average] Division 7 101 Kushagra 95 102 Ajay 92. 103 Vilay 70 Class Average i, find Total of two subject for each student ji, find average of two subject for each student iii, find class as average of average column iv. find division of student as first, second, third, assume percentage of division of your own and maximum marks in each student as 100 v. Apply conditional formatting for division column, first division should be in bold, second division should be in italic and third division should be underline 0 ye feast go Qieey BE go ob 1. Create macro in excel to make selected cell, bold, italic outside bordered and center across select 2. create bar chart with given data 2001 2002 2003 Tea 19 2B 25 Coffee 22 24 2 Sugar 43 40 43 (D) Provide heading production detail (U1) Provide z axis title; lacks metric tone a Provide x axis title year 3. Create a table with column heading as shown below and using form perform data entry of records. Zone Department Employee Salary West Marketing Mukesh 10500 East Sales Rahul 20000 South Marketing ‘Suresh 5500 North Marketing Anju 23000 South Sales Neeraj 8000 North Sales Ajay 8000 South Marketing Mahesh 7500 West Sales Rajesh 4300 i. Sort the data according to Zone then by Department ii, Use group and outline feature to show & hide details 8. Create a table with column heading as shown below and using form perform data entry of records. Zone Department Employee Salary West Marketing Mukesh 10500 East Sales Rahul 20000 South Marketing Suresh 5500 North Marketing Anju 25000 South Sales ‘Neeraj 8000 North, Sales Ajay 8000 South, Marketing Mahesh 7500 West Sales Rajesh 4500 (D). Use filter command to show records having zone: West (11) Use filter command to show records having zone: West and salary less than 5000 (mm Use filter command to show records having salary greater than 10000 9, Create pivot table using Data of exercise 8 1. Suppose a database exists in ms-access you are required to import the data. How will you? 11. Create a able using feature Principle 1500 Rate % Time 3 300 [3 4 3 1% | 45 0 B 2% | 90 120 150 3% | 135 180 | 225 12, Using goal seek feature find out the interest rate it must be to eam interest 500 Priniple 1500 A im Rate 4% Vy \9 AD bue— Za a" pay Time 5 Interest 300 MS-Access QL. Create the following table in MS-Access Field Name Data Type _| Description ContaetiD AutoNumber | Primary Key ContactT ype Text 50 Type of contact (Wholesale, dealer, other) Name Text 50 Contact's first name ‘Company Text 50 The Contact’s employer ‘Address Text 50 Contact's address City Text 50 Contact's city State Text 50 Contact's state ZipCode Text 50 Contact's zip code Phone Text 50 Contact's phone Fax Text 50 Contact's fax E-Mail Text 100 | Contacts e-mail address WebSite Text 100 | Contact's Web address TastSalesDate Date/Time | The most recent date the contact purchased something, DiscouniPercent | Number __| The customary discount provided to the customer ‘Notes: Memo ‘Notes and observations regarding this customer Active Yes/No Whether the customer is still buying or selling products Q.2. Create the following tables in MS-Access with the refential integrity-foreign key’ 1, tblProducts Primary Key - ProductID ProductID |Description | Category | Quantity | Cost] RetailPric | Produc | SalePric | Taxable e tNumb | e er 2. tbiSalesLineltems Primary Key - SalesLineltemID SalesLineltemiD | InvoiceNumber | ProductID | ProductNumber | Quantity | Description | Price | Disco. 3. thiSales Primary Key — InvoiceNumber InvoiceNumber | SaleDate | InvoiceDate | Buyer | PaymentMethod | TaxLocation | TaxRate MS PowerPoint Q 1 Create a PPT of Atleast 10 Slides with one slide for comparison, one slide displaying a chart with the table Q2 Create a PPT presentation use rehearse timing for the slide show Q3 Create PPT presentation slide import sound and video clips Q4 Create PPT presentation with hyperlinking, Q5 Create PPT presentation and ay themes and transitions. , + Ae Me 19 Wwapaees ZEEE FLASH LIST OF PRACTICALS ‘QI. Draw the following shapes neatly in Flash and convert them in symbols. Also apply different transformations like scale, rotate, skew, skip ete. 1, Fish 2, Palm Tree 3._ Swan - 4, Teddy Bear 5. Tree 6._ Santa Claus 7._ House 8. Car 9._ Ballon 10. Boat | Q.2. Create a Flash movie to draw the symbol of an animal and apply motion between. Q3. Create a Flash movie to create a minimum of five layers (Water, fish, bubbles, plants etc) of an aquarium and apply motion between. Q4. Create a Flash movie to create mask QS. Create a Flash movie to create Fade In/Fade Out in four pictures. Q6. Create a Flash movie to create the symbol of a wheel and scale and rotate it Q7. Create a flash movie to create growing circles. Q8. Create hand writing in Flash. Q9. Create a Flash movie of a moving car with rotating wheels. Q.10, Transform a circle into a square using shape tween. QI11. Create a Flash movie to import text from MS-Word and apply different transformations. Q.12. Create a Flash movie to demonstrate onion skin markers Q.13. Create a Flash movie to create ripple effect. Q.14. Create a Flash movie to demonstrate motion guide. Q.15. Create a Flash movie of a sheep climbing a mountain using layers, Tehe scenery should contain mountain, river, trees, clouds, birds, sheep etc. PHOTOSHOP LIST OF PRACTICALS QL. Import an image in Photoshop and change its background using marquee and lasso tools. Q.2. Import an image in Photoshop and copy it using heal brush tool Q.3. Import an image in Photoshop and desaturate it and recolor it. Q44. Use layers and filters to design an image in Photoshop. Use the flatten image as well. Q55. Import an image in Photoshop and desaturate it and reveal selective portions. CORAL DRAW LIST OF PRACTICALS, Q.2. Use artistic media brush tool to-create different backgrounds. 4 ye So ect Sao sqate ae =) ot a ey: Bi Q.4. Draw different objects and fill them with different patterns. Q.5. Draw different objects and fill them with different textures. age AH Chow Bezry Aven ‘Making a simple Video file (not using video file) with suitable sound file using Windows Movie Maker Edit Video file, like - changing sound and adding starting and ending banner with ttle using Windows Movie Maker. Create a WAV file with the help of Windows sound recorder application. With the help of Adobe Image Ready create attractive .GIF image. Create & save MP4 files using appropriate software. Create & save MP3 files using appropriate software. Insert sound clips in webpage using Front Page application Software, oS ay, z BCA-109 - LAB III: Web Technology Lab 1. Scheme of Examination:~ Practical examination will be of 3 hours duration. The distribution of practical marks will be as follows Program 1 - 20 Program 2 : 20 Program 3 : 20 Viva : 25 [Practical Copy + Intemal Record] - 15 Total : 100 2. In every program there should be comment for each coded line or block of code 3. Practical file should contain printed programs with name of author, date, path of program, unit no. and printed output 4, All the following programs or a similar type of programs should be prepared Q.1. Write an HTML program to create the following table: Class Subjectt_| Subject? Subject3 BCAI | Visual Basic | PC Software | Electronics BCA TI CH DBMS English BCA I Tava Multimedia CSA Q2. Write an HTML program to create the following lists: oc (i C+ (a) Fortran ayy COBOL Q3. Write an HTML program to create the following lists: 1. Java 2. Visual Basie 3. BASIC 4. COBOL Q4. Write an HTML program to demonstrate hyperlinking between two web pages. Create a marquee and also insert an image in the page Q.5. Write an HTML program to create frames in HTML with 3 columns (Width = 30%, 30% , 40%). Q6. Write an HTML program to create a web page with a blue background and the following ‘text: ele NER Pi Ze Bee “A New Delhi New Delhi, the capital and the third largest city of India is a fusion of the ancient and the modern. The refrains of the Muslim dynasties with its architectural delights, give the majestic ambience of the bygone era. Q7. Write an HTML program to create the following table: Admission Course OC [BC [MBC [SC/ST | TOTAL Computer science a iw | 5 3 | 37 Commerce wp | 6 3) 30 Grand total - La Q8. Write an HTML program to create the following table: Maruti | Tata Ford Model | Price Model Price ‘Model Price Maruti 800 | 2 Lac ‘Sumo 2Lac Tkon SLac Omni 3 Lac ‘Scorpio 3Lac Gen 2Lac Q.9. Write an HTML program to create the following table: ‘Students Records Name Subject Marks ‘Arun Java 70 Cc 80 Ashish Java 5 Cc 69 Q.10. Create an HTML document and embed a flash movie in it. QL. Write the HTML coding to display the following table, Also insert an image in the web page Subject Max | Min | Obtain Java 100 [33 75 Multimedia 100/33 70 Operating System 100, [33 68. CH 100 33 B Q.12. Write the HTML coding to display the following table:_ Name Rahul Roll No. Subject Max Mi Obtain Tava 100 ‘(33 75 Multimedia 100 33 70 Q.13, Write an HTML program to create a form asthe following Enter Name Enter Roll No.: Enter Age: Qtr sm o ae 7 Shiv aco URIN a TAN Wr Enter DOB. Q.14. Write an HTML program to create a web page with an image as background and the following text: New Delhi ‘New Delhi, the capital and the third largest city of India is a fusion of the ancient and the moder. The refrains of the Muslim dynasties with its architectural delights, give the majestic ambience of the bygone era On the other side New Delhi, the imperial city built by British, reflect the fast paced present. The most fascinating of all is the character of Delhi which varies from the 13 present century mausoleum of the Lodi kings to ultra modern glass skyscrapers, Q.15, Create the following HTML form. USERNAME > PASSWORD = When user types characters in a password field, the browser displays asterisks or bullets instead of characters. Q.16, Create the following HTML form, FIRSTNAME LASTNAME | GENDER: Male ( Female © SUBJECTS: ‘Meitinedia ‘Operating Systern CSA Q.17. Create the following HTML form. Enter your name Enter your roline Subjects Clava ac (2 Visual Basic moe Class: SCAT SCAN BCA Q.18. Write the HTML coding for the following equations: (C:H.OH+PCLs=C3HsCL+POCL+HCL 4HsPO;=3HsPO,+PHs PCL3+CL:=PCLs Q.19. Write the HTML code to display the following: 1. Actors 1. Bruce Willis 2. Gerard Butler 3. Vin Diesel 4. Bradd Pitt 2. Actress 1, Julia Roberts 2, Angelina Jolie 3. Kate Winslet 4. Cameron Diaz Q.20. Write the HTML code to display the following: 1. Cricket Players 1. Batsman 1, Sachin Tendulkar 2. Rahul Dravid 3. Virendra Sehwag 4. Kumble ©. Zaheer Khan f Balaji 3. Spinner 4) Harbhajan ©) Kumble f) Kartik Note: At least 5 programs of CSS and Java Script to be done separately. ) = Qa 2 x 2 SCHEME OF EXAMINATION 2019-2020 BCA PART-II Theory Marks | Internal Teaching Load Subject Subject Paper Marks per Week Code Lot P Max. Min. | Max. Min. (A) «B) | © (D) BCA201_| Calculus and Differential Equations so | 27 | 2 | 8 |4)2]~- BCA202 | Database Management System 80 27 20 8 4 2 - BCA203 | Programming in 'C++" 80 27 20 8 4 2 - | ++ BCA204_| Computer Networks so | 2 | 2 | 8 |4j2]- BCA205 | Operating Systems with Linux 80 27 20 8 f|4]2]- BCA206_| Foundation Course 80 27 20 8 4 2 - BCA207_| LAB IV: Programming Lab in “C++” too | so | 40 | ie | - | - | 3x2 BCA208 | LAB V: Database Management 100 50 40 16 - - 2x2 System Lab. BCA209_| LAB VI: Operating System Lab too | 30 | 20 | & |-| - [i TOTAL 780 | 312 | 220 | 88 GRAND (PAPER + INTERNAL) (Are) (BD) TOTAL 1000 400 © Student will have to pass individually in all theory, practical and sessional. ERO ean ee he BiKa8 bs Calculus and Differential Equations Subject Code - BCA-201 ‘Max Marks : 80 Min Marks : 27 Note : The Question Paper setter is advised to prepare unit-wise question with the provision of internal choice. Only Simple calculators allowed not scientific calculator. Differentiation UNIT-1 Limits -Definition of limits, Continuity of one variable, Types of continuity, Properties of continuous function: Borel’s Theorem, Boundedness Theorem, Mostest Theorem, Intermediate value theorem, Differentiability of function(s) of one variable UNIT -IL Differentiation of Functions, Differentiation of functions of functions, parametric functions, product of functions, function in Product and quotient form, Logarithmic differentiation, Differentiation of Parametric functions. Higher order derivative, Maxima and Minima Integration UNIT - IIT Indefinite Integral- Basic integration Formulas, Trigonometrie Integrals, Integration by Parts, Integration by substitution UNIT-IV Definite Integrals- Introduction, Properties of definite integrals, Problem based on properties of definite integrals Differential Equation UNIT -V Introduction to differential equation: Definition, order and degree of differential equation, derivation of a differential equation, general and particular solution of differential equation, separation of variables. TEXTBOOK: 1, Calculus and Statistical Analysis: H.K. Pathak 2. Calculus : BR. Thakur 3. Differential Equation: HK Pathak REFERENC! Differential Calculus : Gorakh Prasad Differentiation & Integration : H.K Pathak 1 2. 3. Integral Calculus: Gorakh Prasad 4. Differential Equation : Gorakh Prasad 5. Caleulus: Rey & Sharma we Aw ee denn CR AGE ella be 7 BEN <3\\ 7 a Database Management System Subject Code - BCA-202 Max Marks : 80 Min Marks : 27 Note : The Question Paper setter is advised to prepare unit-wise question with the provision of internal choice. Only Simple calculators allowed not scientific calculator. UNIT - I: Overview of Database Management Data, Information and knowledge, Increasing use of data as a corporate resource, data processing verses data management, file oriented approach verses database oriented approach to data ‘management; data independence, database administration roles, DBMS architecture, different kinds of DBMS users, importance of data dictionary, contents of data dictionary, types of database languages. Data models: network, hierarchical, relational. UNIT - II; Relational Model & Relational Algebra Entity-Relationship model as a tool for conceptual design-entities, attributes and relationships. ER diagrams; Concept of keys; Case studies of ER modeling Generalization; specialization and aggregation. Converting an ER model into relational schema. Extended ER features, Introduction to UML, Representation in UML diagram (Class Diagram etc.) UNIT - II: Relational Database Design Relational Algebra: select, project, cross product different types of joins (inner join, outer joins, self-join); set operations, Tuple relational calculus, Domain relational calculus, Simple and complex queries using relational algebra, stand alone and embedded query languages. UNIT - IV: Structured Query Language (SQL) ‘Normalization concept in logical model; Pitfalls in database design, update anomalies: Functional dependencies, Join dependencies, Normal forms (INF, 2NF, 3NF). Boyce Codd Normal form, Decomposition, Multi-Valued Dependencies, 4NF, SNF. De-normalization. UNIT - V: Query Processing and Security Introduction to SQL constructs (SELECT...FROM, WHERE... GROUP BY... HAVING. ORDERBY ....), INSERT, DELETE, UPDATE, DROP, VIEW definition and use, Temporary tables, ‘Nested queries, and correlated nested queries, Integrity constraints: Not null, unique, check, primary key, foreign key, references, Inner and Outer Joins. Query Processing: Parsing, translation, optimization, evaluation and overview of Query Processing. Protecting the Data Base: Integrity, Security and Recovery. Domain Constraints, Referential Integrity, Assertion, Triggers, Security & Authorization in SQL. BOOKS RECOMMENDED: Database System Concept: 4. Silberschatz , HLF. Korth and S. Sudarshan, TMH Fundamentals of Database Systems: Z/masri & Nawathe, Pearson Education ‘An Introduction to Database Systems: C. J. Date, AWL Publishing Company SQL, PLISQL: fvan Bayross, BPB Publication ‘An Introduction to database systems: Bipin Desai, Galgotia Publication Database Management System: 4. K Newmar s & P. Bhattacharya, TMH dB Gait 4& ae © ee @ Ges a aya a Programming in “C++”? Subject Code - BCA-203 Max Marks : 80 Min Marks : 27 Note : The Question Paper setter is advised to prepare unit-wise question with the provision of internal choice. Only Simple calculators allowed not scientific calculator. UNIT - I: Language Fundamental Overview of OOP: The Object Oriented paradigm, Basic concepts of OOP, Benefits of OOP, Object oriented languages, Application of OOP Overview of C+: History of C++, Data Types: Built-in data types, User-defined data types, Derived data types. Constants and Variables: symbolic constants, Dynamic initialization of variable, Reference variable. Operators in C++. Control Structures: if-else, nested if-else, while, do-while, for, break, continue, switch, goto statement. UNIT - II: Structure & Function Structures: A Simple structure, defining a structure variable, Accessing structure’s member, Enumeration data type. Function: Function Declaration, Calling Function, Function Definition, Passing Arguments to function: Passing Constant, Passing Value, Reference Argument, Structure as argument, Default ‘Argument Returning values from function: return statement, Returning structure variable, Retum by reference, Overloaded Function, Inline Function. UNIT - III: Object Classes and Inheritance Object and Class, Defining the class and its member, Making an outside function inline, nesting of member function, array as class member, structure and classes. Memory allocation: memory allocation for objects, new and delete operator, static data member, static member functions, object as function argument. Constructor & Destructor: Null and default constructor. Parameterized constructor, Constructor with default argument, copy constructor, class destructors, ointers and Inheritance introduction, & and * operator, pointer to object, this pointer, pointer to derived class. Inheritance: Introduction to inheritance, Types of inheritance, function overriding, Constructor in Derived class. Access specifiers: public, private, protected. UNIT - V: Polymorphism Dynamic polymorphism: Virtual function, Pure Virtual Function, Abstract class Static Polymorphi increment), --) using operator function, overloading binary operators (+, Operator keyword, overloading unary operators (++ (pre increment and post > OD. Friend function, Friend class, overloading binary operators using friend function RECOMMENDED BOOKS : 1 2 2: 4. dee Cain eu Object Oriented Programming with C++ : £. Balagurusamy, The McGraw-Hill Let Us C++: Yesvant Kanetkar, BPB Publications The C++ Programming Language: Bjarne Stroustrup, Addision Wasley. Object Oriented Programming in C+ : Robert Lafore, Galgotia Publications. PET Computer Networks Subject Code - BCA-204 Max Marks : 80 Min Marks : 27 Note : The Question Paper setter is advised to prepare unit-wise question with the provision of internal choice. Only Simple calculators allowed not scientific calculator. UNIT - I -Introduction to Computer Networking Data Communication, Networks - Distributed Processing, Network Criteria, Applications; Protocols and Standards, Standard Organization, Line Configuration - Point to Point, Multi Point; Topology ~ Mesh, Star, Tree, Bus, Ring, Hybrid; Transmission mode, Categories of Network - LAN, MAN, WAN, Inter Networks, UNIT - II Transmission of Digital Data Analog and Digital, digital data transmission - parallel transmission, serial transmission, DTE-DCE interface - data terminal equipment, data circuit terminating equipment, standards, modems- Transmission rate, Modem standards. UNIT - III- The OSI Model 1SO organization, The model - Layered architecture, functions of the layers -Physical layer, Data Link layer, Network layer, Transport layer, session layer, Presentation layer, Application layer UNIT - IV TCP/IP Model & Protocols ‘The TCPAP reference model, comparison of TCP/IP & OSI, Introduction to Intemet - ARPANET, Architecture of Internet, Client server model, www, IP Address Classes, Protocols: IP, HTTP, TCP, FTP, ARP. UNIT - V Network Security Introduction of Network Security and it’s importance. Cryptography: Definitions, Symmetric Key Cryptography: Traditional Ciphers, Simple modern Ciphers, Asymmetric Key Cryptography: RSA, Security Services, Digital Signatures BOOKS RECOMMENDED: 1, Introduction to Data communication & Networking - Behrouz & Forouzan 2. Computer Networking - Andres & Tanenbaum hor esti Operating Systems with Linux Subject Code - BCA-205 Max. Marks: 80 Min Marks : 27 Note : The Question Paper setter is advised to prepare unit-wise question with the provision of internal choice. Only Simple calculators allowed not scientific calculator. UNIT - I: Introduction Defining operating system, History and Evolution of operating system, Basic Concepts: batch processing, spooling, multiprogramming, multiprocessor system, time sharing, real time systems, Functions and Goals of operating system. UNIT - II: Process Management Process concept, Process Control Block, Process State: State Transition Diagram, Scheduling Queues: Queuing Diagram, Types of schedulers-context switching and dispatcher, various types of CPU scheduling algorithms and their evaluation, multilevel queues and multilevel feedback queues. UNIT - III: Memory Management Preliminaries of memory management, Contiguous memory allocation, fragmentation, partition allocation policies, compaction, Non-Contiguous memory allocation, Paging, Segmentation, Virtual Memory: Demand paging, Swapping, Page replacement policies: FIFO, Optimal, LRU, MRU. UNIT - IV: Introduction to UNIX. Introduction to Multi-user System, Emergency and history of Unix, Feature and benefits, Versions of Unix. System Structure:-Hardware requirements, Kemel and its function, introduction to System calls and Shell File System : Feature of Unix File System, Concept of i-node table, links, commonly used commands like who, pwd, ed, mkdir, rm, Is, mv, Ip, chmod, cp, grep, sed, awk, pr, lex, yace, make, ete. Getting started (login / logout).Vi Editor:-Intro to text processing, command and edit mode, invoking vi, command structure, deleting and inserting line, deleting and replacing character, searching strings. UNIT - V: Shell Programming Introduction to shell feature, wild card characters, i/out redirections, standard error redirection, system and user created shell variables, profile files, pipes/tee, background processing, command line arguments, command substitution, read statement, conditional execution of commands, special shell variables $ #, #2, $* ete. Shift commands, loops and decision making- for, while and until, choice making using case...esac, decision making if ...fi, using test, string comparison, numerical comparison, logical operation, using expr. BOOKS RECOMMENDED: 1, Operating System Concepts, Abraham Silberschatz, Peter B. Galvin and Greg Gagne (Wiley India Edition) 2. Modem Operating System, Andrew .S, Tanenbaum, (PHI) 3, UNIX Complete Reference Foundation Course Subject Code - BCA - 206 Max. Marks: 80 Min Marks : 27 Note : The Question Paper setter is advised to prepare unit-wise question with the provision of internal choice. Only Simple calculators allowed not scientific calculator. OBJECTIVE This course is designed to make the students acquainted with Indian History and Culture. To make students aware of their fundamental rights & duties and to have the knowledge of parliamentary form of Government. To groom students and develop their professional skills. Unit 1 Indian Art, meaning of art, features of indian art, elementary knowledge of paintings, music,dancing, sculpture archeology, iconography & other social arts. Unit 11 Indian Literature, Ancient Indian Literature, Elementary knowledge of Vedic Literature, Mahabharta, Ramayan and other main granthas. Unit 11 Indian Freedom Struggle : Freedom Struggle of 1857, National Consciousness, non-cooperation movements. Civil disobedient movement quit India movement, contribution of revolutionaries in freedom struggle. Unit IV Indian Constitution : Introduction, main features of constitution, fundamental rights. Parliamentary Government: Meaning, Features, Rajya Sabha, Lok Sabha. Unit V ‘Communication: Process, Channels, Barriers. Listening: Types, Purpose, Barriers, Effective Listening Strategies Job Interviews: Résumé Writing, Group Discussion, Job Application Writing, Interview Preparation BOOKS RECOMENDED: ‘© Indian Culture the book sponsored by M.P. Hindi granth Academy ‘Parliamentary Procedure in India by A.R Mukherjea ‘© Effective Technical Communication by M Ashraf Rizvi Y 2A he i zon ee Ae? Ww Oe ES Taw PRACTICAL WORK _ BCA II BCA-207 - LAB IV: Programming Lab in ‘C++” 1 Scheme of Examination: Practical examination will be of 3 hours duration. The distribution of practical marks will be as follows Program1 =~ 20 Program2 =~ 20 Program 3 - 20 Viva : 25 [ Practical Copy + Internal Record | ~ 15 Total - 100 2 In every program there should be comment for each coded line or block of code 3 Practical file should contain printed programs with name of author, date, path of program, unit no. and printed output. 4 All the following programs or a similar type of programs should be prepared List of Practical Loops, DECISIONS, NESTED METHOD, MEMBER FUNCTION DEFINED OUTSIDE CLASS BODY: 1, Write program to generate following pattern a)ABCDEFG ed ABC EFG + + AB FG vee A G bt ) 1 12 121 123 1331 1234 14641 2. Write member functions which when called asks pattern type; if user enters 11 then a member function is called which generates first pattern using for loop. If user enters 12 then a member function is called which generates first pattern using while loop. If user enters 13 then a member function is called which generates first pattem using do-while loop. If user enters 21 then a member function is called which generates second pattern using for loop and so on. 3. Write program to display number 1 to 10 in octal, decimal and hexa-decimal system. 4. Write program to display number from one number system to another number system. The program must ask for the number system in which you will input integer value then the program must ask the number system in which you will want, output of the input number after that you have to input the number in specified number system and program will give the output according to number system for output you mentioned carlicr. Array 5, Write a program using function to add, subtract and multiply two matrices of order 3x3. You have to create one function for addition, which accepts three array arguments. First two array arguments are matrices to add and third matrix is destination where the resultant of addition of first two matrixes is stored, In similar way create functions for matrix subtraction and multiplication. 6. Create a single program to perform following tasks without using library functions: a) To reverse the string accepted as argument. ) To count the number of characters in string passed as argument in form of character array. ©) To copy the one string to other string; passed as arguments in form of source character array and destination character array without using library function. d) To count no. of vowels, consonants in each word of a sentence passed as argument in form of character array. Class, Object, Array of object, Object Using Array 7. Create a class Student having data members to store roll number, name of student, name of three subjects, max marks, min marks, obtained marks. Declare an object of class student. Provide facilities to input data in data members and display result of student. 8. Create a class Student having data members to store roll number, name of student, name of three ‘subjects, max marks, min marks, obtained marks. Declare array of object to hold data of 3 students. Provide facilities to display result of all students, Provide also facility to display result of specific student whose roll number is given, 9. Create a class Sarray having an array of integers having 5 elements as data member provide following facilities a) Constructor to get number in array elements. b) Sort the elements. c) Find largest element b) Search for presence of particular value in array element. Static member function 10. Create a class Simple with static member functions for following tasks: a) To find factorial by recursive member function. b) To check whether a no, is prime or not c) To generate Fibonacci series up to requested terms. ‘Object as argument to function, function returning object 11, Write program-using class having class name Darray. Darray has pointer to pointer to integer as, data member to implement double dimension dynamic array and provide following facilities: a) Constructor to input values in array elements b) Input member function to get input in array clement ©) Output member function to print element value d) Add member function to perform matrix addition using objects. €) Subtract member function to perform matrix subtraction using objects. Multiply member function to perform matrix multiplication using objects 12, Write program to create class complex having data members to store real and imaginary part Provide following facilities: a) Add two complex no. using objects. b) Subtract two complexes no. using objects. ) Multiply two complexes no. using objects. d) Divide two complex no. using objects. Friend Function 13. Create class Polar having data members radius and angle. It contains member functions for taking input in data members and member function for displaying value of data members. Class Polar contains declaration of friend function add which accepts two objects of class Polar and retums object of class Polar after addition, Test the class using main function and objects of class Polar. 14, Write program to create class distance having data members feet and inch (A single object will store distance in form such as 5 feet 3 inch). It contains member functions for taking input in data members and member function for displaying value of data members. Class Distance contains declaration of friend function add which accepts two objects of class Distance and retums object of class Distance after addition. Class Distance contains declaration of another friend function Subtract that accepts two objects of class Distance and retums object of class Distance after subtraction, Test the class using main function and objects of class Distance. 15. Write a program to create class Mother having data member to store salary of Mother, create another class Father having data member to store salary of Father. Write a friend function, which accepts objects of class Mother, and Father and prints Sum of Salary of Mother and Father objects Friend Class 16. Write a program to create class Mother having data member to store salary of Mother, create another class Father having data member to store salary of Father. Declare class Father to be friend class of Mother. Write a member function in Father, which accepts object of class Mother and prints Sum of Salary of Mother and Father Objects. Create member function in each class to get input in data member and to display the value of data member. Static Data Member 17. Create a class Counter having a static data member, which keeps track of no. of objects created of type Counter. One static member function must be created to increase value of static data member 29 . , as re ne ‘as the object is created. One static member function must be created to decrease value of static data member as the object is destroyed. One static member function must be created to display the current value of static data member. Use main function to test the class Counter ‘STRUCTURE AND CLASS. 18, Define structure student. Structure student has data members for storing name, rollno, name of three subjects and marks. Write member function to store and print data, COPY CONSTRUCTOR, CONSTRUCTOR OVERLOADING, THIS POINTER, CONSTRUCTOR WITH DEFAULT ARGUMENT. 19. 20, Write program to create a class Polar which has data member radius and angle, define overloaded constructor to initialize object and copy constructor to initialize one object by another existing object keep name of parameter of parameterized constructor same as data members. Test function of the program in main function. Write program to create a class Polar which has data member radius and angle, use constructor with default arguments to avoid constructor overloading and copy constructor to initialize one object by another existing object keep name of parameter of parameterized constructor same as data members. Test functioning of the program in main function FUNCTION OVERLOAD, REFERENCE VARIABLE, PARAMETER PASSING BY ADDRESS, STATIC FUNCTION 21. 22. 23, 24, Write a class having name Calculate that uses static overloaded function to calculate area of circle, arca of rectangle and area of triangle. ‘Write a class ArraySort that uses static overloaded function to sort an array of floats, an array of integers Write a program using class, which uses static overloaded function to swap two integers, two floats methods use reference variable Write a program using class, which uses static overloaded function to swap two integers; two floats methods use parameter passing by address. ‘STRING, POINTER, AND OPERATOR OVERLOADING 28, Create class String having pointer to character as data member and provide following Facilities: a) Constructor for initialization and memory allocation b). Destructor for memory release ©) Overloaded operators + to add two string object. 4) Overloaded operator = to assign one string object to other string object. e) Overloaded operator == to compare whether the two string objects are equal or not. £) Overloaded operator < to compare whether first-string object is less than sccond-string object. 2) Overloaded operator > to compare whether first-string object is greater than second-string abject or not, bh) Overloaded operator <= to compare whether first string object is less than or equal to second string object or not i) Overloaded operator >= to compare whether first string object is greater than or equal to second string object. j) Overloaded operator != to compare whether first string object is not equal to second string object or not k) Overloaded insertion and extraction operators for input in data member and display out put of data members 5. Create a class Matrix having data member double dimension array of floats of size 3x3. Provide following facilities: a) Overloaded extraction operator for data input b) Overloaded insertion operator for data output. ©) Overloaded operator + for adding two matrix using objects. 4) Overloaded operator - for subtracting two using matrix objects €) Overloaded operator * for multiplying two using matrix objects. OPERATOR OVERLOADING WITH FRIEND FUNCTION 27, Create a class Polar having radius and angle as data members. Provide following facilities: 8) Overloaded insertion and extraction operators for data input and display : sg = Kean skin 26 inal b) Overloaded constructor for initialization of data members, ©) Overloaded operator + to add two polar co-ordinates using objects of class Polar. 28, Create class DegreeCelsius having a single data member to hold value of temperature in degree Celsius. Provide following facilities: a) Overloaded operator + which will increase value of data member by 1 (consider postfix and prefix operator overloading). b) Overloaded operator -- which will decrease value of data member by 1 (consider postfix and prefix operator overloading). ©) Overloaded insertion and extraction operators for input in data member and display value of data member. OPERATOR OVERLOADING AND DATA TYPE CONVERSION 29, Create a class Polar that contains data member radius and angle, Create another class Cartesian in the same program and provide following facilities: a) It should be possible to assign object of polar class to object of Cartesian class. b) It should be possible to assign object of Cartesian class to object of polar class. 30. Create a class Fahrenheit that contains a data member to hold temperature in Fahrenheit. Create another class Celsius that contains a data member to hold temperature in Degree Celsius; in the same program and provide following facilities: a) It should be possible to assign object of Fahrenheit class to object of Celsius class, b) It should be possible to assign object of Celsius class to object of Fahrenheit class. ©) It should be possible to compare objects of class Fahrenheit and Celsius to find out which object contains higher temperature. ‘Vol POINTER, POINTER AND POINTER TO OBJECT 31. Create a program having pointer to void to store address of integer variable then print value of integer variable using pointer to void. Perform the same operation for float variable. 32. Write program to find biggest number among three numbers using pointer and function. 33. Write swapping program to demonstrate call by value, call by address and call by reference in a single program. 34, Write program to Create a class Employee having data members to store name of employee, employee id, salary. Provide member function for data input, output. Use Pointer to object to simulate array of object to store information of 3 employees and test the program in function main. INLINE FUNCTION. 35. Write a program using inline function to calculate area of circle, 36. Write a program using inline function to find minimum of two functions. The inline function should take two arguments and should return the minimum value. INHERITANCE 37. Create a class account that stores customer name, account number and type of account. From this derive the classes cur acct and sav_acct to make them more specific to their requirements. Include necessary member functions in order to achieve the following tasks: a) Accept deposit from customer, b) Display the balance ©) Computer and deposit interest. 4) Permit withdrawal and update the balance ©) Check for the minimum balance, impose penalty, necessary and update the balance, 38. Create a class circle with data member radius; provide member function to calculate area, Derive a class sphere from class circle; provide member function to calculate volume, Derive class cylinder from class sphere with additional data member for height and member function to calculate volume. 39. Consider an example of declaring the examination result. Design three classes:- student, exam and result, The student class has data members such as that representing roll number, name of student. Create the class exam, which contains data members representing name of subject, minimum. AD e Be. Bam 2 Qe” 2 AF Waly marks, maximum marks, obtained marks for three subjects. Derive class result from both student ‘and exam classes, Test the result class in main function, VIRTUAL AND PURE VIRTUAL FUNCTION 40. Create a base class shape having two data members with two-member function getdata (pure virtual function) and printarea (not pure virtual function). Derive classes triangle and rectangle from class shape and redefine member function printarea in both classes triangle and rectangle and test the functioning of classes using pointer to base class objects and normal objects. go Ree Kiron GR AS we gps. qa cane? PRACTICAL WORK BCA-208 - LAB V: Database Management System Lab 1 Scheme of Examination:- Practical examination will be of 3 hours duration, The distribution of practical marks will be as follows Program 1 (Oracle) ~ 20 Program 2 (Oracle) - 20 Program 3 (Oracle) - 20 Viva - 28 [ Practical Copy + Practical Sessional] : 15 Total - 100 2 In every program there should be comment for each coded line or block of code 3 practical files should contain printed programs with name of author, date, path of program, unit no, and printed output. 4 All the following programs or a similar type of programs should be prepared List of Practical 1. Using the following database, Colleges (cname, city, address, phone, afdate) Staffs ( sid, sname, saddress, contacts) StafiToins ( sid, ename, dept, DOJ, post, salary) Teachings ( sid, class, paperid, feession, tsession) Subjects ( paperid, subject, papemo, papername) Write SQL statements for the following — Sree mene ge Create the above tables with the given specifications and constraints. Insert about 10 rows as are appropriate to solve the following queries. List the names of the teachers teaching computer subjects. List the names and cities of all staff working in your college, List the names and cities of all staff working in your college who earn more than 15,000 Find the staffs whose names start with ‘M’ or ‘R’ and ends with ‘A’ and/or 7 characters long Find the staffs whose date of joining is 2005 Modify the database so that staff N1 now works in C2 College. List the names of subjects, which TI teaches in this session or all sessions, Find the classes that T1 do not teach at present session, a. Find the colleges who have most number of staffs b. Find the staffs that carn a higher salary who carn greater than average salary of their college. ¢. Find the colleges whose average salary is more than average salary of C2 4. Find the college that has the smallest payroll ©. Find the colleges where the total salary is greater than the average salary of all colleges. £ List maximum, average, minimum salary of each college a. List the names of the teachers, departments teaching in more than one department. b. Acquire details of staffs by name in a college or each college. ¢. Find the names of staff that eam more than each staff of C2 College. 4. Give all principals a 10% rise in salary unless their salary becomes greater than 20,000 in such case give 5% rise. ¢. Find all staff that do not work in same cities as the colleges they work. Som Zon) Hoo. SMM se Brians sy e BE vA iad i List names of employees in ascending order according to salary who are working in your college or all colleges. a. Create a view having fields sname, cname, dept, DOJ, and post b. Create a view consisting of ename, average salary and total salary of all staff in that college. ¢. Select the colleges having highest and lowest average salary using above views, ._ List the staff names of a department using above views. 2. Create the following database, Enrollment (enrolling, name, gender, DOB, address, phone) Admission (admno, enrollno, course, yearsem, date, cname) Colleges (cname, city, address, phone, afiiate) FeeStructure (course, yearsem, fee) Payment (billno, admno, amount, pdate, purpose) Create the above tables with the given specifications and constraints. Insert about 10 rows as are appropriate to solve the following queries, Get full detail of all students who took admission this year class wise Get detail of students who took admission in Bhilai colleges. Calculate the total amount of fees collected in this session ‘) By your college ii) by each college iii) by all colleges a. List the students who have not payed full fee i) in your college ii) in all colleges List the number of admissions in your class in every year. . List the students in the session who are not in the colleges in the same city as they live in, List the students in colleges in your city and also live in your city. 3. Create the following database, Subjects ( paperid, subject, paper, papername) ‘Test (paperid, date, time, max, min) Score (rollno, paperid, marks, attendence) Students (admno, rollno, class, yearsem) Create the above tables with the given specifications and constraints Insert about 10 rows as are appropriate to solve the following queries List the students who were present in a paper of a subject. List all roll numbers who have passed in first division, List all students in BCA-II who have scored higher than average i) in your college ii) in every college g. List the highest score, average and minimum score in BCA-II i) in your college ii) in every college 4. Using the following database Colleges (cname, city, address, phone, afidate) Staffs (sid, sname, saddress, contacts) StafiJoins ( sid, cname, dept, DOJ, post, salary) Teachings ( sid, class, paperid, fSession, tscession) Subjects ( paperid, subject, paperno, papername) Write SQL statements for the following — Create the above tables with the given specifications and constraints. Insert about 10 rows as are appropriate to solve the following queries. List the names of the teachers teaching computer subjects. List the names and cities of all staff working in your college. List the names and cities of all staff working in your college who earn more than 15,000 Using the following database ye Suen | ES pis £ Asay Weqsullt ZS" &= aooe wane epee er eeoge Colleges (cname, city, address, phone, fate) Staffs ( sid, sname, saddress, contacts) Staffoins ( sid, cname, dept, DOJ, post, salary) Teachings ( sid, class, paperid, fSession, tsession) Subjects ( paperid, subject, paperno, papername) Find the staffs whose names start with “M” or “R’ and ends with ‘A’ and/or 7 characters long. Find the staffs whose date of joining is 2005 Modify the database so that staff NI now works in C2 college. List the names of subjects which T1 teaches in this session or all sessions, Using the following database Colleges (cname, city, address, phone, afdate) Staffs ( sid, sname, saddress, contacts) Staffloins ( sid, ename, dept, DOJ, post, salary) ‘Teachings ( sid, class, paperid, fsession, tsession) Subjects ( paperid, subject, paperno, papername) Find the classes that TI do not teach at present session. Find the college who have most number of staffs Find the staffs who cam a higher salary who earn greater than average salary of their college. Find the colleges whose average salary is more than average salary of C2 Find the college that has the smallest payroll. Find the colleges where the total salary is greater than the average salary of all colleges, List maximum, average, minimum salary of each college Using the following database Colleges (cname, city, address, phone, afilate) Staffs ( sid, sname, saddress, contacts) StaffJoins ( sid, ename, dept, DOJ, post, salary) Teachings (sid, class, paperid, feession, tsession) Subjects ( paperid, subject, papemno, papername) Find the classes that T1 do not teach at present session List the names of the teachers, departments teaching in more than one departments. Acquire details of staffs by name in a college or each college. Find the names of staff who earn more than each staff of C2 college. Give all principals a 10% rise in salary unless their salary becomes greater than 20,000 in such case give 5% rise. Find all staff who donot work in same cities as the colleges they work. List names of employees in ascending order according to salary who are working in your college or all colleges. Using the following database Colleges (cname, city, address, phone, afidate) Staffs ( sid, sname, saddress, contacts) StaffJoins ( sid, ename, dept, DOJ, post, salary) Teachings (sid, class, paperid, fSession, tsession) Subjects ( paperid, subject, paperno, papername) Find the classes that T1 do not teach at present session. Create a view having fields sname, ename, dept, DOJ, and post Create a view consisting of cname, average salary and total salary of all staff in that college. Select the colleges having highest and lowest average salary using above views. List the staff names of a department using above views. j <9 hye Gs: ae Q BEES Sine Bo amt BE Ne Son 9. 10. u Enrollment (enrolino, name, gender, DOB, address, phone) Admission (admno, enrolino, course, yearsem, date, name) Colleges (cname, city, address, phone, afdate) FeeStructure (course, vearsem, fee) Payment (billno, admno, amount, pdate, purpose) Create the above tables with the given specifications and constraints. Insert about 10 rows as are appropriate to solve the following queries. Get full detail of all students who took admission this year classwise Get detail of students who took admission in Bhilai colleges. Calculate the total amount of fees collected in this session i) by your college i) by each college iii) by all colleges Enrollment (enrolino, name, gender, DOB, address, phone) Admission (admno, enrolino, course, yearsem, date, cname) Colleges (cname, city, address, phone, afdate) FeeStructure (course, vearsem, fee) Payment (billno, admno, amount, pdate, purpose) a. _ List the students who have not payed full fee i) in your college ii) in all colleges b. List the number of admissions in your class in every year. List the students in the session who are not in the colleges in the same city as they live in. List the students in colleges in your city and also live in your city. ae Subjects ( paperid, subject, paper, papername) Test (paperid, date, time, max, min) Score (rolino, paperid, marks, attendence) Students (admno. rolino, class, yearsem) Create the above tables with the given specifications and constraints. Insert about 10 rows as are appropriate to solve the following queries. List the students who were present in a paper of a subject. List all roll numbers who have passed in first division. List all students in BCA-II who have scored higher than average i) in your college ii) in every college £ List the highest score, average and minimum score in BCA-II we in your college ii) in every college Sn , x R 9 wt Hon ES ME Yowe Fae 7 Bly A / « “AN epose PRA BCA-209 - LAB VI: Operating System Lab Scheme of Examination: 1. Practical examination will be of 3 hours duration. The distribution of practical marks will be as follows Program 1 - 20 Program 2 - 20 Program 3 - 20 Viva - 25 [ Practical Copy + Internal Record J - 13 Total : 100 In every program there should be comment for cach coded line or block of code 3. Practical file should contain printed programs with name of author, date, path of program, unit no, and printed output. 4, All the following programs or a similar type of programs should be prepared List of Practical 1, Change your shell environment — path, home, ifS, mail, ps1, ps2, term, logname i) at commandline ii) at shell level iii) at login level Change the wallpaper, screensaver in GNOME, KDE Install Linux with following specifications ~ usename, password, partitions for various directories such as fete, home, ete ‘Add a user and password, change the password Add & remove a group Create partitions on your disk. Install and configure (i) printer Gi) scanner Using vi editor do the following exercives Linafile i) replace the words ‘has’ with ‘has not * ii) Locate n" character iii) Sort lines 21 to 40 2. Ina file copy/cut and paste following text- i Ati line, n lines to j line ii Yank few words iii Cut and paste n words to i" position in I line 2. Open two files “txtfile’ and ‘newfile’ and copy/cut 5 lines from txtfile and paste them in newfile using vi editor. Open ‘txtfile’ and copy/cut following and paste to the ‘newfile” i i to the last line in it 5, Create macro ii to paste your name at any position in the file iii to map the 1* function key to search for “loop” and copy into the buffer ‘a’ all text following it up to but not including the string “end”, iv to remove all leading spaces in a file ¥ to save and quit vi editor in input mode Write commands i, Listall files that match a class. oN es Wt ii. iv. vi vil. List all files that do not match a class. Change the file permissions Configure or set characteristics of your terminal. Describe any 3 Display the lines in a file that contain a particular word Append the contents of two files in a file JABC. ‘Count the number of files in a directory. Write shell programs i iti iv. v vi vii. vill, ix, x. xi xiii xiv. Display all the users currently logged in detail with column headers. List all files in current directory and save the list in a file ABC. Also save the contents of the files in ABC and display the contents in ABC in sorted order. Sort the contents of a file ABC and save it in OABC. Display all the users currently logged in detail with column headers. ‘To save current date & time, number of files & directories in the current directory and contents of all the files to a single file NFL. To input a number and test whether it is +ve, -ve or zero. To test whether a filename is a regular file or a directory or of other type To list only the directories in current path. To print the greatest of three numbers. To print 12 terms of Fibonacci series. To display all users currently logged in & also check a particular user every 30 seconds until he logs in, To save current date & time, number of files in the current directory and contents of all the files matching a pattern to a single file NPFL. To display particular messages depending on the weekday. To display common messages for following group of days-Monday & Wednesday, Tuesday & Thursday and Friday & Saturday and other day. To accept a string from the terminal and echo a suitable message if it doesn’t have at least 9 characters Write a Shell Script to find the factorial of a number. Write a Shell Script to swap two numbers using third variable. Write a Shell Script to print prime numbers between 1 to 20. White a Shell Script to greatest of three numbers. Write a Shell Script to sort the contents of a file XYZ and save it in BCATI Write a Shell Script to display mathematical table of any number in the format E x :-3*1=3. Oheo fea Bee ye Wns Oem “ayia 2 SCHEME OF EXAMINATION 2019-2020 BCA PART-II Theory aN Internal Marks | Teaching Load Subject _ | Subject Paper per Week Code LTP Max. | Min, | Max. | Min a |® [© |o *BCA3OI | Part Calculus & Geometry 30 - 2 ]- |- Part Il-Differental Equation & Fourier | *° “ |} . Bele | Series Part Ill Computer System Architect | 50 : : 2 |. |- BCA302_ | Java 100 | 40 so |30 Ja |2 |- BCA303 100/40 a BCA304 | Software Engineering too | 40 so 30 |4 |2 |- BCA305_ | A. MULTIMEDIA TOOLS AND so | 20 = 2 2 ~ APPLICATIONS so | 20 a 3 [2x2 B._ Practical based on course 305A. BCA306 | A. Financial Management & so | 40 - - 2 |- |- Accountancy 50 “ = % te be B. Foundation Course BCA307 | Practical Based on Course-302 100 | 50 - : - |. | 3x BCA308 | Project too | 50 - - - fe fae TOTAL 850_| 360 150_| 90 GRAND | (PAPER = INTERNAL) ao (eD) TOTAL 1000 450 * Minimum passing marks in subject BCA3O1 i 40% of total marks 150(. Total of Part I+ Part Il + Part IL marks of BCA301) (4 Sea lp a I Sav oe BCA301 CALCULUS & GEOMETRY Max. Marks: 50 NOTE ;- The Question Paper setter is advised to prepare unit-wise question with the provision of internal choice. Only Simple calculator is allowed not Seientific calculator. CALCULUS UNIT-T ‘The Reimann Integral, Existence of the Riemann Integral, Properties of Reimann Integrals, Fundamental Theorem of Integral Calculus. UNIT-IL Maxima and minima of functions of two and three variables. Langrange’s method of undetermined multipliers. UNIT-TT . . Improper integrals, Meaning of integrals of type Ja" f(x) dx, la’ f(x) dx where f(x) is not defined at a and/or b. Tests of convergence for improper integrals. GEOMETRY UNIT- IV. Equation to cone with given base, Generators of Cone, condition for three mutually perpendicular generators, Right Circular Cone, Equation of a cylinder UNIT-V Polar Coordinates, Polar equation to straight line, Circle. Polar equation of a Conic. REFERENCE: 1.Calculus of two and more variables: G.S. Pandey & V.P. Saxena (Wiley Eastern) 2.Higher calculus P.L.Sharma 3.Nector Calculus & Geometry; B.R.Thakur. BCA301 DIFFERENTIAL EQUATIONS & FOURIER SERIES Max Marks : 50 Note : The Question Paper setter is advised to prepare unit-wise ques internal choice. Only Simple calculator is allowed not Scientific calculator. with the provision of UNIT Concept of Differential equation. Recall of first order and first degree differential equations. first order but of higher degree, Homogeneous and exact differential equations. ‘quation of UNIT-IL Geometric representation, Family of curves and orthogonal trajectories, Linear differential equation with constant coefficients. Operational rules of D. Homogeneous linear equation aot ‘UNIT-IIL Partial differential equations of first order, Standard forms, Linear partial differential equations of | order with constant coefficients. UNIT-IV Periodic Function, Fourier Sine and Cosine Series, Even and Odd Functions, Full Range and Half Range Fourier Series UNIT-V, Convergence of Fourier Series, Gibbs Phenomenon, Operations on Fourier Series, Applications of Fourier Series to Differential Equation REFERENCE: Introductory course in differential equations : D. A. Murray 2.Differential equations(Awkl Sameekaran) : B.P. Parashar & L.P. Rajpal 3.Differential equations and Fourier Series : H.K.Pathak BCA 301 COMPUTER SYSTEM ARCHITECTURE ‘Max Marks : 50 Note : The Question Paper setter is advised to prepare unit-wise question with the provision of internal ‘choice. Only Simple ealeulator is allowed not Scientific Calculator. UNITI Data Representation ~ Data Types, Number System, Fixed Point Representation — 1's, 2's complements, Binary Fixed point representation, Arithmetic operation on Binary operation, Overflow & Underflow, Codes, ASCII, EBCDIC codes, Grey codes, Excess-3, BCD codes, Error detection & correcting codes. UNIT IL Digital Logic Circuits — Logie Gates AND, OR, NOT, Gates & their truth tables, NOR, NAND & XOR Gates, Boolean algebra, Basic Boolean Law, Doorman's theorem, Map Simplification, Minimizing technique, K Map, Sum of product, Product of sums, Combinational & sequential Circuits Half adder & Full adder, Full Subtractor, Flip Flop — RS, D, JK & T Flip Flop, Shift register, RAM & ROM. UNIT UL CPU organization, ALU & Control circuit, Idea about arithmetic circuits, Program control, Instruction sequencing, Introduction to Microprocessor, Microprocessor architecture, System buses, Registers, Program counter,, Block diagram of a Macro computer system, Microprocessor control signals, Interfacing Devices .Introduction to Motherboard .SMPS- UNITIV Input output organization, /O Interface, Properties of simple /O devices and their Controller, Isolated ‘versus Memory mapped I/O, Modes of Data transfer, Synchronous & Asynchronous Data Transfer, Handshaking, Asynchronous serial transfer, I/O processor UNIT V ‘Auxiliary memory - Magnetic drum, Disk & Tape, Semi conductor memories, Memory Hierarchy, ‘Associative memory, Virtual memory, address space & memory space, Address mapping, Page table, Page replacement, cache memory, Hit ratio, Mapping Techniques, Writing into cache. oy REFERENCE: 1. Computer System architecture - M. Moris Mano BCA - 302 PROGRAMMING IN JAVA Max marks-100 Min marks ~ 40 Note : The Question Paper setter is advised to prepare unit-wise question with the provision of internal choice. Only Simple caleulator is allowed not Scientific ealeulator. UNIT-1 Introduction :Genesis of java, importance to the Internet, overview of features. OOP : COP features, data types, control structures, arrays, methods and classes, nested & inner classes, string and String Buffer class, Wrapper Class, vectors, UNIT-IL Inheritance : Basics type,, method Override, using abstract and final classes, using super. Packages and Interfaces : Defined CLASSPATH, importing packages, implementing interface. UNIT - IL Exception Handling : Fundamental: exception types, using try and catch, throwing exceptions, defined exceptions. Multithreaded Programming : Java spread model, creating threads, and thread priorities, synchronization. Suspending resuming and stopping threads. UNIT -=IV Input/Output: Basic Streams, Byte and Character Stream, predefined streams, reading and writing from console and files. Using standard Java Packages (lang,util,io) Networking :Nasecs. TCP/IP client & server sockets, URL connection. JDBC: Setting the JDBC connectivity with backend database. UNIT-V Applets : Fundamentals, life eycle, over Developing single applets. Introduction to AWT : Window fundamentals, creating windowed, programs waking with graphics, using 'AWT controls, menus. Delegation event model, handling mouse and keyboard events. ing update, HTML APPLET tag, passing parameters BOOKS RECOMMENDED: 1, java complete reference - by Patrick naughten & Mesut Sepddt. [TMH] 2. Java Primer - by E.Balaguruswami 3. Java Programming - Khalid Mughal Sein wt 5 ee BCA — 303 OPERATING SYSTEM. ‘Max marks-100 ‘Min marks - 40 Note: The Question Paper setter is advised to prepare unit-wise question with the provision of internal choice. Only Simple caleulator is allowed not Scientific calculator. UNIT-I Introduction What is operating system, basic concept, terminology, batch processing, spooling, multiprogramming, time sharing, real time systems, protection, multiprocessor system, operating system as resource manager, process view point, memory management, process management, device management and information ‘management, other views of operating system, historical, functional job control language and supervisor service control. UNIT-II Processor Management (CPU Scheduling) Reviewing of multiprogramming concept, scheduling concept, basic concept, CPU /O burst cycle process state, PCB ( Programme Control Block) scheduling queries, schedulars, scheduling algorithms - performance criteria, first-come - first served shortest job - first priority, preemptive algorithm, round robin, multilevel queues and multilevel feedback queues, algorithm evolution, multiprocessor scheduling , separate system, coordinated job scheduling, master / slave scheduling. UNIT-III Memory Management Preliminaries of memory management, memory handling in M/C, relocation, swapping and swap time calculation, multiple partitions, partitioned allocation MFT, fragmentation, MVT, compaction, paging. job scheduling implementation of page tables, shared page, virtual memory-overlays, concepts of virtual memory demand page, memory management and performance, page replacement and page replacement algorithms. Allocation algorithms. Storage hierarchy disk and drum scheduling - physical characteristics fefs scheduling SCAN, short of seek time first disk scheduling algorithms sector queuing. UNIT -IV Information Management (File System) File concept, file type, typed based system, disk based system, general model of file system, file directory maintenance, symbolic file system, basic file system, physical file system, file support device directory, access methods free space management contiguous, linked allocation and indexed allocation performances. UNIT V Dead Locks ‘The Dead Lock problem - Dead Lock definition, Dead Lock detection, detection algorithm usage, Dead Lock characterization, resource allocation graph, Dead Lock prevention, mutual exclusion, hold and wait, no preemption and circular wait, dead lock avoidance-bankers algorithm. Recovery from Dead Lock process termination, resource preemption, combined approach to Dead Lock handling. BOOKS RECOMMENDED : 1 1. Principles of Operating System -Peterson. 2. 2. Operating System -Mandinick & Donovan. Hos x14 BCA (Third Year) : BCA -304 SOFTWARE ENGINEERING Max marks-100 Min marks ~40 NOTE ; The Question Paper setter is advised to prepare unit-wise question with the provision of internal choice. Unit 1: Introduction to Software Engineering A. Definition B. Need and Software problem C. Software Crises D. Software Engineering Problem 1, Fundamental Problem 2. Important Quality of Software Product Software Engineering Approach 1. Phase Development Process 2. Life Cycle of Software Principles Of Software Engineering Software Development Process Model 1. Waterfall model 2, Spiral Model 3. Prototype Model 4. Iterative Model Unit 2: Project Management ‘A. The Phase Management Process B. Software Me 1, Size Oriented Metrics 2, Function Oriented Metrics Unit3: Software Requirement and Specification ‘A. Introduction and Need of SRS B. Structured Analysis 1. Data Flow Diagram 2. Context Diagram 3. Data Dictionary Unit 4; Software Design & Coding ‘A. Principle of Software Design 1. Partitioning 2. Abstraction 3. Top Down and Bottom up Strategies B. Concept of Module 1. Coupling 2. Cohesion C, Structured Chart D. Coding— a. Rules of Good programming Style b. Code Verification Unit $: Software Testing and Maintenance Definition ‘Testing Fundamentals Error, Fault, Failure Test Oracles Types of Testing 1. Black Box Testing 2. White Box Testing » so A B. c D. Gna A a Vy ae 29

You might also like