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

Student Registration System Web Project using HTML, CSS & PHP

By
Student Registry System In this task, you’re to further develop the student registry you started on lab-task. The solution is based the on the use of HTML5, stylesheets, and PHP, and will use a database for storage of information, MySQL on (school website) is used for this. Information of students is saved in the table student, ID is primary key and is set In addition to this, you need a table named class where id a is the primary key and is set up with AUTOINCREMENT, other columns and data types in accordance with the figure. The property class in the student table needs to be a foreign key that refers to the ID column in the class table. In MySQL you need to use tables of the type INNODB with support for foreign keys, reference integrity shall remain. The task: Write a class with the name StudentRegister (means Student registry), the class should use PDO and only prepared statements/questions. The class shall implement the interface StudentInterface, and use the two classes, Student,...
Post a Comment
Read more