| Assignment |
Work |
Due Date |
| Assignment 1 |
SKS (text) 4.2 and 4.3-must use postgresql
on gwiggins-old.mc.edu |
March 31 |
| Assignment 2 |
SKS (text) 6.7, 6.8 and 6.10-must use postgresql
on gwiggins-old.mc.edu |
April 9 |
| Assignment 3 |
SKS (text) 7.2, 7.4, 7.11, 7.12, 7.13 |
April 23 |
| Assignment 4 |
SKS (text) 15.8,15.10 and 16.2 |
April 30 |
| DBMS Project |
Database Project selection -Per Instructor Approval
In your folder you are to provide the following : ER or UML diagrams, database schema and tables. Include all queries to show table creation . Sufficient queries to show that the database is complete , in other words, it works. This should include some regular selection queries as well as all types of modification queries. This can be done in any suitable DBMS, Access, Oracel, Postgresql etc., Turn in all of the above in a folder with a cover sheet for the class and your name followed by a 1 to 2 page description of the Database project. |
April 30 |