A bad sector is an unusable part or subdivision within a track on a magnetic or optical disc located on a computer's hard disk or flash drive. A bad sector is typically formed as a result of physical damage of some sort, or rarely, the operating system's inability to access the information. The physical damage occurs to the disk surface or as a...
In relational databases, a one-to-many relationship occurs when a parent record in one table can potentially reference several child records in another table. In a one-to-many relationship, the parent is not required to have child records; therefore, the one-to-many relationship allows zero child records, a single child record or multiple child records. The important thing is that the child cannot have more than one parent record. The opposite of a one-to-many relationship is a many-to-many relationship, in which a child record can link back to several parent records.
Consider a database for recording sales information in a store. There are two tables in this database:
The SALES table contains the CUST_ID foreign key, which references the column of the same name in the CUSTOMER table to track the customer to whom the sale was made. A single sales transaction can only apply to one customer, but one customer can have many sales transactions over the course of time. This logic is what is defined by the one-to-many relationship. One, in this example, is one customer to many sales transactions.The one-to-many relationship is only a principle of database design, which cannot be explicitly defined in the database structure. Instead, it is implicitly created and enforced by the use of relationships between tables, especially the relationship between a primary key and a foreign key.
Read More »
Join 138,000+ IT pros on our weekly newsletter
Home | Advertising Info | Write for Us | About | Contact Us
2010 - 2014
Janalta Interactive Sites: