dbms Flashcards
One of the major factors for realising the need of
Computerised Accounting System is the
overwhelming quantity of —- in our
organisations.
data
A simple solution to this situation is available in the form of a Database Management System (DBMS) (e.g.
‘—-’, ‘——’, ‘SQL Server’, etc.) that provides
a variety of software tools for organising,
processing and querying data in a flexible manner.
Access
oracle
name 3 components of dbms
tqf
namely, ‘tables’, ‘queries’
and ‘forms
In most of the cases, database is not directly accessible to users. Any
addition, modification or retrieval of information from database is done
by the user-friendly programs. Database is thus rightly referred to as
‘—- -end’ while the interactive program is termed as ‘front-end’ of a
database application
back-end
db is of 2 types;
– and —
desktop
or server
While the —– databases – residing on standard personal computers
– are oriented toward single-user applications, ‘server databases’ are
geared toward multi-user applications. Understandably the ‘server
database’, containing additional provisions for ensuring reliability and
consistency of data in a multi-user environment, are substantially costlier
than the ‘desktop database
desktop
If our requirement entails approach to database by many users, or if it involves simultaneous updating of data by different users, then perhaps
server databases such as ‘Microsoft SQL Server’, ‘—’ or ‘IBM —–’
will provide desired solutions
Oracle
IBM DB2
MICROSOFT ACCESS IS desktoo or server . it which
comes with the licensed copy of Microsoft Office Professional – providing
one of the simplest and most flexible DBMS solutions today, besides
giving the advantages of familiar ‘Windows’ look and integration with
other Microsoft Office products such as ‘Excel’.
desktop
Access 2007 usually comes as part of Microsoft Office —– . However,
it can also be purchased separately as a standalone program. In order
to run this program, your computer should have a minimum configuration
of —- MHz Processor, 256 megabyte RAM, —- gigabyte Hard disk,
and Windows XP Operating system.
2007
500 mhz
1.5 gb
256 mb
windows xp
database is simply an organised collection
of data with ‘—-’ as its fundamental building blocks. they allow
us to create the framework for storing information in the database.
tables
Each column (also called ‘’—-) of the table corresponds to a specific
characteristic (or ‘’——- in database terms) of the stored
information. Each row (also called ‘—’) corresponds to a particular
instance of the information
field
attribute
record
(instance)
The term ‘—–’ can be used to describe the
structure of different parts of the overall database
database design
In Access 2007, the entire database is encompassed in a file (with
extension ——) which can be stored in your hard-drive or CD. There
can be multiple tables (each storing a specific set of data) with in this file.
Then there are multiple fields in each table according to different categories (types) of data within the table. And at every instance
(—–) of a collection of data covering all fields, a row/—- gets created
.accdb
occurrence
record
Identification of various attributes of a database is generally considered
as—–. Such a process may entail database
designer to elicit needed information from those with the domain
knowledge.
part of requirement analysis
