This is after long time I am writing something about the training program and I have a reason for that.I saw terrible search for sample questions over the internet and am getting good responses on my previous posts.Actually after the FRP and TRP got over i was completely busy with a lot of formalities like domain allocation, posting location, settling at new place etc. Recently one of my batch mates asked me whether i have any sample questions on UNIX trp and that is how this thing came to my …

RDBMS Continued-3
According to me this is a very small chapter but very basic stuffs are discused in here.So read through very carefully try to understand the terms and feel free to ask any doubts we will try to clarify doubts as far as we can.From the previous chapters you would have got a brief idea about what is a database which are the different database models etc.Here we are going to start on a Relational database.
A Relational Database Management System uses the relational model that is relationship between records …

RDBMS Chapter-2 Contind
Now that we have finished with the evolution of databases and the uses of a DB,the next important portion is understanding the architecture of a database system.A Db is complex piece of software that usually consists of a number of modules.As we know the PRIME aim of a DB is to handle data efficiently for the wide array of users,the DB must be aware of the data it is holding,or simply to help users DB must maintain ” information about the DATA ” itself.This information include what …

Introduction to Database Management Systems-chapter-1
What is a database and how it emerged when a strong and widely accepted languges like C was there???The answer is simple
in language like C the programmer deal with user and DATA directly where as in DBMS the programmer is least bothered of
user.Only thing he need to take care of is effective management of  lumbs of data.Here i will try to explain DBMS and RDBMS
mostly relating to ‘C’ assuming it as a known language to most people.The first thing that comes to our mind when we …

The Project Readiness Program started with RDMS,and continued through SQL and PL/SQL.The class is very good,the madam teaching us all these are very enthusiastic about the subject so the class is very interesting,i can see even the non-IT people enjoying her class.Her arrangment of the topics is very good,putting across right examples.The RDBMS  course is just one day still it covered the expectations.From day two onwards she started with SQL.
RDBMS Topics

What is RDBMS ?
Benefits and Features of RDBMS.
Relations,Tuples,Attributes,degree.
Keys:-Super Key,Candidate Key,Primary Key,Alternate Key.
Designing using Entity-Relationship Model.
E-R Diagrams,Case Studies 1 or 2.
Normalization,1NF,2NF,3NF.

SQL Topics

Basic …