Follow and like us on our Facebook page where we post on the new release subject and answering tips and tricks to help save your time so that you can never feel stuck again.

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.

Fundamentals of Database System

Introduces database concepts, including relational databases, tables and data types, data selection and manipulation, views, stored procedures, and more.

elmasri navathe


ramez elmasri

system fundamentals

computer science

information technology









  • Integer

Display a form to be fill out by the user.

  • Forms-based Interfaces

Entity Instance is an instance of a particular entity.

  • True
  • False

Multi-value dependency

  • 4th Normal Form (4NF)

Data Manipulation Language is use for manipulating data in a database.

  • True
  • False

Asterisk (*) means all or a list of _____


A process of producing a set of tables (relations) with a proper attribute.


It is a stricter form of 2nd and 3rd normal form

  • Boyce Codd Normal Form (BC/NF)

It is the number of attributes in a relation.


Used to performed or rollback the changes that we made in the database using DML commands.

  • Transaction Control Language (TCL)

sum of all or selected values

  • sum


  • Tuples

Attribute is a name for a set of similar things that you can list. Like objects, events, people.

  • True
  • False

It is a collection of related data.


Columns or expressions can be in the SELECT clause only if they are in the GROUP BY clause.

  • True
  • False


  • name, primary key


  • Text

All possible column values

  • Domain

Entity Relationship Diagram (ERD) was proposed by _____


Used for creating tables, schema etc. in database.

  • Data Definition Language (DDL)

Records that have matching records from two (2) tables


It is a combination of symbols and operators that returns a single value.


NO “repeating groups” (columns)

  • 1st Normal Form (1NF)

DCL - Use the command: Permissions

  • True
  • False

An Expression can't be a number, columns, literals, functions connected by operators

  • True
  • False

A displayed schema is called Schema figure.

  • True
  • False

NO Partial Dependency

  • 2nd Normal Form (2NF)

Relational Model is a table with columns and rows.

  • True
  • False

A single entity instance of one entity class is related to a multiple entity instance of another entity class.

  • One-to-Many

The interface allows users to access their data through their mobile phone or mobile device.

  • Applications for mobile devices

Composite attribute can be divided into more attributes.

  • True
  • False

Data model is a collection of concepts that is used to describe the structure of a database.

  • True
  • False

Controlling Redundancy is used to improve the performance of queries.

  • True
  • False

A computerized system that permits users to create and maintain a database.


The participation of an entity in the relationship is mandatory.

  • Mandatory

Use to retrieve data from multiple tables.


Use _____ if there is ambiguity when distinguishing a column.


An Expression can be a single constant, column, variable, or scalar function.

  • True
  • False

Attribute describes an entity class.

  • True
  • False

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 between high-level and low-level data models.


Level of database design use to create database.


To sort the records in descending order, use the DESC keyword.

  • True
  • False


  • Time

DDL used to control data access.

  • True
  • False

Relationships can't have attributes.

  • True
  • False

An attribute that has a multiple value.


DDL - Schema: databases, tables, views and many more

  • True
  • False


  • Relation

Displays a record if any of the conditions separated by OR is TRUE.


DML - Manipulate data using commands: insert, update and delete

  • True
  • False

In SQL the command language used is like an Spanish language.

  • True
  • False

This relationship exists if they are independent or different to each other.


Include all qualified records from both tables in the join condition.


Its is one or more columns of a relation or table that is used to identify a record.

  • KEY


  • name, data type, size, value range

Used to retrive data and manipulate data

  • DML

Database System automatically takes care of backup and recovery.

  • True
  • False

We use _____ to give column another name.


It describes how entities are related to each other.


It is a command used or a request for information from a database.


The table is in a 1NF if It satisfies the definition of a relation.

  • True
  • False

Use to get aggregation results for different groups of records.


The interface presents a menu that lead to a user through request.

  • Menu-based Interfaces for Web Clients or Browsing

Facts that can be recorded and that have implicit meaning.

  • DATA

The participation of an entity in the relationship is optional.

  • Optional

Like Web search engines (engine like Google), which the user can specify a string or any keywords and expect to get a relevant result.

  • Keyword-based Database Search

