Referential integrity is used to maintain the accuracy and consistency of data in a relationship. Sorting means arranging the data in either ascending order or descending order. The properties of character type data are shown below :ġ) Entry Required – if set to yes then it will be a must to insert the value in the field.Ģ) Length – By default length of the field is 10 but the size of the field can be set to maximum length.ģ) Default Value – A default value can be set for a field if the user doesn’t provide any value while entering the values in the table.Ĥ) Format – This property helps to set the format of the data entered in the field such as 91-222-333. The properties of numeric type data are given below :ġ) AutoValue – if set to yes then the field will get the auto numeric values.Ģ) AutoValue – if set to no then the field will not get the auto numeric values.ģ) Length – By default length of the field is 10 but the size of the field can be set to maximum length.Ĥ) Default Value – A default value can be set for a field if the user doesn’t provide any value while entering the values in the table.ĥ) Format – This property helps to set the format of the data entered in the field such as 91-222-333.ĭatabase Management System Class 10 Notes for term 2. There are various properties of fields according to the data type set for each field in the design view.
In the OpenOffice Base, we store data in tables that can be inserted, modified, and removed using suitable options.Ģ) The table will open in Datasheet View.ģ) Insert the required number of records in Datasheet View.ģ) Edit the required record in Datasheet View.ģ) Select the data > right click on selected data > select the Delete option Relational Database Management System Class 10 Notes Session 3 -: SESSION 3: PERFORM OPERATIONS ON TABLE This can be used for storing photos, music files, etc.ĭATE TIME: Used for storing information such as date of birth, date of admission, date of product sale, etc.
Numeric Types: Used for storing information such as mobile number, roll number, door number, etc.Īlphanumeric Types: Used to store information that has alphabets as well as numbers for example address, book summary field, etc.īinary Types: Used for storing data in binary formats. Data types in the OpenOffice base are broadly classified into five categories. Database reduces Duplication of data, in fact, there is no chance to encounter duplicate data in a database.Ģ) Sharing of Data: The users of the database can share the data among themselves.ĭata Types: These are used to identify which type of data we are going to store in the database. ġ) Reduces Data Redundancy: Database reduces data redundancy. Databases are available on database servers and are usually accessed through a command line or Graphic User Interface tools. This is suitable for medium to large amount of data.ĭatabase Servers: These are dedicated computer systems that hold the databases and run only the DBMS and related software. Relational: Data is stored in multiples tables which are linked by a common field.This is usually suitable for less amount of data.
Database Management System: DBMS is a software package with computer programs that control the creation, maintenance, and use of a database.