0% found this document useful (0 votes)
17 views2 pages

Web Programming and DBMS Overview

The document outlines a curriculum for Web Programming and Database Management Systems, covering topics such as internet basics, JavaScript, Active Server Pages (ASP), XML, and database concepts including E-R models and normalization. It details the structure and components of DBMS, various data models, and relational algebra. Additionally, it includes references for further reading on these subjects.

Uploaded by

kunalbarmase88
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
17 views2 pages

Web Programming and DBMS Overview

The document outlines a curriculum for Web Programming and Database Management Systems, covering topics such as internet basics, JavaScript, Active Server Pages (ASP), XML, and database concepts including E-R models and normalization. It details the structure and components of DBMS, various data models, and relational algebra. Additionally, it includes references for further reading on these subjects.

Uploaded by

kunalbarmase88
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Web Programming

Unit I : Internet, Internet users and working, Information on Internet, Requirements for
connecting to Internet, Basic Internet Terms, Introduction to world wide web, Evaluation
of world wide web, basic features, web browsers, popular web browsers, web servers,
HTTP, URL, Search Engines, Search Engines categories, how to use Search Engines,
Searching criterion, Introduction to browsers, Working with e-mail, Parts of e-mail text,
working with messages.
Unit II : Java Script -Introduction , values and variables, operators, loops and various
statements in java script, Date object, Math object, string object, window events,
working with forms, document object, screen object, navigator object, images and
animation, java script objects
Declaration, definition, and referencing. Identifiers scope rules. Recursion. Arrays;
declaration, allocation & accessing, sorting of arrays, JavaScript objects : Math, String,
Date, Number and Boolean.
Documents, forms, Statements, Functions, Objects in Java scripts, events and event
handling, arrays, FORMS, Buttons, Checkboxes, Text fields and text areas.
Unit-III : Introduction to active server pages (ASP) : working of ASP, setup, ASP
objects, file system object, session tracking & cookies. Accessing databases using ASP.
XML: Introduction, Document type definition, XML Schemas, Document Object model,
Presenting XML, Using XML Processors: DOM and SAX
Unit IV : XML displaying an XML Document, Data interchange with an XML Document,
advantages of integrating ASP & XML. Introduction to Java Server Pages (JSP):
scripting standard actions, Directives. Custom tag libraries. JSP & XML case study:
advantages of integrating JSP & XML.

References:
1. Deitel, Deitel & Nieto, Internet and Worldwide Web how to Program, Pearson Education
2. Techmedia : The Complete Java Script
3. Eddy et. al. : "Teach Yourself Active Server Pages" (IDG)
4. R Bangia, Second edition Internet and web design, firewall media
5. R Bangia Multimedia and Wed technology
6. Internet and web designing, Macmillan
7. Ivan Bayross Web Enabled Commercial Application Development Using HTML, DHTML, JS,
Perl
8. Kathhleen Kalata, Internmet Programming with VBScript and Java Script. Thomson
Publication
9. Robert W. Sebesta, Programming the World Wide Web Pearson
10. Pekowsky : "Java Server Pages" (Pearson Education)
Database Management System
UNIT- I :
DBMS : Definition: Databases, DBMS, Problems with traditional file processing system,
Objectives of the database systems, Three level architectures of DBMS, Component of
DBMS, Database Administrator, Database Users, Data model, Different types of data
models, Concepts of Hierarchical, Network Models.
UNIT-II :
E-R Models : Basic Concepts, Entity, Attributes, Relation Ship, Mapping, Keys, Weak
and Strong Entity Set, Problems on E-R Diagrams, Extended E-R Features:
Specialization, Generalization, Aggregation, Problems on Reduction of an E-R Schema
to Tables, Tabular representation of Strong, Weak entity Sets and Relationship Sets.
UNIT-III :
Relational Model: Structure, Relational Algebra, Fundamental Operations, Set –
Intersection, Natural Join, Division and Assignment Operation. Extended Relational
Algebra Operations, Aggregate Functions.
UNIT–IV :
Functional Dependency: Functional Dependency, Fully Functional Dependency, Partial
Dependency, Transitive Dependency, Multi Valued Dependency. Normalization, Normal
Forms ( 1NF, 2NF, 3NF, BCNF, 4NF, 5NF). Problems on Normal forms.

