Breaking News
You are here: Home / Notes / SEM-3 / RDBMS

Category Archives: RDBMS

Feed Subscription

this is a subcategory of sem-3

WHAT IS A REALATIONAL DATABASE MANAGEMENT SYSTEM (RDBMS)?

WHAT IS A REALATIONAL DATABASE MANAGEMENT SYSTEM (RDBMS)?

A Relational Database Management system (RDBMS) is a database management system (DBMS) that is based on the relational model as introduced by Dr. Edgar F. Codd. Strictly speaking it should also satisfy codd’s 12 rules, but in practice there is no DBMS that satisfies all these rules. In fact, most successful DBMS that are considered to be relational violate the ... Read More »

Dr. E. F. Codds Rules for RDBMS

Dr. E. F. Codds Rules for RDBMS

Dr.  E. F. Codd’s Rules for RDBMS   Dr. E. F. Codd is an IBM researcher who first developed the relational data model in 1970. In 1985, Dr. Codd published a list of 12 rules that define ideal relational database and has provided a guideline for the design of all relational database systems.   Dr. Codd has used the term ... Read More »

What is table, field, record, null in rdbms?

table

What is Table? The data in RDBMS is stored in database objects called tables. The table is a collection of related data entries and it consists of columns and rows. Remember, a table is the most common and simplest form of data storage in a relational database.  Following is the example of a STUDENT table:     What is Field? Every table is ... Read More »

Introduction to Structure Query Language (SQL)

sql

Introduction to Structure Query Language (SQL) Structure Query Language (SQL) is language that provides an interface to relational database systems. SQL was developed by IBM in the 1970s for use in System R, and is a de facto standard, as well as an ISO and ANSI standard. SQL is often pronounced SEQUEL and SEQUEL means Structure EnglishQUEry Language.   Features of SQL SQL can be used by ... Read More »

Components of SQL

Components of SQL

Components of SQL 1.   DDL(Data Definition Language) : It is a set of SQL commands used to create, modify and delete database structures but not data. These commands are normally not used by a general user, who should be accessing the database via an application. They are normally used by the DBA to a limited extent, a database designer or application ... Read More »

TABLESPACE IN ORACLE

TABLESPACE IN ORACLE

Logical Structure of a Database An Oracle database comprises of a number of physical files called data files. These files are logically grouped together into oracle(logical) structure called aTablespace.   Tablespace User data in an Oracle database is logically stored in tablespace and physicallystored in data files, which are bound to the corresponding tablespace.   Tablespace are a mechanism or a means by ... Read More »

SQL Constraints

SQL Constraints

                                                                                There are two types of constraints: 1).Input output constraints. Primary key constraint Foreign key constraints Unique key constraints 2).Business rule ... Read More »

SQL INDEX

SQL INDEX

Use to create and retrieve data from the database very quickly. The INDEX is used to create and retrieve data from the database very quickly. Index can be created by using single or group of columns in a table. When index is created it is assigned a ROWID for each rows before it sort out the data. Example For example, ... Read More »

SQL Loader

sqlloader

SQL LOADER utility is used to load data from other data source into Oracle. For example, if you have a table in FOXPRO, ACCESS or SYBASE or any other third party database, you can use SQL Loader to load the data into Oracle Tables. SQL Loader will only read the data from Flat files. So If you want to load ... Read More »

Oracle CORE Concepts

Oracle CORE Concepts

What is Oracle?   “Oracle is a program that is running in the background, maintaining your data for you and figuring out where it should go on your hard drive. “ “Oracle is made up of a set of processes running in your operating system. These processes manage how data is stored and how it is accessed.”   What is SQL? ... Read More »

Scroll To Top