1. intro to DB Flashcards
What is a database?
An organized collection of logically related data.
Define data.
A stored representation of objects and events that have meaning and importance in the user’s environment.
Define metadata.
Data that describe the properties or characteristics of user data.
What is the difference between data and information?
Data are stored representations, while information is processed data that increases knowledge.
What are the major disadvantages of file processing systems?
They include program-data dependence, data duplication, limited data sharing, lengthy development times, and excessive maintenance.
What problems arise from data dependency in file processing?
Each application must manage its own data and metadata, leading to non-standard formats and lack of central control.
What issues stem from data redundancy?
Duplicate data wastes space and can lead to inconsistencies and increased maintenance.
What is the database approach?
A centralized system using a DBMS that organizes, controls, and secures data in a standardized and efficient manner.
What are the benefits of the database approach?
It improves:
* data sharing
* security
* integration
* scalability
* consistency
* maintenance
* overall productivity.
What does a DBMS provide?
Efficient, durable data storage; logical data organization; controlled, concurrent access; data integrity enforcement; security; and backup/recovery capabilities.
What are the phases of the Database Development Lifecycle?
- Capture user requirements
- develop a conceptual model
- create a logical model
- design the physical implementation
- implement, and maintain the database.
What is the focus of the course in terms of database technology?
Data modeling using the Entity Relationship Model, relational data modeling with MySQL, and querying with SQL.
What is SQL used for?
It is a structured language for retrieving and updating data in a database.
