Relational Database Management Systems: Core Concepts
Database Fundamentals
Primary and Candidate Keys
A Candidate Key is a minimal set of attributes that can uniquely identify a tuple. A Primary Key is the candidate key chosen by the designer to uniquely identify records in a table (cannot be NULL).
Integrity Constraints
- Referential Integrity: Ensures that a foreign key value in one table must either match a primary key value in the referenced table or be NULL, maintaining consistency between related tables.
- Entity Integrity: States that the primary key
Essential Linux Command Reference for System Tasks
1. Information Maintenance Commands
wc (Word Count)
Counts lines, words, and characters in a file.
wc file.txt— Show lines, words, and characterswc -l file.txt— Count only lineswc -w file.txt— Count only wordswc -c file.txt— Count only characters
clear (Clear Screen)
Clears the terminal screen.
clear
cal (Calendar)
Displays a calendar of the current or specified month/year.
cal— Show current month’s calendarcal 2025— Show calendar for the year 2025cal 03 2025— Show calendar for March
Essential Business Research Concepts & Methods
Business Research: Definition, Objectives, Importance
Business Research is a systematic and objective process of gathering, recording, and analyzing data to aid in making business decisions. It involves identifying problems or opportunities, collecting relevant data, analyzing the data, and interpreting the results for decision-making.
Objectives of Business Research:
- To understand business problems and challenges.
- To identify opportunities and threats.
- To support decision-making with data.
- To forecast
Mastering Windows File Management and MS-DOS Commands
Understanding Windows Explorer
Windows Explorer (now commonly known as File Explorer) is a fundamental tool for navigating through directories and subdirectories on your computer. It provides a windowed interface where you can efficiently manage files and folders.
Customizing Windows Explorer
- Task Pane Options: Within a Windows Explorer window, you can customize the task pane. The number of choices available depends on your current view and settings.
- Folder View Indicators: In the folder options, you’
Basic Linux Terminal Commands
File & Directory Commands
- ls: List directory contents.
- cd directory_name: Change directory.
- pwd: Print working directory.
- mkdir directory_name: Create a directory.
- rmdir directory_name: Remove an empty directory.
- cat file: Display file content.
- cp source destination: Copy files or directories.
- mv source destination: Move or rename files or directories.
- stat file: Display file or file system status.
- stat -f file: Display file system status.
- wc -c file: Count bytes in a file.
- zcat file.gz: Display content
Managing Files: Wildcards, Commands, and Operations
Understanding File Templates (Wildcards)
File templates, often using wildcards, help select multiple files:
*.exe: Selects all files with the.exeextension.?????.bat: Selects all files with a five-character name and the.batextension.*.??: Selects all files with any name and a two-character extension.*.*: Selects all files.????????.???: Selects all files with names up to eight characters and extensions up to three characters (common in older systems).