Database Management System [BCA-402] Syllabus BCA 3rd-IV Sem Syllabus for DAVV Indore Affiliated Institutions

 DEVI AHILYA VISHWAVIDYALAYA (DAVV), INDORE

Bachelor Of Computer Applications (BCA) (Full-Time) 
Fourth-4th-IV Semester Curriculum/ Syllabus 2011-12 Academic Year Onwards

Database Management System – Syllabus 

 

Database Management System [BCA-402] Syllabus /Course contents

Max.Marks:50

Min.Marks:17

UNIT-I

Introduction: purpose of DBMS, view of data, data models: physical model, logical model, conceptual model, hierarchical model,  network model. Object oriented model. database language, Database administrator, database user, overall system structure.

UNIT-II

Entity relationship model: basic concepts, mapping constraints, keys, E-R diagram, weak, entity features, design of an E-R database schema, reduction of E-R schema to table.

UNIT-III

Structured Query Language(SQL):basic structure, set operations, aggregate functions, null values, nested sub queries, data definition language(DDL), data manipulation language(DML), data control language(DCL), transaction control language(TCL),QBE,QUEL.

UNIT-IV

Relational database design: pitfalls in relational database design, decomposition, normalization using functional dependencies, normalization using multivalve dependencies, normalization using joined dependencies. Integrity constraints: domain constraints, entity integrity constraints, referential integrity constraints, assertion, triggers, functions, procedures, cursors.

UNIT-V

Concept of RDBMS, characteristics of RDBMS, Codd’s 12 rules, introduction to oracle tools, security.

Text Book

1. Database system concepts by A.silberschatz, H.F.Korth, and S.Sudershan 5th Edition McGraw Hill

Reference Books

1. An introduction to database management system by Vipin Desai
2. Modern database system by Mcfadden

Objective: To introduce the concept of database management system

Examination: The examination will be of 50 marks. The question will contain questions equally distributed in all units. The balance of the paper will be maintained by including appropriate (numerical/objectives/conceptual/analytical/theoretical) combination of subsection in each question.

Coordinate Geometry of Three Dimensions [BCA-401] Syllabus BCA 3rd-IV Sem Syllabus for DAVV Indore Affiliated Institutions

 DEVI AHILYA VISHWAVIDYALAYA (DAVV), INDORE

Bachelor Of Computer Applications (BCA) (Full-Time) 
Fourth-4th-IV Semester Curriculum/ Syllabus 2011-12 Academic Year Onwards

Coordinate Geometry of Three Dimensions Syllabus 

 

Coordinate Geometry of Three Dimensions [BCA-401] Syllabus /Course contents

Max.Marks:50

Min.Marks:17

UNIT I

Rectangular Cartesian of a point in space. Distance between two points. Cylindrical coordinates, Spherical Coordinates, direction cosines, point of division, orthogonal projections, angle between straight. Examples and exercise. Shortest distance between the straight line, line of greatest slope, Conditions for line intersection. Orthogonal projection of a plane area. Area of triangle in space, volume of triangle in space. Examples and Exercise.

UNIT II

Sphere circle and related topics, Tangent lines and tangent planes to a sphere, radial plane, radial line, coaxial spheres, limiting points. Examples and exercises. Surface and conicoid: transformation of axes, Invariant and decrementing Cube, centre, tangent planes, normal lines, principle directions, Diametrical and principle planes. Examples and exercises.

UNIT III

Conicoid polar planes, Locus of chords, Pole with respect to conicoid. Examples and Exercises. Parabolic, definition and description, Elliptical and Hyperbolic parabolic, Parabolic of revolution, Tangent planes and normal to a parabolic, Diametrical and Conjugate planes, Examples and exercises.

UNIT IV

The Ellipsoid, normal plane to it, director sphere of an ellipsoid, normal line to ellipsoid, diametrical plane to ellipsoid, conjugate diameters and diametrical planes to ellipsoid, locus of chords, polar planes. Examples and Exercises.

UNIT V

The definition and description, finding equation of cone, standard equation, condition of general Quadratic equation representing cone, Angle between two generators, enveloping cone of coincoids, right circular cone. Examples and exercises. The Cylinder definition, equation, right circular cylinder, enveloping cylinder to a coincoid. Examples and exercises.

Text Book

1. Coordinate Geometry of three Dimensions by G. Paria, Scholar Publishing House, Indore

Reference Books

1. Differential Equations, Fourier Series and Analytical Solid Geometry : P.R. Vittal (Margham Publishers)
2. Engineering Mathematics Volume 3: M. K. Venkataraman (National Publishing Co.)
3. Engineering Mathematics Volume 3: R Kandasamy and others (S. Chand and Co.)
4. Advanced Engineering Mathematics : Stanley Grossman and William R. Devit (Harper and Row publisher)
5. Fundamentals of mathematical statistics: S. C. Gupta and V. K. Kapoor (Sultan Chand and sons)

Objective: To Introduce the concept of coordinate geometry of three dimensions.

Examination: The internal examination will carry 20% marks i.e. 10 marks. The external examination will be of 80% marks i.e. 40 marks. The question paper will contain questions equally distributed in all units. The balance of the paper will be maintained by including appropriate (Numerical objective/conceptual/analytical/theoretical) combination of subsection in each question.

Data and Network Communication [BCA -403] Syllabus BCA 3rd-IV Sem Syllabus for DAVV Indore Affiliated Institutions

 DEVI AHILYA VISHWAVIDYALAYA (DAVV), INDORE

Bachelor Of Computer Applications (BCA) (Full-Time) 
Fourth-4th-IV Semester Curriculum/ Syllabus 2011-12 Academic Year Onwards

Data and Network Communication – Syllabus 

BCA-403-Data and Network Communication Syllabus /Course contents

Max.Marks:50    Min.Marks:17

UNIT-I

Data communication system, data communication links, character codes, digital data rates, serial data formats, encoded data formats, telephones systems, error detection & correction.

UNIT-II

Model, data topologies, data switching, type of networks, networking medium twisted pairs, coaxial cable, optical fibers, system network architecture, SNA operating system. Introduction to OSI & TCP/IP.

UNIT-III

Limits of communication, RS449 interface standards, RS422 & RS423, F5K & V0 modems, multiplexing methods, sampling theorem and quantization, delta modulation, digital T carrier, CODEC.

UNIT-IV

Data link protocol, character oriented protocol & bit oriented protocol, network architecture protocols, Ethernet & token ring

UNIT-V

Integrated services & routing protocols, B-ISDN, DSL& ATM, and Internet

Text Book:

1. Computer Network by Andrew S. Tannenbaum PHI, Fourth Edition

REFERENCE BOOKS:

1. Data & Network Communication by Michael A. Miller
2. Understanding of Data Communication & Networks by William A. Shay

Objective: To introduce the concept of data and network communication

Examination: The internal examination will carry 20% marks i.e. 10 marks. The external examination will be of 80% marks i.e. 40 marks. The question will contain questions equally distributed in all units. The balance of the paper will be maintained by including appropriate (numerical/objectives/conceptual/analytical/theoretical) combination of subsection in each question.