BE 8th sem IT syllabus of RTMNU (Nagpur university – Information Technology)

81T47 DISTRIBUTED DATABASES & OBJECT ORIENTED DATABASES
UNIT-I:
Distributed databases features – distributed database management systems – review of databases and nomputer n~tworks, levels of
distribution transparency. reference architecture, type of data fragmentation, distribution transparency for read only applications and update applications. distributed database access primitives and integrity constraints.

UNiT-Il:
Distributed database design, a frame work for distributed database design, the design of database fragmentation, the allocation of
fragments. translation global queries to fragment queries, equiv~tlenpe ttansformation for queries. transforming global qUeries into
fragment queries. distributed grouping and aggregate function evaluation, parametric queries

UNIT-Ill:
Query optimization, problems in query Optiintza~i0fl. objectives in query process optimization. simpler representation of queries,
model fo~ query ootiniization,- join query, general queries, ‘concept of two phase commit, resolving dmsrHbumcd transaction.
concept of replication, snapshot on replication and multimaster replication. conflict resolution in multimaster replication,
concurrency control and database recovery in d~tributed databases.

UNIT-lV~
The evolution of object oriented concepts. object-oriented concepts, characteristics of an objectoriented data mode!, object schemas,
class-subclass relationships. interobject relationships, late and early binding, support for vcrsioning. Similarities & differences
between 00DM and other data models, features of air object-oriented databases management system, OODBMS architectural
approaches-extended relational model approach, semantic database approach, object oriented database programming language
extension approach. DBMS generator approach. obiect definition language and object query language.

UNIT-V:
OODBMS architectures, performance issues in OODBMS. application selection for OODBMS, database design for an object
relational database management system (ORDBMS). structured types & ADTs. object identity, extending ER mode!. using nested
collections, storage and access methods, query processing, query optimisation. design and architecture of POSTGRES. distributed
computing in CORBA and BiB.

TEXTBOOKS:
I. Distributed data bases principles and systems by Ceri & Pelagatti (McGraw Hill Pub!.)
2. Fundamentals of Database System by Eliniskv & Navathe (3Td Ed. Addison W,.elsey)
3. Object Oriented Database System – Approaches & Architectures by C.S.R. P~ablui (PHE Pub.)

REFERENCE BOOKS:
I. Database System – Design Jinpicinentation & Management by Peter Rob & Carlos Coronel. (Course Tech.)
2. Database Management Svstenis by Raghu Ramakrishnan & Johannes Gehrke.(McGraw Pub.)
3. Oracle Si Distributed Database Replication Manual.

81T48 WEB TECHNOLOGIES

UNIT-1
Basic tools of internet access, emaiL ftp. news. ww~. anarchie, introduction to internet programming, sockets : connections, atiributesm donmins. types and protocols (sockets), creating and closing sockets, socket communication. client server application using C on linux
platform. .1

UNIT-Il:
Standard use for www documents on internet. HTTP. MIME. SGML. DTD. MTNL, URL, URI. HTML tags special chatacters im ~ ibiLs forms thL h pLrllnks I-fJ’ML URLs serving HTML pages.

UNIT-Ill:
CGI : CGT prograrnrni1~g using C.

UNIT-IV :
XML basics, understanding markup languages. sructures and syntax, valid Vi. well formed XML, DTD (document type Definition) classes.

UNIT-V:
Scripting XML, XML processor. parent child reJarionship XML as a data, data type in XML, XML namespaces, linking with XML simple link. the HTML way. XSL : XML. with stie: style sheet basics, XSL basics. XSL SN he sheets

TEXTBOOKS:
I. XML in action web technology by William J. Pardi (P1-LI Pub.)

REFERENCE BOOKS:
I. Step by Step XML by Michael J. Young (Pill Pub.)
2. Designing Interactive Web sites by James L. Mohier & John M Duff (Thomson Learning)
PRACTICALS based on above syllabus
1. Socket programming and CGI using C’ on linux platform.
2. HTML, XML web page designing.

81T47 DISTRIBUTED DATABASES & OBJECT ORIENTED DATABASES

