Chapter 1&2: Key Concepts of Database Systems Flashcards
What is the difference between data and information?
Data refers to raw, unprocessed facts and figures, while information is data that has been processed or organized in a way that is meaningful and useful.
What is metadata?
Metadata is data that describes other data, such as the structure, format, and context of the data.
What is the difference between structured and unstructured data?
Structured data is organized in a well-defined manner, typically in tables with rows and columns (e.g., databases), while unstructured data has no pre-defined format (e.g., text, images, videos).
What are the advantages of using a database system over traditional file processing systems?
Database systems provide better data integrity, reduced redundancy, easy querying, and data security. Traditional file processing systems are prone to data redundancy, inconsistency, and difficulties in querying data.
What is a DBMS and what can you do with it?
A Database Management System (DBMS) is software that manages databases. It allows users to store, retrieve, update, and manage data. It provides functionalities like data definition, data manipulation, and access control.
What is the role of a Database Administrator (DBA)?
The DBA is responsible for managing the database system, ensuring data security, optimizing performance, and maintaining database integrity.
What does a DB designer do?
A DB designer creates the database schema, designs the data structure, and ensures that the database meets business requirements and user needs.
What are the phases in the database application development process?
The phases include requirements analysis, conceptual design (ER model), logical design (relational model), physical design, implementation, and maintenance.
