Punjabi University 2008 M.Phil Computer Science Advanced Database and Data Communication - Question Paper

M.Phil( computer science Syllabus)

DDE - Syllabus – M.phil (Computer Science)

Course: Advanced Database and Data Communication

Unit I: RDBMS & ORDBMS

Relational Database design – Pitfalls in Relational Database design – Normalization – Functional Dependencies – Normalization using multi-valued dependencies – Join dependency – Domain Key Normal Form – Mapping Relational Data into Files – 3rd Manifestation – Guiding Principles, Object Center Relations, 3rd Manifesto – A New Relational Algebra, subtyping & inheritance – preliminaries, Formal specifications, Multiple inheritance, Tuple and Relational kinds.

Unit II: Query Processing

Query Interpretation – Equivalence of Expressions – Query Processing Cost – Query Optimizer. Basic concepts of Database recovery, Concurrency control - Database Security and Integrity, Distributed Database

Unit III: Web Based Technologies

Introduction – World Web Fundamentals; Getting connected – History of web and Internet – working principles URL’s – Internet services – Multimedia – and the web; Text, Audio, Graphic images, full-motion digital video, Hypertext, CDROM’s on World Wide Web, communication on web access – ISPS – TCP/IP and Windows – SLIP and PPP – Bandwidth – Dedicated connections – Modems and web - Browsers – Netscape Navigator – Electronic Mail: Accessing Internet Electronic Mail and on-line services – Cyberspace – Web Server Hardware. Setting up a web server – Hardware requirements – Dedicated phone lines – Web Server software: Typical software package – Installation Execution – HTML – Introduction – Using HTML – Structural, Character, Paragraph, List, Specific formatting – Hyperlink

Unit IV: Advanced Data Communication ( LAN)

ISDN – Data Link Layer Design problems = Data Link Layer in public Networks – Networks layer design issued – Network layer in public Network – Transport layer design problems – Transport layer in public networks – Session layer design problems – Session layer in public networks – Presentation layer design problems – Presentation layer in public networks – Application layer design problems – Access and Management – Email – Application layer in Public Networks.

Unit V: Client Server

Basic concepts of Client Server – Upsizing – Downsizing – Right Sizing – Characteristics – Filer Servers – Database Servers – Transaction Server – Groupware Servers – object server middleware client/server building blocks – Operating System server based services – External services – server scalability – remote procedure calls – multi-servers, SQL Database servers – server architecture – multithread architecture – Hybrid architecture - Stored procedures – Triggers – Rule – Client/Server Transaction Models – Chained and Nested Transaction – Transaction processing monitors = Transaction Management Standard. Database connectivity solutions: ODBC- The need for database connectivity.

Earning:   Approval pending.