Homework and Programming Assignments(作業)

Assignments

• Assignment 1: Textbook(DBSC7) exercises: 1.5, 1.9, 1.10, 1.12, 1.14 (DBSC7: p32) Due date: Oct 13, 2022
• Assignment 2: Textbook(DBSC7) exercises: 2.12, 2.13, 2.14, 2.15, 2.18 (DBSC7: p45, p60, p61, p62, p63,) Due date: Nov 3, 2022
• Assignment 3: Textbook(DBSC7) exercises: 3.14, 3.15, 3.16, 3.17, 3.18 (DBSC7: p117, p118, p120,) Due date: Nov 24, 2022
• Assignment 4: Textbook(DBSC7) exercises: 4.14, 4.16, 4.17, 4.18, 4.20 (DBSC7: p177, p179, p180,) Due date: Dec 15, 2022
• Assignment 5: Textbook(DBSC7) exercises: 6-3, 6-15, 6-16, 6-21, 6-22 (DBSC7: p295, p298, p299,) Due date: Dec 29, 2022
• Assignment 6(optional): Textbook(DBSC7) exercises: 7-21, 7-22, 7-29, 7-30, 7-31 (DBSC7: p353, p357, p358,) Due date: Jan 12, 2023

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)