NIOS Class 12 Computer Science Chapter 23 Database Management System

NIOS Class 12 Computer Science Chapter 23 Database Management System Solutions English Medium As Per New Syllabus. to each chapter is provided in the list so that you can easily browse throughout different chapters NIOS Class 12 Computer Science Chapter 23 Database Management System Notes and select need one. NIOS Class 12 Computer Science Question Answers Download PDF. NIOS Study Material of Class 12 Computer Science Notes Paper 330.

NIOS Class 12 Computer Science Chapter 23 Database Management System

Also, you can read the NIOS book online in these sections Solutions by Expert Teachers as per National Institute of Open Schooling (NIOS) Book guidelines. These solutions are part of NIOS All Subject Solutions. Here we have given NIOS Class 12 Computer Science Textbook Solutions, NIOS Senior Secondary Course Computer Science Notes for All Chapter, You can practice these here.

Database Management System

Chapter: 23

Module – 4: Database Concepts, Web Designing

INTEXT QUESTIONS 23.1 

1. Fill in the blanks: 

(a) A ______________ is an organized collection of data. 

Ans: Database.

(b) Having multiple copies of the same data is called ______________. 

Ans: Redundancy.

(c) In a ______________ database the data is organized in two dimensional tables. 

Ans: Relational.

(d) A ______________  key is a group of one or more columns in a table which is used to set relationship of a table with some other table. 

Ans: Foreign.

2. State whether the following statements are true or false: 

(a) A table can have more than one primary keys. 

Ans: False.

(b) A relation can have more than one foreign keys. 

Ans: True.

(c) By normalization we combine all the data into one big table. 

Ans: False.

(d) Conceptual data model and logical data model are the same. 

Ans: False.

(e) In the physical data model we specify the data types of the attributes.

Ans: True.

INTEXT QUESTIONS 23.2 

1. Fill in the blanks: 

(a) Oracle, MySQL, and PostgreSQL are examples of ______________ software. 

Ans: RDBMS.

(b) SQL is an abbreviation for______________.

Ans: Structured Query Language.

(c) ________ is a language specially oriented around ______________ databases. 

Ans: SQL is a language specially oriented around relational databases.

(d) ____________ consists of the commands which are used to create, modify, and remove objects in a database. 

Ans: DDL (Data Definition Language).

(e) Each command in SQL is terminated by a ______________ .

Ans: ; (or) semicolon.

2. State whether the following statements are true or false: 

(a) MySQL is an open source free software. 

Ans: True.

(b) To run MySQL we can enter any password. 

Ans: False.

(c) DDL, DML, and DCL are three different languages. 

Ans: False.

(d) SQL is a case-sensitive language. 

Ans: False.

(e) In SQL, a statement may spread into multiple lines.

Ans: True.

TERMINAL EXERCISE 

1. Create a following table:

(a) Supplier:

Field	Type	Null	Key
SNO	varchar(4)	No	Primary
SName	varchar(20)	Yes
Status	number(4)	Yes
City	varchar(20)	Yes

Ans: CREATE TABLE Supplier (
    
SNO VARCHAR(4) NOT NULL,
    
SName VARCHAR(20),
    
Status NUMBER(4),
    
City VARCHAR(20),
    
PRIMARY KEY (SNO)
);

(b) Parts:

Field	Type	Null	Key
PNO	varchar(4)	No	Primary
PName	varchar(20)	Yes
Color	varchar(10)	Yes
Weight	number(4)	Yes
City	varchar(20)	Yes

Ans: CREATE TABLE Parts (

PNO VARCHAR(4) NOT NULL,

PName VARCHAR(20),

Color VARCHAR(10),

Weight NUMBER(4),

City VARCHAR(20),

PRIMARY KEY (PNO)
);