Data Definition Language DDL in SQL

Idea : Group-work to understand and present diffrent aspect of defining data in SQL databases.
Background: http://www.w3schools.com/sql/default.asp
(create table, constraints, primary,foreign key, check, index, auto incretement, dates etc.)

Case 1 : Simple creation Of Tables

Background:

Create https://www.w3schools.com/sql/sql_create_table.asp
Delete https://www.w3schools.com/sql/sql_drop_table.asp
Modify https://www.w3schools.com/sql/sql_alter.asp
Primary Key https://www.w3schools.com/sql/sql_primarykey.asp
Auto Increment https://www.w3schools.com/sql/sql_autoincrement.asp

Present how to create, delete, modify a simple table and how to define a primary key with or without auto increment.

An example could be:

Person

PersonID (PK)

Address

Phone

Case 2 : Simple Data types in Tables

Background:

Types MSSQL https://docs.microsoft.com/en-us/sql/t-sql/data-types/data-types-transact-sql
Types MySQL https://dev.mysql.com/doc/refman/5.7/en/data-types.html
Dates https://www.w3schools.com/sql/sql_dates.asp
Enum https://www.w3schools.com/sql/sql_datatypes.asp

Present how to use different data types in SQL including Date

Case 3 : More Data types in Tables

Background:

Check https://www.w3schools.com/sql/sql_check.asp
Default https://www.w3schools.com/sql/sql_default.asp
index https://www.w3schools.com/sql/sql_create_index.asp
Unique https://www.w3schools.com/sql/sql_unique.asp

Present how to make different constraints on datatypes, the presentations should contain check, default, index and unique

Case 4 : Relationships between Tables

Background:

Foreign Key https://www.w3schools.com/sql/sql_foreignkey.asp
Referential Integrity: DATABASE p.166 + 171

Present how to create foreign key between tables and describe the constraints. Describe how to obtain Referential Integrity by using ON Delete/On Update.

An example could be:

Customer

CustomerID (PK)

Address

Phone

Reservation

ReservationID (PK)

Date

Customer (FK)

NoOfSeats

Case 5 : Creating Views

Background:

View https://www.w3schools.com/sql/sql_view.asp
DATABASE, 176-186 (views)

Present how to create and use Views.

Case 6 : Creating Users and Grants

Background:

User https://docs.microsoft.com/en-us/sql/t-sql/statements/create-user-transact-sql
Grant DATABASE p. 189-192

Present how to create users and how to grant privileges to users for tables and views..