Please enable JavaScript.
Coggle requires JavaScript to display documents.
SQL - Coggle Diagram
SQL
Structured Query Language
Data management & Manipulation.
SQL executes queries against a database
SQL retrieves data from a database
SQL can insert/create records
SQL can delete records from a database
TESTING THE DATABASE
Functional Testing
Whitebox/Blackbox
Non-functional Testing
Database handling
Structural Database Testing
Testing tables
How to Test
Check the name of the procedure
Test the signal at the input
Transfer the output request to test the storage handling
Make the error message wrong for any wrong query use.
DATABASE
SCHEMA (Database Model)
Database Tables
Record (rows = horozontal)
Field (columns = vertical)
Foreign Key
Identify a field in a table that can identify another table
Primary Key
Uniquely identify a record in a table
DMBS
Create and manage DATABASES using Extensions
Data Types (create a table)
Numeric
Date/Time
Binary
Character/String
Miscellaneous
SQL DATABASE
Structured Database in columbs
NoSQL DATABASE
Easy to scale, is not structured.