INTRODUCTION TO RDBMS

INTRODUCTION to RDBMS / 1 CHAPTER 1 INTRODUCTION TO RDBMS Objectives INTRODUCTION What is RDBMS ? Difference between DBMS & RDBMS Summary Check your Progress Answers Questions for Self Study Suggested Readings OBJECTIVES After reading this chapter you will be able to, Describe what RDBMS is State the difference between DBMS & RDBMS INTRODUCTION Most of the problems faced at the time of implementation of any system are outcome of a poor database design. In many cases it happens that system has to be continuously modified in multiple respects due to changing requirements of users. It is very important that a proper planning has to be done. A relation in a relational database is based on a relational schema, which consists of number of attributes. A relational database is made up of a number of relations and corresponding relational database schema.

2.6 Select Query and Clauses 2.7 Select Statement with Order by Clause 2.8 Group by Clause 2.9 Having Clause 2.10 String Operation 2.11 Distinct Rows 2.12 Rename Operation 2.13 Set Operations 2.14 Aggregate Functions 2.15 Nested Sub Queries 2.16 Embedded SQL 2.17 Dynamic SQL 2.18 Summary 2.19 Check Your Progress - Answers

Loading..

Tags:

  Operations

Information

Related search queries