Database Management Systems: Core Concepts and SQL
E.F. Codd’s 12 Rules for RDBMS
E.F. Codd, a pioneer in the field of relational databases, defined 12 rules (numbered 0 to 12) to determine whether a Database Management System (DBMS) can be considered a truly Relational Database Management System (RDBMS).
The 12 Rules Breakdown
- Rule 0: The Foundation Rule: A system must use its relational facilities exclusively to manage the database.
- Rule 1: The Information Rule: All information must be represented as values in tables (rows and columns).
- Rule 2: Guaranteed
Essential Computer Science and Networking Concepts
1. What is the Internet?
The Internet is a global network of networks that connects millions of private, public, academic, business, and government networks. It uses the standard Internet Protocol Suite (TCP/IP) to link devices worldwide and share data.
2. Understanding Network Protocols
A protocol is a set of formal rules that govern how data is transmitted and processed over a network. Five common protocols include:
- HTTP (Hypertext Transfer Protocol): Used for transferring web pages over the internet.
Implementing Stacks, Queues, and Linked Lists in C
Stack Implementation
typedef struct Node {
int value;
struct Node* next;
} *pNode;
typedef struct Stack {
pNode top;
int len;
} *pStack;
pStack createStack() {
pStack pS = (pStack)malloc(sizeof(struct Stack));
if (pS) {
pS->top = NULL;
pS->len = 0;
}
return pS;
}
int isEmpty(pStack pS) {
if (pS->top && pS->len) return 0;
return 1;
}
int push(pStack pS, int c) {
pNode p = (pNode)malloc(sizeof(struct Node));
if (p) {
p-&Computer Architecture: Key Concepts and Principles
Von Neumann Architecture
Definition: The Von Neumann Architecture is a computer design model proposed by John von Neumann in which data and instructions are stored in the same memory and share the same communication path.
Main Components
- Central Processing Unit (CPU): Executes instructions (ALU + Control Unit).
- Memory Unit: Stores both data and programs.
- Input Unit: Takes input from the user.
- Output Unit: Displays results.
- System Bus: Transfers data between components.
Key Feature: Uses single memory for
Read MoreOperating System Fundamentals and Core Architecture
Operating System Roles and Basic Concepts
- An Operating System (OS) manages hardware and acts as an intermediary between users and hardware, providing a foundation for application programs.
- The OS kernel is the core component loaded initially during startup; it has direct hardware access and remains resident in memory.
- The startup process involves a bootstrap program that loads the OS kernel into memory.
Hardware Components and System Structure
- Components include the CPU, main memory, secondary memory,
Java Networking and Design Patterns: Key Concepts
Java Networking Classes Comparison
| Inet4Address | Inet6Address |
|---|---|
| Represents IPv4 address. | Represents IPv6 address. |
| 32-bit address. | 128-bit address. |
| Dotted decimal format (e.g., 192.168.1.1). | Hexadecimal colon format (e.g., 2001:db8::1). |
| Limited address space (about 4.3 billion). | Very large address space (2¹²⁸). |
| Simple header structure. | More advanced and larger header. |
Subclass of InetAddress for IPv4. | Subclass of InetAddress for IPv6. |
| URLConnection | HttpURLConnection |
|---|---|
| Superclass for all types of URL connections. | Subclass |