Archive

Archive for the ‘Bachelor of Science’ Category

Principles of Rational Database Management System

UNIT 1

1. The relational database model.
1.1 Structure of relational database.
1.2 Relational algebra, extended relational algebra.
1.3 Relational calculus.
1.4 Modification of database.
1.5 Views.

2. Integrity constraints.
2.1 Domain constraints.
2.2 Referential integrity constraints.
2.3 Triggers.
2.4 Functional dependencies.

3. Controlling database access – users, groups, user authentication, user profiles and roles.

UNIT 2

4. Structured Query Language- SQL/92.
4.1 DCL, DDL and DML statements.
4.2 DDL statements- Select, Insert, Update and Delete.
4.3 DDL statements- Create, Alter, Drop, Rename, Truncate, Grant, Revoke.
4.4 Database transaction and transaction control statements- Commit, Rollback, save point. Two Phase Commit.
4.5 Explanation about the stages in proceeding and SQL DML statement.
4.6 Embedded SQL- Declare cursor, Open, Close, Declare Database, Connect.

5. Database Triggers.
5.1 Row triggers and statement triggers.
5.2 Before and after triggers.
5.3 Instead of triggers.
5.4 Cascaded triggers.
5.5 Enabled and disabled triggers.

UNIT 3

NOTE: – The syllabus is depending upon the implementation chosen. The topics below may be considered as guidelines.

6. Programming language interface.
6.1 Constants, Variables, Data Types, Data subtypes, Composite Data types.
6.2 Control Structures.
6.3 Cursor and exception handling.
6.4 Subprograms / functions.
6.5 Stored Procedure.
6.6 Calling external DLL’s.

7 Forms interface (syllabus not implemented, as it is implementation dependent).

8. Reports interface (syllabus is not expanded as it is implementation dependent)

Categories: Bachelor of Science Tags:

Introduction to file and Database Management Systems

Overview of Database Management.
1.1 Shortcomings of a file management system.
1.2 Difference between a database and a database system.
1.3 Benefits of database approach.
1.4 Data independence.
1.5 Data abstraction – Thee ANSI / SPARC architecture.
1.5.1 The external level.
1.5.2 The conceptual level.
1.5.3 The internal level.
1.5.4 Mappings between levels.
1.5.5 Data independence.
1.6 The database management system.
1.7 The database administrator.
1.8 Database users.
1.9 Overall database system architecture.

UNIT 2

2. Data Models.
2.1 The entity relationship model.
2.1.1 Entity sets, relationship sets.
2.1.2 Mapping cardinalities.
2.1.3 Primary key specification.
2.1.4 Entity relationship diagram.
2.1.5 Weak entities.
2.1.6 Extended E-R features.
2.1.7 Design of an ER schema.
2.1.8 Reducing an ER schema to tables.

UNIT 3

4. File Structures.
4.1 Fixed length records.
4.2 Sequential file organization.
4.3 Clustering file organization.
4.4 Data dictionary storage

5. Indexing and hashing.
5.1 . Types of indices.
5.1.1 Ordered indices.
5.1.2 B*- Tree index files.
5.1.3 B- Tree index files.
5.2. Hashing.
5.2.1 Static Hashing.
5.2.2 Dynamic Hashing.
5.3 Comparison of ordered indexing and hashing.
5.4 Multiple keys access.

Categories: Bachelor of Science Tags:

Introduction to Java

UNIT 1

1. Object oriented fundamentals.

2. Java language introduction.
2.1 Types.
2.2 Operators.
2.3 Flow Control.

UNIT 2

3. Classes.

4. Packages and Interfaces.

5. String Handling.

UNIT 3

6. Exception handling.

7. Input / Output.

8. Applets.

Categories: Bachelor of Science Tags:

Numerical Analysis with “C”

UNIT 1

1. Iterative methods. Methods of Bisection, False position method, Newton Rap son method, Secant method, Method of Successive approximation method.

2. Solution of simultaneous algebraic method.

3. Gauss elimination method, method of pivoting.

4. III conditioned equations, Gauss – seideliterative method.

5. Comparisons of direct and iterative methods.

UNIT 2

6. Interpolation: Forward and Backward differences, difference table, Newton Gregory forward interpolation formula, truncation error in interpolation.

7. Least square approximation, linear regression, and polynomial regression.

UNIT 3

8. Numerical Integration.
8.1 Trapezoidal and Simpson’s rules.
8.2 Errors in integration formulae.

9. Numerical solutions of ordinary differential equations. Euler’s method, Ruge Kutta method of fourth order.

Categories: Bachelor of Science Tags:

Event drive programming using Visual Basic

UNIT 1

1. Visual Basic fundamentals.
1.1 Development of environment. Menu Bar, Toolbar, Toolbox, Properties, Windows etc.
1.2 Customisation of environment.
1.3 Introduction to event driven programming.

2. The Visual Basics language.
2.1 Data types, Variables, Constants, and Arrays.
2.2 Collections.
2.3 Procedures, Subroutines, Functions.
2.4 Flow Control Statements.

