Designing the Data Layer in MSF

Database schema is a formally described structure in terms of DBMS. In an RDBMS, schema is defined using database tables, fields, and relationships (foreign keys)..........
Types of physical data models - Flat-file, Hierarchical, Relational and object-oriented.......
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).......
Data is often partitioned to achieve better maintainability and accessibility. For example, in case of a data warehouse......
The performance increases on optimizing transactions because: 1. An optimized query targets the exact field data are needed..........
Databases indexes are used to improve the speed of operations on database tables. Indexes are created using one or more fields of a table........
Horizontal partitioning of data refers to storing different rows into different tables. E.g.: Students with their first name starting from A-M are stored in table A........
Microsoft solution framework - What are the benefits of using components to implement business rules?.........