Define database management system. Write two advantages of using database management system for school. -Technology

Define database management system. Write two advantages of using database management system for school. -Technology
by

1 Answer

Answer :

Database Management System (DBMS) is a collection of programs that enable users to create, maintain database and control all the access to the database. The primary goal of the DBMS is to provide an environment that is both convenient and efficient for the user to retrieve and store information.The advantages of using DBMS for school are as follows:1. In school, DBMS is used to store the data about students, teachers and any other related thing at a centralized location.2. It provides security to the personal information of the school, stored in it.
by

Related questions

Write any two advantages of using database. -Technology

Description : Write any two advantages of using database. -Technology

Last Answer : 1. Can ensure data security.2. Reduces the data redundancy.

Write any two uses of database management system. -Technology

Description : Write any two uses of database management system. -Technology

Last Answer : 1. DBMS is used to store data at a centralized location.2. It is used to minimize data redundancy and data inconsistency.

Mention any two example of common Database Management System. -Technology

Description : Mention any two example of common Database Management System. -Technology

Last Answer : MySQL, Ingres, Postgres, Oracle etc.

RDBMS provides relational operators to manipulate the data. Here, RDBMS refers to (a) Record Database Management System -Technology

Description : RDBMS provides relational operators to manipulate the data. Here, RDBMS refers to (a) Record Database Management System -Technology

Last Answer : (b) RDBMS stands for Relational Database Management System, which provides the operator to manipulate the data stored in the database table.

Explain Database Management. What are the features of DBMS? -Technology

Description : Explain Database Management. What are the features of DBMS? -Technology

Last Answer : It refers to the software that is responsible for storing, maintaining and utilising a database. It enables a user to define, create and maintain the database and provide controlled access on it. A ... Data security e.g. MS-Access, Corel Paradox, Lotus Approach, MySQL, OpenOffice.org Base etc.

Define query in the context of database. -Technology

Description : Define query in the context of database. -Technology

Last Answer : A query is an inquiry into the database using the SELECT statement. These statements give you filtered data according to your conditions and specifications indicating the fields, records, and summaries which a user wants to fetch from a database.

In a school, a database named “school” is created in mysql whose password is “cbse”. Smith is trying to add a new record of a student having details -Technology

Description : In a school, a database named “school” is created in mysql whose password is “cbse”. Smith is trying to add a new record of a student having details -Technology

Last Answer : import mysql.connectormydb = mysql.connector.connect{host='localhost',user='root',passwd='cbse',database='school'}mycursor = mydb.cursor()mycursor.execute('INSERT INTO student values(3,'Michelle', 'Agartala');')mydb.commit()

Write the advantages of using Unicode to represent text. -Technology

Description : Write the advantages of using Unicode to represent text. -Technology

Last Answer : Unicode encoding standard provides the basis for processing, storage and interchange of text data in any language in all modern software and information technology protocols.

Write the advantages of using Unicode to represent text. -Technology

Description : Write the advantages of using Unicode to represent text. -Technology

Last Answer : Advantages of using Unicode to represent text are as follows :1. Allows for multilingual text using any or all the languages that you desire.2. Text in any language can be exchanged worldwide

In a Bank’s database, there are two tables ‘Customer’ and ‘Transaction’ as shown below. Write a query to display customer’s name who has -Technology

Description : In a Bank’s database, there are two tables ‘Customer’ and ‘Transaction’ as shown below. Write a query to display customer’s name who has -Technology

Last Answer : (i) Select cust_name from customer c,transaction t where c.Acc_No=t.Acc_No and Transaction_Type= 'Debit';(ii)Select cust_name, t.* from customer c, transaction t where c.Acc_No=t.Acc_No;(iii) ... total amount of all type of transactions, it will only display the total of credit transactions only.

Write the relationship between a database and a table. -Technology

Description : Write the relationship between a database and a table. -Technology

Last Answer : A database contains multiple tables whereas, a table cannot exist outside a database.

What is the utility of primary key in database? Write distinct features of primary keys. -Technology

Description : What is the utility of primary key in database? Write distinct features of primary keys. -Technology

Last Answer : The primary key is used to uniquely identify the record in a database. It can be a column or a set of columns in the table.Main features of the primary key are as follows:1. It must contain a unique value for each record of the table.2. It does not contain null values.

Write the steps to design a database. -Technology

Description : Write the steps to design a database. -Technology

Last Answer : Steps to Design a DatabaseThere are various steps to design a database which are as follows:Step 1 Determine the purpose of your database The first step of designing a database is to determine the ... that the database structure meets the goals you needed, add all your existing data to the tables.

