Database Management System slc class 10 syllabus

Course Contents:

Unit 1: Introduction to Database System Architecture [3 Hours]

1.1. Introduction to Database System, Data Independence, Three Levels of Architecture: External,

Conceptual and Internal, Mappings, Database Administration, DBMS, Data Communication,

Manager, Client-Server Architecture, Distributed Processing, E-R Model, Data Dictionary

Unit 2: Relational Algebra and Relational Calculus [9 Hours]

2.1 Relational Calculus: Introduction, Operators, Syntax, Semantics, Examples, Additional Operators,

Grouping and Ungrouping, Relational Comparisons,

2.2 Relational Algebra: Introduction, Tuple Calculus, Relational Calculus vs. Relational Algebra,

Computational Efficiency, Domain Calculus.

42

Unit 3: Introduction to Relational Database, SQL and Relational Model Basics [9 Hours]

3.1 Relational Database: Introduction, Relational Model and Relations, Optimization. The Catalog, Views,

Transactions

3.2 SQL: Overview, The Catalog, Views, Transactions, Embedded SQL, Relational Model Basics:

Introduction, Domains. Relation Value. Relation Variables. SQL Features

Unit 4: Data Integrity and Views [8 Hours]

4.1 Data Integrity: Introduction, Type constraints, Attribute Constraints, Relvar Constraints, Database

Constraints, State vs. Transition Constraints.

4.2. Views: Introduction, Retrieval and Updates of Views, Snapshots.

Unit 5: Database Design [9 Hours]

5.1 Functional Dependencies: Introduction, Trivial and Non-trivial Dependencies, Closure of a Set of

Dependencies, Closure of a Set of Attributes.

5.2 Data Normalization: Introduction, Non-Loss Decomposition and Functional Dependencies, MVD,

JD, INF, 2NF and 3NF, BCNF, 4NF, 5NF, PJNF, Trigger.

Unit 6: Recovery and Concurrency [9 Hours]

6.1 Transaction Recovery: Introduction, Transaction, Transaction Recovery, System Recovery, Media

Recovery, Two-Phase Commit Protocol.

6.2 Transaction Concurrency: Introduction. Locking Deadlock, Serializability, Isolation Levels, Intent

Locking

Unit 7: Security [4 Hours]

7.1 Introduction, Discretionary Access Control. Mandatory Discretionary Access Control, Statistical

Database, Data Encryption.

43

PRACTICAL

Unit 3: Introduction to Relational Database, SQL and Relational Model Basics [17 Hours]

3.1. Design a Database and create required tables. For e.g. Bank, College Database

3.2. Apply the constraints like Primary Key, Foreign key, NOT NULL to the tables.

3.3. Write a sql statement for implementing ALTER, UPDATE and DELETE

3.4. Write the queries to implement the joins

3.5. Write the query for implementing the following functions: MAX(),MIN(),AVG(),COUNT()

Unit 4: Data Integrity and Views and Unit 5: Database Design [20 Hours]

4.1. Write the query to implement the concept of Intergrity constrains

4.2. Write the query to create the views

4.3. Perform the queries for triggers

4.4. Perform the following operation for demonstrating the insertion, updating and deletion using the

referential integrity constraints

4.5. Write the query for creating the users and their role.

Unit 5: Project work [40 Hours]

The course will be supplemented by project work. The project can involve the design of a schema for a

realistic application, and the implementation and coding of the entire application using SQL (and other

development tools such as graphical user interfaces or forms packages) on a relational database system (say

Oracle)

Evaluation techniques:

S. No. Nature First

Assessment

Second

Assessment

Final

Assessment

Total Pass

Marks

1 Theory 4 12 24 40 40%                                         

2 Practical 6 18 36 60 60%

Total 10 30 60 100 100%

Reference books:

1. Abraham Silberschatz, Henry F. Korth and S. Sudarshan- “Database System Concepts”, Fourth Edition,

McGraw-Hill, 2002.

2. Ramez Elmasri and Shamkant B. Navathe, “Fundamental Database Systems”, Third Edition, Pearson

Education, 2003.

3. Raghu Ramakrishnan, “Database Management System”, Tata McGraw-Hill Publishing Company, 2003.

4. Hector Garcia–Molina, Jeffrey D.Ullman and Jennifer Widom- “Database System Implementation”- Pearson

Education- 2000.

5. Peter Rob and Corlos Coronel- “Database System, Design, Implementation and Management”, Thompson

Learning Course Technology- Fifth edition, 2003.

6. Date, C.J., An Introduction to Database, 7th Edition, Addison Wesley . 2010

7. Elmasri, R. and Navathe, Shamkant B., Fundamentals of Database Systems, 2010, Addison Wesley

C++ Object Oriented Programming (OOP) class 10 slc syllabus

Object Oriented Programming (OOP)

THEORY

Unit-1: Overview (3 Hours)

1.1.Procedural language limitations

1.2.The object-oriented approach

1.3.Object-oriented concepts

1.3.1. Abstraction

1.3.2. Encapsulation

1.3.3. Inheritance

1.3.4. Reusability

1.3.5. Other features

1.4.Distinction between C and C++

Unit-2: C++ language basic syntax (6 Hours)

2.1.Basic program construction

2.1.1. Functions

2.1.2. Program statements

2.1.3. Whitespaces

2.2.Directives

2.2.1. Preprocessor directives

2.2.2.Header files

2.3.Comments and their appropriate use

2.4. Integer variables

2.4.1. Defining integer variables

2.4.2. Declarations and definitions

2.4.3. Variable names

