Test 1 - Module 1 Flashcards
What’s the definition of Database
A usually large collection of data organized especially for rapid search and retrieval.
What’s the purpose of Database
The purpose of a database is to help people track things of interest to them.
Who’s the creator of Relational Model
Eduard (Ted) F. Coddy invented the Relational databases in 1970
Which problems Codd faced to make his research become a legitimacy in the field?
- The technical community at large (new paradigm)
- One within IBM (Conflict with IMS product)
What is SQL
Structured Query Languange is a procedural language for use relational databases
What are ER models
Allows the designer to concentrate on the use of data instead of the logical table structure.
How can a database table be described
Database tables contains rows (objects) and columns (attributes) like spreadsheets.
What are the differences between data and information
- Data = recorded facts and figures
- Information = knowledge derived from data
Which are the components of a database system
- Users
- Database application
- SQL
- DBMS
- Database
What is metadata
It’s the self-describing data of a database itself, which is data about data.
Database contents
- Tables of user data
- Metadata
- Indexes
- Stored procedures
- Triggers
- Security data
- Backup/recovery data
Different types of database
- Single user: own purpose (CEO)
- Multiple User: Blackboard
- E-business: SAS
Three different types of database design
- from existing data
- new systems development
- Database redesign
What is normalization
A set of rules do organize columns and tables to minimize data redundancy
What are the main characteristics of databases
A database is a self-describing collection of integrated tables.
- The tables are called integrated because they store data about the relationships between the rows of data.
- A database is called self-describing because it stores a description of itself (metadata)
