Post date: Oct 05, 2019 6:7:20 PM
hapter 6: The Relational Algebra and Relational Calculus (Continued)
Binary relational operations: JOIN and DIVISION
Additional Relational Operations
Chapter 4: Basic SQL
SQL data definition and data types
Specifying constraints in SQL
Basic retrieval queries in SQL
INSERT, DELETE, and UPDATE statements in SQL
Simplified DDL SQL:
CREATE SCHEMA schema_name;
USE schema_name;
CREATE TABLE table_name (
columnName1 datatype1 [PRIMARY KEY],
columnName2 datatype2,
...
[PRIMARY KEY (columnName1, columnName2, ...),]
CONSTRAINT constraint2_name FOREIGN KEY (columnName) REFERENCES other_table_name(other_table_column)
);
DROP TABLE IF EXISTS table_name;
ALTER TABLE table_name
ADD CONSTRAINT ...,
DROP COLUMN ...
...;
Lab Exercises:
Settings:
MySQL Connection Details: Connection name: YOUR NAME
Hostname: 10.32.33.54
Port: 3306
username: uFULLID
password: FULLID (STORE IN VAULT)
YOUR SCHEMAS HAVE TO START WITH: sFULLID