X Chapter - 3

Class X : Chapter3

● LONG ANSWER TYPE QUESTIONS.

a.        Database Management System has got many applications like:

         Reservation system: To reserve the train or air tickets from any location centralised information storage and retrieval system is needed. Database Management System allows performing such operations quickly in a networked system.

         Banking services: Using Database Management System banks can easily perform all types of account related transactions from any of their branch.

         Business Industry: Large organisations can be centralised their operations in one place using such type of system.

         Government Service: Various government services like income tax, return filing, etc. can be easily accessed from anywhere.

          Insurance Service: Insurance industry can use it to provide services to their customers like depositing, premiums, claim settlements from any of the location.

b.   Relational database system provides more flexibility to store data in the form of multiple tables which are linked together on a common field. It reduces the complexity of designing and storing data in the tables and moreover, it can be retrieved quickly and easily when needed.

c.       The possible fields in a table can be:

                StudID Text

                Student_name Text

                Class      Text

                RollNo   Text

                Event    Text

                Character            Text

                Event incharge Text

                 StudID field can be used as primary key field in this table.

	d.            Tcode	Text	No numeric calculations are needed
	T_Name	Text	names are always character based
	Address	Text	Alphanumeric value is to be stored
	Designation	Text	Text type value is to be stored
	Date of Joining	Date/Time	Dates to be stored
	Subject	Text	it is an alphanumeric value

The two ways to create tables in Access are:

Using Datasheet View: This is one of the quickest and easiest ways to design the tables as you can add fields to this table as per your needs and can enter data in the datasheet view.

Using Design View: This method is more flexible and it provides facility to design tables as per the requirements. But as no help is provided by the Access for designing these tables, user need to think very carefully about the fields required and their properties so that only valid data can be stored in these.

● Application Based Questions.

a.     (i) The required fields in the personal details of the employees can be EmpID, name, sex, designation, department, address, phone_no, mailed, date of birth, date of joining.

	(ii) EmpID		Text
		Name	Text
		Sex	Text
		Designation	Text
		Department	Text
		Address	Text
		Phone_no	Number
		e-mail	Text
		Date of birth	Date/time
		Date of joining	Date/time

                 (iii) EmpID field can act as a primary key field for table.

b.    (i) Data types of these fields are as follows:

				Roll no		Number
			Name		Text
			Address		Text
			Date of birth		Date/time
			Phone_no		Text
			Date of admission		Date/time

     (ii)  Rollno field field act as a primary key beacuse it stores unique roll numbers of each student.  

     (iii) Field name         Data type

            Father Name         Text

            Sex                       Text

      (iv) Date/time data type

      (v)  Phone no. field is defined as Text Data type because no calculations are to be performed on this field.

      c.         

	(i)         ItemID	Text
	ItemName	Text
	ItemStock	Number
	ItemDOP	Date/time
	QuantityPurchased	Number

             (ii) ItemID and ItemName can act as a primary key field in the table.