Class – 10th
IT (402)
Book : Domestic Data
Entry Operator
UNIT 3: DATABASE MANAGEMENT SYSTEM
Fill in the blanks
SESSION 1:
APPRECIATE THE CONCEPT OF DATABASE MANAGEMENT
SYSTEM
Fill in the blanks
1) A database is an organized collection of data. You can visualize it as a container of information.
2) Database programs such as Microsoft Access, OpenOffice.org Base, and MySQL Well known DBMSs include Oracle, IBM DB2, Microsoft SQL Server, Microsoft Access, PostgreSQL, MySQL, FoxPro, and SQLite.
3) A DBMS (database management system) is a software package with computer programs that controls the creation, maintenance, and use of a database.
4) Flat File means Data is stored in a single table. Usually suitable for less amount of data.
5) Relational means Data is stored in multiple tables and the tables are linked using a common field. Relational is suitable for medium to large amount of data.
6) A database is an organized collection of data.
7) A _Microsoft Access, / OpenOffice.org Base,/ MySQL _is a software package that can be used for creating and managing databases.
8) A _Microsoft Access / OpenOffice.org Base is a database management system that is based on the relational model.
9) Three popular DBMS software are Oracle, IBM DB2, Microsoft SQL Server, Microsoft Access, PostgreSQL, MySQL, FoxPro, and SQLite.
10) A Primary Key (PK) is a unique value that identifies a row in a table.
11) Composite Key is a combination of _one or more columns.
12) A foreign key is a column or a set of columns in one table that references the primary key columns in another table.
13) The database management systems contain multiple files that are to be stored in many different locations in a system or even across multiple systems. Because of this, there were sometimes multiple copies of the same file which lead to data redundancy.
14) Data integrity means that the data is accurate and consistent in the database. Data Integrity is very important as there are multiple databases in a DBMS. All of these databases contain data that is visible to multiple users. So it is necessary to ensure that the data is correct and consistent in all the databases and for all the users.
15) Data Security is an important concept in a database. Only authorised users should be allowed to access the database and their identity should be authenticated using a username and password. Unauthorised users should not be allowed to access the database under any circumstances as it violates the integrity constraints.
16) Data consistency is ensured in a database because there is no data redundancy. Data Consistency means there should be multiple mismatching copies of the same data. All data appears consistently across the database and must be same for all the users viewing the database. Moreover, any changes made to the database are immediately reflected to all the users and there is no data inconsistency.
17)
SESSION 2: CREATE
AND EDIT TABLES USING WIZARD AND SQL
COMMANDS
Fill in the blanks:
1. A table is a
set of data elements that is organized using a model of vertical columns(which are identified by their name) and horizontal rows.
2. A Column or Field or Attribute is a set of data values of a particular
type, one for each row of the table.
3. A Row or Record or Tuple represents a single, data item in a table.
4. Datatypes are used to identify which type of
data we are going to store in the database.
5. There are Two (1Create table in Design View , 2. Use
Wizard to Create Table ) ways to
create a table.
6. Field
properties can be set in both the _design view_ and _datasheet view_ .
SESSION 3: PERFORM
OPERATIONS ON TABLE
Fill in the blanks:
1. The types of languages used for creating and manipulating the
data in the Database are __Data Definition Language. __
& _Data Manipulation Language .
2. A _Data Definition Language
(DDL) is a standard for commands that define the different structures in
a database.
3. A data manipulation language (DML) is a
language that enables users to access and manipulate data in a database.
4. A query language is a part
of DML involving information retrieval only.
5.A popular data manipulation language is Structured
Query Language (SQL) .
6. Entity, attribute and
relationships are the basic building blocks of a database.
7. There are three specific types
of relationships that can exist between a pair of tables: one-to-one,
one-to-many, and many-to-many.
SESSION 4: RETRIEVE
DATA USING QUERY
Fill in the blanks
1. A form helps the
user to systematically store information in the database.
2. A form enables users to view,
enter, and change data directly in database objects such as tables.
3. SELECT statement
retrieves zero or more rows from one or more database tables or database views.
4. By default, data is arranged in ascending order. order using
ORDER BY clause.
5. UPDATE statement
is used for modifying records in a database.
6. DELETE statement is
used to remove one or more records in a Database.
SESSION 5: CREATE
FORMS AND REPORTS USING WIZARD
Fill in the blanks:
1. To create a form you need to select FORMS_ option
available under Database section.
2. A QUERY is helps to
collect specific information from the pool of data in the database.
3. data dashboard is used to display the
display the summary of data.
4. Graphical user interfaces (GUIs) are the interfaces with
which the user interacts.
5. Data from multiple tables can be stored in database. .
No comments:
Post a Comment