Class 10 Info Tech Code 402 NCERT Solution
Unit 3 – Relational Database Management Systems (Basic)
SESSION 1: APPRECIATE THE CONCEPT OF DATABASE MANAGEMENT SYSTEM
ASSESSMENT
Fill in the blanks:
1. A Database is an organized collection of data.
2. A DBMS is a software package that can be used for creating and managing databases.
3. A RDBMS is a database management system that is based on the relational model.
4.Three popular DBMS software are OpenOffice.org BASE, Ms-Access, & MySQL .
5. A PRIMARY KEY is a unique value that identifies a row in a table.
6. Composite Key is a combination of two or more columns.
Short Answer Questions
1. What does DBMS stands for?
Answer: DBMS stands for Database Management Systems
2. What does RDBMS stands for?
Answer: RDBMS stands for Relational Database Management System
3. How is data organized in a RDBMS?
Answer: In RDBMS data is organized in the form of row and column i.e. tabular arrangement, called Table. Table is also know as Relation.
4. State the relationship and difference between a primary and foreign key?
Answer: Foreign key is a non key attribute which value is derived from the primary key of other table. Foreign key is used to establish the relationship between two or more tables with the help of primary key.
Differwnce between Primary Key and Foreign Key
a) Primary key can not contain NULL value while Foreign Key can contain NULL value.
b) Primary key always contain unique value, while Foreign Key can contain duplicate value.
Unit 3 – Relational Database Management Systems (Basic)
Class 10 Info Tech 402 NCERT Book exercise Solution
SESSION 2: CREATE AND EDIT TABLES USING WIZARD AND SQL COMMANDS
ASSESSMENT
Fill in the blanks:
1. A table is a set of data elements that is organized using a model of vertical column (column/attribute) and horizontal row (tuple/record).
2. A column is a set of data values of a particular type, one for each row of the table.
3. A tuple represents a single, data item in a table.
4. Data type are used to identify which type of data we are going to store in the database.
5. There are 2 (two) ways to create a table.
Note : in three ways possible if include the SQL Command – CREATE TABLE
6. Field properties can be set in both the Table Wizard and in Table Design .
Short Answer Questions
1. In how many ways tables can be created in Base?
Answer: Tables can be created in three ways : (a) Create table in Design View (b) Use Wizard to Create Table (c) Use SQL CREATE TABLE command.
2. Why are data types used in DBMS /RDBMS?
Answer: Datatypes are used to identify which type of data (value) we are going to store in the database.
Fields themselves can be of different types depending on the data they contain
3. List datatypes available in Numeric Datatype?
Answer: Numeric data types are used for describing numeric values for the field used in the table of a database.
The different types of numeric data types are:
BOOLEAN, TINYINT, SMALLINT, INTEGER, BIGINT, NUMERIC, DECIMAL, REAL, FLOAT, DOUBLE
4. List datatypes available in Alphanumeric Datatype?
Answer: Alphanumeric datatypes allows to store alpha numeric value i.e. alphabet, numbers, and symbol.
The different types of numeric data types are:
LONGVARCHAR (Memo), CHAR (Text Fix), VARCHAR (Text), VARCHAR_IGNORECASE (Text)
5. Define the structure of a table.
Answer: A table is a set of data elements (values) that is organized using a model of vertical columns(which are identified by their name) and horizontal rows.
A table has a defined number of columns, but can have any number of rows.
Each row is identified by the values appearing in a particular column identified as a unique key index or the key field.
6. Differentiate between Tuples and Attributes of a table.
Answer: A row also called a Record or Tuple represents a single, data item in a table. Each row in a table represents a set of related data, and every row in the table has the same structure.
A column is a set of data values of a particular simple type, one for each row of the table.
The columns provide the structure according to which the rows are composed. For example, cFirstName, or cLastName are fields in a row.
7. Name different Binary data types.
Answer: Binary data types are used for storing data in binary formats. Binary data types in a database can be using for storing photos, music files, etc.
The different types of binary data types are:-
LONGVARBINARY (Image), BINARY (Binary fix), VARBINARY (Binary)
