Notes, summaries, assignments, exams, and problems

1. Create Table Coach

CoachID INT PRIMARY KEY,

CoachName VARCHAR(20) NOT NULL,

Sports VARCHAR(15) NOT NULL,

DOJ DATE NOT NULL,

Gender CHAR(1) NOT NULL,

Salary INT NOT NULL

INSERT INTO Coach (CoachID, CoachName, Sports, DOJ, Gender, Salary)

VALUES

(1001, 'Mulund Gogoi', 'Boxing', '2004-09-01', 'M', 40000),

(1002, 'Arnab Duwara', 'Karate', '1999-10-01', 'M', 60000),

(1003, 'Nayan Bora', 'Arm Wrestling', '2005-02-28', 'M', 50000),

(1004, 'Devesh Hazarika', 'Basketball', '2010-05-05', 'M', 25000),

(1005, 'Chetan Sharma', 'Swimming', '2010-03-31', 'M', 25000),

(1006, 'Lakshmi Devi', 'Boxing', '2012-01-01', 'F', 22000);

3. Queries for Questions:

a) Display the Maximum and Minimum Salary of the Coaches

SELECT MAX(Salary) AS Max_Salary, MIN(Salary) AS Min_Salary

Exceptional Measures Without Successful Securitization

• Securitization theory posits that security threats are socially constructed through speech acts rather than objective dangers.
• However, exceptional measures, such as emergency laws, surveillance, or restrictions on rights, can be implemented without a successful securitization move.
• For instance, COVID-19 lockdowns were exceptional measures, but they were not always framed as a “security” issue like terrorism.

Characteristics of Securitization

• A shift from the political sphere to the security sphere occurs when a political issue (e.g., immigration, climate change) is transformed into a security threat.
• Existential threat language is employed, framing the issue as an urgent crisis that threatens

English Future Tenses: Will, Going To, & Present Continuous

Using "Will"

Used for spontaneous decisions and predictions without evidence.

1. Predictions: "He will be a good doctor."
2. Instant Decisions: "I’ll buy some then."
3. Promises and Refusals: "I will help you, but I won’t lend you money."
4. Offers: "I’ll carry your bag."
5. Requests: "Shall we eat out today?"

Using "Be Going To"

Used for prior plans, intentions, or predictions based on evidence.

1. Predictions with Evidence: "Look at the clouds. It’s going to rain."
2. Decisions Made Before Speaking: "Are you going to watch the game tonight?"

Using the Present Continuous

Used for actions happening at the moment of speaking or for confirmed future plans and arrangements.

• "I’m flying to New York tomorrow.

Amputations are classified based on the specific level at which a limb is removed. This classification typically follows anatomical regions and varies depending on whether it involves the upper or lower limb. This document provides a detailed breakdown by anatomical region:

Upper Limb Amputation Levels

Partial Hand Amputations (Transphalangeal)

• Finger Amputation: Removal of one or more fingers at the distal, middle, or proximal phalanx level.
• Thumb Amputation: Particularly significant due to its importance in grip function.
• Metacarpal Amputation: Loss of part or all of the hand while preserving the wrist.

Wrist Disarticulation

• Wrist Disarticulation: Amputation through the wrist joint, preserving the forearm bones.

Below Elbow Amputation (Transradial)

Review of Art Spiegelman's Maus

Maus by Art Spiegelman is a groundbreaking graphic novel that tells the true story of Vladek Spiegelman, a Jewish survivor of the Holocaust, as narrated by his son, Art. Combining historical events with personal struggles, the novel explores trauma, memory, and the complexities of father-son relationships.

One of the most striking aspects of Maus is its artistic style. Spiegelman represents different groups using animals—Jews as mice, Nazis as cats—which serves as a powerful metaphor for oppression and survival. The black-and-white illustrations enhance the raw and emotional tone of the story, making it even more impactful.

The novel alternates between past and present, depicting both Vladek’s survival and... Continue reading "Art Spiegelman's Maus: A Holocaust Narrative" »

First Line of Defense:

• 1) Mechanical Barriers & Surface Secretions:
  • A) Skin
  • B) Mucus Membrane:
    • 1) Sticky Mucus Membrane
    • Cilia
    • Mechanical Cleansing Action: Saliva, Tears, Urine
    • Low pH Stomach
    • Tears & Saliva: Lysozyme
    • Peristalsis in GIT
• 2) Normal Bacterial Flora
• 3) Naturally Occurring Antimicrobial Substances:
  • A) Type I Interferon: Antiviral Effect
  • B) Lysozyme: Lysis of Bacteria
  • C) Complement System: Responsible for Lysing Microorganisms
• 4) Body Hormones
• 5) Genetic Predisposition
• 6) Body Temperature: Pyrexia
• 7) Oxygen Tension
• 8) Inflammation

Serum Soluble Proteins:

• 1) C-Reactive Protein: Binds bacteria, activates complement, causes bacterial lysis (opsonin)
• 2) Ceruloplasmin: Oxidizes iron, inhibiting microbe iron uptake
• 3) Haptoglobin: Binds hemoglobin, inhibiting

Assam's Role in the Swadeshi Movement

The Swadeshi Movement, which began in 1905 as a response to the Partition of Bengal, soon spread to other parts of India, including Assam. The people of Assam actively participated in the movement, promoting the use of Indian-made goods and boycotting British products.

Key Organizations Promoting Swadeshi in Assam

Various associations and organizations were formed in Assam to promote the Swadeshi Movement. Some of these included:

• The Assam Association
• The Asomiya Bhasar Unnati Sadhini Sabha
• The Utkal Sammilani

Welfare Activities and Indirect Benefits

To achieve their objectives, these organizations undertook several welfare activities, which resulted in indirect benefits from the Swadeshi Movement. These activities... Continue reading "Assam's Contribution to India's Freedom Struggle: 1905-1922" »

Customer Value: (Quality, Time, Flexibility, Customer Experience, Innovation) / Price

Sustainability Paradigms: Economic (Viable, Equitable), Environment (Viable, Bearable), Social (Bearable, Equitable)

- Efficiency (Optimization), Differentiator (Innovation), Driver (Motivation) | - Audits (Assess Sustainability Performance)

Table 7.3: Factors for Calculating Three-Sigma Limits for the X (Bar) Chart and R-Chart

*A sample is out of control if its value falls below the LCL or above the UCL*

Acid Value Determination in Oils: Principle and Procedure

Here's an explanation of the principle and procedure involved in determining the acid value of an oil sample:

Principle

The acid value of an oil sample is a measure of the amount of free fatty acids present in the oil. The principle of the acid value determination is based on the reaction between the free fatty acids in the oil and a strong base, such as potassium hydroxide (KOH). The reaction is as follows:

RCOOH (Free Fatty Acid) + KOH → RCOOK (Potassium Salt) + H₂O

Procedure

Here's the step-by-step procedure for determining the acid value of an oil sample:

1. Apparatus

• 250 mL Erlenmeyer flask
• Burette
• Pipette
• Volumetric flask
• Phenolphthalein indicator

2. Reagents

• Potassium hydroxide (KOH) solution