UNIT 2

3. Visual Basics forms.
3.1 Appearance of a form.
3.2 Designing menus.
3.3 Drag and Drop operations.

4. Basic ActiveX Control.
4.1 Textbox.
4.2 List box and Combo box.
4.3 Scrollbars and Slides.
4.4 Common dialogs.
4.5 Files.

UNIT 3

5. Drawing and painting with Visual Basics.
5.1 Picture box and image box control.
5.2 Co-ordinate system, drawing methods.
5.3 Manipulating Pixels.

6. Database programming with Visual Basics (Introduction only).
6.1 Data controls and related methods.
6.2 Relational concepts.
6.3 Data entry and validations

Categories: Bachelor of Science Tags:

Data structures with advanced C

UNIT 1

1. Pointers and Indirection’s.
2. Strings and String Functions.

UNIT 2

3. Structures.
4. ‘C’ Input/Output files.

UNIT 3

5. The ‘C’ Pre- Processor.

6. Advanced Topics.
6.1 Type declaration.
6.2 Register and extern storage classes.
6.3 Labels and GOTO statements.
6.4 Functions pointers.
6.5 Recursion.
6.6 Bit wise operators.
6.7 Unions.
6.8 Bit fields.

Categories: Bachelor of Science Tags:

Networking and Internet fundamentals

UNIT 1

1. What is a computer network?
1.1 The goals of a network.
1.2 Network uses and applications.
1.3 Analogue and digital signals.
1.4 Codes for digital signals.
1.5 Serial and parallel transmission.
1.6 Bandwidth.

2. Local Area Network.
2.1 Distinction between LAN’s, MAN’s, and WAN’s.
2.2 The ISO-OSI reference model.
2.3 The TCP/IP reference model.
2.4 The features and uses of LAN.
2.5 Components of LAN – Server, Nodes or Peers, Cabling, Connectors, Network Interface Cards.
2.6 The Networking operating System.
2.7 Classification of LAN’s.
2.7.1 LAN Topology – Star, Bus, Ring, Modified Ring, Tree.
2.7.2 LAN Access control- CSMA/CD, Token Passing.
2.7.3 LAN Cabling.
2.7.4 LAN Protocols.
2.7.5 LAN Standards – IEEE 802,2,3,5.
2.8 Advantages of LAN over a mainframe of minicomputer.

UNIT 2

3. Commercial LAN System.
3.1 The Ethernet LAN.
3.1.1 Standard Ethernet Limitations.
3.1.2 Other Ethernet Networks.
3.1.3 10 Mbps Switched Ethernet.
3.1.4 100 Mbps Boot Ethernet.
3.2 The Arcnet LAN.
3.3 The IBM Token Ring LAN.
3.4 The Fibre Distributed Data Interface.

4. Metropolitan Area Networks – Asynchronous Transfer Mode Networks.

5. Integrated Services Digital Network.

UNIT 3

6. Wide Area Network – The Internet.
6.1 Internet Basics.
6.2 Internet in India.
6.3 TCP/IP.
6.4 IP Address and URL’s.
6.5 Domain Name Service.
6.6 File Transfer Protocol.
6.7 Telnet.
6.8 World Wide Web.
6.8.1 Hypertext Transfer Protocol.
6.8.2 Web Servers.
6.8.3 Browsers.
6.8.4 Search Engines.
6.8.5 Web Services.
6.9 Hypertext Mark-up Language.
6.10 Usenet.
6.11 Shell PPP/Slip Account. 6.12 Firewalls.
6.13 Intranets.

Categories: Bachelor of Science Tags:

Programming techniques and Algorithms through C

UNIT 1

1. History of ‘C’.

2. The structure of typical ‘C’ program.

3. Integer data types.
3.1 Variable declaration.
3.2 Assignments.
3.3 Arithmetic expressions.

4. Floating-point data type.

5. Character data type.

UNIT 2

6. Logic Control Selection Statements.
6.1 Logical and relational statements.
6.2 If and if…. Else statements.

7. Iterative statements
7.1 While and Do…While Loops.
7.2 For loops.

UNIT 3

8. Input / Output functions scanf () and printf ().

9. Library functions and user defined functions.

10. Arrays.

11. Concepts of Pointers.

Categories: Bachelor of Science Tags:

Ms-Windows and Ms-office

UNIT 1

1. Difference between the DOS and the Ms-WINDOWS user interface. In distinguish between the DOS command driven interface and the Ms-Windows GUI/WIMP interface.

2. MS-Windows Basics.
2.1 The password dialog box.
2.2 The Ms-Windows Desktop. Changing background, Screen saver, Settings and Appearance.
2.3 The Taskbar Repositioning the Taskbar, Changing the Taskbar properties.
2.4 Ms-Windows standard icons. My Computer, Network Neighbourhood, Inbox Recycle Bin, My Briefcase.
2.5 Ms-Windows navigation, Different parts of Windows, Minimize, Maximize, Restore and Close a Window, Moving and Sizing Windows, Opening multiple Windows, Proportional Scrollbars, the File, Edit Menu options in Windows.
2.6 The start menu, Running Programs, Opening previously opened documents, Finding files and Folders, Using MS-Windows Help.

