|
- Course Work1 = 11% (Individual Work Set 12th Nov, Returned 13th Dec)
- Course Work2a = 11% (Group Work [2/3] Set 7th Jan, Required 14 Feb)
- Course Work2b = 11% (Group Work [2/3] Set 7th Jan, Required 21 Mar)
- Exam = 67%
Please note there is no "right" answer to this, the actual diagram will depend on your interpretation and may not look like this one.
You can print these from the screen or right-click on the links and then open the documents in MS-Word, MS-Excel or WORDPAD. The ZIP file contains all the UNIX scripts you will need to create the Ivory Towers Schema on GUS. You need to unzip the file into your home directory on one of the UNIX servers you usually have access too (lawn, bacon, gemini, etc). Then connect to the GUS database using SQL us usual and then type START create_ivory_towers_db to run the scripts.
If you would rather use Toad, then unzip the files into a PC directory and use CUT&PASTE techniques to load the files into the database. You might not have access to the CREATE USER statements on this database, so leave them out and use your own UserID instead.
The file create_ivory_towers_db.sql contains the CREATE USER and GRANT
statements, followed by a call to each of the files that create
each table in the database. Each table script is called something
like:
citdb_[table_name].sql where citdb means "Create Ivory Towers DataBase"
and [table_name] is one of the tables in the database. Please note:
The database tables must be created in the order given or else the
FOREIGN KEY constraints will complain.
Once you have created the tables, you can create the views to help with some of the queries. Lastly you can populate the tables by the INSERT statements found at the end of the create_ivory_towers_db.sql script file.
|
|
|
|
|
|
|
|