DCIT 24 (1st Quiz) Flashcards
These are individual facts, statistics, or items of information, often numeric, that are collected through observation.
Data
These are set of values of qualitative or quantitative variables about one or more persons or objects.
Data
It is processed, organized and structured data.
Information
It provides context for data and enables decision making.
Information
It is an information that is set up for easy access, management and updating.
Database
They typically store aggregations of data records or files that contain information, such as sales transactions, customer data, financials and product information.
Computer databases
These are used for storing, maintaining and accessing any sort of data.
Databases
They collect information on people, places or things.
Databases
Databases can be thought of as an?
Organized collection of information
It is a design of the database.
Database Schema
It is a skeleton of the database that is used to represent the structure.
Database Schema
In a database, sometimes we put some restrictions on the table that what type of data can be stored in one or more columns of the table, it can be done by using constraints.
Data Constraints
It is known as the data about the data.
Metadata
We can say that the database schema along with different types of constraints on the data is stored by DBMS in the dictionary is known as _____.
Metadata
It is used to define the complete database environment and its components.
Database instance
It is a set of memory structures and background processes that are used to access the database files.
Database instance
It is used to access data from the database.
Query
In a database, we can easily manipulate data using the three main operations.
Data Manipulation
What are the three main operations?
Insertion
Deletion
Updation
It is an underlying component that is used to create and manage various database queries.
Data Engine
It is the process of collecting, sorting, organizing, maintaining and analyzing data.
Database Management
It is software that permits the organization to centralize data, manage them efficiently, and provide access to the stored data by application programs.
Database Management System (DBMS)
It is a general-purpose software system that facilitates the processes of defining, constructing, manipulating, and sharing databases among various users and applications.
Database Management System (DBMS)
The main purpose of this is to provide an interface that enables organizations to standardize data management consistently across teams and departments.
Database Management System (DBMS)
It is aggregated, stored, and analyzed by the organization.
Data
It enables organizations to access, store and modify data.
Database engines
It determines the logical structure for each database.
Database Schema
It is for a wide variety of tasks, including logging and auditing, or rollbacks and restarts.
Automation
It unifies data processes into one visualized workflow, accessed via multiple devices and locations, and enable different users to display different views of one database schema.
Centralization
It determines roles and privileges for each user, to ensure users gain limited access to corporate data and prevent abuse of privileges.
Access Controls
DBMSs often provide an intuitive user experience, which enables users of different skills levels to access and leverage data.
User friendly
A type of database that contains a single database located at one location in the network.
Centralized Database
A type of database that contains two or more database files located at different locations in the network.
Distributed Database
In this database, the data is organized in form of tables.
Relational Database
In this database, the data is not organized in form of tables.
Non-relational Database
It models information and data into a set of tables with rows and columns.
Relational Database Design (RDD)
Each ____ of a relation/table represents a record.
Row
Each ____ represents an attribute of data.
Column
This is a way to visually represent the architecture, design, and implementation of complex software systems.
Unified Modeling Language (UML)
It divides that software system into components and subcomponents.
UML Diagrams
The various tables and attributes related to each table are identified.
Define relations/attributes
The attribute or set of attributes that help in uniquely identifying a record is identified and assigned as the primary key.
Define primary keys
The relationships between the various tables are established with the help of foreign keys.
Define relationships
These are attributes occurring in a table that are primary keys of another table.
Foreign keys
It is the process of optimizing the database structure.
Normalization
It shows the relationships of entity sets stored in a database.
Entity Relationship Diagram (ERD)
It is an object, a component of data.
Entity
It is a collection of similar entities.
Entity set
It illustrates the logical structure of databases.
ER Diagram
It is used to sketch out the design of a database.
ER Diagram
It is any object, person or activity which the data is recorded.
Entity
It is a property of a given entity.
Attributes
It is a type of association on entity types.
Relationship
Entities are represented by _____
Rectangle
It describes the property of an entity.
Attributes
An attribute is represented as _____
Oval or ellipses
These are further divided in a tree like structure.
Composite
These are depicted by double ellipse.
Multivalued
These are depicted by dashed ellipse.
Derived
Relationship is represented by a ______
Diamond-shaped box
It is when a single instance of an entity is associated with a single instance of another entity.
One-to-one relationship
It is when a single instance on an entity is associated with more than one instances of another entity.
One-to-many relationship
It is when more than one instances of an entity is associated with a single instance of another entity.
Many-to-one relationship
It is when more than one instances of an entity is associated with more than one instances of another entity.
Many-to-many relationship
It is designed to support to store and to maintain the personal information.
Personal Database
It is designed to support to maintain database by a group of people.
Workgroup Database
It is designed to support to maintain departmental wise activities in an organization.
Department Database
It is designed to support to maintain organization database.
Enterprise Database
It performs all the activities of an organization.
Enterprise Database
He worked for International Business Machines
Edgar F. Codd
He invented the relational model for database management, the theoretical basis for relational databased and relational management systems.
Edgar F. Codd
He later won the prestigious Association of Computing Machinery Turing Award for his work.
Edgar F. Codd
It is the first DBMS product based on the relational model.
DB2 from IBM
It allows both relational and object views of data in the same database.
Object-relational database systems
It was designed primarily for decision support applications, which are query-intensive, yet the mainstay of databases in the 1980s was transaction-processing applications, which are update-intensive.
Structured Query Language/Data System (SQL)
It is the associated query language that emerges as a new database technology.
XQuery
They have been built to handle the data management requirements of very large web sites such as Amazon, Facebook, Google, Microsoft and Yahoo!, and some of these are now offered as web services that can be used by application developers.
Data-storage systems
What query language is associated in the first half of the 2000s?
XQuery
2 open-source databases systems
PostgreSQL and MySQL
What award did Edgar F. Codd received?
Association of Computing Machinery Turing Award
Where did Edgar F. Codd worked?
International Business Machines