Veritabanı Programlama

Table of Contents 1. Introduction .......................................................................................................................... Page# 1.1. Project Scenario ...................................................................................................................... 2. Entity Relationship Diagram......................................................................................................... 3. Relational Model ............................................................................................................................. 4. SQL ................................................................................................................................................... 4.1. Create table statments ............................................................................................................. 4.2. Insert statements...................................................................................................................... 4.3 Update statements ................................................................................................................... 4.4. Delete statements..................................................................................................................... 4.5. Alter table statments................................................................................................................ 4.6. Drop table statments............................................................................................................... 4.7. SQL Queries............................................................................................................................. 5. Conclusion.......................................................................................................................................... 6. References ........................................................................................................................................ You are to create a script that will include all SQL (DDL, DML, DCL, TCL) commands that should cover the following:  Drop table statements  Create table statements (all tables should be created)  Alter table statements (3 – 5)  Insert statements (at least 3 into each table)  Update statements (at least 3)  Delete statements (at least 2)  SQL Queries (at least 3)