Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 126 - CodePilot V5.0 C8
P. 126

    Microsoft Access, Oracle, MySQL, etc. are some of commonly used RDBMS.

                                         DBMS vs RDBMS

                                                   Table               Table
                                                             Table

                        xml                        Table               Table
                          xml
                            xml                              Table                The Relational  Model  was proposed  in
                               xml                                                1970 by E.F. Codd of IBM.
                                 xml
                           DBMS                            RDBMS

                      COMPONENTS OF RELATIONAL DATABASE
                      The key components of a relational database are as follows:

                                                                 Student Table

                                                                    Fields

                            Student_ID  First_Name   Last_Name    Date of Birth          Email           Course_ID

                                 1      Aarav        Sharma      15-Mar-2012   aarav.sharma@gmail.com    C101
                                 2      Priya        Patel       20-May-2012   priya.patel@gmail.com     C102
                          Table  3      Rahul        Verma       10-Mar-2012   rahul.verma@gmail.com     C103          Records

                                 4      Sneha        Iyer        25-Nov-2011   sneha.iyer@gmail.com      C101
                                 5      Dev          Kapoor      12-Jul-2012   dev.kapoor@gmail.com      C102

                      The different components of a relational database are as follows:

                          Tables: A table is a collection of related records arranged in rows and columns. Each column
                         represents a specific type of information (attribute) and each row represents a record (tuple)
                         containing related data.
                          Fields: A field represents one related part of a table. It contains the same kind of data in a

                         table. For example, Student_ID, First_Name, Last_Name, Date of Birth, Email and Course_ID
                         are fields in the table.

                          Records: A record is a collection of related data stored in different fields, treated as a single
                         unit. It represents the data which is entered in a set of different fields which are related to a
                         particular item. For example, 1, Aarav, Sharma, 15-Mar-2012, aarav.sharma@gmail.com and
                         C101 is one of the records of the table.

                      KEYS IN DATABASE
                      A key is a column or set of columns that identifies records in a table. It is also called a key field and
                      can link data between tables. The most common types of keys in SQL are the primary key and the

                      foreign key.

                       124
                            CodePilot (V5.0)-VIII

| 121 122 123 124 125 126 127 128 129 130 131 |