Homework




CS 425: Database Organization - Fall 2017

IIT logo
  • CS logo 
  • CSL logo

http://cs.iit.edu/~cs425/schedule.html


Important Dates

Schedule

The course schedule and linked slides will be updated over time. The slides are a modified version of the slides from Avi Silberschatz created for Database System Concepts.
For convenience, here is a combined versions of all slides and all handouts (6 slides per page).
08/210. Course Organizationslides or handout (6 slides per page)
08/231. Introductionslides or handout (6 slides per page)
08/282. The Relational Datamodelslides or handout (6 slides per page)
08/30
09/063. Formal Relational Query Languagesslides or handout (6 slides per page)
09/11Discussion on Application Domain for Course Project
09/134. SQL - Introductionslides or handout (6 slides per page)
09/18
09/20
09/255. SQL - Intermediate (Views, Integrity Constraints, Access Control)slides or handout (6 slides per page), SQL script developed in class
09/27
10/026. SQL - Advanced (APIs for SQL Access, Procedural Constructs)slides or handout (6 slides per page)
10/04
10/09
10/117. ER-Modelslides or handout (6 slides per page)
10/16
10/18
10/23Mid Term Exam
10/258. Database Design and Normal Formsslides or handout (6 slides per page)
10/30
11/06
11/08
11/13
11/159. Transactionsslides or handout (6 slides per page)
11/2010. Concurrency Controlslides or handout (6 slides per page)
11/27
11/3911. Storage and Index Structuresslides or handout (6 slides per page)
12/05Final Exam

Comments

Post a Comment

Popular posts from this blog

SQL Query Questions and Answers for Practice

Image
https://www.techbeamers.com/sql-query-questions-answers-for-practice/ If you want to improve SQL skills, then install a SQL package like MySQL and start practicing with it. To get you started, we’ve outlined a few  SQL query questions  in this post. Solving practice questions is the fastest way to learn any subject. That’s why we’ve selected a set of  50 SQL queries that you can use to step up your learning. We’ve also given  SQL scripts to create the test data . So, you can use them to create a test database and tables. Most of the SQL query questions we’ve filtered out of interviews held by top IT MNC like Flipkart and Amazon. So you’ll gain real-time experience by going through them. Also, we recommend that you first try to form queries by yourself rather than just reading them from the post. Try to find answers on your own. But you can’t start until the required sample data is not in place. You can check out the tables below that we’ve provided for...
Read more

Interview Questions and Answers

Image
https://www.softwaretestinghelp.com/50-popular-sql-interview-questions-for-testers/ These are the most common and useful SQL interview questions useful for freshers as well as experienced candidates. From basics up to questions asked on advanced concepts of SQL have been also covered in this article. You can go through these questions for a quick revision of major SQL concepts before appearing for an interview.  Best SQL Interview Questions & Answers Question #1) What is SQL? Structured Query Language is a database tool which is used to create and access database to support software application. Question #2) What are tables in SQL? The table is a collection of record and its information at a single view. Question #3) What are different types of statements supported by SQL? There are 3 types of SQL statements 1) DDL (Data Definition Language):  It is used to define the database structure such as tables. It includes three statements such as...
Read more

Homework

Homework 3 CSE444             This homework will give you practice writing SQL statements and using the query facility of SQL Server.   The queries that you'll implement in SQL Server are based on a movies database.   The schema for the movie database is as follows: Customers   CustID LastName FirstName Inventory TapeID MovieID Movies MovieID MovieName MovieSupplier SupplierID MovieID Price Orders OrderID SupplierID MovieID Copies Rentals CustomerID TapeID CkoutDate Duration Suppliers SupplierID SupplierName Write out SQL statements for the following 10 queries about the movie database.   Enter the SQL code in the ISQL_w facility of SQL Server (a...
Read more