Define Database. List advantages of database system.

Description : Define Database. List advantages of database system. 

Last Answer : A database is an organized collection of data so that it can be easily accessed, managed and updated. Advantages of database system are the following:  1. Controlling ... Providing Backup and Recovery facilities is provide by DBMS for recovering from hardware or software failures.

What are the main purposes of a database system? -Technology

Description : What are the main purposes of a database system? -Technology

Last Answer : • Storage of information.• Retrieval of information quickly.• Sorting, selecting data that satisfies certain criteria (filtering).• Produce the report in some standardized and readable format.

There arecertain packages that allow people to define data items, place these items in particular records, combine therecords into designated files and then manipulate and retrieve the storeddata. What arethey called? A. Data storage system B. Database management system (DBMS) C. Batch processingsystem D. Data communication package E. None of the above

Description : There arecertain packages that allow people to define data items, place these items in particular records, combine therecords into designated files and then manipulate and retrieve the storeddata. What arethey ... (DBMS) C. Batch processingsystem D. Data communication package E. None of the above

Last Answer : Database management system (DBMS)

What is an E_mail? Write two advantages of an E_mail. -Technology

Description : What is an E_mail? Write two advantages of an E_mail. -Technology

Last Answer : E-mail (Electronic mail) is a popular Internet service, which is used for sending or receiving messages electronically over a computer network.The advantages are as follows:1. E-mail is a cost-effective medium of communication.2. Ease of use.

Write down the advantages of networking for an office. -Technology

Description : Write down the advantages of networking for an office. -Technology

Last Answer : Various advantages of networking for an office are as follows:1. Using network we can store our files in many places or computers for data recovery purpose from a disk crash.2.It provides sharing of ... , i.e. they can be centralised and can be accessed by anyone from the central system itself

Identify the topology shown below. Write 2 advantages of this topology. -Technology

Description : Identify the topology shown below. Write 2 advantages of this topology. -Technology

Last Answer : Star Topology Two advantages of star topology are as follows :1. Easy to detect faults and remove It.2. Failure to single system will not bring down the entire network.

List the advantages of using CSS. -Technology

Description : List the advantages of using CSS. -Technology

Last Answer : It controls layout of many documents from one single style sheet.It has more precise control of layout.It applies different layouts to different media-types.It has numerous advanced and sophisticated techniques to be applied on web page

Give any two disadvantages of the database. -Technology

Description : Give any two disadvantages of the database. -Technology

Last Answer : 1. High complexity2. Database failure

If a piece of data (field value) is stored in two places in the database, then storage space -Technology

Description : If a piece of data (field value) is stored in two places in the database, then storage space -Technology

Last Answer : False If a piece of data is stored in two places in the database, then storage space is wasted and changing the data in one spot will cause data inconsistency.

In a Bank’s database, there are two tables ‘Customer’ and ‘Transaction’ as shown below. -Technology

Description : In a Bank’s database, there are two tables ‘Customer’ and ‘Transaction’ as shown below. -Technology

Last Answer : (i)Acc_No, Cust_Phone(ii)All the columns having capability to become Primary Key are known as Candidate Keys.(iii)Acc_No(iv)Trans_Id

What is part of a database that holds only one type of information? -Technology

Description : What is part of a database that holds only one type of information? -Technology

Last Answer : Field. Record. is the answer

A software that searches through a database of Web pages for particular information is known as (a) domain -Technology

Description : A software that searches through a database of Web pages for particular information is known as (a) domain -Technology

Last Answer : (d) Search engine searches a software through a database of Web pages for particular information.

Give any one use of database. -Technology

Description : Give any one use of database. -Technology

Last Answer : A database is used to store logically related information in the table.

What is database? Give example. -Technology

Description : What is database? Give example. -Technology

Last Answer : A collection of related information organized as tables is known as the database, e.g. INGRES, MySQL etc.

What is field in database? Give an example. -Technology

Description : What is field in database? Give an example. -Technology

Last Answer : A field is an area, reserved for a specific piece of data. It is also known as an attribute, e.g. Customer_Name.

What is a primary key in database? Give an example. -Technology

Description : What is a primary key in database? Give an example. -Technology

Last Answer : A field which uniquely identifies each record in a table is known as the primary key. e.g. emp id is the primary key of the Employee table.

What is the default extension of OO.o not zero BASE database? -Technology

Description : What is the default extension of OO.o not zero BASE database? -Technology

Last Answer : The default extension of OO.o BASE database is .odb.

Below is the list of various types of application softwares: A. Database B. Desktop publishing C. Drawing -Technology

