Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 60 - 2611_SmartGPT Pro V(5.0) C-8
P. 60

    DBMS vs RDBMS
                                                                         Table               Table

                                                                                   Table
                                              xml                        Table               Table
                                                xml
                                                  xml                              Table
                                                     xml
                                                       xml
                                                 DBMS                            RDBMS

                      COMPONENTS OF RELATIONAL DATABASE

                      The key components of a relational database are as follows:

                                                                 Student Table

                                                                     Fields

                             Student_     First_       Last_        Date of              Email           Course_ID
                                ID        Name         Name          Birth
                                 1      Aarav        Sharma      15-Mar-2012   aarav.sharma@gmail.com        C101
                          Table  2      Priya        Patel       20-May-2012   priya.patel@gmail.com        C102       Records
                                                     Verma
                                        Rahul
                                 3
                                                                                                            C103
                                                                               rahul.verma@gmail.com
                                                                 10-Mar-2012
                                 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.

                       58   Computer Science (V5.0)-VIII

| 55 56 57 58 59 60 61 62 63 64 65 |