Skip to main content

Advanced Databases Project Design & Development

By

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. 

Get Project Solution by contacting us

- via WhatsApp: +92-324-7042178
Labels:

Popular posts from this blog

The Zoo Management System - entity relationship diagram & MS Access Database

By
Zoo Management System - Project Details: You are the employee of a big, worldwide working Zoo Management Company. Your company is responsible for the Zoo management. Your boss thinks it would be a great idea to store all data for each Zoo in a brand new self-developed ZOO Management System. Up to now, the ZOO management company has maps of each ZOO available. Your boss knows that you took a course in introduction on an ERP system, so he asks you if you could help designing such a system. Each ZOO must have the same organizational structure, which should look like this: Each Zoo has a Zoo-Address. Each Zoo has many visitors (Visitor Ticket Process (VTP). Many Zoo-Attractions belong to a Zoo. Module 1: Entity Relationship Diagram Design a ER (entity-relationship) diagram for your ZOO Management System. Use the information provided below with the entities and its attributes. Put the entities in the correct relationship to each other (organizational structure). Module 2: DB Implem...
1 comment
Read more

Human Physiology by Stuart Ira Fox [PDF] (12th edition) free download

By
21 comments
Read more

Sudoku Game Project in Java with full source code including GUI task

By
Introduction The purpose of the project is to try in practice the use of recursion and object-oriented program design. Please make sure to read this entire note before starting your work. Pay close attention to the sections on deadlines, deliverables, and exam rules. The problem Your task in this part of the project is to write a solver for Sudoku puzzles. Sudoku puzzles are a kind of crossword puzzles with numbers where the following two conditions have to be met: In each row or column, the nine numbers have to be from the set [1,2,3,4,5,6,7,8,9] and they must all be different.  For each of the nine non-overlapping 3x3 blocks, the nine numbers have to be from the set [1,2,3,4,5,6,7,8,9] and they ust all be different. The following two figures show a Sudoku puzzle and its solution. The input The input of your program, the Sudoku puzzles, is given in text files. More specifically, they are represented as nine lines of nine characters separated by spaces. The characters can be of two...
Post a Comment
Read more