Things that you need to keep in mind while designing the fields for a table.

Q4. What are the things that you need to keep in mind while designing the fields for a table?

Ans. You need to decide the type and number of fields required for the tables in your database. Each table in a database contains data or information about a single entity. This information is inserted in the fields of the table. Read More …

Points do you need to remember while designing a database.

Q2. What points do you need to remember while designing a database?

Ans. The points that you should keep in mind while designing the database are:

  1. Determining the purpose of your database: You have to decide why you need to create a database and how you intend to use it. You also need to know what type of information you want from your database.
  2. Determining the tables you require: Tables are one of the most important elements of a database. To create a well-organized database, you have to define the tables for it. Keep in mind the following points while determining your tables:
    1. Each table provides information about a single entity.
    2. A table does not contain duplicate values. Read More …

What is a relational database system.

Q5. What is a relational database system?

Ans. Relational Database refers to a database in which data is stored in multiple tables. these tables are linked to one another through common fields.

A Relational Database.

A relational database is shown in figure. in figure , you can see a database that contains several tables. these tables are linked to each other through a common fields.

Define DBMS and its functioning.

Q2. Define DBMS and its functioning.
Ans. DBMS is a program that controls the creation, maintenance, and use of a database. In DBMS, data is stored centrally. This allows users to easily access and share data as a common resource. DBMS helps in the integration of stored data by preventing inconsistencies and duplicate data. In addition, accessing, retrieving, and modifying the stored data is easy. DBMS also allows multiple users to access the data at the same time. Moreover, the access to the database is controlled. In other words, unauthorized users are prevented from accessing the database.

PRACTICE QUESTIONS

Practice Questions

Q1. Identify the software that helps you in sending and receiving an e-mail:

  1. MS-Office
  2. Internet Explorer
  3. MS-Outlook
  4. None of these

Ans. (c)

Read More …

Web browser and Web server.

Q7.

  1. What do you understand by the terms Web browser and Web server?
  2. Expand the following domain name extensions used with the Web address:
    • .com
    • .gov

Ans.

  1. A Web browser is an application that is used to access or retrieve information or resources from the Internet. On the other hand a Web server is a computer or a group of computers that stores Web documents. In other words, a Web server can be defined as a package or container that contains a huge amount of information.
    • .com – Commercial organizations
    • .gov – Government organizations

 

Two advantages of Internet.

Q6.

  1. Write two advantages of using the Internet.
  2. What is a Web server?

Ans.

  1. Two advantages of using the Internet are:
    • Helps in research and homework.
    • Helps in shopping.
  2. A Web server is a computer or a group of computers that stores Web documents. In other words, a Web server can be defined as a package or container that contains a huge amount of information.

Solved Questions-I

Q1. A software used to open Web pages on the Internet is called a ____.

  1. Browser
  2. Portal
  3. Surfer
  4. Provider

Ans. a. Browser

Q2.

  1. What is Home Page? Explain briefly.
  2. abc@mnc.co.in represents a ____.
  3. Give one advantage of Electronic Mail over ordinary mailing method.
  4. What is a Web Server and how is it related to a web page?
  5. Name one Internet Service Provider in India.
  6. What is the function of FTP.
  7. Give the full form of the following terms:
  8. Lal owns a factory which manufactures automobile spare parts. Suggest him the advantages of having a web page for his factory. Read More …