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 …
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:
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.
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:
Each table provides information about a single entity.
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.
What do you understand by the terms Web browser and Web server?
Expand the following domain name extensions used with the Web address:
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.