Class X B
Project Allocation List
Group 1
Roll No Name Project 1 (In HTML) Project 2 (In XML) Project 3 ( Database)
5 Manpreet Singh About DPS FilmFestival
3 Manas About Hockey Class Result Data
9 Karanbir Latest Mobile App Vehicle Database
2 Raghav About Punjab Your Class Data
31 Khushi Bollywood Phone Book
Group 2
Roll No Name Project 1 (In HTML) Project 2 (In XML) Project 3 ( Database)
10 Gurkamal Different Operating System Phone Book
8 Inderpartap About Computer Class Result Data
11 Ankush About Hockey FilmFestival
21 Udit Science Vehicle Database
7 Sukhman Cricket Your Class Data
Group 3
Roll No Name Project 1 (In HTML) Project 2 (In XML) Project 3 ( Database)
1 Gurkaran Latest Mobile App Phone Book
23 Gurleen Science Class Result Data
19 Karandeep About Punjab FilmFestival
27 Japjeet Music Vehicle Database
25 Sukham Latest Mobile App Your Class Data
Group 4
Roll No Name Project 1 (In HTML) Project 2 (In XML) Project 3 ( Database)
26 Harnoor Latest Mobile App Different Types of Computer
22 PrincePal Bollywood Phone Book
32 Sukhpreet About Computer Your Class Data
15 Mehtab Music Employee Record
24 Nimrat About Hockey FilmFestival
Group 5
Roll No Name Project 1 (In HTML) Project 2 (In XML) Project 3 ( Database)
4 Nipun Bollywood Employee Record
30 Narinder About Hockey Your Class Data
6 Aastha About Computer FilmFestival
13 Gulkirat About Punjab Phone Book
Different Operating System Different Types of Computer
Group 6
Roll No Name Project 1 (In HTML) Project 2 (In XML) Project 3 ( Database)
18 Harleen About Punjab Different Types of Computer
17 Simerpreet Latest Mobile App Phone book
12 Navroop About Hockey Class Result Data
14 Abhishek Bollywood FilmFestival
Group 7
Roll No Name Project 1 (In HTML) Project 2 (In XML) Project 3 ( Database)
28 Dilraj About DPS Your Class Data
29 Raman Music Employee Record
16 Pardeepak About Computer Class Result Data
20 Hardik Latest Mobile App FilmFestival
Table Structure for different Database and Tables
Database Name EmpDB    
  Table Name EmployeeRecord    
  Column Name Data Type
EmpID Number Automatically Generated Primary Key
EmpName VarChar(100)
DateOfBirth Date
DateOfJoining Date
Salary Float
Department varchar(50)
EmailID varchar(150)
MobileNumber number(11)
Address varchar(200)
Database Name ClassDB    
  Table Name ClassRecord    
  Column Name Data Type
ClassID Varchar(15)
Rollno Number Automatically Generated Primary Key
Name VarChar(100)
Address varchar(200)
TeacherID varchar(50)
Subject1 varchar(50)
Subject2 varchar(50)
Subject3 varchar(50)
subject4 varchar(50)
Marks1 number(3,2)
Marks2 number(3,2)
Marks3 number(3,2)
Marks4 number(3,2)
Database Name PhoneBookDB    
  Table Name PhoneRecord    
  Column Name Data Type
ContactID Varchar(50) Primary Key
FirstName Varchar(50)
LastName Varchar(50)
MobileNumber1 number(11)
MobileNumber2 number(11)
LandlineNumber Number(13)
EmailID Varchar(150)
DateOfBirth Date
Database Name VehicleDB    
  Table Name VehicleRecord    
  Column Name Data Type
NumberPlate varchar(10) Primary Key
TypeofVehicle Varchar(50)
NameOfVehicle Varchar(50)
Color Varchar(50)
Cost float
Average float
fueltype varchar(20)
       
  XML Document Tree Structure
FilmFestival
RegionalFilm
TeleFilm
ActionFilm
Cultural
Your Class Data
School
Class
RollNo
Name
MobileNumber
Different Types of Computer
Computers
SuperComputer
MiniComputer
MainFrameComputer
Laptops