![]() The above Employee table consist of four attributes, ID, Name, Age and Salary. 1Ī table consists of several records(row), each record can be broken down into several smaller parts of data known as Attributes. For example, the above Employee table has 4 tuples/records/rows.įollowing is an example of single record or tuple. A tuple in a table represents a set of related data. IDĪ single entry in a table is called a Tuple or Record or Row. Below is an example of an Employee table. Table is the most simplest form of data storage. But a table can have duplicate row of data while a true relation cannot have duplicate data. A table is also considered as a convenient representation of relations. In Relational database model, a table is a collection of data elements organised in terms of rows and columns. Relational Database is the most commonly used database these days. Relational database is a collection of organized set of tables related to each other, and from which data can be accessed easily. RDBMS is used to manage Relational database. In relational model, data is stored in relations(tables) and is represented in form of tuples(rows). ![]() ER Model: Generalization and SpecializationĪ Relational Database management System(RDBMS) is a database management system based on the relational model introduced by E.F Codd.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |