1.What is database ? What is its significance?
A database is a collection of logically related data. The Database systems store data centrally at one place where from all applications can get the data required. The centralized storage facilitates many advantages like :
a) Reduced Redundancy
b) Data Sharing
c) Data Consistency
d) Standardization
e) Enhance Data Security
2.Write short note on DBMS.
A DBMS is a general-purpose software system that facilitates the process of defining, constructing and manipulating databases for various applications.
3. Write a short note on OOo Base function.
Base is a database management system part of openoffice.org. It offers many features to mange databases. With Base, one can manage all information store in a .odb file.
- Data into separate storage containers called Table
- Add and update table data using form
- Find and retrieve just the data, which is required using queries
- Analyze or print data in a specific layout using Reports.
4.What do your understand by table in a database management system?
In a database management system, various types of objects together mange tand maintain the system. Table are one of them.
5. What is the difference between a flat database and relational database?
In a flat database, all the data is stored in a single file e.g. a spreadsheet.
In a relational Database, data is stored in multiple tables linked via common fields BASE of OpenOffice.org is a relational database.
6. Which of the following is not an example of database?
Cross n Know Game
Employee Payroll Management
Numeric Calculator.
Customer Management System
7. What is Primary key?
A primary key is a field that uniquely identifies the records in a table.
8. What is the difference between a foreign key and a primary key?
A foreign key is a field or fields that refer to a primary key of another table while primary key is a field in a table that uniquely each record in a table.
9. What is alternate key?
The keys that have the unique values for each record but are not selected as the primary keys are called the alternate keys.
10. What is foreign key?
A non-primary key field/attribute in a table is called a foreign key if it is primary key in another table.
11. What is candidate key?
Primary keys and the alternate keys together are called candidate keys. In other words, all fields or field-combination that are eligible to be a primary key, are the candidate keys.
12. What is Queries?
A query is a statement that gives you filtered data according to your conditions and specifications.
13. What is form?
A form is an interface in user specified layout that lets users view, enter, change data directly in the table.
14. What is report?
A Report is an effective way to present data in a printed format. It is a formal, presentable printed document that lists data in formatted manner.
17. What is data type or field type?
The field type tells which type of data (whether numbers or text or date etc.) can be stored in a field. Field type in other words means the data type of the field.
Number Datatype
Integer
Real No
Text datatype
Char
Varchar
Date datatype
Date()
Time datatype
Time()
Date/Time datatypes
Timestamp
Boolean Datatypes
Boolean(stores 0 or 1)
Date field type stores dates only
TIME field type stores time only TIMESTAMP stores both date and time.
The users work on a database using the interface provided to them (such as wizard, design view etc. ). The interface with which users work is called the Front end of the database. However, actual work is done by the Database Server as per the user instructions. This end (of database server) is called the Back end.
18. The centralized storage facilitates many advantages like:
Controlled Redundancy
Data Sharing
Data consistency
Standardization
Enhanced data Security.
19. What do you understand by tables in database management system?
In a database management system various types of object together manage and maintain the system. Tables are one of them. A table is a storage container that stores data pertaining to single object, subject or purpose.
20. What is difference between a flat database and relational database?
In a flat database, all the data is stored in a single file e.g. a spreadsheet.
In a Relational database data is stored in multiple tables linked via common fields e.g. Base of OpenOffice.org is relational database.
What is the purpose of the Database Management System?
Major Organisations choose to work using the Database Management System because it helps the user and the administrator easily manage the data and information on the database. The ultimate purpose of a DBMS is to store and transform data into information to support making decisions.
22. What are the components of the database management system?
The database management system can be divided into four major components, they are DATA, User, Hardware and Software.
What are the types of the database management system?
There are 4 important types of Database Management System, which are as follows:
Network Database
Hierarchical Database
Relational Database
Object-Oriented Database
Important Terms related to Database Management System
Data Manipulation Languages (DML)
Structured Query Language (SQL)
Data Definition Language (DDL)
Transcation Control language (TCL)
Primary Key .
Foreign Key .
Table/Relational.
Query.
Advantages of using a Database Management System:
It allows multi-users to operate the database at a single time, making it more efficient
Securing the data is easy. The administrator can restrict the usage of the database to a few people only.
A single file can manage the entire database which is why duplicity and redundancy cannot happen. This makes the data more consistent and easy to update
Since tables can be created in DBMS, interrelating the data and elements with each other is convenient
The backup and recovery of data is managed by the software, which ensures that the database is secure at all times
.png)
.png)
.png)
.png)
.png)
0 Comments