Notes, summaries, assignments, exams, and problems for Primary education

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

English Connectors and Linkers

1. Reason and Cause

(Razón o causa de algo) →

• Because / as / since (+ sentence)
• Because of / owing to / due to (+ noun)

2. Purpose

(Propósito o finalidad) →

• To / In order to / So as to (+ infinitive)
• In order that / So that (+ sentence with modal verb)

3. Exemplifying

(Aclarar lo que explicamos) →

• For example / for instance
• Such as... / like...

4. Additions

(Para añadir algo) →

• Moreover / Furthermore / Besides (Además)
• In addition to / as well as (+ noun or pronoun)

5. Result or Consequence

(Resultado o consecuencia de una acción) →

• Therefore (Por ello) / Consequently / For this reason / Thus
• As a result of (+ substantive or pronoun)

6. Contrast

→

• However / Nevertheless / On the contrary
• While / Whereas (Sentence with

Unit 3: Financial Consolidation Methods

Global Integration (Consolidation)

• Non-current investments: 0
• Share capital and reserves: Parent company only
• Profit/loss: % Parent + (% Subsidiaries × Profit of subsidiaries)
• External shareholder: % Remaining purchase × (Share capital B + Reserves B + Profit/loss B)
• Goodwill: Price paid - (Share capital B × % B)
• Non-controlling interest: % Remaining purchase × (Share capital B + Reserves B + Profit/loss B)
• Non-current assets: Goodwill + PPE (A and B)
• Investment in A: 0 (due to consolidation)

Proportional Integration (Joint Ventures)

• Non-current investments: 0
• PPE, Current Assets, Liabilities, and Profit/loss: Parent + (Subsidiary × % Purchased)
• Share capital and reserves: Parent company only
• Negative differences

Steps in Root End Surgery

• Local anesthesia and hemostasis
• Management of soft tissue
• Management of hard tissue
• Surgical access (visual and operative)
• Access to root structure
• Periradicular curettage
• Root end resection
• Root end preparation
• Root end filling
• Soft tissue repositioning and suturing
• Post-surgical care

Root End Preparation

Preparing a cavity to receive root end filling.

According to Carr and Bentkover, this involves a Class I preparation at least 3mm into root dentin with walls parallel to and coincident with the anatomic outline of the pulp space.

Key requirements:

1. The apical 3mm of the root canal must be freshly cleaned and shaped.
2. The preparation must be parallel to and coincident with the anatomic outline of the pulp space.
3. Adequate retention form

Mineral Trioxide Aggregate (MTA) Applications

Pulp Therapy

• Pulp capping
• Furcation repair
• Strip perforation repair
• Root resorption repair
• Immature teeth
• Root end filling material

Elements of Pulp Regeneration

Therapy for exposed dental pulps using stem cells and a biofunctional scaffold, inhibiting or eliminating infection to facilitate pulp generation.

Nickel-Titanium (NiTi) Rotary Instruments

Advantages of NiTi Reciprocation

• Mimics manual movement
• Reduces risks associated with continuous rotation in curved canals

Types of Posts

1. Carbon fiber epoxy resin posts
2. Zirconia posts
3. Glass fiber reinforced posts
4. Ultra-high strength polyethylene fiber reinforced posts

Advantages of NiTi Rotary

• Gradual, evenly tapered radicular preparation
• Fewer instruments required
• Reduced

Aggressive Periodontitis: Localized vs. Generalized

This section outlines the key similarities and differences between Localized Aggressive Periodontitis (LAP) and Generalized Aggressive Periodontitis (GAP).

Localized Aggressive Periodontitis (LAP)

• Circumpubertal onset.
• Robust serum antibody response to infecting agents.
• Localized first molar/incisor presentation with interproximal attachment loss on at least two permanent teeth, one of which is a first molar.
• Lack of clinical inflammation.
• Presence of deep periodontal pockets.
• Amount of plaque inconsistent with the amount of periodontal destruction.
• Plaque forms a thin biofilm, rarely mineralizing into calculus.
• Distolabial migration and diastema formation.
• Increasing mobility of first molars.
• Sensitivity

Classification of Pulpal Diseases

Reversible Pulpitis (Acute)

This refers to inflammation of the pulp that is not severe. If the cause is eliminated, the inflammation will resolve and the pulp will return to normal.

Etiology: Mild or short-acting stimuli such as:

• Incipient caries
• Cervical erosion
• Occlusal attrition

Irreversible Pulpitis (Acute)

This is often a sequel to and a progression from reversible pulpitis. It is a severe inflammation that will not resolve even if the cause is removed.

Chronic Ulcerative Pulpitis

The pulp is cariously exposed with an abscess formation at the site. Pain is typically absent because of adequate drainage and the absorption of the exudate.

Chronic Pulpitis (Closed Form)

This may occur from operative procedures, trauma,... Continue reading "Pulpal Diseases and Maxillary First Premolar Anatomy" »

Masseter Muscle

The masseter is a quadrilateral muscle consisting of three layers:

• Superficial Layer: Arises by a thick aponeurosis from the zygomatic process of the maxilla and the anterior two-thirds of the lower border of the zygomatic arch. It passes downward and backward at a 45-degree angle and inserts into the lower part of the lateral surface of the ramus of the mandible.
• Middle Layer: Arises from the anterior two-thirds of the deep surface and the posterior one-third of the lower border of the zygomatic arch. It passes vertically downward and inserts into the middle part of the ramus.
• Deep Layer: Arises from the deep surface of the zygomatic arch, passes vertically downward, and inserts into the upper part of the ramus and the coronoid

Introduction to the Respiratory System

The cells of the human body require oxygen to stay alive. The respiratory system provides oxygen to the body's cells while removing carbon dioxide, a waste product that can be lethal if allowed to accumulate.

3 Major Parts of the Respiratory System

• Airway: Nose (nasal cavity), mouth, pharynx, larynx, trachea, bronchi, and bronchioles.
• Lungs: The functional unit of the respiratory system, facilitating the exchange of O2 and CO2 via the alveoli.
• Diaphragm Muscles: Muscles of respiration (including intercostal muscles) that separate the thoracic cavity from the abdominal cavity.

Mechanism of Respiration

Respiration involves two main mechanisms:

• Inhalation (Inspiration): Intake of O2.
• Expiration (Exhalation): Exhale

Understanding Antibiotics and Antimicrobial Agents

Antibiotics are chemical substances obtained from various species of microorganisms that kill or inhibit the growth of other microorganisms in low concentrations. They are categorized as antimicrobial agents, which include antivirals, antifungals, and antibacterials.

Types of Antibacterial Action

• Bacteriostatic: Agents that inhibit the growth of bacteria.
• Bactericidal: Agents that actively kill bacteria.

Classification of Antibiotics

Antibiotics are classified according to their spectrum of activity:

• Narrow Spectrum: Effective against a specific or short range of bacteria.
• Broad Spectrum: Effective against a wide range of bacteria, capable of inhibiting or killing multiple types.

Classification by Source

1. Natural: