holidays homework of IP class XI

Holidays Homework 2016-17

Informatics Practices

Class – XI

Dear Students,

As you know now a days computers are used everywhere like metro station, departmental store, student’s Registration for various subjects/ streams at school or collage level, hotel/ restaurants, stationary/ books, movies, banks, offices etc. You must have observed that the purpose of using computers is to maintain/store one or the other type of data into it i.e. database is created and maintained.

You have to collect information about any two such databases and create a table for each with their basic required fields and their datatypes. Also insert minimum 10 records in each table.

Example : You did survey of The Bank of India

DATABASE NAME : TheBankOfIndia

TABLE : Accountdetails

Fields :                 ACCNo                  int                          primary key

                Name                    varchar(15)

                DateAcOpen      date

                AmtDeposit       decimal(8,2)

                Address               varchar(20)

                phoneNo             varhcar(11)

                DateOfBirth       date

Data :

AccNo	Name	DateAcOpen	AmtDeposit	Address	PhoneNo	DateOfBirth
1234	Krishan Lal	2000-07-12	20000.00	R-42, Saket, New Delhi	9878985684	1964-08-20
1235	Neha Rani	2006-09-24	5000.00	H-2/504, Hill View Appt, Vivek Vihar, New Delhi	9878111184	1973-09-02
1307	Kushal Gupta	2000-05-20	25000.00	D-53, Noida, Ghaziabad	9112205684	1970-10-27

***************Happy Holidays***************