Documents shared by Anónimo

Create table emp1 and dept1 same as emp and dept.  Create a trigger which will delete all records from emp1 table of corresponding department deleted from dept1 table

CREATE TABLE emp1 AS
SELECT * FROM emp;

CREATE TABLE dept1 AS
SELECT * FROM dept;

CREATE OR REPLACE TRIGGER trg_delete_emp1
AFTER DELETE ON dept1
FOR EACH ROW
BEGIN
    DELETE FROM emp1
    WHERE deptno = :OLD.deptno;
END;
/

Create table totalsal as select deptno, sum(sal) sal from emp1 group by deptno;  Write a trigger which will update

Knowledge Management (KM) is the process of creating, storing, sharing, using, and managing the knowledge and information of an organization. It involves capturing knowledge from various sources, organizing it systematically, and making it accessible to employees for better decision-making and innovation. Key Points: Helps in managing organizational knowledge. Converts data into useful knowledge. Improves efficiency and innovation. Supports better decision-making. Prevents knowledge loss
Main Activities

Aim

To implement cloud-native security controls including Encryption, Access Management, and Network Security.

Theory Overview

• Encryption: Protects data at rest (stored) and in transit (moving).

• Access Management (IAM): Ensures the Principle of Least Privilege by managing user roles and Multi-Factor Authentication (MFA).

• Network Security: Uses VPCs, Firewalls, and DDoS protection to isolate resources and filter malicious traffic.

Implementation Procedure

1. Data Encryption

• At Rest: Use

Principals of Formulation 1. Clearly define the objective and boundary of the process system. 2. Identify all important variables such as pressure, temperature, flow rate, and concentration. 3. Apply basic conservation laws like mass balance, energy balance, and momentum balance. 4. Make suitable assumptions to simplify the model (steady state, ideal mixing, negligible heat loss, etc.). 5. Establish mathematical relationships between variables using physical and chemical laws. 6. Include process

Really moving beyond the individual now! Organizations, insititutions and structures. Start by thinking about development of society Types of Societies (1): What differentiates types of societies? One answer: their mode of production Mode of production = how a society gets/makes the stuff its people need. anowher answer: their size & complexity. Size = numeber of people. Complexity = number and type of institutions. Premodern / Pre-industrial. Modern / Industrial. Postmodern / Post-industrial.

1. Schuman-Plan (1950)

Frankreichs Außenminister Schuman will Kohle & Stahl gemeinsam verwalten – damit Frankreich und Deutschland nie wieder Krieg führen.

2. Gründung der EGKS (1951/1952)
Vertrag von Paris: 6 Länder (D, F, I, NL, B, LUX) gründen die Montanunion (Gemeinschaft für Kohle und Stahl).

3. Römische Verträge (1957)
Gründung der EWG (Wirtschaftsgemeinschaft) und EURATOM (Atomgemeinschaft). Ziel: Gemeinsamer Markt.

4. Zollunion (1968)
Alle Zölle zwischen den Mitgliedstaaten

Honourable teachers, respected guests, and my beloved classmates, Class of 2026,

If someone had told us a few years ago that this would be the moment we would all stand here together, at the end of this journey, I don’t think many of us would have fully believed it. Back then, everything felt so far away. Graduation felt like something that only happened in movies or to older people who somehow had life figured out. But now we are here, and I think one of the strangest things about growing up