Font size
WorksheetsAdvance Database Concepts (BSIT 3)
Total questions: 20
Worksheet time: 11mins
An organized collection of structured information, or data, typically stored electronically in a computer system.
Database Application
Database Management System
Database Integration
Database
Controlled by a Database
Management System (DBMS). Together, the data and the DBMS, along with the applications that are associated with them.
Database Application
Database Integration
Database
Database System
Serves as an interface between the database and its end-users or programs, allowing users to retrieve, update, and manage how the information is organized and optimized.
RDBMS
DBMS
MySQL
Microsoft SQL Server Management
Facilitates oversight and control of databases, enabling a variety of administrative operations such as performance monitoring, tuning, and backup and recovery.
MySQL
NoSQL
RDMS
DBMS
A set of one (1) or more computer programs that serves as an intermediary between the user and the DBMS.
Database Application
Database Software
Database Integration
Database System
Unsophisticated users who interact with the system by using predefined user interfaces, such as web or mobile applications.
Naïve Users
Application Programmers
Sophisticated users
Computer professionals who write application programs.
Database Developers
Back-End Developers
Application Programmers
System Programmers
Interact with the system without writing
programs. Instead, they form their requests either using a database query language.
Application Programmers
Sophisticated users
Back-End Programmers
System Programmers
involves database design and construction on how the databases will operate and f unction within exisiting structures and location.
Database System Architecture
Database System Schedma
Database System Developer
Database System Platform
Database that supports data located at a single site.
Centralized Database System
Distributed Database System
Centered Database System
Distribution Database System
Collection of multiple
interconnected databases, spread physically across various locations.
Centralized Database System
Distributed Database System
Centered Database System
Distribution Database System
Data that are stored in relational databases.
(a)
data that exist in its original (raw) state that can come in all shapes and sizes.
(a)
Individual data items of the same type may have different sets of attributes. It contains semantic tags and there is no pre-defined schema.
(a)
A computer language for storing, manipulating, and retrieving data stored in a relational database.
(a)
Features a dynamic schema for unstructured data and the data can be stored in different ways.
(a)
By combining the reliability of SQL with the speed and
performance of NoSQL, NewSQL provides improved functionality and services.
(a)
A database that stores object rather than data as individual relations.
(a)
Simplifies data sharing between various systems because of its platform-independent nature.
(a)
This principle ensures that sensitive information is only accessible to authorized individuals or systems. It's about preventing unauthorized disclosure of information.
(a)
