Various relationships that can exist between database tables - MSF

What are the various relationships that can exist between database tables? Explain them [Hint - One-to-one relationship, One-to-many and Many-to-many]

One-to-One: Depicts that one instance of entity A is and can be only related to one instance of entity B. e.g.: Student->Class (One-to-One)
This means that one student can belong to only one class.

One-to-Many: Depicts that one instance of entity A can be related to one or more instances of entity B. e.g.: Class->Student (One-to-Many)
This means that one class can have many students.

Many-to-Many: Depicts that one or more instances of entity A can be related to one or more instances of entity B. e.g.: Teacher->Student (Many-to-Many)
This means that one teacher can have many students and a single student can have many teachers.
Purpose of partitioning data - microsoft solution framework
Data is often partitioned to achieve better maintainability and accessibility. For example, in case of a data warehouse......
How do you optimize transactions for good system performance? - MSF
The performance increases on optimizing transactions because: 1. An optimized query targets the exact field data are needed..........
Impact of indexing on data access - microsoft solution framework
Databases indexes are used to improve the speed of operations on database tables. Indexes are created using one or more fields of a table........
Post your comment