CS 338: Computer Applications in Business: Databases
Fall 2012
Assignments
Note that the assignments are not going to be marked. We will provide the solutions and you are encoruaged to do them since they will help you check your understanding of the material, practice with the ideas, and prepare for the exams.
Assignment 1
This assignment will focus on basic SQL queries. You will write a number of SQL queries and execute them on DB2.
Assignment 2
This assignment will focus on more advanced features of SQL . Again, you will write a number of SQL queries and execute them on DB2.
Assignment 3
This assignment is on conceptual and logical database design. You will be given a spec and asked to create an ER model, which you will then map to a relational model
Assignment 4
This assignment will cover a number of topics: views, transactions, and query processing.