Fundamental C Programming Concepts
Here’s a brief explanation for each topic:
1. Modular Programming, Top-Down and Bottom-Up Approaches
Modular Programming: Involves dividing a program into smaller, manageable modules or functions, each performing a specific task. This promotes code reusability, readability, and easier debugging.
Top-Down Approach: The problem is broken down into smaller sub-problems, starting from the highest level of abstraction. Each sub-problem is solved step by step.
Bottom-Up Approach: In contrast to the top-down
Read MoreServer Administration: Essential Tasks and Configuration
Creating a Domain
Server Manager: Add Roles and Features, Active Directory Domain Services.
Adding a Computer to the Domain
Steps:
- Control Panel
- System
- Change Settings
- Computer Name: Change
- Member of: Input domain
Creating Local and Domain Accounts
Domain Accounts
Steps:
- Control Panel
- System
- Administrative Tools
- AD Users and Computers
- Right-click, New User, and create the user
- Right-click on the user created, Add to group, Find now
- Click on the group to add
Local Accounts
Steps:
- Login to local host
- System
- Administrative
Data Link Layer Communication Protocols and Cabling
Link Layer
Protocols
Contention-Based Protocols
Strife (Pure and Slotted ALOHA): Stations compete for transmission time. Pure ALOHA is optimal for low traffic (18.4% efficiency), while Slotted ALOHA improves efficiency to 36.8% by synchronizing transmissions into time slots.
CSMA (Carrier Sense Multiple Access): Transmission is delayed if the medium is busy. Variations include:
- 1-persistent CSMA: Wait until the medium is free (optimal for low, continuous traffic).
- Non-persistent CSMA: Wait a random
Database Design for Art Galleries: Schema & SQL Queries
Although you always wanted to be an artist, you ended up being an expert on databases because you love to cook data and you somehow confused database with data baste. Your old love is still there, however, so you set up a database company, ArtBase, that builds a product for art galleries. The core of this product is a database with a schema that captures all the information that galleries need to maintain.
ArtBase Database Schema
Artists
Artists, their names (which are unique), birthplaces, age, and
Virtual Memory and Data Storage Explained
Virtual Memory and Segmentation
In memory segmentation, partitions are resizable. Segmentation takes advantage of the fact that programs are divided into logical parts, such as pieces of data, code, etc. In this case, the program and its data are divided into a number of segments. The translation is carried out in the same way as paging, but taking into account that the size of the segments is variable. The segment table controls this. Thus, each entry in the table should also contain the residence
Read MoreEssential SQL Commands: Query, Modify, and Manage Data
Frequently Used SQL Commands
DROP (Delete a Table)
DROP TABLE table_name;
DROP TABLE IF EXISTS table_name; (Checks if the table exists before deleting)
DELETE (Delete Records)
DELETE FROM table_name WHERE field_name = "value";
Example: DELETE FROM table_name WHERE field_name = "delete to juan:";
WHERE Clause
SELECT * FROM table_name WHERE field_name > 1000;
AND and OR Operators
SELECT * FROM table_name WHERE field_name > 1000 OR (field < 500 AND field > 275);
BETWEEN Operator
SELECT * FROM table_