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

Strategic Management

 

Strategy is a long broad term plan designed to achieve the overall objectives of the firm.

Components of Strategy -

Direction -  where is the business trying to get in the long term ?

Market , scope- Which market should the company compete in and what kinds of activities are involved in such markets?

Advantage - How can the business perform better than the competition in those markets ?

Resources -What resources are required in order to be able to compete?(skills, asset , finance)

Environment -What external environmental factors affect the business ability to compete?

Stakeholders -What are the values and expectations of those who have power in and around the business?

Stakeholder is interested in the activities of the business.

Strategic management is the process of making strategy.It is required for the implementation of the strategy and designed to achieve the objectives of the business.

Comments

Post a Comment

Popular Posts