1. Define the following terms: a) Tuple b) Foreign key c) Primary key d) DBMS e) RDBMS f) SQL g) Database Servers 2. DIFFERENTIATE BETWEEN a) Char and Varchar data type b) DDL AND DML
Answers
Answer:Tuple:The horizontal subset of the table.
b) foreign key:Ita column or set of columns in one table that refers to a columns or set of climbs in another table. It is used to link two tables.
c) primarykey: It is a unique value that identifies a row in table.
d) DBMS: it is a software package with computer program that controls the creation,maintenance and use of a database.
e) RDBMS:It is a DBMS that is based on the relational model.
f) SQL:this is used to retrieve an manipulate data in a relational database.
g) Database servers:they are dedicated computer that hold the actual database and run only theDBMS and related software.
Explanation:
Answer:
a)Tuple is a sequence of python objects that cannot essentially be changed or altered in any case. They are sequences, almost similar to that of lists. B) DML is the acronym for data manipulation language and DDL stands for data definition language. Both these are the words that are used to define the structure and content of data. The DDL structure is more of an understanding of the language of a particular database. In this connection, there is a semantic value attached to it.