You feel excited to learn computer languages

Then you are at the right place. Computer languages are most fun thing you have ever seen. Use this excellent languages and have a nice future...

How computer can help you?

I will ask how it can not? From the latest trend of social networking sites like Facebook, Twitter to the extended use of computer in our house hold devices. You can be benefited from computer in the every aspect of life.

What web technology?

It is the blessings of web technology, that brings you here and you are reading my post now. Strange huh!! Not at all. Use my web technology tutorials and understand, how they can help you for better marketing and advertising systems.

How Mobile technology can help us?

You have answer right? I know. But in my tutorials I will cover some unique features that may add some information in your hard disk too. Sounds good? Check them...

Computer and future

Yes that is the most important question to me. What is next? What is going to be the next big thing for us? Well I will answer them in my blog. Check the corresponding section..

Thursday, November 28, 2013

ER Diagram Example | Entity Relationship Diagram Examples

An Entity Relationship Diagram (ERD) or ER diagram is the best visual representation of a Database. Any Database Designer will  follow Entity Relationship Diagram to design physical database. An Entity-Relationship diagram (ERD) typically serves as the main deliverable of a conceptual data model. While newer approaches to E-R modeling have developed, the E-R approach is still cited by some professionals as "the premier model for conceptual database design". An ERD is a logical representation of an organization's data, and consists of three primary components:

Entities -- Major categories of data and are represented by rectangles
Attributes -- Characteristics of entities and are listed within entity rectangles
Relationships -- Business relationships between entities and are represented by lines
An Entity is a person, place, object, event, or concept that an organization wants to maintain data on. Each entity has a unique identity that differentiates it from other entities. A point of distinction must be made between entity types and entity instances. An entity type is a collection of entities that share common properties. Entity types are also known as entity classes. An entity instance is an individual occurrence of an entity type. A data model describes an entity type only once; however there may be numerous instances of that type within a database.

Lets take an example and solve it using ER diagrams :

This above ER diagram example describe this problem:
A publishing company produces books on various subjects. The books are written by authors who specialize in one particular subject. The company employs editors who, not necessarily being specialists in a particular area, each take sole responsibility for editing one or more book publications. Every book require some items for publication. These items supplied by suppliers. One supplier can supply many items. Shop owner buys books from the publisher. Shop owner can buy many books but one book can be bought by one shop owner only. Books are uniquely identified by Bookid.



Tuesday, November 26, 2013

Database management System Tutorial : Introduction



DBMS means Database Management system. It deals with handling and assembling data into database properly. Here we have complete Database Management system ( DBMS ) Course. The DBMS is the software that interacts with the users' application programs and the database. the Database Management system ( DBMS ) is an extremely powerful and useful tool. However, as the end-users are not too interested in how complex or easy a task is for the system, it
could be argued that the DBMS has made things more complex because they now see more data than they actually need or want.DBMS for a personal computer
may not support concurrent shared access, and it may provide only limited security,
integrity, and recovery control. 
However, modern, large multi-user DBMS products offer
all the above functions and much more. Modern systems are extremely complex pieces
of software consisting of millions of lines of code, with documentation comprising many
volumes. This is a result of having to provide software that handles requirements of a
more general nature. 
Furthermore, the use of DBMS nowadays requires a system that
provides almost total reliability and 24/7 availability (24 hours a day, 7 days a week), even
in the presence of hardware or software failure. The DBMS is continually evolving and
expanding to cope with new user requirements. For example, some applications now
require the storage of graphic images, video, sound, and so on. To reach this market, the
DBMS must change. It is likely that new functionality will always be required, so that the
functionality of the DBMS will never become static.