Title Untitled document - 2024-08-30T124642.633.pdf ✅

PRIMARY KEY (deptno), FOREIGN KEY (empno) REFERENCES EMPLOYEE(empno) ); Theory related Questions 1. List DDL commands with its syntax Answer: 1. CREATE Syntax: ● Create a Database: CREATE DATABASE database_name; ● Create a Table: CREATE TABLE table_name ( column1 datatype constraints, column2 datatype constraints, ... ); 2. ALTER Syntax: ● Add a Column ALTER TABLE table_name ADD column_name datatype; 3. DROP Syntax: ● Drop a Database Practicalkida.com