Homework and Programming Assignments(作業)

Assignments

• Assignment 1: Models and Architectures (Check the lecture note 02ModelsAndArchitectures.pdf(p.39) and (p.32) for more details.) Due date: Mar 21, 2024
• Assignment 2: Relational Model and Languages (Check the lecture note 04RelationalAlgebraCalculus.pdf(p.68) and (p.60-63) for more details.) Due date: Apr 25, 2024
• Assignment 3: Basic SQL (Check the lecture note 05BasicSQL.pdf(p.41), pages (p.45) and (p.117-120) for more details.) Due date: May 9, 2024
• Assignment 4: More SQL (Check the lecture note 06MoreSQL.pdf(p.40), pages (p.177-180) and (p.236) for more details.) Due date: May 30, 2024
• Assignment 5 (optional): ER/EER Model (Check the lecture note 08EERmodel.pdf(p.28) and pages (p.298-300) for more details.) Due date: June 20, 2024

Web Resources

• W3Schools SQL Tutorial (https://www.w3schools.com/sql/default.asp)
• SQL Queries Tutorial (https://www.mssqltips.com/sqlservertip/7163/sql-query-examples/)
• SQL Exercises, Practice, Solution (https://www.w3resource.com/sql-exercises/)
• 50 SQL Query Questions and Answers for Practice (https://www.techbeamers.com/sql-query-questions-answers-for-practice/)

On-line SQL Resources

1. Online SQL interpreter. (https://www.db-book.com/university-lab-dir/sqljs.html) (for the DB Concepts book)
2. SQLite online. (https://sqliteonline.com/)
3. The Try-SQL Editor. (https://www.w3schools.com/sql/trysql.asp?filename=trysql_op_in)(w3schools)
4. Online SQL Compiler. (https://www.tutorialspoint.com/execute_sql_online.php)(tutorialspoint)
5. Online SQL IDE (https://www.jdoodle.com/execute-sql-online)