Ctrl + F is the shortcut in your browser or operating system that allows you to find words or questions quickly.
Ctrl + Tab to move to the next tab to the right and Ctrl + Shift + Tab to move to the next tab to the left.
On a phone or tablet, tap the menu icon in the upper-right corner of the window; Select "Find in Page" to search a question.Share Us
Sharing is Caring
It's the biggest motivation to help us to make the site better by sharing this to your friends or classmates.
Introduces database concepts, including relational databases, tables and data types, data selection and manipulation, views, stored procedures, and more.
Column header / field
SQL is not a Programming Language.
Level of database design use to create database.
AND operator displays a record if all the conditions separated by AND are FALSE.
It is a stricter form of 2nd and 3rd normal form
DCL - Use the command: Permissions
AND operator displays a record if all the conditions separated by AND are TRUE.
To sort the records in descending order, use the DESC keyword.
The table is in a 1NF if It satisfies the definition of a relation.
Used to control data access
sum of all or selected values
Used to manage data within the object schema.
Cross Join – Used the foreign key as the matching criteria
_____ means missing value.
We use _____ to give column another name.
number of all or selected values
A process of producing a set of tables (relations) with a proper attribute.
It is a command used or a request for information from a database.
minimum of all or selected values
Composite attribute can be divided into more attributes.
Display a form to be fill out by the user.
Used to performed or rollback the changes that we made in the database using DML commands.
Data model is a collection of concepts that is used to describe the structure of a database.
A computerized system that permits users to create and maintain a database.
It is between high-level and low-level data models.
Include all qualified records from the right table in the join condition even if they do not have matching records in the left table.
Data abstraction is the data type, relationships and constraints that apply to the data.
Used to give or control privilege in a database.
Internal Level describes the physical storage structure of the database.
People whose jobs require access to the database for querying, updating, and generating reports.
Like Web search engines (engine like Google), which the user can specify a string or any keywords and expect to get a relevant result.
Entity Instance is an instance of a particular entity.
Attribute describes an entity class.
Logical Design – transforming the ERD into relational model.
Structured Query Language is a command use by relational database management system to perform database operations.
Include all qualified records from both tables in the join condition.
It describes how entities are related to each other.
Used to sort the result.
In SQL the command language used is like an Spanish language.
Database System automatically takes care of backup and recovery.
Maximum Cardinality describes the maximum number of entity instances in the relationship.
Minimum Cardinality describes the minimum number of entity instances that must participate in a relationship.
Use to retrieve data from multiple tables.
We call the database and DBMS software together as a _____
The participation of an entity in the relationship is optional.
The interface allows users to access their data through their mobile phone or mobile device.
Is an instance of a particular entity.
Displays a record if any of the conditions separated by OR is TRUE.
Records that have matching records from two (2) tables
Used to define and modify data structures
NO Transitive Dependency
Composite Attribute can be calculated from other attributes.
All possible column values
Controlling Redundancy is used to improve the performance of queries.
It is a collection of related data.
A single entity instance of one entity class is related to a single entity instance of another entity class.
DML - Manipulate data using commands: insert, update and delete
Who is responsible in administering the primary and secondary resource in the database?
Used for creating tables, schema etc. in database.
Entities can be related indirectly by two (2) relationships.
NO “repeating groups” (columns)
Facts that can be recorded and that have implicit meaning.
Include all qualified records from the left table in the join condition even if they do not have matching records in the right table.
Its is one or more columns of a relation or table that is used to identify a record.
Each entity instance of one entity class is related to a multiple entity instance of another entity class; and vice versa.
It is the number of tuples in a relation.
It is a question or an inquiry, sometimes loosely used for all types of interactions with databases.
It is the number of attributes in a relation.
An Expression can be a single constant, column, variable, or scalar function.
Indirect relationship causes functional dependency.
Null means zero
The interface presents a menu that lead to a user through request.
Describes how entities are related.
A single entity instance of one entity class is related to a multiple entity instance of another entity class.
Use to get aggregation results for different groups of records.
This relationship exists if they are independent or different to each other.
For each entity instance the value of the identifier attribute is Unique.
NO Partial Dependency
Data Manipulation Language is use for manipulating data in a database.
Compound Conditions use logical operators to filter or connect multiple criteria.
Relational Model is a table with columns and rows.
A non-key attribute is dependent on part of a composite primary key.
Relationships can't have attributes.
An Expression can't be a number, columns, literals, functions connected by operators
Asterisk (*) means all or a list of _____
A displayed schema is called Schema figure.
DDL used to control data access.
Used to retrive data and manipulate data
They are liable for identifying the data to be stored within the database and for selecting appropriate structures to represent and store this data.
The table is in a 2NF if there's NO Partial Dependency.
It is needed when minimum cardinality is optional on a table.
The participation of an entity in the relationship is mandatory.
Physical data models is a concept that shows how the data is stored on the computer.
There’s no difference between the description of database and the database itself.
A thing that shares a common attribute.
Attribute is a name for a set of similar things that you can list. Like objects, events, people.
DDL - Schema: databases, tables, views and many more
Columns or expressions can be in the SELECT clause only if they are in the GROUP BY clause.
It is a combination of symbols and operators that returns a single value.
OR operator displays a record if any of the conditions separated by OR is TRUE.
average of all or selected values
Use _____ if there is ambiguity when distinguishing a column.
The relational model (RM) was first described by Edgar F. Codd
No primary key can be null.
SQL is used to retrieve data from relational databases.
Entity Relationship Diagram (ERD) was proposed by _____
maximum of all or selected values
Null means a value is unknown.
An attribute that has a multiple value.
To keep up this site, we need your assistance. A little gift will help us alot.Donate
- The more you give the more you receive.Related Subject
Bookkeeper and Clerk
Applied Business Tools and Technologies
Object Oriented Programming Laboratory
Management Information Systems
Managing Information and Technology
Living in the Information Technology Era
Mail and Web Services
Introduction to Computing
Intro to Hardware Description Language
Introduction to Human Computer
Integrative Programming and Technology 2
Information Assurance and Security 2
Information Assurance and Security 3
Information Security and Management
Information Systems Operations and Maintenance
Fundamentals of Investigation and Intelligence
3D Game Art Development
Mobile Application Design and Development
Mobile Application Design and Development 2
Information Technology Practicum
Information Technology Capstone Project
Introduction to Information Systems
Introduction to Multimedia
Internet Marketing and Entrepreneurship
Internet Technology in Real Estate
Data Communications and Networking
Cyber Security: Theories and Practice
Data Communications and Networking 2
Data Structures and Algorithms
Database Management System
Chemistry for Engineers
Auditing and Assurance Concepts and Applications
Integrative Programming and Technology
System Administration and Maintenance
Current Trends and Issues
Data Communications and Networking 4
Principles of Operating System and its Application
Systems Integration and Architecture
Application Lifecycle Management
Data Communications and Networking 3
Information Assurance and Security
Computer Programming 2
Relational Database Systems
Database Management System 2
Intrusion Detection System
Operating System Functions
Web Application Development
Web Systems Technologies
Health Information Technology
Computer Information Systems
Computer Support Technician
Risk Management Applied to Safety Security and Sanitation
Property Management System
Investment and Portfolio Management
Shopee 3D Floor
Lazada Smart TV Box