24 Questions
What is a primary key in a database record?
A field or combination of fields that uniquely identifies a record
What is a foreign key in a database record?
A field that is used to relate to a primary key in another table
What is a database?
A collection of related files or information about a subject
What is a table in a database?
A collection of records that contain the same fields
What is the problem with a flat database in the scenario described?
Customer details are duplicated unnecessarily many times
What is the advantage of relating tables in a database?
It prevents data duplication
What is a record in a database?
A collection of fields that contain data
What is a field in a database?
A unit of data that has a data type and a picture
What is a major advantage of relating tables in a database?
It minimizes the size of the database
What happens when we update the address and phone number of a customer in a relational database?
We only need to update the customer's information in one place
What is the purpose of the 'Cust ID' column in the Customers table?
To link the customer to their orders
What is an advantage of minimizing data redundancy in a database?
It minimizes the work involved in entering new records
What is the purpose of the Orders table?
To store order details
What is a benefit of using a relational database?
It enhances the response time of the database application
What is the result of relating tables in a database?
Data redundancy is minimized
What information do we enter when creating a new order in the Orders table?
The customer's ID and order details
What is the primary function of a database management system (DBMS)?
To create, store, organize, and access data from a database
What is the primary purpose of a database management system?
To manage and use data from a database
Which of the following is an example of a DBMS for desktop systems?
Microsoft Access
What is the primary difference between Oracle Database and Oracle Database Lite?
Oracle Database is for desktop systems, while Oracle Database Lite is for small handheld computing devices
What is the primary purpose of identifying the data required by a business?
To create files for business data
Which of the following is an example of a DBMS for large mainframes and midrange computers?
DB2
What is the primary reason for using a database management system?
To manage and use data from a database
Which of the following is an example of a popular DBMS?
MYSQL
Study Notes
Database Concepts
- A primary key is a field (or combination of fields) in a database record that uniquely identifies the record.
- A foreign key is a field (or combination of fields) in a database record that is used as a primary key in another table.
Database Structure
- A database is an organized collection of related files or information about a particular subject.
- A table is a collection of records that contain the same fields.
- A database contains one or more tables.
- Each record in a table has a number of fields, and each field contains data and has a data type and a picture.
Relational Databases
- A relational database is a database made up of related tables.
- Relating tables in a database eliminates unnecessary duplication of data and reduces data update tasks.
Advantages of Relating Tables
- Relating tables minimizes the size of the database.
- Relating tables enhances the response time of the database application.
- Relating tables minimizes the work involved in entering new records.
- Relating tables minimizes the work involved in editing existing records.
Database Management System (DBMS)
- A DBMS is a specific type of software for creating, storing, organizing, and accessing data from a database.
- Examples of DBMS include ORACLE, MS SQL Server, MS Access, DB2, and MYSQL.
- Each DBMS is suitable for specific types of systems, such as desktop systems, mainframes, midrange computers, and handheld devices.
Understand the basics of database systems, including primary keys, foreign keys, and tables. Learn how to identify and define records with unique identifiers.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free
