Database and Software Development Concepts

These flashcards cover key concepts related to databases and software development, including definitions, commands, and characteristics of programming.

Types of databases

Databases can be classified by functional type (e.g., Operational, Analytical) or by data model (e.g., Relational, Document, Key-Value, Graph, Hierarchical).

Data model

A structure that defines how data is stored, organized, and related.

TRUNCATE

SQL command that deletes all rows in a table but retains the structure of the table.

DROP

SQL command that deletes the entire table and all its data.

SQL injection attack

A hacking method where bad SQL code is entered to access or destroy data.

Version control

A system that tracks changes to code and enables team collaboration, such as Git.

High-quality programming code

Code that is easy to read, well-structured, reusable, efficient, tested, and maintainable.

Types of software quality

Includes functional quality (does it work?) and non-functional quality (speed, usability, security).

Managing complexity in programming code

Techniques include using functions, breaking code into modules, and maintaining simplicity and readability.

Code coupling

The degree to which one part of code relies on another, with types including data coupling (low risk) and stamp coupling (more risky).

Cohesion

The extent to which parts of a module belong together.

Measuring cohesion

Assessing whether functions in a module all focus on the same task.

Package in programming code

A container that holds related classes or files, for example, in Java.

Java foundations

Core concepts in Java include Object-Oriented Programming, Inheritance, Encapsulation, Polymorphism, and the Java Virtual Machine (JVM).

SQL UPDATE command

Command to change data in a table, formatted as:

UPDATE table_name SET column1 = value1 WHERE condition.