Forgot your password?
Document Actions
hw6.htm
CS 311: Databases
Database Creation for your Project
(Homework 6)
due on April 17
This is the third of five assignments for our semester-long project.
For this assignment you are to implement your relational schema as a set of Oracle tables. This requires you to define the relations and also to enter data into them. You should prepare one SQL file and a sequence of SQLLDR files that accomplish these tasks. If two people are working together, it is sufficient to have the tables on only one of the accounts. In this case let me know which account in the comment section at the top of the SQL file.. I suspect both partners would prefer to have copies. Since all of the data entry is being done through scripts, it should be easy enough to share these.
A. The first file creates the tables.
- At the top of the file there should be a comment section with the names of those who worked on it, the date and a brief description of the project.
- For each table you should include a DROP statement to delete any previous table with this name.
- For each table you should include a CREATE statement that defines the table, its attributes, its primary key, and any foreign keys.
- I want to be able to see the tables, so for each table FOO there should be a statement granting me access to the table: GRANT SELECT on FOO to bob;
B. The remaining files load data into the tables. These are the control files for the bulk load untility sqlldr. You should have one file for each table in your database. Include the data in your file; I want to see the data.
I expect to see a substantial amount of data -- at a minimum 5 to 10 tuples per table. Talk to me if you can't get that much data for your particular project. The next part of this project will be to write some standard queries for your database, so think about what these might be and ensure that you have enough data to support them.
Put all of these files in one directory and hand it in by Monday, April 17.