Description : Below is the list of various types of application softwares: A. Database B. Desktop publishing C. Drawing -Technology

Last Answer : 1. Drawing2. Word processing3. Desktop publishing4. Spreadsheet5. Database

Discuss the components of a database. -Technology

Description : Discuss the components of a database. -Technology

Last Answer : A database consists of several components. Each component plays an important role in the database system environment.The major components of the database are as follows:DataIt is raw numbers, ... perform different operations on the database by inserting, deleting etc., through menus or forms.

Consider the following database Student:Roll No. First Name Last Name Class Marks Obtained(%) Scholarship Awarded -Technology

Description : Consider the following database Student:Roll No. First Name Last Name Class Marks Obtained(%) Scholarship Awarded -Technology

Last Answer : 1. 95.42. Mohan Garg and scholarship awarded is 50000.3. 54. 6

The director of a company uses a database to store data about job title. This is a part of the database given below: -Technology

Description : The director of a company uses a database to store data about job title. This is a part of the database given below: -Technology

Last Answer : 1. 62. 63. Secretary4. Finance department and their Payroll Numbers are A621 and M502.

Which of the following is not an example of database? (a) Cross knot game -Technology

Description : Which of the following is not an example of database? (a) Cross knot game -Technology

Last Answer : (c) Numeric calculator because it is used to calculate the numeric numbers only as it is unable to store data.

Database is a combination of (a) hardware and software -Technology

Description : Database is a combination of (a) hardware and software -Technology

Last Answer : (a) A database consists of several components. These are data, software, hardware, and user.

Operations performed on a database are controlled by (a) user (b) hardware -Technology

Description : Operations performed on a database are controlled by (a) user (b) hardware -Technology

Last Answer : (a) Users are those persons, who need the information from the database to perform operations.

Database is made up of all the following components except (a) tables (b) queries -Technology

Description : Database is made up of all the following components except (a) tables (b) queries -Technology

Last Answer : (d) A database is made up of tables, queries, and forms.

All the information about a thing or a person is known as a (a) database (b) file -Technology

Description : All the information about a thing or a person is known as a (a) database (b) file -Technology

Last Answer : (d) A record refers to a raw of data, which represents a complete set of information in a table.

Which of the following is not the main building block of a database? -Technology

Description : Which of the following is not the main building block of a database? -Technology

Last Answer : (a) The main building blocks of database are tables, queries, forms and reports.

Which of the following best describes a form? (a) Form enables people to enter or view data in a database easily -Technology

Description : Which of the following best describes a form? (a) Form enables people to enter or view data in a database easily -Technology

Last Answer : (a) The form enables people to enter or view data in a database easily.

DBMS is a program that controls the creation, maintenance and use of database. Here, DBMS referred to -Technology

Description : DBMS is a program that controls the creation, maintenance and use of database. Here, DBMS referred to -Technology

Last Answer : (c) Here, DBMS stands for Database Management System.

A database that contains tables linked by common fields is called a (a) Centralized database (b) Flat file database -Technology

Description : A database that contains tables linked by common fields is called a (a) Centralized database (b) Flat file database -Technology

Last Answer : (c) Relational database stores data in the form of tables which are linked by common fields.

In database, all the data are stored at a ……………. location. -Technology

Description : In database, all the data are stored at a ……………. location. -Technology

Last Answer : In database, all the data are stored at acentralizedlocation.

What is the default extension of a MS_Access database? -Technology

Description : What is the default extension of a MS_Access database? -Technology

Last Answer : The default extension of an MS-Access database is .accdb.

The database is managed by a software package known as …………….. . -Technology

Description : The database is managed by a software package known as …………….. . -Technology

Last Answer : The database is managed by a software package known as DBMS.

Database is the collection of logically non_related data. -Technology

Description : Database is the collection of logically non_related data. -Technology

Last Answer : False A database is the collection of integrated and logically related data.

A database can have only one table. -Technology

Description : A database can have only one table. -Technology

Last Answer : False No, database does not have a limit on the number of tables. It depends on the disk space.

Give five names of database templates used in MS_Access 2007. -Technology

Description : Give five names of database templates used in MS_Access 2007. -Technology

Last Answer : Assets, Contacts, Events, Faculty and Issues.

How will you create a blank database in MS_Access 2007? -Technology

Description : How will you create a blank database in MS_Access 2007? -Technology

Last Answer : Creating a Blank DatabaseTo create a new blank database, you need to perform the steps which are as follows:Step 1 Start Microsoft Access 2007, then Getting Started with Microsoft Office Access page will ... in the first empty cell in the Add New Field column as shown in the following figure: