0
What relationship to use if you have one record in a table is related to many records in another table.?
Wiki User
∙ 11y ago
One-to-many relationship
Wiki User
∙ 11y ago
Add your answer:
Earn +20 pts
What is a civil record?
Official records related to civil cases, i.e., when one party sues another.
What relationship would to use where one record in a table is related to many records in another case?
That's what you call 1:n relation. An example is the 'father of' relation: everyone has only one father, but any male can have zero, one or more children.
Referential integrity prevents the creation of records?
It prevents the creation of records that do not have a related record in the database. For example, a product record might have to have a category, but it cannot be entered with a category that has not already been created in another table in the database. It has to reference it. This is very important in relational databases.
How many types of relationship available in access 2007?
Your tables can participate in three types of relationships, and the picture shows them.You have a one-to-one relationship when a single record in one table is related to a single record in another table, and vice versa. For example, one specialized file server may have just one repair technician.You have a one-to-many relationship when one record in a table is related to many records in another table. For example, one employee can use many assets, such as a computer, chair, and desk.You have a many-to-many relationship when several records in one table are related to several records in another table. For example, your company probably owns a large number of computers, and you may use several technicians to maintain those computers. Many technicians can be responsible for many computers.One-to-many relationships are the most common type in a database. The others are fairly rare, and you won't use any during this series of courses. However, we will show you the basics of how to create them. For more information about them, see the links in the Quick Reference Card at the end of this course.
What situations are indicated when referring to records marked for Disposition?
Record transfer to a records center or the National Archives.Destruction, salvage, or donation of records.Any actions taken with inactive records to include erasure of data.Transfer to a staging area or record center or another org-record transfer to a records center or the National Archives-destruction, salvage, or donation of records-any actions taken with inactive records to include erasure of data-transfer to a staging area or record center or another organizationdestruction, salvage, or donations of recordsrecord transfers to a records center or the National Archivesany actions taken with inactive records to include erasure of datatransfer to a staging area or record center or another organizationany actions taken with inactive records to include erasure of datatransfer to a records center or the national archivestransfer to a staging area or record centerdestruction, slavage, or donation of recordsTransfer to a staging area or record center or another organization Record transfer to a records center or the National Archives Destruction, salvage, or donation of records Any action taken with inactive records to include erasure of data
What is the relationship between a record and a field?
A record is a collection of fields that represent a single entity or object. Each field in a record holds a specific piece of information about that entity. Together, records and fields help organize and store data in a structured manner within a database or spreadsheet.
Where in Los Angeles can you sell your records?
Record stores like Amoeba in Hollywood will buy back records, CDs and DVDs. Another store in Los Angeles to sell used records to is Record Surplus.
How can you get a record deal with Hollywood Records if you live in another country?
Yo Can't
What is the purpose of cascade update related fields according ms access?
Just like Cascade Update Related Fields updates any record you change to the other table you have made a relationship with, Delete does the same thing! Delete one record and the other table which you have also made a relationship with will be deleted aswell.
What is the worst baseball record?
Click the related link bellow, I laughed when I read some of these records.
Who still makes vinyl records?
Check the related links below for a list of record pressers.
What is database composition in database?
Composition is a term that comes from object oriented design. It is a relationship in which a number of parts comprise a whole, and these parts can only be part of one whole. There is no direct translation of this concept to database design, but there are some situations in the database world that represent the concept of composition. Field to record A record is composed of fields and these fields are part of only one record. When the record is removed, the fields are also removed. So, each field has a composition relation with its record. This means that when you store a collection (a comma separated list of names for example) in a database field, this is in fact a composition relationship. Record to record from other table If you want to create a composition relation between records from a table A and records from another table B, where A is the whole and B the parts you must ensure that 1. There is a one-to-many relationship between table A and B. This is done by adding a foreign key to table B. 2. That all part records in B are deleted when the whole record in table A is deleted. This can be done by setting ON DELETE CACADE on the foreign key relationship. 3. That the records in table B don't become part of another composition relationship. But this restriction cannot be enforced by the database to my knowledge.
