Syllabus
Annamalai University - DDE - Syllabus - MPhilComputer Science - 120 - Advanced Database and Data Communication
Course II: 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 – Third Manifestation – Guiding Principles, Object Center Relations, Third Manifesto – A New Relational Algebra, subtyping & inheritance – preliminaries, Formal specifications, Multiple inheritance, Tuple and Relational types.
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 Issues = Data Link Layer in public Networks – Networks layer design issued – Network layer in public Network – Transport layer design issues – Transport layer in public networks – Session layer design issues – Session layer in public networks – Presentation layer design issues – Presentation layer in public networks – Application layer design issues – 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.
Reference Books:
1. Hendry F. Korth and Abraham Sileberscharz, “Database System Concepts”, McGraw Hill Inc., 1991
2. Bipin C Desai, “An Introduction to Database Systems”, West Publ. Co. 1990
3. C.J. Date and Hugh Darween, “Foundation for Object/Relational Databases – The Third Manifesto”, Addison – Wesley Inc., 1998, ISDN-0-201-30978-5
4. Andrew S Tanenbaum, “Computer Networks”, 2 nd Edition, Pearson Education, 1998
5. Robert, Orafaji, Dan Harkey and Jerri Edwards, “Essential Client/Server Survival Guide”, John Wiley and Inc., 1994.
6. Alice YH Tsai, “Database System Management and Use”, PHT, 1989
7. R Elmasri and SB Navathe – “Fundamental of Database Systems”, Pearson Education, Redwood City, 2002
8. Douglas C Comer, “Computer Networks & Internet”, Pearson Education