Practical SQL Examples for Database Management
Student and Course Database Examples
Database Creation
It’s good practice to create a dedicated database for your tables.
-- Create a new database (optional, good practice)
CREATE DATABASE IF NOT EXISTS StudentDB;
USE StudentDB;Table Creation
Here, we define the Student and Course tables. Note the use of PRIMARY KEY, FOREIGN KEY, NOT NULL, UNIQUE, and CHECK constraints.
CREATE TABLE Student (
StudentID INT PRIMARY KEY AUTO_INCREMENT,
Name VARCHAR(100) NOT NULL,
Dept VARCHAR(50),
Age INT,Essential Research Methods for Data Collection
Core Research Methods and Techniques
The aim of research is to systematically discover and respond to the many questions that human beings pose. This document examines four essential data collection methods used across social sciences and psychology.
The Interview
The interview is a technique for research that serves as an essential tool for professional psychology. It involves formulating a set of questions orally to individuals for the purpose of obtaining information.
Features of the Interview
- Frequently
Niche Strategy and Corporate Responsibility: Driving Small Business Success
The Competitive Edge of Small Enterprises
Introduction to Niche Marketing
There is a new generation of competitors that has entered the market and is posing a great threat to larger companies. These companies tend to operate on a specific niche, which makes them appear “closer to the customer.”
These companies concentrate on selling to a smaller market. This can help lower costs because specialization creates savings. These small firms can establish a strong image and position in their niche. Niche
Read MoreFundamentals of Algorithm Design, Analysis, and Complexity Theory
Iterative Algorithms: Definition and Structure
An iterative algorithm repeatedly executes a set of instructions using loops (for, while, do-while) until a certain condition is satisfied. Instead of solving a problem directly in one step, the solution is approached gradually by repeating computations and updating variables.
Iterative algorithms rely on repetition (iteration) and are widely used for problems involving repeated calculations, searching, and optimization. Examples include Linear Search,
Read MoreThe First World War: Origins, Fronts, and Conclusion
The Belligerents of World War I
The Central Powers and The Allies
The conflict involved two major groups:
- The Central Powers: Germany, Austria-Hungary, The Ottoman Empire, and Bulgaria (other countries joined later).
- The Allies (or Triple Entente): France, Russia, the United Kingdom (UK), and Serbia (the US and other countries joined later).
Underlying Causes of the First World War
Imperialism and Colonial Conflicts
Competition among European countries for imperialist expansion fueled tensions (e.g., the
Read MoreGeological Time Scale and Principles of Stratigraphy
Steno’s Fundamental Principles
Nicolas Steno proposed three main principles in stratigraphy:
- The Principle of Original Horizontality of the Strata.
- The Principle of Lateral Continuity of the Strata.
- The Principle of Superposition of the Strata.
Principle of Cross-Cutting Relationships
An event or feature that cuts across layers of rock must be younger than the layers it affects.
Principle of Faunal Succession
The fossils within rock layers are from the time the rock was deposited. Therefore, we can recognize
Academic English Final Test Solutions: Vocabulary & Grammar
FINAL TEST 1
Vocabulary (Page 1)
Exercise 1: Matching/Definitions
- involved in
- set up
- various
- impractical
- surroundings
- track
- sensitive
- ecological balance
- career
- sign up for
Exercise 2: Word Forms/Definitions
- educational
- requirements
- worthless
- incomplete
- rechargeable
- reliable
- disappear
- underestimate
Vocabulary (Page 2)
Exercise 3: Open Answers
Accept all logical and grammatically correct answers.
Exercise 4: Possible Answers
- know any foreign languages
- very little freedom of speech there
- will lead you into the ceremony
- don’t
T+1 Settlement Cycle: Clearing Process in Indian Capital Markets
Introduction to Clearing and Settlement
Clearing and settlement is the backbone of the securities market. It ensures that every trade executed on the stock exchange is completed safely and efficiently – the buyer receives the securities and the seller receives the funds. In India, the equity market follows a T+1 rolling settlement cycle, meaning settlement takes place one working day after the trade date.
The 7-Step Settlement Cycle
Step 1: Trade Execution (T Day)
The process begins when an investor
Read MoreMicrobial Hydrocarbon Cleanup: Bioremediation Techniques
Microbial Biodegradation of Hydrocarbons
Hydrocarbons are major constituents of crude oil and petroleum. They can be biodegraded by naturally occurring microorganisms in freshwater and marine environments under a variety of aerobic and anaerobic conditions.
The Role of Microbes in Bioremediation
The ability of microorganisms—including bacteria, archaea, fungi, and algae—to break down hydrocarbons is the fundamental basis for both natural attenuation and enhanced bioremediation efforts.
Enhancing
Read MoreEssential Calculus Theorems and Formula Reference
Fundamental Calculus Definitions and Theorems
The Derivative and Integral Definitions
The Derivative Definition
The derivative of a function $f(x)$, denoted $f'(x)$, is defined using the limit of the difference quotient:
$$f'(x) = \lim_{h \to 0} \frac{f(x+h) – f(x)}{h}$$
The Definite Integral (Riemann Sum)
The definite integral of $f(x)$ from $a$ to $b$ is defined as the limit of the Riemann sum:
$$\int_a^b f(x) dx = \lim_{n \to \infty} \sum_{i=1}^n f(x_i^*) \Delta x$$