What is a database?
A shared collection of related data supporting an organization's activities.
What is the purpose of a database system?
To meet an organization's information needs.
What does a database system contain?
Basic components that support data collection and use.
What are data in relation to a topic or item?
Raw facts that are unorganized and unstructured.
How is information different from data?
Information is processed or organized data that is meaningful or useful.
When do separate unordered values become information in the student example?
When organized under fields like STUDENT_ID, NAME, ADDRESS, and PHONE.
What is a file management system?
Software that manages data files in a computer system.
How are files related in a traditional file-based system?
Each file is independent of the others.
How is data integrated in traditional file-based systems?
By writing an individual program for each application.
What are the advantages of traditional file systems?
They are simple, less complex, require minimal investment, and no specialists.
Why are traditional file systems inefficient for large firms?
They are inefficient for maintaining records with many items.
Why do traditional file systems have high data redundancy?
Because the same data may be duplicated across files.
Why do traditional file systems have high program-data dependency?
Changing a file structure requires changing the application programs that access it.
What causes data integrity problems in traditional file systems?
A changed constraint must be updated in every application program accessing the data file.
What security and backup features do traditional file systems lack?
They provide poor security and lack automatic backup and recovery.
How is concurrent access commonly managed in traditional file systems?
By locking a file when an application opens it.
What is Industry 4.0 focused on?
Interconnectivity, automation, machine learning, and real-time data.
Name three technologies included in Industry 4.0.
Blockchain, IoT, and artificial intelligence.
What is Blockchain?
A distributed database maintaining a growing list of cryptographically linked blocks.
How does IoT differ from IIoT?
IoT connects physical objects to the Internet; IIoT connects people, data, and machines in manufacturing.
What does Big Data consist of?
Large sets of structured or unstructured data analyzed to reveal patterns and trends.
What is artificial intelligence?
A computer's ability to perform tasks requiring human-like intelligence.
What is cloud computing?
Using interconnected remote servers on the Internet to store, manage, and process information.
What enables quantum computing to process beyond traditional speeds?
Qubits that represent 0 and 1 simultaneously for parallel processing.
What is a database management system (DBMS)?
Software that controls data storage, organization, retrieval, and access to databases.
What is the primary goal of a DBMS?
To provide a convenient and efficient environment for retrieving and storing information.
Which sectors commonly use databases for managing information?
Schools, banks, airlines, railways, and telecommunication departments.
How does the database approach reduce data redundancy?
By storing each data item in only one place in the database.
What does a DBMS enforce to maintain data integrity?
Integrity constraints that ensure users enter valid information.
How does a DBMS support concurrent access?
Through a concurrency control subsystem that manages simultaneous data access and updates.
How does a file system store data compared to a database system?
A file system stores unstructured data as isolated files, unlike databases.
What type of data does a database system store?
A database system stores structured data with constraints and interrelationships.
What is a characteristic of data redundancy in file systems?
File systems generally have high data redundancy.
How does data inconsistency in file systems compare to databases?
File systems have high data inconsistency, unlike databases which have low.
What is the security level of file systems compared to database systems?
File systems have low security, whereas databases have high security.
When are file systems typically used regarding security constraints?
File systems are used for files requiring fewer security constraints.
For what security conditions are database systems preferred?
Database systems are preferred when security constraints are high.
Who accesses the database from a terminal using applications?
End users.
What do database designers define besides content and structure?
Constraints and functions or transactions.
Who communicates with end users to understand their needs?
Database designers.
Who implements application programs that access stored data?
Application programmers.
What must application programmers be familiar with?
DBMSs.
Who authorizes access and monitors database use?
Database administrator.
Who decides database instances and defines the schema?
Database administrator.
Who manages backup, recovery, and security for the database?
Database administrator.
Test your knowledge with 23 questions on Database Systems Overview.
1. What best defines a database?
2. Why is a database system developed for an organization?
Review the complete course in the study sheet for Database Systems Overview.
See study sheet →Import your course and AI generates flashcards in 30 seconds.
Flashcard generator