Page 372 - TP_IT_V1.0_C10_flipbpookl
P. 372

21 st
                                                                                              Century   #Media Literacy
                                                                                               Skills
                    Video based question                                                                    Scan the
                                                                                                            QR Code
                   Watch the video and answer the questions. - https://youtu.be/TUXIQHWYPSQ?si=azVFtNRW-TwElmhF
                       What is the purpose of a Foreign Key in a relational database?



                       Explain the concept of Referential Integrity in database management.









                    REVISIT



                    ▶ A database is an organised collection of structured information or data, typically stored in tabular format.
                    ▶ Data is a collection of values in the form of text, numbers, dates, images, audios, videos, etc
                    ▶ Flat file stores data in a plain text format.
                    ▶ Relational file stores data of different data types like text, number, date in the form of rows and columns to form
                   a table.
                    ▶ Information is processed, organised, and meaningful data that provides context, relevance, and value.
                    ▶ To store and manage the data in a database electronically we use a Database Management System software.
                    ▶ A data model in  Database Management Systems (DBMS)  is  a conceptual  representation  of  how data is
                   organised and structured within the database.
                    ▶ The relational database model is a conceptual framework used to organise and structure data in a tabular
                   format, consisting of rows and columns.
                    ▶ Tables are the basic structure of a database where data is stored.
                    ▶ Fields or columns are the individual pieces of data stored within a table.
                    ▶ Key is a field or combination of fields that uniquely identify a record (row) in a table.
                    ▶ Relationships define how tables within a database are related to each other.
                    ▶ Constraints are rules that enforce data integrity within a database.
                    ▶ A primary key uniquely identifies each record (row) in a table.
                    ▶ In  a Relational  Database Management System (RDBMS), objects  are fundamental  entities  used  to  store,
                   represent, or manipulate data within the database.
                    ▶ Data types help you define the type of the data that can be stored in a field/ column.
                    ▶ Referential integrity is a fundamental rule in relational databases that ensures the consistency and validity of
                   relationships between tables.
                    ▶ Query is a set of commands that generates a request to access or manipulate data in a table.
                    ▶ Wildcard characters are used to retrieve a set of records from a table that contains some specified character.
                    ▶ Structured Query Language (SQL) is the standard language for managing relational databases and performing
                   various operations on the data in the tables.
                    ▶ Form is a database object which is used to create an interactive user interface by connecting it with a table.
                    ▶ A report displays the retrieved data in an appealing and customised format.






                370   Trackpad Information Technology (Ver. 1.0)-X
   367   368   369   370   371   372   373   374   375   376   377