“Database is a collection of related data items stored in an organized manner".
DBMS can be defined as system designed for efficient storage, maintenance and retrieval of data. In short the DBMS software is what makes database practical and more usable.
As we are aware of terms data, information, database and database management system, l
Introduction to Base Base is Relational Database Management System (RDBMS) as it follows relational model.
the organization of data into collections of two-dimensional tables called “relations.” Designed by E.F. Codd, relational model is based on the theory of sets and relations of mathematics.
Base is a collection of related data objects known as Tables, Queries, Reports and Application Modules.
Table :- Tables are organized in the form of columns and rows. To decide what information would be stored in a table and what would be the column titles, database designer needs to first decide entities in database.
Queries : A question asked within the database environment is known as Query
Reports : The output of Query in Base is displayed in the form of rows and columns.The presentation of information in an organized and readable format as per the user requirement is known as Reports.
Creating a Sample Database for an Application During the entire journey of learning Base, we will move towards creation of a small application for a hypothetical Modern Electronic Store
Logical Names and Physical Names of Attributes When thinking about the name for attributes it is useful to differentiate between a logical name of the attribute and the physical name used in the database application.
Data types available in Base
Data types available in Base can be divided into three categories, namely,
Alphanumeric type, Calendar type and Binary type.
(1) DBMS Stands for _________
(a) Database Management System
(b) Database Migration System
(c) Data Management System
(d) Direct Base Management System
(2) Which of following is a term used for “Raw facts or figures”?
(a) Information (b) Variable (c) Data (d) Field
(3) Which of the following best describes customer in Database?
(a) Relationship (b) Attribute (c) Entity (d) Data
(4) Processed data is known as
(a) Fact (b) Prepared data (c) Information (d) Decision
(5) Which one of the following is not a database?
(a) MySQL (b) Base (c) SQL Server (d) SpreadSheet
(6) Which of the following is not an Open source DBMS?
(a) MySQL (b) Ingress (c) Base (d) Oracle
(7) The alphabet R in RDBMS stands for which of the following?
(a) Rotational (b) Relational (c) Random (d) Ring
(8) What is the name of the database available as part of Open Office Suite?
(a) OfficeDB (b) Base (c) OpenDB (d) Access
(9) Which of the following is the default extension of Base Database file?
(a) .bdf (b) .odf (c) .odb (d) .dbf
(10) Which of the following is not an object maintained by Base?
(a) Tables (b) Queries (c) Charts (d) Forms
(11) Which data type cannot be used to store numbers?
(a) Decimal (b) Integer (c) Text (d) Date
(12) Which data type is used to store image in Base database?
(a) Binary (b) Photo (c) Long (d) Huge
(13) Which of the following is false statement?
(a) Primary key cannot contain null values.
(b) Primary key cannot contain duplicate values.
(c) Primary key can be combination of more than one field.
(d) Primary key is always numeric field.
