1.1 Flashcards
What is Data
numeric, textual, visual, or audio information that describes real-world systems.
What is data scope?
The amount of data produced and collected
What is data format?
Data may be produced as numbers, text, image, audio, or video
What is data access?
Some data sources are private while others are made publicly available
What is meant by analog ?
encoded as continuous variations on various physical media.
What is meant by digital?
encoded as zeros and ones on electronic and magnetic media.
What is a database?
A database is a collection of data in a structured format.
What is a database system or database management system (DBMS)?
A database system, also known as a database management system or DBMS, is software that reads and writes data in a database. Database systems ensure data is secure, internally consistent, and available at all times.
What is a query?
A query is a request to retrieve or change data in a database.
What is query language?
query language is a specialized programming language, designed specifically for database systems. Query languages read and write data efficiently, and differ significantly from general-purpose languages such as Python, Java, and C++.
What is a database application?
A database application is software that helps business users interact with database systems.
What is a database administrator responsible for?
A database administrator is responsible for securing the database system against unauthorized users. A database administrator enforces procedures for user access and database system availability.
What does a database designer do?
A database designer determines the format of each data element and the overall database structure. Database designers must balance several priorities, including storage, response time, and support for rules that govern the data. Since these priorities often conflict, database design is technically challenging.
What does a database programmer do?
A database programmer develops computer programs that utilize a database. Database programmers write applications that combine database query languages and general-purpose programming languages. Query languages and general-purpose languages have significant differences, so database programming is a specialized challenge.
What is a database user?
database user is a consumer of data in a database. Database users request, update, or use stored data to generate reports or information. Database users usually access the database via applications but can also submit queries directly to the database system.
