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)
-
Module 01a - History12
-
Module 01b - Components of a Database System9
-
Module 02a - Introduction to SQL8
-
Module 02b - Basic SQL - Part I/II13
-
Module 02b - Basic SQL - Part II/II11
-
Test 1 - Module 115
-
Test 1 - Module 222
-
Module 03a - Dependencies17
-
Module 03b - Normalization12
-
Module 04 - Data Modeling13
-
Module 05a - Relationship and Cardinality21
-
Module 05b - Relationships and Patterns in ER Model11
-
Module 06a - Creating Tables13
-
Module 06b - Creating Relationships7
-
Module 06c - More Constraints14
