CSc 498/698, Introduction to Database Systems
Spring 1998

• Course Syllabus
• Tutorial
  
  
• Homework 1: (Due: 13 April, Monday).
  • Problem 3.16
  • Problem 3.17 (Graduate Credit)
  
  
• Homework 2: (Due: 20 April, Monday).
  • Problems 6.19 (a,b,c,e,f,i,j)
  • Problem 6.20 (d,g,j)
  • Problem 6.25
  • Map the ER schema of Homework 1 to a relational schema.
    Specify all the primary and foreign keys. (Graduate Credit)
  
  
• Homework 3: (Due: 29 April, Wednesday).
  • Write and execute SQL queries for Problem 6.19
  • Write and execute SQL queries for Problem 7.14 (Graduate Credit)
    
    
  • See Instructions for submission of SQL*Plus Script
  • In all your queries, you should refer to the database tables as csc498.employee, csc498.department etc. . I have created and populated the company database under the csc498 schema and have granted public access to query these tables.
• Homework 4: (Due: 13 May, Wednesday).
• Homework 5: (Due: 27 May, Wednesday).
• Final Exam (Take Home Portion): (Due: 5 June, Friday).
• Prolog Programs for Chapters 12 and 13 problems
  
  Course Project (Phase I due: April 27, Monday)
  Course Project (Phase II due: May 15, Friday)
  Course Project (Phase III due: June 3, Wednesday)
  Sample embedded-SQL program which loads suppliers table using the data file s.dat
  Project Teams

Page Maintained by raj@cs.gsu.edu