Computer Awareness Study Material – Database Concepts
Computer Awareness Study MaterialBanking AwarenessMarketing Aptitude
A database is a collection of logically related information in an organised way so that it can be easily accessed, managed and updated. Some other operations can also be performed on database such as adding, updating and deleting data. A database could be simple as a single text file with a list of names or it could be complex as a large bunch of text files including some data.
Fundamentals of Database
For defining database, two terms, which are used frequently with database, should be known.
- Data These are raw and unorganised facts that need to be processed such as digital representation of text, numbers, graphical images or sound, e.g. a student’s test score is one piece of data.
- Information When data is processed, organised, structured or presented in a given context to make it useful or meaningful, it is called information, e.g. the class’s average score is the information that can be concluded from the given data.
Types of Database
Databases are of three types, namely as follows
- Network Database In this type of database, data is represented as collection of records and relationships among data are represented as links.
- Hierarchical Database In this type of database, data is organised in the form of tree with nodes. Nodes are connected via
- Relational Database This database is also known as structured database in which data is stored in the form of tables. Where, columns define the type of data stored in the table and rows define the information about the data.
Components of a Database
A database consists of several different components. Each component listed, is called an object. Within the file, you can divide your data into separate storage containers called tables view, add and update table data by using online forms; find and retrieve the data that you want by using queries and analyse or print data in a specific layout by using reports.
Database components are described below
- Tables These are the building blocks or relation of any relational database model where all the actual data is defined and entered. Different types of operation are done on the tables such as storing, filtering, retrieving and editing of data. Tables consist of cells at the intersection of records (rows) and fields (columns), which are describe below
- Field It is an area (within the record) reserved for a specific piece of data. e.g. customer number, customer name, street address, city, state, phone number, current address, etc. Field of a table is also known as column.
- Record It is the collection of data items of all the fields pertaining to one entity, i.e. a person, company, transition, etc. Record of a table is also known as row or a tuple and the number of records in a relation is called the cardinality of that relation.
- Queries These are basically questions based on the data available in a database. A query consists of specifications indicating which fields, records, and summaries a user wants to fetch from a database. Queries allow you to extract data based on the criteria that you define.
- Forms Although you can enter and modify data in datasheet view of tables but you neither control the user’s action very well nor you can do much to facilitate the data-entry process. To overcome this problem, forms are introduced. Like tables, forms can be used to view and edit your data. However, forms are typically used to view the data in an underlying table one record at a time. e.g. a user can create a data entry form that looks exactly like a paper form. People generally prefer to enter data into a well-designed form, rather than a table.
- Reports When you want to print those records which are fetched from your database, design a report. Access even has a wizard to help produce mailing labels.
Database Management System (DBMS)
A DBMS is a collection of interrelated data and a set of programs to retrieve data from a database. It is an organised collection of data viewed as a whole, instead of a group of separate unrelated files.
The primary goal of DBMS is to provide an environment that is both convenient and efficient for user to store and retrieve database information, e.g. MySQL, Oracle, FoxPro, dBASE, SyBase MS-Access. The purpose of database management system is to bridge the gap between information and data.
The basic processes that are supported by DBMS are as follows
- Specification of data types, structures and constraints to be considered in an application.
- Storing the data.
- Manipulation of the database.
- Querying the database to retrieve desired information.
- Updating the content of the database.
Architecture of DBMS
The architecture of DBMS is divided into three levels are as follows
- Internal Level It is the lowest level of data abstraction that deals with the physical representation of the database on the computer. It is also known as physical level.
It defines how the data are actually stored and organised on the storage medium.
- Conceptual Level It is the overall view of the database and includes all the information that is going to be represented in the database.
It describes what type of data is stored in the database, the relationship among the data without effecting to the physical level. It is also known as logical level. - External Level This is the highest level of data abstraction which describes the interaction between the user and the system. It permits the users to access data in a way that is customised according to their needs, so that the same data can be seen by different users in different ways, at the same time. It is also known as view level.
Advantages of DBMS
There are following advantages of DBMS
- Reduction in Data Redundancy The duplication of data refers to data redundancy. DBMS cannot make separate copies of the same data. All the data is kept at a place and different applications refer to data from centrally controlled system.
- Better Interaction with Users In DBMS, the availability of upto-date information improves the data to be access or respond as per user requests.
- Improvement in Data Security DBMS can allow the means of access to the database through the authorised channels. To ensure security, DBMS provides security tools, i.e. username and password.
- Maintenance of Data Integrity Data integrity ensures that the data of database is accurate. In DBMS, data is centralised and used by many users at a time, it is essential to enforce integrity controls.
- Ease of Application Development The application programmer needs to develop the application programs according to the user’s need. The other issues like concurrent access, security, data integrity, etc, are handled by database itself. This makes the application development an easier task.
- Backup and Recovery The DBMS provides backup and recovery subsystem that is responsible to recover data from hardware and software failures.
Disadvantages of DBMS
As there are many advantages, DBMS also have some minor disadvantages.
These disadvantages are listed here
- Cost of Hardware and Software A processor with high speed of data processing and memory of large size is required to run the DBMS software. It means that you have to upgrade the hardware used for file based system. Similarly database software is also very costly.
- Complexity The provision of the functionality that is expected from a good DBMS makes the DBMS an extremely complex piece of software.
Failure to understand the system can lead to bad design decisions, which can have serious consequences for an organisation. - Cost of Staff Training Mostly DBMS are often complex systems so the training for user to use the database is required. The organisation has to pay a lot of amount for the training of staff to run the DBMS.
- Appointing Technical Staff The trained technical persons such as database administrator, application programmers, etc are required to handle the database. You have to pay a lot of amount to these persons. Therefore, the system cost increases.
- Database Failure In most of the organisations, all data is integrated into a single database. If database is corrupted due to power failure or it is corrupted on the storage media, then our valuable data may be lost or whole system stops.
Applications of DBMS
Some applications of DBMS are as follows
- Banking For customer information, accounts, loans and other banking transactions.
- Reservation For reservation and schedule information.
- Universities For student information, course registration, grades, etc.
- Credit Card Transaction For purchase of credit cards and generation of monthly statements.
- Telecommunication For keeping records of calls made, generating monthly bill, etc.
- Finance For storing information about holdings, sales and purchase of financial statements.
- Sales For customer, product and purchase information.
Relational Database
In a relational database, data is stored in different tables with relationships to each other. These tables communicate and share information, which facilitates data search ability, organisation and reporting. In the case of relational database, a Relational Database Management System (RDBMS) performs these tasks. An important feature of this database system is that a single database can be spread across several tables, e.g. Base, Oracle, DB2, SAP SyBase, Informix, etc.
Terms Related to Database
Various terms related to relational database are as follows
- Relation It is a table with columns and rows which represent is the data items and relationships among them. Relation have three important properties a name, cardinality and a degree.
These properties help us to further define and describe relations- Name The first property of a relation is its name, which is represented by the tide or the entity identifier.
- Cardinality The second property of a relation is its cardinality, which refers to the number of tuples (rows) in a relation.
- Degree The third property of a relation is its degree, which refers to the number of attributes (columns) in each tuple.
- Domain It is a collection of all possible values from which the values for a given column or an attribute is drawn. A domain is said to be atomic if elements are considered to be indivisible units.
- Attributes The heading columns of a table are known as attributes. Each attribute of a table has a distinct name.
- Tuples The rows in a relation are also known as tuples. Each row or tuple has a set of permitted values for each attribute.
Keys
Key is one of the important concepts of database. A key is defined as the column or S£t of columns in a table that is used to identify either row of data in a table or establish relationship with another table.
It is also referred as super key, arranging the records either in ascending or descending order.
If a table has id, name and address as the column names then each one is known as the key for that table. The keys are also used to uniquely identify each record in the database table.
Types of Keys
There are mainly four types of keys which are described below
- Primary Key It is a set of one or more attributes that can uniquely identify tuples within the relation. It identifies unique records within a table. The primary key should be chosen in such a way, i.e. its value must not be changed. There should not be duplicacy in the record of primary key. Primary key can be atomic or composite. The field chosen as primary key, cannot accept null value.
- Candidate Key The set of all attributes which can uniquely identify each tuple of a relation, are known as candidate keys. Each table may have one or more candidate keys and one of them will become the primary key. The candidate key of a relation is always a minimal key.
- Alternate Key From the set of candidate keys after selecting one of the keys as primary key, all other remaining keys are known as alternate keys.
- Foreign Key It is a non-key attribute whose value is derived from the primary key of the same or some another table. The relationship between two tables is established with the help of foreign key.
A table may have multiple foreign keys and each foreign key can have a different referenced table. Foreign keys play an essential role in database design, when tables are broken apart then foreign keys make it possible for them to be reconstructed.
Database Languages
There are various types of database languages
- Data Definition Language (DDL) DDL is used to define structure of your tables and other objects in database. In DBMS, it is used to specify a database schema as a set of definitions.
- Data Manipulation Language (DML) DML provides various commands used to access and manipulate data in existing database. This manipulation involves inserting data into data base tables, retrieving existing data, deleting data from existing tables and modifying existing data.
- Data Control Language (DCL) DCL commands are used to assign security levels in database which involves multiple user setups. They are used to grant defined role and access privilages to the users.
Entity- Relationship Model (E-R Model)
It represents the entities contained in the database. It is a diagrammatically representation of entities and relationship between them. It is also known as E-R diagram. Some terms related to E-R model are described ahead
Entity
It is an object that has its existence in the real world. It includes all those things about which the data are collected. “Entities are represented in rectangles.” e.g. customer buys goods, it means customer and goods are entities. ‘
Attributes
It describes the characteristics or properties of entity. In tables, attributes are represented by columns. Attributes are drawn in elliptical shapes, e.g. ITEM entity may contain code and price.
Entity Set
It is a set of entities of the same type that share that same properties or attributes, e.g. Students is an entity set of all student entities in the database.
Entity set is of two types as follow
- Strong entity set It has a primary key or can be easily distinguishable each attributes.
- Weak entity set It does not posses sufficient attributes to form a primary key.
Relationship
It is an association among several entities. A relationship describes how two or more entities are related to each other. It is represented by diamond shape.
Relationship can be divided into three parts
- One to one
- Many to one
- One to many
QUESTION BANK
1. Devices that could be used to input data into a database are
- keyboard, fax roller ball
- mouse, keyboard, monitor
- mouse, keyboard, touch screen
- All of the above
- None of the above
2. DBMS is comprised of tables that made up of rows called…… and columns called
- fields, records
- records, fields
- address, fields
- ranges, sheet
- records, ranges
3. A database that contains tables linked by common fields is called a
- centralised database
- flat file database
- relational database
- All of these
- None of these
4. Which of the following places the common data elements in order from smallest to largest?
- Character, File, Record, Field, Database
- Character, Record, Field, File, Database
- Character, Field, Record, File, Database
- Bit, Byte, Character, Record, Field, File, Database
- None of the above
5. The primary key must be
- numeric
- unique
- multiple
- related
- object
6. Periodically adding, changing and deleting file records is called…… file.
- updating
- upgrading
- restructuring
- renewing
- None of these
7. Items such as names and addresses are considered as
- input
- data
- output
- records
- information
8. Which of the following objects is/are contained in database?
- Table
- Query
- Form
- All of these
- None of these
9. A ……… is a collection of data that is stored electronically as a series of records in a table.
- spreadsheet
- presentation
- database
- Web page
- None of the above
10. In files, there is a key associated with each record which is used to differentiate among different records. For every file, there is atleast one set of keys that is unique. Such a
- key is called
- unique key
- prime attribute
- index key
- primary key
- null key
11. Rows of a relation are called
- relation
- tuples
- data structure
- an entity
- None of these
12. Which of the following types of table constraints will prevent the entry of duplicate rows?
- Primary key
- Unique
- Null
- Foreign key
- None of these
13. The dBASE HI Plus is mostly used for
- office automation
- database management problems
- scientific problems
- calculations only
- None of the above
14. Which out of the following is not a DBMS software?
- dBASE
- FoxPro
- Oracle
- SyBase
- Database 2000
15. The primary key must be a(n) ……….
- numeric
- object
- unique
- related
- None of these
16. Architecture of database can be viewed as
- two levels
- four levels
- three levels
- one level
- None of these
17. In an ER diagram, attributes are represented by
- rectangle
- square
- ellipse
- triangle
- circle
18. In case of entity integrity, the primary key’ maybe
- not null
- null
- Both ‘1’ and ‘2’
- any value
- None of these
19. In an ER diagram, an entity set is represented by a
- rectangle
- ellipse
- diamond box
- circle
- None of these
20. An advantage of the database management approach is
- data is dependent on programs
- data redundancy increases
- data is integrated and can be accessed by multiple programs
- All of the above
- None of the above
21. DBMS helps to achieve
- data independence
- centralised control of data
- selection of data
- Both ‘1’ and ‘2’
- None of the above
22. A set of possible data values is called
- attribute
- degree
- tuple
- domain
- None of these
23. Which type of database, organised the data in the form of tree with nodes?
- Network Database
- Hierarchical Database
- Relational Database
- Multiple Database
- None of these
24. The code that relational database management systems use to perform their database task is referred to as
- QBE
- SQL
- OLAP
- Sequel Server
- None of these
25. In which the database can be restored up to the last consistent state after the system failure?
- Backup
- Recovery
- Redundancy
- Security
- None of these
26. The cardinality property of a relation, refers to the
- number of database
- number of columns
- number of rows
- number of tables
- None of these
27. The smallest unit of information about a record in a database is called a
- cell
- field
- record
- query
- None of these
28. ………. means that the data contained in a database is accurate and reliable.
- Data redundancy
- Data integrity
- Data reliability
- Data consistency
- None of these
29. Which of the following contains information about a single ‘entity’ in the database like a person, place, event or thing?
- Query
- Form
- Record
- Table
- None of these
30. A program that generally has more user-friendly interface than a DBMS is called a
- front end
- repository
- back end
- form
- None of these
31. The database stores information in [SBI PO 2010]
- rows and columns
- blocks
- tracks and sectors
- All of these
- None of these
32. The database administrator’s function in an organisation is [SBI PO 2010]
- to be responsible for the technical aspects of managing the information contained in organisational databases
- to be responsible for the executive level aspects of decision regarding the information management
- to show the relationship among entity classes in a data warehouse
- to define which data mining tools must be used to extract data
- None of the above
33. Key to represent relationship between tables is called [SBI Clerk 2010]
- primary key
- secondary key
- foreign key
- composite key
- None of these
34. A collection of related files is called a [SBI PO 2011]
- character
- field
- database
- record
- None of these
35. A logical schema [SBI PO 2011]
- is the entire database
- is a standard way of organising information into accessable part
- describes how data is actually stored on disk
- All of the above
- None of the above
36. In the relational modes, cardinality is termed as [IBPS Clerk 2011]
- number of tuples
- number of attributes
- number of tables
- number of constraints
- None of the above
37. An E-R diagram is a graphic method of presenting [IBPS Clerk 2011]
- primary keys and their relationships
- primary keys and their relationships to instances
- entity classes and their relationships
- entity classes and their relationships to primary keys
- None of the above
38. A computer checks the ……. of username and password for a match before granting access. [SBI Clerk 2011]
- Website
- network
- backup file
- database
- None of these
39. An entity set that does not have sufficient attributes to form a primary key, is a [IBPS Clerk 2011]
- strong entity set
- weak entity set
- simple entity set
- primary entity set
- None of the above
40. In a relational database, a data structure that organises the information about a single topic into rows and columns, is [RBI PO 2011]
- block
- record
- tuple
- table
- None of these
41. In ER diagram, relationship type is represented by [IBPS Clerk 2012]
- ellipse
- dashed ellipse
- rectangle
- diamond
- None of these
42. To locate a data item for storage is [IBPS PO 2012]
- field
- feed
- database
- fetch
- None of these
43. ……… are distinct items that don’t have much meaning to you in a given context.
- Fields
- Data
- Queries
- Properties
- None of these
44. The particular field of a record that uniquely identifies each record is called the [SBI PO 2012]
- key field
- primary field
- master field
- order field
- None of these
45. provides total solutions to reduce data redundancy, inconsistency, dependence and unauthorised access of data. [IBPS Clerk 2012]
- DBMS
- Tables
- Database
- Protection password
- Centralisation of data
46. ………… is one reason for problems of data integrity. [IBPS Clerk 2012]
- Data availability constraints
- Data inconsistency
- Security constraints
- Unauthorised access of data
- Data redundancy
47. E F Codd represented ……… rules that a database must obey if it has to be considered truly relational. [IBPS Clerk 2012]
- 10
- 8
- 12
- 6
- 5
48. A collection of conceptual tools for describing data, relationships, semantics and constraints is referred to as [IBPS Clerk 2012]
- ER model
- database
- data model
- DBMS
- None of these
49. What is the overall term for creating, editing, formatting, storing, retrieving a text document? [IBPS PO 2012]
- Word processing
- Spreadsheet design
- Web design
- Database management
- Presentation generation
50. When data changes in multiple lists and all lists are not updated. This causes. [RBI Grade B 2012]
- Data redundancy
- Information overload
- Duplicate data
- Data consistency
- Data inconsistency
51. A collection of interrelated records is called a [RBI Grade B 2012]
- utility file
- management information system
- database
- spreadsheet
- datasheet
52. is a primary key of one file that also appears in another file. [IBPS Clerk 2013]
- Physical key
- Primary key
- Foreign key
- Logical key
- None of these
53. is an invalid type of database key. [IBPS Clerk 2013]
- Structured primary key
- Atomic primary key
- Primary key
- Composite primary key
- None of the above
54. Which name is suitable to run a macro at starting time of database? [RBI Grade B 2014]
- Start, exe
- Auto.exec
- Mocro.exe
- Any of these
- None of these
55. A field is a related group of
- cables
- records
- files
- characters
- None of these
56. Oracle is a (n)
- hardware
- high level language
- operating system
- system software
- RDBMS
57. …….. tags, placed on animal’s body can be used to record and track in a database all of the animal’s movements. [IBPS Clerk 2014]
- POS
- RFID
- PPS
- GPS
- Other than those given as options
58. What is a stored question about information in a database? [SBI Clerk 2015]
- Query
- Sort
- Report
- Record
- Field
59. Data duplication wastes the space, but also promotes a more serious problem called [IBPS PO 2015]
- isolated called
- data inconsistency
- other than those given as options
- program dependency
- separated data
60. The purpose of the primary key in a database is to [IBPS Clerk 2015]
- unlock the database
- provide a map of the data
- uniquely identify a record
- establish constraints on database operations
- None of the above
61. Which of the following contains data descriptions and defines the name, data type and length of each field in the database?[IBPS Clerk 2015]
- Data dictionary
- Data table
- Data record
- Data field
- None of these
62. A range checks [IBPS Clerk 2015]
- that only the correct data type is entered into a field
- that all required data are present
- whether a number is within a specified limit
- if the data in two or more associated fields is logical
- None of the above
63. Which of the following will not eliminate the ambiguities of a null value? [IBPS Clerk 2015]
- Define the attribute as required
- Define subtypes
- Define each attribute as having an initial value that is recognised as blank
- Define super types
- None of the above
64. Which of the following statements is true? [IBPS Clerk 2015]
- Logical design is software dependent.
- In a distributed database, database is stored in one physical location
- Conceptual design translates the logical design info internal model.
- Logical design is software independent.
- None of the above
ANSWERS
Leave a Reply