Unit 2: Operating Web Based ApplicationsE-Commerce, E-Governance & Web Project Management
Complete curriculum guide based on Pages 48–80 of the CBSE Class XII Student Handbook. Master online reservation platforms (IRCTC case study), national e-governance portals (india.gov.in, NeGP), e-commerce workflows (Flipkart), online learning architectures, and structured project development lifecycles with Hangman, Quiz, and Bill Calculator case studies.
india.gov.in.Online Reservation Systems & IRCTC Case Study
An online reservation system enables users to search availability, compare options, book tickets, select seat/berth preferences, make digital payments, and receive instantaneous booking confirmations over the internet 24x7.
- Convenience: Book anytime from home without standing in physical queues.
- Price Comparison: Portals like MakeMyTrip compare multi-airline fares side by side.
- Choice Making: View seat matrices, select lower/upper berth, choose dietary meals.
- Instant Confirmation: E-tickets delivered in seconds to mobile/email.
- Less Staffing: Automated web forms handle millions of bookings without large counter staff.
- No Spatial Restrictions: Operations can run out of a small basement or single office.
- Global Market Reach: Customers anywhere in the world can reserve services 24/7.
CBSE Case Study: Step-by-Step IRCTC Train Reservation (Pages 51–55)
- Access
https://www.irctc.co.in/using an encrypted web browser. - Register a new account or log in with verified username and password.
- Enter travel details in Plan My Travel: Origin, Destination, Journey Date, Class (1A, 2A, 3A, SL), and Quota.
- Review train timetable, arrival/departure schedules, and seat availability (marked with 'x' if unavailable).
- Fill passenger particulars: Name, Age, Gender, Berth Preference, and Senior Citizen concessions.
- Review fare summary and select payment method (Credit/Debit Card, Net Banking, UPI gateway).
- Generate and download the electronic reservation slip (e-ticket) sent via SMS/Email.
E-Governance Initiatives in India: NeGP & Portals
E-Governance is the application of Information and Communication Technology (ICT) tools to deliver government services, exchange information, communicate transactions, and integrate departmental services for citizens and businesses with high transparency.
Developed and maintained by the National Informatics Centre (NIC) under the Ministry of Electronics and IT (MeitY). Acts as a single-window portal providing unified access to government schemes, citizen forms, passport applications, and RTI filings across all ministries.
A comprehensive directory indexing all official government websites across sectors (agriculture, education, commerce, finance), constitutional bodies, the Supreme Court and judiciary, state legislatures, and Union Territory administrations.
Web Application Project Management & Case Studies
A project is an organized undertaking to produce a unique product or service within defined boundaries, finite resources, and a specific timeline. Web development follows four essential phases:
Feasibility (Technical & Economic) and Scope (features list, goals, limitations).
Site map navigation, database table structures, page layout (header, sidebar, content).
Backend database SQL scripts, frontend forms (HTML/CSS), and data connectivity.
Validating functionality with sample datasets, debugging, and user acceptance sign-off.
Database Architecture for the 3 Textbook Case Studies
Scope: Player selects category, game picks random word, shows dashes, allows 7 letter guesses.
Category(Category_Id VARCHAR(10) [PK], Category_Name VARCHAR(20))
Words_in_Category(Category_Id VARCHAR(10) [FK], Word VARCHAR(15))
Scope: Student registration, category selection, timed question attempt, automated scoring report.
Admin_Login(Username VARCHAR(10) [PK], Password VARCHAR(10))
Quiz_Info(Question_No INT [PK], Subject VARCHAR(10), Question VARCHAR(40), Option1, Option2, Option3, Option4, Answer)
User_Info(Username VARCHAR(10) [PK], Password, Name, Email_id, Gender, Dob)
Result(Username VARCHAR(10) [FK], Marks INT, Category VARCHAR(10))
Scope: User account registration, billing data entry, automated billing amount & late fine computation.
User_Info(Username VARCHAR(10) [PK], Password, Name, Email_id, City, State, Country, Pin_Code, Mobile_Number)
Bill_Info(Username VARCHAR(10) [FK], Name, Address, City, State, Country, Pin_Code, Month_Dispatch, Duration_of_Bill, Mobile_Number)
Official Unit 2 Practice Questions
Q1. What was the main milestone that laid the foundation for e-Governance in India in 1987?
Q2. Which of the following portals serves as a single window access to all Indian Government services as a Mission Mode Project?
Q3. Which phase of web project management focuses specifically on evaluating whether the project is technically and economically feasible?
Q4. In the Hangman Game database design, which two tables are constructed to manage game data?
Q5. What is a major advantage of online reservation systems for service providers?
Q6. In the Online Quiz database schema, which table stores the administrator credentials for question management?
Q7. Which educational website was founded in 2006 to provide free video tutorials in mathematics, science, and economics?
Q8. What is the primary purpose of the 'goidirectory.nic.in' portal?
Q9. Which of the following is NOT one of the four main phases in web application project development?
Q10. In the Online Bill Calculator case study, what are the primary database tables used to store customer and billing data?
Unit 2 Operating Web FAQs (AEO & Board Focus)
Build Web & Database Projects with Expert Mentors
TeacherColab offers 1-on-1 practical mentoring for Class 12 IT web applications, relational table modeling, and board viva preparation.