0
What relationship would to use where one record in a table is related to many records in another case?
Kblady
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.
Wiki User
∙ 15y ago
Add your answer:
Earn +20 pts
How records are logically deleted from files?
You might define a boolean field in the record meaning 'this record is logically deleted: yes/no'.
What are anomalies in DBMS and their types?
Tables that have redundant data have problems known as anomalies.So data redundancy is a cause of an anomaly. Redundancy is the duplicaion of the data. There are 3 types of anomalies. Insert Anomaly:When you insert a record without having it stored on the related record. Delete Anomaly:When you delete some information and lose valuable related information at the same time. Update Anomaly: Any change made to your data will require you to scan all records to make the changes multiple time.
What is a flat data structure?
A flat data structure is essentially one that has no relationships among its various records. Each record is just part of a list of records. One example would be a worksheet in Excel of names and addresses with one record per row of the table.
What are the records maintain by production engineers?
For only production engineer Fitup record and weld record is must,fitup and weld visual checking goes under the QA/QC department.
Sorting IN FOXPRO?
Sorting in FoxPro changes the physical record position in the table. Records can also be rearranged in FoxPro by indexing.
What relationship to use if you have one record in a table is related to many records in another table.?
One-to-many relationship
What relationship describes when a record from one table is related to several records in another table.?
One-to-many relationship. This means that for every record in the first table, there can be multiple related records in the second table, but each related record in the second table corresponds to only one record in the first table.
What Is the relationship between fields records and databases?
Fields are the individual data elements within a record, which is a collection of related fields. Databases are collections of records organized in a systematic way for efficient data storage and retrieval. In summary, fields make up records, and records make up databases.
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
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.