2.4.4. Assignment statements

2.4.5. Integer constants

2.4.6. Other integer types

2.5.Character variables

2.5.1. Character constants

2.5.2. Initialization

2.6.Stream output / input

2.6.1. String constants

2.6.2. Cascading

2.6.3. Expressions

2.6.4. Precedence

2.7.Floating point types

2.7.1 Floating Types (float, double, long etc.)

2.7.2 Floating point constants

2.7.3 The define directive

2.8 Signed /unsigned data type

2.9 Type conversion

2.10 Arithmetic operators

2.10.1 The remainder operator

2.10.2 Assignment operators

2.10.3 Increment operators

Unit-3: Loops and control structures (5 Hours)

3.1 Relational operators

3.2 Loop structure

3.2.1 The for loop

3.2.2 The while loop

3.2.3 The do loop

3.2.4 Precedence: arithmetic and relational operators

3.2.5 Selection among loop types

3.3 Decision structure

3.3.1 The if statement

3.3.2 The if ...... else statement

3.3.3 The switch statement

3.3.4 The conditional operator

3.4 Logical operator

3.4.1 AND operator

3.4.2 OR operator

3.4.3 NOT operator

3.5 Other control statements

3.5.1 The break statement

3.5.2 The continue statement

3.5.3 The go to statement

Unit-4: Functions (6 Hours)

4.1. Function declaration and calling

4.2. Argument passing to functions

4.2.1. Passing constants

4.2.2. Passing variables

4.2.3. Passing by value

4.2.4. Passing structures as arguments

4.3. Returning values from functions

4.3.1. The return statement

4.3.2. Returning structure variables

4.4. Reference arguments

4.4.1. Passing simple data types by reference

4.4.2. Passing complex data by reference

4.4.3. Passing structure by reference

4.5. Overloaded functions

4.5.1. Varying number of arguments

4.5.2. Different kinds of arguments

4.6. Recursion

4.7. Inline functions

4.8. Default arguments

4.9. Scope of variables

4.9.1. Local variables

4.9.2. Global variables

4.9.3. Static local variables

4.9.4. Storage

4.10. Returning by reference

Unit-5: Objects and Classes (6 Hours)

5.1. Class-Object concept

5.1.1 Structure definitions

5.1.2 Accessing members of structures

5.2. Simple class construction

5.2.1. Defining class

5.2.2. Using class

5.2.3. Calling member function

5.3. Initializing class objects

5.3.1. Constructors

5.3.2. Default copy constructor

5.3.3. Destructors

5.3.4. When constructors and destructors are called

5.4. Objects as physical objects

5.5. Objects as data types

5.6. Objects as function arguments

5.6.1. Overloaded constructors

5.6.2. Member functions defined at outside the class

5.6.3. Objects as arguments

5.7. Returning objects from functions

5.8. Structures and classes

5.9. Classes, objects and memory

5.10. Static class data

5.10.1. Uses of static class data

5.10.2. Separate declaration and definition

Unit-6: Arrays and strings (6 Hours)

6.1. Array fundamentals

6.1.1. Defining arrays

6.1.2. Accessing array elements

6.1.3. Initializing array

6.1.4. Multidimensional arrays

6.1.5. Passing arrays to functions

6.1.6. Arrays of structures

6.2. Array as class member data

6.3. Arrays of objects

6.4. Standard string class

6.4.1. Defining and assigning string objects

6.4.2. Input/output with string objects

6.4.3. Finding string objects

6.4.4. Modifying string objects

6.4.5. Comparing string objects

6.4.6. Other functions

Unit-7: Operator overloading (6 Hours)

7.1. Overloading unary operators

7.1.1. Operator argument

7.1.2. Operator return values

7.1.3. Postfix notation

7.2. Overloading binary operators

7.2.1. Arithmetic operators

 7.2.2. Concatenating strings

7.2.3. Multiple overloading

7.2.4. Comparison and arithmetic operators

7.3. Data conversion

7.3.1. Conversion between basic types

7.3.2. Conversion between objects and basic types

7.3.3. Conversion between objects of different classes

Unit-8: Inheritance (5 Hours)

8.1. Basic Concepts

8.1.1. Base class and derived class

8.1.2. Accessing base class members

8.1.3. The protected access specifier

8.2. Derived class constructor

8.3. Overriding member functions and scope resolution

8.4. Class hierarchies

8.4.1. Abstract base class

8.4.2. Constructors and member functions

8.5. Public and private inheritance

8.6. Multiple inheritances

Unit-9: Streams and File Processing (8 Hours)

9.1. Stream classes and hierarchy

9.2. Stream error types

9.3. Disk files I/O with streams

9.3.1. Formatted file I/O

9.3.2. Strings with embedded blanks

9.3.3. Character I/O

9.3.4. Binary I/O

9.3.5. Object I/O

9.3.6. Closing files

9.3.7. I/O with multiple objects

9.4. Error handling in file I/O

9.5. File I/O with member function

9.6. Memory as a string object

9.7. Command line argument

9.8. Printer output

PRACTICAL

Practice all the contents mentioned in theory part using C++ programming language as per unit wise

indicated number of hours.

Unit-2: C++ language basic syntax (12 Hours)

Unit-3: Loops and control structures (9 Hours)

Unit-4: Functions (9 Hours)

Unit-5: Objects and Classes (9 Hours)

Unit-6: Arrays and strings (10 Hours)

Unit-7: Operator overloading (8 Hours)

Unit-8: Inheritance (8 Hours)

Unit-9: Streams and File Processing (12 Hours