AND operator displays a record if all the conditions separated by AND are FALSE.

  • True
  • False

maximum of all or selected values

  • max

OR operator displays a record if any of the conditions separated by OR is TRUE.

  • True
  • False

minimum of all or selected values

  • min

No primary key can be null.

  • True
  • False

Minimum Cardinality describes the minimum number of entity instances that must participate in a relationship.

  • True
  • False

Null means a value is unknown.

  • True
  • False

Used to sort the result.


Used to manage data within the object schema.

  • Data Manipulation Language (DML)

Who is responsible in administering the primary and secondary resource in the database?


Include all qualified records from the right table in the join condition even if they do not have matching records in the left table.


Is an instance of a particular entity.


Composite Attribute can be calculated from other attributes.

  • True
  • False

NO Transitive Dependency

  • 3rd Normal Form (3NF)

Include all qualified records from the left table in the join condition even if they do not have matching records in the right table.


Indirect relationship causes functional dependency.


There’s no difference between the description of database and the database itself.

  • True
  • False

The table is in a 2NF if there's NO Partial Dependency.

  • True
  • False

Table definition

  • Schema of relation

A single entity instance of one entity class is related to a single entity instance of another entity class.

  • One-to-One

SQL is not a Programming Language.

  • True
  • False

For each entity instance the value of the identifier attribute is Unique.

  • True
  • False

number of all or selected values

  • count

Cross Join – Used the foreign key as the matching criteria

  • True
  • False

Data abstraction is the data type, relationships and constraints that apply to the data.

  • True
  • False

Entities can be related indirectly by two (2) relationships.


Compound Conditions use logical operators to filter or connect multiple criteria.

  • True
  • False

Physical data models is a concept that shows how the data is stored on the computer.

  • True
  • False

It is needed when minimum cardinality is optional on a table.


Null means zero

  • True
  • False

People whose jobs require access to the database for querying, updating, and generating reports.


Used to control data access

  • DCL

Internal Level describes the physical storage structure of the database.

  • True
  • False

SQL is used to retrieve data from relational databases.

  • True
  • False

AND operator displays a record if all the conditions separated by AND are TRUE.

  • True
  • False

Used to give or control privilege in a database.

  • Data Control Language (DCL)

Used to define and modify data structures

  • DDL

Each entity instance of one entity class is related to a multiple entity instance of another entity class; and vice versa.

  • Many-to-Many

A thing that shares a common attribute.


A non-key attribute is dependent on part of a composite primary key.



  • true/false

The relational model (RM) was first described by Edgar F. Codd

  • True
  • False

Maximum Cardinality describes the maximum number of entity instances in the relationship.

  • True
  • False

Structured Query Language is a command use by relational database management system to perform database operations.

  • True
  • False

We call the database and DBMS software together as a _____


average of all or selected values

  • avg

Logical Design – transforming the ERD into relational model.

  • True
  • False

Describes how entities are related.


_____ means missing value.

  • NULL


  • all kinds of keys

They are liable for identifying the data to be stored within the database and for selecting appropriate structures to represent and store this data.


Column header / field

  • Attributes
Paypal Donation

To keep up this site, we need your assistance. A little gift will help us alot.


- The more you give the more you receive.

Related Subject

Bookkeeper and Clerk

Applied Business Tools and Technologies

Object Oriented Programming Laboratory

Mobile Programming

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

Digital Imaging

Computer Fundamentals

Animation Project

3D Game Art Development

Computer Programming

Network Security

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

Load Testing

Auditing and Assurance Concepts and Applications

Integrative Programming and Technology

Linux Administration

Software Engineering

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

Javascript Algorithms and Data Structures


Logistics Management

General Mathematics


Computer Programming 2

Relational Database Systems

Database Management System 2

Intrusion Detection System

Operating System Functions

Web Application Development

Web Systems Technologies

Web Development

Network Administration

Health Information Technology

Computer Information Systems

Computer Support Technician

Risk Management Applied to Safety Security and Sanitation

Property Management System

Investment and Portfolio Management

Show All Subject
Affiliate Links

Shopee Helmet

Shopee 3D Floor

Lazada Smart TV Box