CHAPTER 6
DATABASE – PART I
1. MCQ
Ans 1. B) Set of computer programs
Ans 2. C) Super key
Ans 3. A) Design view
And 4. D) None of these
Ans 5. C) Pencil
2. Fill in the blanks :
Ans 1. Relational
And 2. Alternate
Ans 3. Relational
Ans 4. Datasheet
Ans 5. Form
3. Answer the following questions :
Ans 1. Database is a systematic collection of structured information or data,
typically stored electronically in a computer system.
Paper-based registers, Microsoft Access database, etc are some examples of
database.
Ans 2. We need database :
• To store data in a systematic and structured manner.
• To avoid any duplication of data.
• To add, update, and delete data quickly and easily.
Ans 3. Primary Key : It is a field or a combination of fields in a table that uniquely
identifies each record. No more than one record is allowed with the same value for that
field.
Foreign Key : It is a key that is used to establish a link between two tables. It is a field in
one table that refers to the primary key in another table.
Candidate Key : It is a field or a group of fields that can be used as primary key of a
table.
Super Key : It is a set of fields that can uniquely identify a record in a table.
Ans 4. The difference between Flat file Database and Relational Database are :
• In Flat file Database, the data is stored in the form of a plain text file and cannot
include multiple tables.
• In Relational Database, the data is stored in a form that the data items are
related to one another. It can have multiple tables.
Ans 5. Data types are categories that specify the kind of data a field can store in a
database.
The different type of data used in Access 2007 are :
• Auto Number : This field creates unique values automatically when Access creates
a new record.
• Text : This field can contain values that are text, numeric, or a combination of both. It
can contain a maximum length of 255 characters.
• Memo : It is a much larger version of the text field that allows storage of up to 2 GB of
data.
• Number : This field can store numeric values of up to 16 bytes of data.
• Date / Time : This field allows storage of date and time information.
• Currency : It stores values in a monetary format. It can be used with financial data.
• Yes / No : It has data of true / false values.
• OLE Object : This filed stores images, documents, graphs, etc. from Office and
Windows based programs.
• Hyperlink : This field is used to store web addresses. It has a maximum size limit of 1
GB of data.
• Attachment: This field is used to store images, spreadsheet files, documents,
charts, and other types of supported files to the records in the database.
Ans 6. Query is a simple question that one asks to find some specific information
from the database.
The different parts of a query window are :
• Design grid
• Object Relationship Pane
Ans 7. Criteria is a part of Design grid for Query. This property contains the condition on the
basis of which the records will be filtered in the Query output.
CHAPTER 5
ETHICS IN IT
Ans 9. We need to protect Intellectual Property Rights as :
• It encourages creativity and innovation - When creators know their ideas, inventions,
or works are legally protected, they feel motivated to create more.
• It prevents unauthorized use – This protection stops others from copying, stealing,
or misusing someone’s original work. This ensures that only the owner can decide
how their creation is used.
• It provides financial benefits - Creators and inventors can earn money from their
work through patents, copyrights, and trademarks. Without protection, others could
use their ideas freely, resulting in financial loss.