Explain Various Types of Data Models
There are mainly three different types of data models: Conceptual:Conceptual data model defines what should the system contain Explain The Fact and Fact Table
The fact represents quantitative data. For example, the net amount which is due List Out Various Design Schema in Data Modelling
There are two different types of data modelling schemes schemas: 1) Star Schema When Should You Consider Denormalization?
Denormalization is used when there is a lot of involvement of the table while retrieving data. It is used to construct a data warehouse Explain Dimension and Attribute
Dimensions represent qualitative data. For example, product, class, plan, etc. A dimension table has textual or descriptive attributes. For example What Is table?
The collection of rows and columns is called as table. Each and every column has a datatype. Table contains related data in a tabular format What Is Composite Primary Key?
Composite primary key is referred to the case where more than one table column is used as a part of primary key What Is Primary Key?
Primary keyis a column or group of columns that unequally identify each and every row in the table. The value of primary key must not be null Explain Foreign Key
Foreign keyis a group of attributes which is used to link parent and child table. The value of the foreign key column, which is available in the child table