When two or more tables share the same number of columns and when their corresponding?When two or more tables share the same number of columns and when their corresponding columns share the same or compatible domains, they are said to be union-compatible.
What is it called when a database is created a collection of related data?A collection of related data is called Database. A database is a data structure that stores organized information. Most databases contain multiple tables, which may each include several different fields.
Which attribute points to a primary key in another table within a database?The foreign key is the attribute which points to the primary key of another table. Example: If we have two tables of Student and Course then we can establish a relationship between these two tables using a foreign key.
When you define a table's primary key the DBMS automatically creates a N index on the primary key column's you declared?when you define a table's primary key, the DBMS automatically creates a unique index on the primary key column you declared. A unique index, is an index in which the index key can have only one pointer value(row) associated with it.
|