Class 10 Info Tech 402 Practical and Project File Download PDF

Class 10 Info Tech 402

Practical and Project File

Class 10 Info Tech 402 Project & Practical File – Question Lists

Practical_Project File #1

Index of Experiment

1. Create a Database named – School

2. Write steps to Create a table Student in Design view with following details.

Field Name	Field Type
Admno	TINYINT (Primary Key)
Name	TEXT (25)
Address	TEXT (30)
Class	TEXT (15)
Sec	TEXT (3)
DOB	DATE
StreamId	TINYINT (FOREIGN KEY)

Table – Student

3. Create a table Stream with following details:

Field Name	Field Type
StreamId	TINYINT (Primary Key)
StreamName	TEXT (25) [Use to store stream – Medical, Non-Medical, Commerce and Arts]

Table – Stream

4. Create a new relation between table Student and Stream named – Student_Stream_Relationship

5. Consider the the following table named “GARMENT”. Write SQL command of SQL for (i) to (iv)

GCode	GName	Size	Colour	Price
111 112 113 114 115 116	TShirt Jeans Skirt Ladies Jacket Trousers Ladies Top	XL L M XL L L	Red Blue Black Blue Brown Pink	1400.00 1600.00 1100.00 4000.00 1500.00 1200.00

(i) To display names of those garments that are available in ‘XL’ size.

(ii) To display codes and names of those garments that have their names starting with ‘Ladies’.

(iii) To display garment names, codes and prices of those garments that have price in the range 1000.00 to 1500.00. Both values are included.

(iv) To change the colour of garment with code as 116 to “Orange”.

6. Create a Form – StudentEntry Form, to insert the record only in student table.

7. Create a Report to display details of all students of Non-Medical.

8. Write key features of following instant messaging application – (a) Google Talk and (b) Telegram

9. Write five best practices used to Ensure Confidentiality of Information.

10. Write any five tips to manage strong passwords.

11. List any five offline blog editors.

Solution of Practical & Project File #1 Class 10 Info Tech.

Practical and Project File #2

Class 10 Info Tech 402 Project & Practical File – Question Lists

Practical_Project File #2

Index of Experiment

1. Create a Database named – Employee

2. Create a table Emp in Design View with following details:

Field Name	Field Type	Description
EmpId	TINTYINT(6) (Primary Key	Employee ID
EName	TEXT (25)	Employee Name
Address	TEXT (30)	Address of Employee
Salary	DECIMAL	Basic Salary
DESGINATION	TEXT (30)	Post on which employee works
DOB	DATE	Date of Birth
DOJ	DATE	Date of Joining
DeptId	TINYINT (FOREIGN KEY)

Table – Emp

3. Create a table Department in Design view with following details:

Field Name	Field Type	Description
DeptId	TINYINT (Primary Key)	Department Id
DName	TEXT (25)	Department Name [ Sales, Manufacturing, Store, Account ]

Table – Department

4. Create a new relation between table Employee and Department named – Emp_Department_Relationship.

5. Create a Form – Employee Entry Form, to Insert, Update & Delete the record in Emp table.

6. Create a Form – Department Entry Form, to Insert, Update & Delete the record in Department table.

7. Create a Report to display details of all Employee of Sales.

8. Write SQL commands, for table name “Teacher”

TEACHERS

NUMBER	NAME	AGE	SUBJECT	DATEOFJOIN	SALARY	GENDER
1	JUGAL	34	COMPUTER	10/01/2019	12000	M
2	PRATIGYA	31	SCIENCE	24/03/2019	20000	F
3	SANDEEP	32	MATHS	12/12/2019	30000	M
4	SANGEETA	35	SCIENCE	01/07/2020	40000	F
5	SATTI	42	MATHS	05/09/2020	25000	M
6	SHYAM	50	SCIENCE	27/06/2021	30000	M
7	SHIV OM	44	COMPUTER	25/02/2021	21000	M
8	SHALAKHA	33	MATHS	31/07/2020	20000	F

a. To show all the information about IT teachers.
b. To list the details of all the teachers who are getting salary between 20000 to 35000.
c. To display the subject of all the teachers whose age is more than 40 years.
d. To display the list of names of all the teachers in alphabetical order.

9. Write key features of following instant messaging application – (a) Facebook Messenger and (b) WhatsApp.

10. State any 03 rules and etiquettes to be followed while chatting on the Internet.

11. Explain the purpose of an offline blog editor.

12. List any three payment tools to use online transactions.

13. Explain different kinds of online threats.

14. Enlist any three basic safety rules to follow at workplace.

Class 10 Info Tech 402 Practical and Project File Download PDF