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

Comment for Annamalai University – DDE – Syllabus – MPhilComputer Science – 120 – Advanced Database and Data Communication
—————————————————————————————–
Automobile Technology
Sir I want to study above stated course pl inform the syllabus and details.
Thanks/Regards
Titus
—————————————————————————————–

Home > Annamalai University - Directorate of Distance Educatio, Master of Philosophy (MPhil) - Computer Science > Annamalai University – DDE – Syllabus – MPhilComputer Science – 120 – Advanced Database and Data Communication
  1. rkdeepa
    November 23rd, 2009 at 00:27 | #1

    Network Security (351)

    Kindly provide the syllabus book for Network Security (351) ASAP.

  1. No trackbacks yet.