Exploring Database Management Concepts

What is a database?

• A database is an organized collection of data stored electronically.

• A database is a physical location where data is printed.

• A database is a collection of random files stored on a computer.

• A database is a type of software used for web browsing.

Which of the following is a type of database model that has tuples concept?

• Network database model

• Relational database model

• Hierarchical database model

• Object-oriented database model

What does SQL stand for?

• Standard Query Language

• Simple Query Language

• Structured Query Language

• Structured Query List

What is the primary purpose of a database management system (DBMS)?

• To ensure data is only accessible to one user at a time.

• To store data in a single file format.

• To create visual representations of data only.

• To provide a systematic way to manage and manipulate data in databases.

In a relational database, what is a primary key?

• A primary key is an optional field in a database record.

• A primary key can have duplicate values.

• A primary key is a foreign key in another table.

• A primary key is a unique identifier for a record in a relational database.

How do you retrieve data from a database using SQL?

• Use the SELECT statement to retrieve data from a database.

• Use the UPDATE statement to modify data in a database.

• Use the INSERT statement to add new data to a database.

• Use the DELETE statement to remove data from a database.

Explain the difference between a primary key and a foreign key.

• A primary key is always a string, while a foreign key is always an integer.

• A primary key uniquely identifies a record in a table, while a foreign key links to a primary key in another table.

• A primary key can be duplicated across tables, while a foreign key cannot.

• A primary key is used for indexing, while a foreign key is used for sorting records.

How would you approach designing a database for a new application?

• Identify requirements, define entities and relationships, create ERD, choose database type, normalize data, implement schema.

• Conduct market research

• Choose a programming language

• Develop a user interface

A data model is a ______________.

• The mathematical model of formulas and logic used in a system

• The abstract creating of an ideal system transformation

• The model that is produced by extreme programming

• The expanded, thoroughly balanced and normalized use case for a system

• A formal way of representing the data that are used and created by a business system

On an ERD _________________:

• Processes are listed alphabetically with relationship connections drawn between processes

• Data elements are listed alphabetically with a cross listing to the processes that manipulate them

• Data elements are grouped in a hierarchical structure that is uniquely identified by number

• Data elements are listed together and place inside boxes called entities