3. Managing files in Ms-Windows. Using My Computer as well as Explorer. File naming conventions and long file names. The explorer two pane view. Expanding and contracting the tree in the left pane. Sorting the files in the explorer. The explorer menus and toolbars. Navigating the Ms-Windows hierarchy. Moving, Copying, Renaming, Deleting and Recovering Files. Using undo and redo features. Operations with multiple files creating new Folders.

4. Creating Shortcuts on desktop – of files, Folders and Drives.

5. Checking the properties of a drive.

6. Ms-Office common features
6.1 The Ms-Office interface.
6.2 Creating a new file, opening an existing file, Deleting and Renaming documents.
6.3 Print preview and printing documents.
6.4 The insertion points, making corrections, spell checks.
6.5 Selecting, Moving and Copying Values.
6.6 Fonts and Format.

UNIT 2

7. MS-WORD BASICS.
7.1 The Ms-Word Windows.
7.2 Entering, Moving, Selecting and Copying text.
7.3 Applying fonts and font styles.
7.4 Creating, Numbering and Bullets.
7.5 Finding and Replacing text.
7.6 Spelling, Grammar and Thesaurus.
7.7 Page formatting, print previewing and printing text.
7.8 Creating headers and footers.
7.9 Constructing tables in Ms-Word.
7.10 Ms-Word Mail Merge.

UNIT 3

8. Introductory Ms-Excel skills
8.1 Entering and Editing cell entries.
8.2 Working with numbers.
8.3 Changing the worksheet layout.
8.4 Formatting Texts, Borders, and Color.
8.5 Printing in Ms-Excel.
8.6 Using functions and references.
8.7 Naming ranges.

9. Charting in Ms-Excel
9.1 Creating Charts.
9.2 Editing and Formatting Charts.

10. Advanced Excel.
10.1 Ms-Excel Financial and Statistical functions.
10.2 Sorting and Creating an Ms-Excel database.
10.3 Creating subtotals in Ms-Excel.
10.4 Using a dataform.
10.5 Creating Pivot tables.
10.6 Using and creating Ms-Excel templates.
10.7 Linking Workbooks.
10.8 Formulas between worksheets.

11. Creating Ms-PowerPoint presentation.

Categories: Bachelor of Science Tags:

Computer Organization

UNIT 1

1. Basic of a Computer System
1.1 View of a computer as an integrated system.
1.2 A brief history of computers.
1.3 Evolution of computer systems.
1.4 Characteristics of a computer system.
1.5 Merits and demerits of a computer system.
1.6 Block diagram of a computer system.
1.7 The working of a computer system.

2. Data Representation.
2.1 Number system
Binary, Octal, Decimal, and Hexadecimal numbers. Conversion of the numbers from one system to another.
2.2 Binary Arithmetic.
Binary addition, and subtraction using signed magnitude, 1’s compliment and 2’s compliment. Binary multiplication and division.
2.3 Alphanumeric codes for character representation. ASCII, SCD and EBCDIC codes.
2.4 Units of memory measurement.

UNIT 2
3. Central Processing Unit.
3.1 Function of CPU
3.2 General register organization.
3.3 Need for stack and stack organization.
3.4 Instruction format.
3.5 Addressing modes.
3.6 Instruction pipelining.
3.7 The Pentium and power PC processors.

4. Input-Output Organization.
4.1 Peripheral device.
4.1.1 Keyboard.
4.1.2 Monitor.
4.1.3 Video display adapter.
4.1.4 Video display modes.
4.1.5 Video resolution.
4.1.6 Printers.
1. Dot matrix printers.
2. Ink jet printers.
3. Laser printers.
4.1.7 Mouse.
4.2 Input-Output interface.
4.3 Asynchronous data transfer.
4.4 Nodes of transfer.
4.5 Direct memory access (DMA).
4.6 I/O processor.

UNIT 3
5. Memory Organization.
5.1 Memory hierarchy.
5.2 Main memory RAM and ROM.
5.3 EDO, FPM, RDRAM, SGRAM, VRAM, WRAM.
5.4 Cache memory.
5.5 Auxiliary memory.
5.5.1 Magnetic Disk.
5.5.2 IDE, ATA, ATAPI, drives.
5.5.3 Magnetic Tape.
5.5.4 CD-ROM.
5.5.5 MO Devices.
5.6 Virtual Memory.

6. System Buses.
6.1 Interconnection structures.
6.2 Bus Interconnection.
6.3 ISA, ESIA, VESA, MCI, SCSI.
6.4 The FCI bus and the Future bus+.
6.5 The PCMCIA standard.

Categories: Bachelor of Science Tags:
Pages: Prev 1 2