0
If a relationship is established between two tables they will share a common?
Wiki User
∙ 11y ago
yes they need to have a commmon field
Wiki User
∙ 11y ago
Add your answer:
Earn +20 pts
Explain the distinction between total and partial constraints?
Total constraints are those in which a table's existence requires the existence of an associated table in a particular defined relation between them. whereas Partial constraints are involved with the tables in which presence of one table is partial for the associated table.
What those database comprise?
Database comprises of records that are related to each other. In database the data is stored in the form of tables, are called database tables .
What is the difference between Primarey key and Forn Key?
establishing a relation between two tables called fornkey.......the colum name should be unique is called "primary key"...a table contain only one primary key...a table contain more then one fornkey....
What is the difference between data model and database model?
A database is a collection of tables that is used for some purpose (typically an application of some sort). A database model is a description of that database, and describes how the tables relate to each other. Typically, a model is designed first, then the actual database is implemented using the model as a blueprint.
What does SQL CREATE VIEW achieve?
SQL CREATE VIEW achieves the creation of a table or tables in the SQL database. One can then create tables to the purpose they desire and fill them in with information.
What is the most common type of relationship between tables in a relational database?
one-to-many relationship
What is the most common type of relationship you will encounter between tables?
one-to-many relationships
What are Joins in dbms?
A join is a temporary relationship that you can create between two tables in a database query that do not already have an established relationship or common field with the same fieldname or data type. Database tables that are joined in a query are related in that query only, and nowhere else. The type of join that you use indicates which records the query will select or perform the chosen actions on.
How many to many relationship are established?
A junction table is added between the two tables involved in the relationship. The primary key from each table is added to the junction table and they are made a joint primary key in that table. Then two one-to-many relationships are set up between the junction table and each of the two other tables.
How are relationship between tables expressed in a relational database?
Tables are the basic building blocks of a relational database.
What role does a foreign key play in the establishment of a relationship between two entities or tables?
A foreign key is a relationship or link between two tables which ensures that the data stored in a database is consistent.
What is the relationship between tables in library management system?
In a library management system, tables represent different entities such as books, users, transactions, etc. The relationship between these tables is established through keys like primary keys and foreign keys. For example, the books table may have a primary key "book_id" which is referenced as a foreign key in the transactions table to link books with users.
In order for two tables to have a relationship they must contain a common?
The must have a topic or object that is the same!
The purpose of the primary key in building the relationship between tables?
primary keys are unique
What happen when you delete foreign key?
You will lose the connection between the tables and break the relationship.
How many relations may exist between two tables in a MS Access database?
only one relationship can exists between two tables in the MS ACCESS software
What is a many to many relationship in dbms?
Many to many relationship in DBMS is usually a mirror of the real-life relationship between objects that tables represent.
