How to submit project 1

1. What to submit.

• Item 1. (Due is on June 16, 2008)

- create.sql : File that shows all the create statements for the tables in Figures 5.7 of the textbook.

• Item 2. (Due is on June 27, 2008)

- Source code: loadRecords.java or loadRecords.c or and so on

- Executable file: loadRecords.class or loadRecords.exe

§ Source code and executable file to load the records into the tables.

- loadRecords.doc: Describe how to install and use your program and show the results of the tables after loading the records through your program.

• Item 3. (Due is on July 2, 2008)

- UpdateResult.txt

§ Write or capture SQL commands in SQLPLUS for the updates which are provided on the course web site.

§ Results of executing the SQL update commands have to be written in the UpdateResult.txt

§ The file should show which updates violate integrity constraints and which do not.

• Item 4. (Due is on July 2, 2008)

- RetrievalResult.txt

§ Write or capture SQL commands in SQLPLUS for the retrieval queries which are provided on the course web site.

§ Results of executing the retrieval SQL commands have to be written in the file QueryResult.txt.

§ The file shows each query and its result.

• Item 5. (Due is on July 2, 2008)

- Item5.txt: Insert queries and result of 3 records that violate different types of integrity constraints. And executed results have to be written in Item5.txt in SQLPLUS.

- Item5.doc: Describe why each integrity constraint violation happened.

• Item 6. (Due is on July 2, 2008)

- Item6.txt: Delete a record and result that violates a referential integrity.

- Item6.doc: Describe why integrity constraint violation happened.

• Item 7. (Due is on July 2, 2008)

- Item7.txt: Insert 3 new records and result of each insert SQL command.

2. How to submit.

• You have to make a zip file including all files.
• File name: lastname1_lastname2.zip (or lastname.zip if individual project)
• Submit to GTA(cse5330@gmail.com) by 11:59PM, June 16. for Item 1.

and by 11:59PM, June 27 for Item 2

and by 11:59PM, July 2 for Item 3,4,5,6, and 7.