RELATIONAL DATABASE SYSTEM

Download
Share  Add to  Flag Embed
Views:
 
Category: Education
     
 
License:   All Rights Reserved

Presentation Description

No description available.

Comments

 

By: smcute (18 month(s) ago)

@piali nw u can download this ppt

 

By: piali (18 month(s) ago)

hey i need this presentation for a noble cause. i have my exam on 30th plz kindly grant me permission to download tis!!

 

By: smcute (21 month(s) ago)

By sign in to authorstream u can download or else by sharing ppt to ur mail u can download

Presentation Transcript

RELATIONAL DATABASE MANAGEMENT SYSTEM : 

RELATIONAL DATABASE MANAGEMENT SYSTEM

Definitions : 

Definitions (RDBMS) are database management systems that maintain data records and indices in tables. Relationships may be created and maintained across and among the data and table. A software application that utilizes a relational database model to hold the data used in the application

: 

DBMS can be regarded as relational if it follows the following rules All the information must be hold in tables Retrival of data can be used by the following operations are a)select b)join c)project All the relationship between data must be represented explicitly in data itself

Aims : 

Aims Performance The ability to distribute data The ability to handle the large amount of data

Database software... : 

Database software... Light Duty Medium Duty Heavy Duty

Database tables : 

Database tables Database Table1 Table2 Table3

RDBMS Terminology : 

RDBMS Terminology

Fundamental operations : 

Fundamental operations

Table structure : 

Table structure

Data definition language : 

Data definition language Create table command Alter table command Truncate table command Drop table command Data manipulation language insert table command Select Update Delete

Constraints : 

Constraints Constraints are rules that are used to control the invalid data entry in the column they are a)primary keys b)Foreign key c)Null d)Not null e)Check f)Default

Query structure : 

Query structure To Create table create table tablename(column1datatype(size),column2 data type(size)); Ex:create table student(rollno number(6),name varchar2(15)); To View data select* from table name;

Slide 13: 

To delete table delete * from table name; To turncate data Truncate table tablename;

The Preliminary ERM : 

The Preliminary ERM Symbolized. Standard Representation Attribute Representation Entity Instance Representation

Advantages : 

Advantages Query language allow ease of use No necessity of learning inner structure of database Data independence allows easy structure modifications Set processing allows one command to modify large amount of data

Disadvantages : 

Disadvantages Query language consume processing time and memory Data must be related to act upon