Functional Dependency in Relational Database

This post is labeled under Software Development

Effective design of relational database follow the principles of relation. Introduced by Dr. F. Codd of IBM during the 70's, relational database became the de facto standard in DBMS.

The following video explains the theory of relation, its properties and dependencies of its attributes. Primary key, foreign key,composite key, and anomalies are also discussed as partial and transitive dependencies are applied.



You may secure the copy of the powerpoint presentation on the link below:

DBMS Relations


Read more...

MySQL Stored Procedure

This post is labeled under Software Development

This is the continuation of Laboratory Activity 4. I suggest that you do the said lab activity first (if you haven't done so) before proceeding on this activity. You may visit it here.

You can compile multiple SQL statements into one function or program. With stored procedure, you are no longer restricted to run one single SQL statements but allows you work on as many of statements you need to execute for your requirements.



Stored procedure can be created using MySQL Query Browser. Once created, you may detect its existence on the object browser area along with other tables. You may also edit it later on if changes are required as you pull data from your database.

Activity 5 below shows us a guide on how to work on simple stored procedures.

MySQL Stored Procedure Activity 5
Read more...

MySQL Query Browser Using JOIN

This post is labeled under Software Development

This is the continuation of Laboratory Activity 3. I suggest that you do the said lab activity first (if you haven't done so) before proceeding on this activity. You may visit it here.

One of the interesting aspects of SQL is the connection of relational tables. The following activity below explains how to issue a SELECT statement that joins multiple tables.

It starts with the connection of two tables. As you understand the concepts of connecting tables, it will take you to the next step of connecting multiple tables using JOIN, LEFT JOIN, RIGHT JOIN or simply using a WHERE clause.

This activity expands further our knowledge of MySQL Commands and Basic Queries. As with our previous MySQL tutorials, this promises an easy-to-follow format. An exercise is included to check understanding of the concepts.

MySQL Query Browser Activity 4


Read more...

MySQL Comparison Operators

This post is labeled under Software Development

This is the continuation of Laboratory Activity 2. I suggest that you do the said lab activity first (if you haven't done so) before proceeding on this activity. You may visit it here.

Comparison operators in MySQL are used parallel with WHERE clause to limit records or row selections. Relational operators such as ,less than, less than equal, equal, not equal, greater than, greater than equal ( <, <=, =,!=, >, >= ) are used to filter out rows depending on criteria set.

On this exercise (see below attached text), the use of IN, NOT, LIKE, GROUP BY, HAVING is also introduced as we expand our SELECT statement criterion.

MySQL Activity 3

Activity 4 of this MySQL Tutorial series will present connection of tables within the MySQL Database and establishing its relationship.




Read more...

MySQL Query Browser Tutorial

This post is labeled under Software Development


One of powerful MySQL Tools available is Query Browser used as Graphical User Interface (GUI) in administering an SQL Database.

It can serve as another alternative to MySQL Command Line Prompt if user opts for the drag-and-drop style in issuing a statement. It is packaged with Table Editor where you can easily set metadata for columns of the table.



Below is a 3-part video tutorial condensed in 23-minute period frame. This is the version of the written tutorial document attached that you could see at the end of this blog.





You may view the following document. This document was designed to go through to the step-by-step MySQL tutorials and easy to follow format. At the end of the document, you are asked to check your understanding on the topic as set on the objectives.

MySQL Activity 2



Read more...

Database Management System Concepts

This post is labeled under Software Development


Database becomes an integral of any organization. Effective information management systems lead companies to profitability by analyzing past data that generate trends and create new markets.

Stock market relies on online data that are vital in making buy or sell decisions on shares at stake everyday.

Doctors and health experts use patient data history to diagnose correctly chronic illnesses and provide better cure in formulating new medicines.

All of these are made possible due to effective and well-managed database systems we are using today. Below is a video blog discussing the basic concepts of a database management system (DBMS):





Read more...

How to make a Flowchart

This post is labeled under Software Development


Flowchart is graphical representation of an algorithm. It uses a special-purpose symbols such as diamonds, rectangles, ovals, small circles which are connected by flowlines. Flowlines indicate the order in which the actions are to be performed. Unlike pseudocode (not real code) the algorithm is represented by these symbols.

Creating flowchart is much easier now considering how these flowcharts are incorporated on Microsoft Office applications. Though there are other applications dedicated on this purpose alone such as Visio, it is best to know the basics on how to use it.



Figure 1. Sample Flowchart
Online flowchart applications that float over the internet sometimes charge fee for you to use it. It often has a ready flowchart template that is ready to use. I have nothing against it. For now, all you need is a paper and pen in drafting your first flowchart. Knowing the fundamentals is still best before using any tool for this purpose. You may refer to the following document on how flowcharts are applied.

Flow Charting Fundamentals

Flowchart is one of the effective tools in representing solutions for programming problems. Students gain discipline on how to structure programs properly thus reducing complexity and long redundant codes.



Read more...

Microsoft Project Video Blog Tutorial

This post is labeled under Software Development


Managing series of tasks on a given project is a horrendous job if one has no tool to track it. Often, project managers who rely on their skills of guess-timate receive all the blame at the end on mostly delayed, expensive projects.

Microsoft Project is a project management tool that can generate Gantt charts, Resource schedule/usage and listing of project cost. It is an effective ally to pinpoint critical paths that may affect the overall implementation of the project. Milestones can be clearly highlighted to emphasize important events that serve as the target date to complete.

The video blog comes in two parts. The first part discusses Microsoft Project 2003 initial setup of tasks, milestones, project start date and predecessors. It already discusses a working example on how to use Microsoft Project.

The last part shows how to assign predecessors to task effectively. It includes also how Microsoft Project 2003 adjusts working time and tags holidays in between your working calendar. The video presentation shows also how to print the gantt chart and adjust its views.



You may also view the documentation part of this tutorial. If it is your first time to view document using Scribd, visit this article first to read and download the document below.

Project Management Basics

The post was intended for first timers in drafting their feasible project proposals as managers. Please let me know if the presentation helps you in knowing the basics and can be an alternative way on existing Micrsoft Project tutorials.


Read more...