Practical Work Week 2
In this module, you are required to design and develop a database using MySQL Workbench. This week you should:- formulate a database project proposal together with one of your classmates. This proposal will be due for submission on Moodle in week 3. You are also required to submit a hard copy of your proposal in your practical class.
- you may use MySQLWorkbench on the college machines or install the application on your own laptop.
Please note: The proposal that you submit will need to support a database with minimum of 15 tables so it is important that you choose an idea which will give you the scope for such a database design. You should use your practical hours to ask for advice on choosing a suitable idea.
Practical Work Week 3
At this stage you should:- use the Sakila example provided with Workbench to familiarise yourself with the operation of the DBMS.
- create a complete ER model in Workbench for your team project. (Min. 15 tables)
- create a database design document for submission to Moodle with the following sections:
- Description of project
- Complete ER model (drawn in Workbench) with a description
- Table Design
Please note: This document will be assessed formatively as it may need re-work at the project end.
Practical Work Weeks 4-5
At this stage you should:- Forward engineer the project model to create the database.
- Populate the tables with enough records in order to sufficiently query the database.
- Create a number of complex queries for execution on your database.
- Explore with a view to implementing the potential functionality provided by workbench which may apply to your project.
- e.g. If different user groups are applicable to your project they can be created in Workbench with appropriate privileges etc.
Please note: Marks will be awarded to those projects which make most appropriate use of the functionality provided by Workbench.
Practical Work Week 6
At this stage you should:- attend a team demonstration of your project in practical class time
- submit a final version of the project document on Moodle and also submit a hard copy in class time.