|
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?.........
|
