Facebook Messenger App for Android Phone Users

Facebook, the leader in social networking service have launched a new messenger app for android phones and the advantage of this app is that non account members of facebook can also send and recieve messages to and fro from anyone with a phone number. Users can just sign in with their phone no and name and can send messages to their phone contacts. First it has been launched in India, Australia, Indonesia, Venezuela and South Africa, with other countries shortly after, it added.

Facebook for this service has partnered with all major device manufacturers and their main goal is to make their users connect to all of their phone contacts.

Read More

Normalization in Database (Continuation)

In Tychons, we never get fed up of sharing information and even working too. On our previous posts regarding normalization in database, we saw what is normalization? Its benefits and we saw how many different types of normalization forms are available and also we saw the first two of its types such as first and second normal form. Now let us see third normal form. 

Third Normal Form (3NF):-

(i)    Remove columns that are not fully dependent upon the primary key.

Example:-

Boys-Codd Normal Form (BCNF or 3.5NF):-

1. A relation is in Boyce-Codd Normal Form (BCNF) if every determinant is a “candidate key”.
2.  Remove the non trival functional dependency.
3.  It’s considered a special condition of third Normal form.

Candidate key:-

Define:-
 More than one primary key in the table, that primary key is called as candidate key.

3NF:-

Step:1

 Step:2

Note:-

•    For each subject, every student is educated by one teacher.
•    Every teacher teaches one subject only.
•    Each subject can be teached by more than one teacher.

3NF to BCNF:-

1)    Student is not a “Primary key”.
2)    Teacher and Subject is “Primary key”.

Note:-

A relation is in BCNF, if and only if, every determinant is a candidate key. So filter the non primary key column.

On Behalf of tychons family, i would like to thank our employee who has been sharing continuos information regarding normalization in database. Do watch our blog for regular updates on remaining types of normalization forms.

Read More

News for Fake Facebook Users

It is a known fact that facebook is one of the world's largest social networking website and worldwide,  more than million users are in this network.  One of the true and worried fact is that there are lots of fake facebook accounts. "Official figures from Facebook say as many as 8.7 per cent or 83 million accounts on the network are bogus. About 4.8 percent of them are duplicate, 2.4 percent are user-misclassified accounts and 1.5 percent are “undesirable” accounts". 

On a recent press meet, Facebook india business manager Pavan Varma said " the social networking website is making “huge efforts” to reduce these numbers and prevent misuse of such identities. The official further reveals in case a dubious account is found, Facebook will ask the user to provide his/her identification details. Accounts that use a generic name instead of a proper name, use images of celebrities/cartoon characters as profile image, or do not have “enough friends,” may come under the Facebook scanner".

Read More