Define joins. Why are they used and name a different kind of joins available?
It is often required to get data from 2 or more different tables, in such situations joins are used through which we can connect two tables and extract data corresponding to those tables. Various types of joins are: -Inner Join -Outer Join -Left Join -Right Join
What are ER diagrams and various parts of an ER diagram?
ER diagrams are Entity-relationship diagrams that are used to depict and show a complete process through various shapes. It is a logical structure that shows how data is being stored in the database. Various parts of an ER diagram are: -Entity -Weak Entity -Actions -Relationship -Attributes -Connecting lines
Define marketing Mix. (one of the most important concepts of marketing)
Marketing mix is various components that can be controlled by an organization in its favor to positively influence the customer behavior towards their product. 4 major P's of marketing are: - Product - Place - Price - Promotion