Category Archives: Projects

Home automation, improvements and other large scale projects around the house.

Database Management System for Online Ticket Sales

Database Management System (DBMS) of online ticket sale for the stage play “Kusa-Paba” at the University of Calgary Theater.

Abstract and Project Description

The University of Calgary Theater has 500 available seats. This particular DBMS is built to allow users to order and purchase tickets online. Tickets sold by agents can also be entered to the system using the agents’ interface. Only a designated set of seats are available for sale. Some are as for reserved guests and others are designated as House Seats hence they are not available for sale. The designated seats for sale are categorized for different price levels; $50.00, $30.00 and $20.00 (Figure 1). The price levels are further broken down for adults and children.

Continue reading Database Management System for Online Ticket Sales

How to build a basic antenna

We use wireless devices to send and receive information without worrying about physical obstacles. In the old days, most consumer-grade wireless devices such as mobile phones, routers and RC controllers came with large antennas. Today some manufactures decided to go with internal or built-in antennas. This is not always beneficial to the consumer. For example, if you have a weak signal in an area, it would be difficult to change the position of the antenna because; you do not know where is it in the casing and you may not be able to place the device in a position. The solution is to add a external antenna.

Continue reading How to build a basic antenna

Modification to extend wireless range

Consumer Electronics Design not always beneficial if it retards the primary functions of a device. The internal antennas are such a design concept that causes a lot of headaches for tech guys like me. The primary function of an antenna is to transmit a signal, capture a signal or both. Since most modern equipment are manufactured with plastic casings (as opposed to metal), a lot of manufactures have opted for internal antennas. The advantage; now nothing is sticking out, they can make the equipment more desirable to mainstream consumers by making “beautiful” equipment boxes. I am on the other hand one of those people who would buy a device for its’ practical functionality overlooks.

Continue reading Modification to extend wireless range