Intro to Databases
![](https://convergesolve.com/wp-content/uploads/2015/05/database-word-cloud.jpg)
What is a database?β
According to Oracle, a database is an "organized collection of structured information, or data, typically stored electronically in a computer system." In simplistic terms, it's a file or document of tangible or intangible data about a particular item. For example, information collected to describe a person would be that individual's name, age, dob, weight, height, etc. A collection of individuals or items would assemble a table, and a group of tables would form a database.
What's a table?
A table represents a subject or event in an application
![](https://s3-us-west-1.amazonaws.com/morpheus-staging/system/spud_media/188/original/tables1.jpg?1414453819)
Types of databasesβ
Relationalβ
This type of database defines database relationships in the form of tables. It is also called Relational DBMS, which is the most popular DBMS type in the market. Database example of the RDBMS system include MySQL, Oracle, and Microsoft SQL Server database.
π₯ Popular Relational DBMS:β
- POSTGRESQL
- MYSQL
- ORACLE
- SQL SERVER
NoSQLβ
π§ No Content
π₯ Popular NoSQL DBMS:β
- MongoDB
- DynamoDB
- ORACLE
- SQL SERVER
What is Structured Query Language (SQL)?β
π§ No Content
The database design processβ
The design process consists of the following steps:β
1. Determine the purpose of your database
2. Find and organize the information required
3. Divide the information into tables
4. Turn information items into columns
Decide what information you want to store in each table. Each item becomes a field, and is displayed as a column in the table. For example, an Employees table might include fields such as Last Name and Hire Date.
5. Specify primary keys
Decide what information you want to store in each table. Each item becomes a field, and is displayed as a column in the table. For example, an Employees table might include fields such as Last Name and Hire Date.
6. Specify primary keys
Decide what information you want to store in each table. Each item becomes a field, and is displayed as a column in the table. For example, an Employees table might include fields such as Last Name and Hire Date.
Choose each tableβs primary key. The primary key is a column that is used to uniquely identify each row. An example might be Product ID or Order ID.
7. Set up the table relationships
8. Refine your design
9. Apply the normalization rules
Primary Keyβ
π§ No Content
Secondary Keyβ
π§ No Content
Constraintsβ
π§ No Content