1. Basic concepts and definitions
2. File Processing System versus Database System
3. Evolution of Database System
Questions and Answers
Explain Data Abstraction
State the reasons why file based system are disadvantageous, state a minimum of 5
State the 8 reasons why the database approach is more advantageous than the file based approach
An organized collection of logically related data
Facts that could be recorded and stored on storage media
Data processed in such a way that it can increase the knowledge of the person who uses it
Data that describe the properties or characteristics of other data.
It is an abstract, self-contained, logical definition of the objects, operators, which users interact with
A distinct object that is to be represented in the database
Corresponds to a row in a table
A property that describes some aspect of the object that we wish to record
An association between several entities
Data by itself is useless unless it is some how aggregated, organized and prepared in a form convenient for decision making or other organization activities, now check the essential parts needed for an organized databse
One who understands that data and the needs of the enterprise with respect to that data, at a senior management level
One who creates the actual database and to implement the technical controls needed to enforce the various policy decisions
Kinds of data independence
The immunity of applications to change in physical representation and access technique
A database management system used in the apollo landing project
A structure used in a database management system that conforms to an upside-down tree
In the 1960's file processing were dominant
An early pioneer of database systems which led to the development of a new type of database system known as network DBMS
A group that defines standard specifications for an environment that would allow database creation and data manipulation
A logical organization of the entire database as seen by the DBA – this includes a definition of the database name, the type of each record, and the components of each record type
The part of the database as seen by the user or application program
A language that define the data characteristics and the data structure, and to manipulate the data.
Below is a Relational Database Trivia Quiz! It is designed to help you understand how databases holding the same information are structured and maintained. Do you think that you have what it takes to tackle it based on what you...
Questions: 9 | Attempts: 8692 | Last updated: Mar 21, 2022
Which of the following makes it possible for entities toshare a relationship?
Ever wondered how much you know about DBMS, or the Database Management System? For this quiz, you should know what is responsible for authorizing access to the databases and obtaining software and hardware services, what is a...
Questions: 31 | Attempts: 7760 | Last updated: Mar 22, 2022
-------------------------------responsible for authorizing access to the database, for coordinating and monitoring its use, acquiring software, and hardware resources, controlling its use, andmonitoring efficiency of operations.
Below is an important trivia quiz on the database. As a programmer or software developer, you need to know the basics surrounding databases, their creation, maintenance, and management. Take up this quiz and get to learn more...
Questions: 15 | Attempts: 7636 | Last updated: May 1, 2022
The Yellow Pages is an example of a paper-based database. True or false?