Skip to main content

Featured

Constraints

NOT NULL CONSTRAINT -    Ensures that a column cannot have a null value. DEFAULT CONSTRAINT -    Provides a default value for a column when none is specified  UNIQUE CONSTRAINT -   Ensures that all values in columns are different  CHECK CONSTRAINT -   Makes sure that all values in a column satisfy certain criteria  PRIMARY KEY CONSTRAINT -   Used to uniquely identify a row in the table  FOREIGN KEY CONSTRAINT -   Used to ensure referential integrity of the data  Primary Key - is used uniquely to identify each row in a table . It can consist of one or more columns on a table . When Multiple columns are used on a table it is called composite key.  Foreign Key - Foreign key is a column or columns that references a column most often primary key of another table . The purpose of foreign key is to maintain referential integrity of the data. Pg admin  Data base - training - right click on training - query click  Always add semi colen to run the query  Int - integer  varchar - variable charact
Post a Comment
Read more

Loan Terminology

 Loans are the most common form of debt . 

A loan is a money borrowed from a financial institution that has to be paid back within certain period of time along with interest.

Principal - Original amount that you borrow and agree to pay back . Casually referred to as an loan amount.


Term - Duration of the loan is also called loan tenure . Money borrowed ( Principal ) must be paid back within this specified time frame along with interest owed .


Interest Rate - The amount , the lender charges for lending money , Example - 9% of principal .


Downpayment - The initial amount you have to pay upfront wen taking loan.


EMI - Equated Monthly Instalments , equal monthly fixed payments you make to pay off the loan during the loan tenure.


Other Fees - Application fees ? processing fees , admin fees ? annual fees , late fees , pre-payment fees etc.

Comments

Post a Comment

Popular Posts