Common questions

Powered by AI

The 'window' object in JavaScript represents the browser window, serving as the global context for all JavaScript, and is the highest level object in the DOM hierarchy. It provides methods for manipulating the browser window like opening new windows, setting time intervals, and managing cookies. Conversely, the 'document' object represents the web page loaded in the browser, and it provides functionalities for accessing and modifying HTML content, handling forms, and managing events directly related to the content of the document. While 'window' is more about the environment, 'document' is about the content .

JavaScript provides several mechanisms for handling events, including event listeners and event handler properties, which allow functions to be executed in response to user actions like clicks, key presses, or mouse movements. Event-driven programming is significant as it allows applications to respond dynamically to users’ interactions, leading to interactive and user-friendly web experiences. The ability to asynchronously handle events supports smooth user interfaces that can react to actions without reloading the entire page .

The basic requirements for connecting to the Internet include a computer or smart device, a modem or network card, an active internet connection (from an ISP), and a web browser to access web pages. These components are essential as the device enables users to interact with the internet, the modem or network card facilitates data transmission, the internet connection provides the necessary link to the wider web, and the browser presents web data in human-readable forms .

Integrating ASP with XML offers several advantages, such as improved data interchange and easy maintenance, since XML can be used to standardize data formats and ASP to dynamically generate web pages. This combination allows for separation of data presentation and data handling logic, facilitating rapid presentation changes without modifying data structure. However, challenges include increased complexity in development and processing overhead due to the need for extended parsing and transformation tasks. Effective integration requires careful planning and understanding of both XML and ASP capabilities .

HTTP (HyperText Transfer Protocol) and URLs (Uniform Resource Locators) are fundamental to how the World Wide Web functions. HTTP is the protocol used for transferring web pages on the Internet; it sets rules for requests and responses between clients and servers, thus enabling web interaction. URLs, on the other hand, are the address system of the web, specifying the location of resources and the method to access them, making HTTP requests possible. Together, they enable seamless browsing by determining where and how data is retrieved and displayed in browsers .

Relational algebra provides a set of fundamental operations like selection, projection, union, and join that form the basis for database queries, allowing queries to systematically manipulate and retrieve data from tables. Extended relational algebra introduces more advanced operations such as aggregate functions, intersection, and division, providing enhanced computation capabilities to handle more complex queries. While basic relational algebra focuses on set-based operations, extended relational algebra supports more sophisticated data manipulations, improving the expressive power of query languages used in databases .

Normalization in Database Management Systems is crucial for minimizing data redundancy and dependency by organizing fields and table relationships in a database. It divides large tables into smaller, related tables through a series of normal forms (1NF, 2NF, 3NF, BCNF, etc.), each of which has specific constraints to remove redundancy. This process greatly improves database performance by reducing anomalies, ensuring data integrity, and optimizing queries by minimizing duplication, which results in faster data retrieval and increased efficiency in storage management .

Search engines are pivotal in making information accessible on the internet by indexing web pages and providing users with the capability to search for information based on keywords and phrases. They categorize searches through algorithms that assess relevance, authority, and recency of web content, returning the most pertinent results for user queries. Different categorization techniques, like organic search ranking and paid advertisements, are used to sort and display results, enhancing users' ability to find accurate information efficiently .

The three-level architecture in DBMS comprises the internal level, conceptual level, and external level. This architecture enhances data abstraction by separating the physical storage of data from user interactions. The internal level concerns physical data storage, the conceptual level provides a unified view of the data across entities, and the external level represents different user views. This stratification allows for greater flexibility, as changes in storage structures do not affect user views and vice versa, facilitating maintenance, customization, and scalability without disrupting user operations .

Data models in DBMS, such as hierarchical, network, and relational models, are frameworks for defining how data is structured and managed. The hierarchical model organizes data in a tree-like structure, suitable for representing many-to-one relationships. The network model allows more complex many-to-many relationships, providing flexibility in representing data paths. The relational model favors a table-based structure, revolutionizing data manipulation with powerful query capabilities and ease of use. Each model's significance lies in its approach to data complexity and scalability, impacting database design and efficiency .

You might also like