0
There are two generic types of relationships that are found between tables in existing databases, those that are explicit (or defined) and those that are implicit (or undefined.)
The explicit relationships are defined differently in each database management system, so finding these relationships will depend on which type of database you're using. Typically they can be found via the user interface when designing one of the two tables in the relationship, viewing a relationship option, or by applying SQL against specific system tables.
The explicit relationships usually enforce referential integrity in the database, so they are strongly encouraged over implicit relationships, but still implicit relationships will be found in the real world in existing databases.
Implicit relationships are relationships where the primary key in one table can be clearly identified in another table as a foreign key, but there is no explicit relationship defined. Because the name of the foreign key matches or is similar in pattern to the the the primary key in the other table, you can imply that there should be a relationship between those tables. These relationships can be identified by foreign key names and by looking at existing SQL and queries in the database system to see what fields tables are joined on.
Wiki User
∙ 12y ago
Add your answer:
Earn +20 pts
How do you find the length of a side of a rectangle when you only have the area?
It can't be done. You must also know at least any one of the following: Perimeter Relation between length and breath Relation between Area and length Relation between Area and breath Relation between perimeter and Area Breath and so on...........
How do you find a domain and range of a relation given by a set of order pairs?
Describe how to find the domain and range of a relation given by a set of ordered pairs.
How can you find the height of a triangle if you have base and area?
The relation between the height of a triangle, its base and its area is given by: Area = 0.5 * Base * Height Therefore, we have: Height = (2 * Area)/ Base.
How can you find a linear relation between time t and another variable containing Vc in an RC circuit and then use linear regression to find the slope and intercept of these two variables?
-τ(ln (Vo-Vc/Vo)=t Mgk is that all
What is the fractional ratio of 1inch equals 300 miles?
The fractional ratio of 1inch equals 300 miles can be find out by finding and determining the relation between inches and miles . 1 mile = 63360 inches . 300 miles =19008000 inchhes. lets find the ratio now . 1 : 19008000.
What is a person's ideology?
To find out the relation in between words in a sentence.To find the relation between word and the world.To find out the relation between spoken and written.To find out the relation between thought and its thinker,seer and seen,word and its image and so on.
What tables shows a relation in which the independent quantities are negatively related?
We're unable to find any such table on the list that follows the question.
What are typical benefit of relational databases?
With a relational database, you can quickly compare information because of the arrangement of data in columns.A typical relational database has anywhere from 10 to more than 1,000 tables. Each table contains a column or columns that other tables can key on to gather information from that table.By storing this information in another table, the database can create a single small table with the locations that can then be used for a variety of purposes by other tables in the database. A typical large database, like the one a big Web site, such as the police would have, will contain hundreds or thousands of tables like this all used together to quickly find the exact information needed at any given time
Write short note on transact-sql?
Transact-SQL is the brand of SQL used by Microsoft SQL Server, Microsoft's most advanced database software.SQL is a language used to operate databases. For example, you could write a SQL query to find the phone numbers for people named "Smith" in a phone database.A database just stores related information in tables organized into rows. For example, a phone book database would have a table of rows where each row contains name, phone number, and address. A database can have multiple tables; so a phone book database would have separate tables for people and businesses.
What are the typical benefits of relational databases?
With a relational database, you can quickly compare information because of the arrangement of data in columns.A typical relational database has anywhere from 10 to more than 1,000 tables. Each table contains a column or columns that other tables can key on to gather information from that table.By storing this information in another table, the database can create a single small table with the locations that can then be used for a variety of purposes by other tables in the database. A typical large database, like the one a big Web site, such as the police would have, will contain hundreds or thousands of tables like this all used together to quickly find the exact information needed at any given time
How do you find the length of a side of a rectangle when you only have the area?
It can't be done. You must also know at least any one of the following: Perimeter Relation between length and breath Relation between Area and length Relation between Area and breath Relation between perimeter and Area Breath and so on...........
Where can you find a database?
on Microsoft excel you can find a database.
How do you find the moles recquired?
In order to find the number of MOLES, you must find the relation to said MOLES. Always remember to balance the equation to determine the coefficients. That would be in order to find the relation between them.
Where can one find information about restoring a database?
There are several places on the internet to find information about restoring a database. Microsoft user forums have information, particularly with relation to their "SQL server management studio" software. Many people have written blogs about the subject that may also be useful.
whatisthe relation ship between logic and language?
the answer but i do know that you can find the answer
What is the relation between the Filipino to to Mexicans?
The same you would find between Indians and South Africans: both ethnicities are non-caucasian.
Where can one find information about an object oriented database?
One can find information about an object oriented database in the book 'On Object Oriented Database Systems'. One can also find information about an object oriented database online on the IndiaBix website.
