Semester : III
S-3.1 Database Management Systems:
Basic Concepts : Database & Database Users, Characteristics or the Database, Database Systems. Concepts & Architecture, Data Models, Schemas & Instances, DBMS Architecture & Data Independence, Data Base Languages & Interfaces, Data Modeling using the Entity-Relationship Approach, E-R Diagrams. Data Dictionary.
Relational Model, Languages & Systems : Relational Data Model Concepts, Relational Model Constraints, Relational Algebra, SQL – A Relation Database language, Data Definition in SQL, View & Queries in SW=QL, Specifying constraints & Indexes In SQL, Specifying Constraints lit Indexes in SQL, A Relation Database Management Systems ORACLE/MS-SQL Server.
Conventional Data Models & Systems : Network Data Model, Membership types & options in a set, DML for the network model, Navigation within a network database, Hierarchical Data Model, Hierarchical Database structure HSAM,HISAM,HDAM , HIDAM organization, DML for hierarchical model, Overview of IMS.
Relational Data Base Design : Functional dependencies, Normal forms based on primary keys (1 NF, 2NF & BCNF), Loss-less Join & Dependency preserving decomposition, De-normalization.
Concurrency Control & Recovery Techniques : Concurrency Control Technique, Locking Techniques, Time stamp ordering, Granularity of Data Items, Recovery Techniques, Recovery concepts, Database backup and recovery from catastrophic failures.
Concepts or Object oriented data base management systems, Data Warehousing, Data Mining.
1.Date, C.J., “An Introduction to Database Systems”,Narosa Publishing House, New Delhi.
2.Desai. B., “ An Introduction to Database Concepts”, Galgotia Publications, New Delhi.
3.Elmsari and Navathe, “Fundamentals of Database Systems”, Addison Wesley, New York.
4.Ullman, J.D., “Principles of Database Systems”, Galgotia Publications, New Delhi.
5.Leon Brothers, “Database Management System”, Vikas Publications.
S-3.2 Computer Communication Net Works :
Introduction to Computer Network :
Advantages of networks, structure of the communications network, point-to-point and multidrop circuits, data flow and physical circuits, network topologies, topologies and design goals. Hierarchical topology, horizontal topology(Bus), star topology, ring topology, mesh topology. The telephone network, switched and non switched options, fundamentals of communications, theory, channel speed end bit rate, voice communications end analog waveforms, bandwidth and the frequency spectrum, connecting the analog and digital worlds, digital signals, the modem, asynchronous en synchronous transmission.
Wide are and local network, connection oriented and connection less networks, classification of communications protocols, Time division Multiple Access (TDMA), Time division Multiplexing (TDM), carrier sense (Collision) systems, token passing, peer-to-peer priority systems; priority-slsot, carrier sense (collision free) systems, token passing (priority) systems.
Layerd Protocols and the OSI model : Golas of Layered Protocols, network design problems, communication between layers, Introduction to standard organizations and the OSI model, standards organization, layers of OSI, OSI status.
Polling /Selection Protocols : Character and bit protocols, binary synchronous controls (BSC) HDLC, HDLC options, HDLC frame format, code transparency and synchronization, HDLC transmission process, HDLC subsets, SDLC, Protocol conversion.
Local Area Networks : Why LANs, Primary attributes of a LAN, Broadband and Base band and base LANs, IEEE LAN standards, relationship of the 802 standards to the ISO/CCITT model, connection options with LANs, LLC and MAC protocol data units, LAN topologies and protocol, CSMA/CD and IEEE 802.3, token ring (Priority), token bus and IEEE 802.4, metropolitan area networks (MANs), ANSI fiber distributed data interface, COMA and mobile communication.
Switching and Routing in Networks : Message switching, packet switching, when and shen not to use packet switching, packet routing,
Packet switching support to circuit switching networks.
TCP/IP : TCP/IP and Internetworking, example of TCP/IP operations, related protocols, ports and sockets. The IP address structure, major features of IP,IPV6,IP data gram. Major IP services. IP source routing, value of the transport layer, TCP, Major features or TCP, passive and active operation, the transmission control block (TCB), route discovery protocols, and examples of route discovery protocols, application layer protocols.
Personal Computer Networks : Personal Computer communications characteristics, error handling, Using the personal computer as a server, file transfer on personal computers, personal computers and local are networks, network operating systems (NOSs).
1.Black. U., “Computer Networks. Protocols, Standards and Interfaces”, Prentice Hall of India.
2.Tannmenbum. A;, “Computer Networks”, Prentice Hall of India.
S-3.3. IT Elective – I
S-3.4. Environmental Management
1.Environment : Elements, Process and Factors
2.The Atmosphere – Composition, structure and factors (Light & Temperature)
3.Environmental Toxicology – Pollution and Pollutants.
Air Pollution – Nature and Source of Pollution Methods of Monitoring and Control of Air Pollution. Acid Rain, Photochemical smog, Green House Effect and Global warning, Ozone depletion, Effect of Pollutants on climatic changes.
Noise Pollution – Nature and Source of Noise Pollution, Noise Exposure limits and Standard, Noise control and abasement measures.
Radioactive and Thermal Pollution : 4. Computer Environment Management-Influence of Temperature, Humidity, Dist and noise interference on the performance of computer system. Promotion and maintenance.
5Central Theme of Environmental Management, Environmental Management Plan (EMP), Environment Act 1986 and Earth Summit 1992, Environmental Acts & Laws.
6.Global and National Environmental Protection
7.Application of Systems Analysis Procedure to Ecology – Approach Mathematical Models and tools, Environment Research.
1.Odum, E.P., “Fundamentals of Ecology”, W.B., Saunders Company, London.
2.Vishwapremi, K.K.C., ”Fundamentals of Toxicology”, Central Book Depot, Allahabad.
S.3.5 Oracle & Elective Lab