Fundamentals of Database Systems Exam Questions Answered Correctly Already Passed
Examples of database applications - Answers -Purchasing from the supermarket
-Purchasing using credit card
-Using the local library
-Studying at university
Records - Answers -Contains logically related data
-Known as rows
Fields - Answers -Represents some characteristics of the real-word object that is being modeled
-known as column
Database - Answers A shared collection of logically related data such as entities, attributes, and
relationship and its description designed to meet the information needs of an organisation
Entities - Answers Distinct object or 'real-world' object
Attributes - Answers A property that describes some aspects of the object that we wish to record
Relationship - Answers An association between entities
Data - Answers The representation of object and usually presented as a table or table-based
Database Management Systems (DBMS) - Answers - A software system that enables users to define,
create, maintain, and control access to the database
- Provides interaction between database application program and the database
Database Application Programs - Answers A computer program that interacts with database by issuing
an appropriate request typically SQL statement to the DBMS
Data Definition Language (DDL) - Answers -Allows users to specify the data types and structures and the
constraints on the data to be stored in the database
-A language that allows the DBA or user to describe and name the entities, attributes, and relationships
required for application, together with any associated integrity and security constraints
-Used to specify database schema or modify the database schema
Structured Query Language (SQL) - Answers Provides controlled access to the database
Data Manipulation Language (DML) - Answers -allows users to insert, update, delete, and retrieve data
from the database
Examples of database applications - Answers -Purchasing from the supermarket
-Purchasing using credit card
-Using the local library
-Studying at university
Records - Answers -Contains logically related data
-Known as rows
Fields - Answers -Represents some characteristics of the real-word object that is being modeled
-known as column
Database - Answers A shared collection of logically related data such as entities, attributes, and
relationship and its description designed to meet the information needs of an organisation
Entities - Answers Distinct object or 'real-world' object
Attributes - Answers A property that describes some aspects of the object that we wish to record
Relationship - Answers An association between entities
Data - Answers The representation of object and usually presented as a table or table-based
Database Management Systems (DBMS) - Answers - A software system that enables users to define,
create, maintain, and control access to the database
- Provides interaction between database application program and the database
Database Application Programs - Answers A computer program that interacts with database by issuing
an appropriate request typically SQL statement to the DBMS
Data Definition Language (DDL) - Answers -Allows users to specify the data types and structures and the
constraints on the data to be stored in the database
-A language that allows the DBA or user to describe and name the entities, attributes, and relationships
required for application, together with any associated integrity and security constraints
-Used to specify database schema or modify the database schema
Structured Query Language (SQL) - Answers Provides controlled access to the database
Data Manipulation Language (DML) - Answers -allows users to insert, update, delete, and retrieve data
from the database
