RELATIONAL DATABASE MANAGEMENT SYSTEM

Image of RDBMS

RELATIONAL DATABASE MANAGEMENT SYSTEM 

  1.  RDBMS means relational database management system which is based on relational model.
  2.  Which follow the rules of codd’slaw.
  3.  RDBMS to store and access the data from the related table.

NAMING CONVERSION
DBMS                                                            RDBMS
1.  Fields                    ===                            Column and Attribute
2.  Record                  ===                             Row, Entity ,Tuple
3.  File                       ===                            able, Relation and Entity class.
The Rules of codd’s law. 
Rule 1: The information rule: All information in the database must be represented in one and only one
way (that is, as values in a table). 
Rule 2: The guaranteed access rule: All data should be  logically accessible  through a combination of
table name, primary key value and column name. 
Rule 3: Systematic treatment of null values: A DBMS must support Null Values to represent missing
information and inapplicable information in a systematic manner independent of data types. 

Click here to download RDBMS pdf :DOWNLOAD RDBMS PDF FILE

Comments

Post a Comment

Popular posts from this blog

Digital Marketing

Image
  Digital Marketing DIGIEDGE is digital marketing institute  DIGIEDGE ·          DIGIEDGE is India's 1st digital marketing institute to offer complete training and career solution by offering a dynamic program in digital marketing aligned with Industrial standards, and empowered by globally recognized DMI, Ireland. ·          For a prominent offering to DIGIEDGE has established an Alliance with a globally recognized digital marketing educational body, DMI, Ireland ·          DMI, with presence in more than 115 countries has trained more than 18000 professionals, currently working with various leading brands. Looking at the demand of industry DIGIEDGE proactively incorporated simulation based training along with video delivery of lecture so as to match the industry requirement. This enables our students to serve in any profiles l...
Read more

LAB ASSIGNMENT -2 DBMS FYBCA (SEM 2)

Image
LAB ASSIGNMENT -2 DBMS FYBCA (SEM 2)   Create following tables solved queries Student(roll_no,name,gender,address,class) Marks(roll_no,sub1,sub2,sub3,total,percentage) 1. insert 10 records for each tables 2. add the column email_id in student table 3. list out detail of student 4. list out student detail whose percentage is 70 5. list out student detail whose class is SYBCA 6. add colomn phone no in student 7. list out student detail whose total is 300 8. list out student detail whose name is raj 9. display student of „fybca‟ 10.display marks of student whose roll_no is 25. 11. change student name raj instead of rahul. 12.change field name address instead of stud_add in student table. 13.list out student detail whose class is fybca 14.remove the records of marks table 15.destroy the detail of student. Q2 Create following tables with appropriate constrain billmaster(billno, custno, billdate, billamt, discount) customer(custno, name, custadd) 1. insert at least 10 records for each ta...
Read more

Ravi Tutorials

Image
The Ravi Tutorials is an FREE Website or Blog which has been created to provide simple and easy online education to the student who are interested to study different Technology related to computer science. This blog is useful for all beginners who have not more knowledge about programming language so you can easily learn a lot of programming language.
Read more