UNIT-I:
Distributed databases features – distributed database management systems – review of databases and  computer n~t~vorks, levels of distribution transparency. reference architecture, type of data fragmentation, distribution transparency for read onl~ applications and update applications. distributed database access primitives and integrity constraints

UNiT-lI
Distributed database design, a frame work for distributed database design, the design of database fragmentation, the allocation of fragments. translation global queries to fragment queries, equivalence ttansformation for queries. traiistbrniing global queries into fragment queries. distributed grouping and aggregate function e’.’aluanon. parametric queries

UNIT-Ill:
Query optimization, problems in query optimization. objectives in query process optimization, simpler representation of queries, model to: query optimization,- join query, general queries, concept of two phase commit, resolving disviburcd tran~action. concept of replication, snapshot on replication and multimaster replication, conflict resolution in ~nu1timaster replication, concurrency control and database recovery in d~tributed databases.

UNIT-IV
The evolution of object oriented concepts. object-oriented concepts, characteristics of an objectoriented data model, object schcmas, class-so bclass relationships. interobject relationships, late and early binding, support for versioning. Similarities & differences between 00DM and other data models, features of an object-oriented databases management system. OODBMS architectural approachesextended relational model approach, semantic database approach, object oriented database
programming language extension approach. DBMS generator approach, object definition language and object query language.

UNIT-V:
OODBMS architectures, performance issues in OODBMS, application selection for OODBMS, database design for an object relational database management system (ORDBMS). structured types & ADTs. object identity. extending Ek model, using nested collections, storage and access methods, query processing, query optimisation. design and architecture of POSTGRES. distributed computing in
CORBA and EJB.

TEXTBOOKS:
I. Distributed data bases principles and systems by Ceri & Pelagatti (McGraw Hill Pubi.)
2. Fundamentals of Database System by Elmiskv & Navathe (3~ Ed. Addison W,elsey)
3. Object Oriented Database System – Approaches & Architectures by C.S.R. P~abhu (Pt-il Pub.)

REFERENCE BOOKS:
I. Database System – Design Implementation & Management by Peter Rob & Carlos Coronel,
(Course Tech.)
2. Database Management Systems h~’ Raghu Ramakrishnan & Johannes Gehrke,(McGraw Pub.)
3. Oracle 8i Distributed Database Replication Manual.

81T50/1 ENTERPRICE RESOURCE PLANNING

UNIT-I:
INTRODUCTION Business needs and ERP, ERP as an overview, entries as an overview, Benefits of ERP, ERP and related technologies, ERP architecture, business process reengineering, data warehousing, data mining, on line analytical processing supply choice management.

UNIT-ii:
ERP ll’~WLEMENTATJON : Client server architecture and ERP, ERP implementation life cycle, implementation m~hodologies, ER? implementation – The hidden cost, organizing implementations, vendors, consultants and users, contracts with vendors, consultants and employees, proj ect management and monitoring. After ERP iinplementatiou.

UNIT-Ill:
THE BUSINESS MODULE : Business models in an ER? package, finance, manufacturing human resource, plant maintenance, materials management, quality management sales and distribution.

UNIT-IV:
Selection of ERP, SWOT anaiysis of various ER? products supply chain enabled ERP.

UNITT-V:
ER? and Electronic Data Interchange (EDI) integration, ERP in manufacturing and nonnianufactunng industries.

TEXT BOOKS:
1. ER.P Demystifled by Aleris Leon (TMH Pub.)
2. Enterprise Resource Planning by Parag Diwan and Sunil Sharma (Pentageon Pren.)

This entry was posted in RTM NU on by .

About Jitendra

Sr. Consultant at Cognizant Technology Solutions. Have more than 6 years of experience in technologies and frameworks like Salesforce, Node.Js, JAVA, PHP, JSP, Struts, Hibernate, C#, ASP.NET, SQL Server. Also many javaScript libraries like AngularJs, JQuery, JQuery Mobile, BootStrap. Connect : Linked In

  • shivani poddar

    please post syllabus for mobile communication and e-commerce

  • Bhagyashri

    Plz post the syllabus for all the subjects foc.mcom,ecom,

  • poonam wandhe

    post syllabus for mcom and ecom

  • Anjali

    plz post the syllabus for all the subject…