1,What do you mean by object oriented data model?
2.What i sordbms.what are it's adv &disadv?
3.what do you mean by object def lang & object query lang?
Monday, 31 March 2014
Assignment-1 (FCPIT)
1. What is the difference between c & C++?
2. What is the difference between Object oriented & procedure oriented Languges?
3.Explain various types of I/O devices.
4. Explain various types of sec storage devices.
Topic to be covered (FCPIT)
Inline Functions,Recursive functions. Programs using inline & recursive functions. Book : E. Balagurusamy
Wednesday, 26 March 2014
MST-2 (FCPIT)
MST-2nd
B. Tech
CSE,ECE,EE (Sem. – 2nd)
Total marks- 24
FCPIT
Course
Incharge:AP. Harwinder Kaur
2 Mark Questions:-
SECTION- A 2*2=4
1. The loop for (; ;) is
valid or not. Explain with reason.
2. What do you mean by
Keywords? Give an example.
5 Mark Questions:- 2*5= 10
SECTION –B
3 . What is the difference between Structure Class ? Explain with the help of an example.
4. What are the various types of goto
statements. Explain with example.
SECTION – C
10.
Mark question:-
5. Write the prog to calculate the sum and average of
n numbers using for loop.
MST-2 (RDBMS-II)
MST-2nd
CSE (Sem. – 6th) Total marks- 24
RDBMS-II
Course
Incharge:AP. Harwinder Kaur
2 Mark Questions:-
SECTION- A 2*2=4
1) What is the
difference between Complete selective
Replication?
2) What do you
mean by Starvation?
5 Mark Questions:- 2*5= 10
SECTION
–B
3 . Explain the various properties of Transactions.
4. Explain the Two phase Locking Protocol
Pessimistic Approach with example.
SECTION – C
10.
Mark question:-
5. What are the various Fragmention Tech.? Explain any
two.
MST-1(RDBMS-II)
Subject
Name : RDBMS-11 Subject Code : BTCS-602
Semester
: 6th Branch : CSE
Sessional
Test : 1st
Time
Duaration : 1.30 hr Max Marks : 24
Section A
Do
any two :
1. What do you mean by FFD?
Explain with an example. (2)
2. Explain the term BCNF. (2)
3. Write down the definition of
MVD. Give an example. (2)
Section B
Each question carries 5 marks:
1. What do you mean by DDL? Explain
the function of ALTER & DROP commands
with an example.
2. Discuss the anomalies in 2nd
NF.
Section C
Each question carries 10 marks. Do any one :
1. Compare the different types
of Data Models.
2. What are the various phases
of Query Processing? Discuss the concept of Heuristic Query Optimization.
MST-1 (FCPIT)
Subject Name : FCPIT Subject Code : BTCS-101
Semester : 1st Branch : CSE,ECE,EE
Sessional Test : 1st
Time Duaration : 1.30 hr Max Marks : 24
Section A
Do any two :
1. What do you mean by ternary operator? Explain with an
example. (2)
2. What do you mean by Data Abstraction? (2)
3. What do you
mean by Firmware? (2)
Section B
Each
question carries 5 marks. Do any two :
1. What do you mean by Operating System? Write down
functions of OS.
2. Write down the features of Word Processors.
3. Discuss the various applications of Internet.
Section C
Each
question carries 10 marks. Do any one :
1. Define the term Tokens. What are the various type of
tokens, explain in detail.
2. Explain the various type of Secondary storage devices
in detail.
Tuesday, 25 March 2014
Topic to be covered (RDBMS)
Immediate Database Modification,Recovery Schemes,Checkpoints,WAL Protocol,Shadow Paging (Pg-399-412) Book : Database Systems By Parteek Bhatia
Syllabus (CSE-3rd yr) RDBMS-2
BTCS 602 RDBMS–II
Introduction
to Database Systems: Database System Concepts and Architecture, Data
Models, Data
Query
Processing and Optimization:
Query
Processing, Syntax Analyzer, Query Decomposition, Query Optimization, Heuristic
Query
Optimization,
Cost Estimation, Cost Functions for Select, Join, Query Evaluation Plans. (6)
Transaction
Processing and Concurrency Control:
Transaction
Processing Concepts, Concurrency Control Techniques: Two-phase Locking,
Timestamp
Ordering,
Multiversion, Validation, Multiple Granularity Locking. (5)
Object
Oriented and Object Relational Databases:
Object
Oriented Concepts, Object Oriented Data Model, Object Definition Language,
Object Query
Language,
Object Relational Systems, SQL3, ORDBMS Design. (5)
Distributed
Databases:
Distributed
Database Concepts, Advantages and Disadvantages, Types of Distributed Database
Systems,
Data
Fragmentation, Replication and Allocation Techniques for Distributed Database
Design, Five Level
Schema
Architecture, Query Processing, Concurrency Control and Recovery in Distributed
Databases. (6)
Backup
and Recovery:
Types
of Database Failures, Types of Database Recovery, Recovery Techniques: Deferred
Update,
Immediate
Update, Shadow Paging, Checkpoints, Buffer Management. (5)
Introduction
to Data Warehousing and Data Mining:
Introduction
to OLAP, OLTP, Data Warehouse, Data Marts, Data Mining, Data Mining Process,
Big Data.
(5)
Server,
MySQL, their features. (7)
Suggested
Readings
1.
Ramez Elmasri, Shamkant Navathe, Fundamentals of Database Systems, Fifth
Edition, Pearson
Education,
2007.
2.
Raghu Ramakrishnan, Johannes Gehrke, Database Management Systems, Tata
McGraw-Hill.
3.
C.J. Date, An Introduction to Database Systems, Eighth Edition, Pearson
Education.
4.
Alexis Leon, Mathews Leon, Database Management Systems, Leon Press.
5.
Abraham Silberschatz, Henry F. Korth, S. Sudarshan, Database System Concepts, Tata
McGraw-
Hill.
6. S.
K. Singh, Database Systems Concepts, Design and Applications, Pearson
Education.
7.
Chris Eaton, Paul Zikopoulos, Understanding Big Data: Analytics for Enterprise Class Hadoop and
Streaming Data
Syllabus FCPIT (B.tech -1st yr- CSE,EE,ECE)
BTCS 101
Fundamentals of Computer Programming and IT
Objective/s and Expected
outcome:
To familiarize the
students of all branches in engineering with computer organization,
operating systems, problem
solving and programming in C++. After the students
have successfully
completed the course, they shall have sufficient knowledge of the
basic computer operations
and various programming techniques especially in C++.
PART A (Fundamentals of
Computer and IT) (25%)
1. Introduction to
Computers
Define a Computer System,
Block diagram of a Computer System and its
working, associated
peripherals, memories, RAM, ROM, secondary storage
devices, Computer Software
and Hardware. (2)
2. Working Knowledge of
Computer System
Introduction to the
operating system, its functions and types, working
knowledge of GUI based
operating system, introduction to word processors
and its features,
creating, editing, printing and saving documents, spell check,
mail merge, creating power
point presentations, creating spreadsheets and
simple graphs, evolution
of Internet and its applications and services. (3)
3. Problem Solving &
Program Planning
Need for problem solving
and planning a program; program design tools –
algorithms, flow charts,
and pseudocode; illustrative examples. (2)
PART B (Basics of
Programming Using C++) (75%)
4. Overview of C++
Language
Introduction to C++
language, structure of a C++ program, concepts of
compiling and linking, IDE
and its features; Basic terminology - Character set,
tokens, identifiers,
keywords, fundamental data types, literal and symbolic
constants, declaring
variables, initializing variables, type modifiers. (3)
5. Operators and
expressions
B. Tech. 1st & 2nd Semester
Batch-2011
28
Operators in C++,
precedence and associativity of operators, expressions and
their evaluation, type
conversions. (2)
6. Beginning with C++
program
Input/output using extraction
(>>) and insertion (<<) operators, writing simple
C++ programs, comments in
C++, stages of program execution. (4)
7. Control Structures
Decision making
statements: if, nested if, if – else. Else if ladder, switch,
Loops and iteration: while
loop, for loop, do – while loop, nesting of loops,
break statement, continue
statement, goto statement, use of control structures
through illustrative
programming examples.(4)
8. Functions
Advantages of using
functions, structure of a function, declaring and defining
functions, return
statement, formal and actual arguments, const argument,
default arguments, concept
of reference variable, call by value, call by
reference, library
functions, recursion, storage classes. Use of functions
through illustrative programming
examples.(4)
9. Arrays and Strings
Declaration of arrays,
initialization of array, accessing elements of array, I/O
of arrays, passing arrays
as arguments to a function, multidimensional arrays.
String as array of
characters, initializing string variables, I / O of strings, string
manipulation functions
(strlen, strcat, strcpy, strcmp), passing strings to a
function. Use of arrays
and strings through illustrative programming examples.(4)
10. Concepts of Object
Oriented Programming
Introduction to Classes,
Objects, Data abstraction, Data encapsulation,
inheritance and
polymorphis. (2)
11. Classes and Objects
B. Tech. 1st & 2nd Semester
Batch-2011
29
Defining classes and
declaring objects, public and private keywords,
constructors and
destructors, defining member functions inside and outside of
a class, accessing members
of a class, friend function. Use of classes and
objects through
illustrative programming examples. (4)
12. Basics of File
Handling
Opening, reading, and
writing of files, error handling during files operation. (2)
Suggested Readings
1. E.
Balagurusamy, Object-Oriented Programming with C++, Tata McGraw Hill.
2. P. K.
Sinha and Priti Sinha, Computer Fundamentals, BPB Publications.
3. Lafore
R., Object Oriented Programming in C++, Waite Group.
4. Bjarne
Stroustrup, The C++ Programming Language, Addison Wesley.
5. Lippman
F. B, C++ Primer, Addison Wesley.
6. R. S.
Salaria, Computer Concepts and Programming in C++, Salaria Publishing House.
7. Gurvinder
Singh, Krishan Saluja, Fundamentals of Computer Programming & IT, Kalyani
Publishers.
8. R. S. Salaria, Fundamentals of Computers, Salaria Publishing House
Subscribe to:
Posts (Atom)