Discuss the components of a database. -Technology

1 Answer

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, characters or facts represented by value. Most of the organizations generate, store and process a large amount of data. The data acts as a bridge between the hardware and the software. Data may be of different types such as User data, Metadata and Application Metadata.SoftwareIt is a set of programs that lies between the stored data and the users of the database. It is used to control and manage the overall computerized database. It uses different types of software such as MySQL, Oracle etc.HardwareIt is the physical aspect of the computer, telecommunication, and database, which consists of the secondary storage devices such as magnetic disks, optical discs etc., on which data is stored.UsersIt is the person, who needs information from the database to carry out its primary business responsibilities.The various types of users which can access the database system are as follows:Database Administrator (DBA)A person, who is responsible for managing or establishing policies for the maintenance and handling of the overall database management system is called DBA.Application ProgrammersThe people, who write application programs in programming languages to interact and manipulate the database are called application programmers.End-userA person, who interacts with the database system to perform different operations on the database by inserting, deleting etc., through menus or forms.

Related questions

Description : What is the need of a database? Discuss briefly. -Technology

Last Answer : Database is usually a large collection of data which is organized in a very effective and efficient manner. It allows the user for rapid search and retrieval of required information.

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.

Description : Sakshi is preparing a lecture on output device like monitor. Discuss. (i) Give some advantages of the output device ‘monitor’. -Technology

Last Answer : (i) (a) Relatively cheap and reliable.(b) Can display text and graphics in a wide range of colors.(ii) (a) No permanent copy to keep the results as it will disappear when the computer is switched OFF.(b) Unsuitable for users with visual problems.

Description : Discuss the structure of an E_mail message. -Technology

Last Answer : In an E-mail message, you will see the following fields which are as follows: To Mail-id of a recipient. Cc (Carbon copy) It allows you to send the same mail message to multiple recipients at ... Send button Once you complete the E-mail message, click at Send button to send the E-mail message.

Description : Discuss the features of Title bar. -Technology

Last Answer : Title bar displays the name of the window or software program. This bar can maximize, minimize, restore or close a window. It is also used to move a window using any pointing device.

Description : Discuss the advantages and disadvantages of advertising in different forms of media. -Technology

Last Answer : Student should be able to discuss following five points During the process of Adaptation:i. A new narrative is formed.ii. The new narrative in formed another medium.iii. Script-writer and Director ... context of the original may change.v. The new narrative is an interpretation of the original.

Description : Discuss the five fundamental categories, PMEST, with the help of suitable example. -Technology

Last Answer : P: Personality-the facet indicates the core point of the subject at handM: Matter-reflects substance or material of the subjectE: covers problem, action including methods, functioning, and other ... their subdivisions, continent, etc.Time: represents periods, like, years, decades, centuries, etc.

Description : Discuss the purpose of HTTP briefly. -Technology

Last Answer : Full form of HTTP is Hypertext Transfer Protocol. It is the foundation of data communication for the World Wide Web.

Description : Discuss the significance of Bluetooth technology. -Technology

Last Answer : Bluetooth is a wireless technology standard for exchanging data over short distances using short-wavelength radio waves.It is used in building personal area networks (PANs).Now a days many gadgets and peripheral devices are Bluetooth enabled like Speakers, mouse, headphone, printer etc.

Description : Discuss the significance of having clause with group by statement with suitable example. -Technology

Last Answer : Sometimes we do not want to see the whole output produced by a statement with Group By clause. We want to see the output only for those groups which satisfy some condition. It means we want ... the total amount of all type of transactions, it will only display the total of credit transactions only.

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

Last Answer : Field. Record. is the answer

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.

Description : Give any one use of database. -Technology

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

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.

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.

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.

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

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

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.

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

Last Answer : 1. High complexity2. Database failure

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.

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.

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.

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.

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.

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

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.

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

Last 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 ... centralized location.2. It provides security to the personal information of the school, stored in it.

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.

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

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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

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

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

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

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.

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.

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.

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.

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

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

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:

Description : A text field is initially 40 characters long and one record has an entry in this field in MS_Access database. -Technology

Last Answer : Since the new field length is 20 characters long. So, this field will contain only left 20 characters including spaces and the remaining data will be discarded. Thus, the data from the right side of the field will be lost.

Description : What is database template? Give the description of five templates, used in Microsoft Access 2007. -Technology

Last Answer : A template is a complete tracking application with predefined tables, forms, reports, queries, macros, and relationships. Each template creates a complete end-to-end solution that you can use ... to create a projects tracking database to track multiple projects and assign tasks to different people.

Description : In a MS_Access database, which component is not present? (a) Formula Bar (b) Tables -Technology

Last Answer : (a) MS-Access contains various components, i.e. Tables, Queries, Forms, Reports, Macros and Modules.