Database Design Chapter 1

What is a database?

• A collection of software programs

• A collection of music files

• A collection of images and videos

• A collection of data that supports electronic storage and manipulation

What is the definition of data?

• Processed information that has no meaning

• Music files

• Images and videos

• Raw facts that are not yet processed to reveal their meaning

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

• To manage structured data, accept queries, and respond to them

• To manage social media accounts

• To manage email accounts

• To manage video streaming services

What are the properties of databases?

• Security, Accessibility, Affordability, Scalability

• Inconsistency, Redundancy, Isolation, Dependence

• Completeness, Integrity, Flexibility, Efficiency

• Speed, Accuracy, Complexity, Simplicity

What is the purpose of the three-schema architecture in DBMS?

• To combine user applications with the physical database

• To store data in a single schema

• To create three different databases

• To separate user applications from the physical database

What is the benefit of using a server database over a desktop database?

• Increase simplicity and affordability

• Decrease performance and consistency

• Decrease flexibility and security

• Increase scalability and accessibility

Who is responsible for implementing the database system within an organization?

• End user

• System Administrator

• Database Administrator

• Application Programmer

What is the main disadvantage of a centralized database architecture?

• Single point of failure and network dependency

• Increased scalability and flexibility

• Decreased security and accessibility

• Multiple points of failure and high traffic

What is the role of an end user in a database system?

• Implement the database system

• Develop application programs

• Manage the physical storage structure

• Use the system without being aware of its presence

What is the purpose of the client-server architecture in DBMS?

• Slowing down data retrieval

• Increasing data redundancy

• Isolating clients from servers

• Efficient processing of messages between clients and servers