Database Q/Ans

What id data?

Data consists or raw facts and figures, Data consists of letter, sound, image or video within the computer.

 What is information?

Processed data is known as information. Using a data base program or software, they are converted into the meaningful result called information.

 What is database?

A database is a collection of interrelated data. It refers to an organized collection of data stored on a computer in such a way that its content can easily be accessed, updated and queried upon with the help of a software program.

Example = Banks must have systems for keeping track of customers and their accounts.

What is rdbms (Relational Database Management System)?

Relational Database Management System (RDBMS) is method of viewing information from several, separate database that relate to one another through the keyword or values. The main advantage of RDBMS is that we can simultaneously use more than one database to see information stored in them.

List importance of database

Database stores the data.

Computerized database saves data from being lost.

Computerized database protects from unauthorized access and use of the data.

Data can be stored in a small area or space in computerized database.

What is dbms? Write its types.

A database management system is a collection of programs that enables you to store, modify, and extract information from database.

Any four database management systems are as follows:

• Relational Database Management System
• Hierarchical Database Management System
• Network Database Management System
• Object Oriented Database Management System

Write advantage of database.

• The advantages of database are as follows:
• Database saves the data.
• Data can be stored in a small area or space in computerized database.
• Database protects from unauthorized access and use of data.
• It saves data from being lost.

List feature of dbms

• Easy to access data
• Ease to modify data
• Delete existing data.
• Organize the data in proper sequence.
• Sorting and indexing of data.
• Easy queries in data.
• Retrieve the data easily.
• Print the formatted reports, labels etc.
• Linking between two or more databases.
• It can be used as SQl (Structured Query Language)

What is ms-access?

 Microsoft Access is a Relational Database Management System which comes as an integral part of the MS Office Suite of applications.

 What is data shorting?

The process of arranging the data smallest to largest and largest to smallest in table or in ascending or descending order is known as data sorting.

 What is query?

Query is a way of extracting information from a database, usually by using certain criteria or requesting certain data. It is request for database records that fit specified criteria.

 
What is the use of query?

The uses of query are as follows:

i. A query can count the amount of records that meet the certain criteria.

ii. It can also be used to extract data to a separate table or delete data, change data and many other things.

What is select query?

Select query is a query in which the relevant data from a table is selected and displayed. It allows the user to retrieve data from one or more tables and displays the results in a datasheet where the user can update the record.

 
What is parameter query?

Parameter query is a query that when run displays its own dialog box prompting the user for information, such as criteria for retrieving records or value the user want to insert in a field. For example: the following criterion selects records for which the records for which the value for the Obtain_mark field is greater than 70: Obtain_mark>70

What is a dynast?

A dynast is a set of data that is dynamically linked back to the database. Instead of having the query result stored in a temporary table, where the data cannot be updated directly by the user, the dynast allows the user to view and update the data contained in the dynast

What is attributes?

Attributes refer to a single data item related to a database object. The database schema associates one or more attributes with each database entity.

Explain different type of query

The different types of queries are as follows:

a. Select query = It is a query in which the relevant data from a table is selected and displayed. It allows the user to retrieve data from one or more tables and displays the results in a datasheet where the user can update the record.

b. Parameter queries = It is a query that when run displays its own dialog box prompting the user for information, such as criteria for retrieving records or value the user want to insert in a field.

c. Crosstab queries = A query that calculates a sum, average, count, or other type of total for data that is grouped by the two types of information is known as crosstab queries.

d. Action queries = A query which performs an action with the records /fields selected by the query. Action queries includes delete, Append, update and make table queries.

Explain different object of MS-access.

a. Table = Table are the core database object, used to store information. The tables are the containers for all the data in a database. In a table, data are arranged in a columns and rows.

b. Queries = Queries means to ask question about the data presented in the table. BY using queries, we can view records or data, modify the content of table and a lot more. It is a way of retrieving and editing information according to the condition asked. It is a strong tool using in searching of desired data from database.

c. Forms = A form is a database object used to enter and edit data in a table. Form can be used to edit the records of underlying tables or to enter new records.

d. Reports = A report is especially formatted collections of data organized according to our specification for summarizing and printing. They are the means to present the information as a printed document.

e. Macros = When macro is executed, it executes one or more database commands automatically. They are meant for automating the task that is done over and over again.

f. Modules = Modules are pieces of code used to impose particular behaviours to your application programmatically. They are more flexible and extensive than macros, although they are usually written for various and particular circumstances.

  Explain different data types of Ms Access

The different data types are as follows

Text = A text field contains up to 255 characters or it can set the length in the field size, text data type can include numbers letters and symbols.

Memo = This type of field holds an unlimited amount of text. It can accommodate 65, 535 characters.

Number = This type of field allows only the numbers to be entered.

Date/Time = This field type only allows date and time to be entered. It occupies 8 bytes.

Currency = This field allows to enter currency.

AutoNumber = This type automatically generates and insert the unique number in the new row.

Yes/No = It allows the user to select Yes or No when completing the field.

OLE object = It allows to link to binary data or files.

Hyperlink = It allows to create a hyperlink. It stores up to 64,000 characters.

Lookup Wizard = The lookup wizard creates a field that allows the user to choose a value from a list of values by using a list box or combo box.

Write difference between filter & query.

Filter

• A filter cannot be saved as separate object.
• A filter cannot be used for displaying the records of more than related table at once.
• A filter cannot be used for performing calculation on values of numeric fields.

Query

• A query can be saved as separate object.
• A query can be used for displaying the records of more than related table at once.
• A query can be used for performing calculation on values of numeric fields.

Write differences between primary key and foreign key 

Primary Key

• It is a column or a set of column that can be used to uniquely identify a row in a table.
• A table can have a single primary key that can reference different tables.

Foreign Key

• It is a column or a set of column that refer to a primary key or a candidate key of another table.
• A table can have multiple foreign key that can reference different tables.