What is Software process framework And, Umbrella activities

Image
  ❖ Software generic process framework activities .   A process framework establishes the foundation for a complete software process by identifying a small number of framework activities that are applicable to all software projects, regardless of their size or complexity. • In fig each framework activity is populated by a set of software engineering actions. A collection of related tasks that produces a major software engineering work product. • Each action in process framework is populated with individual work tasks that accomplish some part of the work implied by the action. 1. Communication: Communication framework activity involves heavy communication and collaboration with the customer,encompasses requirements gathering, data gathering and other related activities. 2. Planning: Planning activity establishes a plan for software engineering work that follows. Planning describes the technical tasks to be conducted, the resources that will be required, schedule, and the risks...

What is Relational structure, Table, Attributes, Rows Record, Domain, Super key, Composite key, Candidate key, Primary key, Foreign key

Table:-The table in a database has it unique name in the relational in table consisting Horizontal  rows that is also called as Tuples fore the Vertical columns also called as attributes. Each table row represent a single entity Occurrence withing the entity set. 

Attributes:-In the above table column represent data stored in it such column is called as attributes. Ex-Name id (column name) every cans a table must have at least one column. The squle standard does not be specify in in only maximum number of column in a table.

Rows Record:-In a single row in a relational table which contain all information about. A single entity each horizantal row of student table represent the student record and in the and table there are multiple row.

Domain:-The every column in a table has set of data values that are allowed for that column that is called as domain.

In a relational table a domain can have a single value or null values 

.Types of keys 

1.Super key 

2.Composite key 

3.Candidate key 

4.Primary key  

5.Foreign key

Super key:-The super key an attributes or a set of attribute that can in the uniquely identify the record in a single entity. In one table there can be more thane one super key. 

Composite key:-Any key with more then one attribute and that more uniquely identity a single entity, Super key has more then one record attribute so that is called as composite key.

Candidate key:-A super key with minimum number of attribute in called as candidate key. Candidate key is a potential of primary key identity  Ex-Passport number, license number, Aadhar number, act like most be candidate key.

Primary key:-Primary key in a column that uniquely identify record in relational table, primary key cannot be a null values. 

Ex-In employee table employee id (eid) is a primary key and it must be uniquely.

Foreign key:-Foreign key is set a column or a group of column in a table that provide connection between two table. Foreign key act as a reference to the other table. The Tuple in one relation is referred only the existing Tuple to another table.   


Comments

Popular posts from this blog

What is Computer engineering, complete information

What is Constants, Variables, and Data Types

What is Diploma Engineering and How to Diploma engineering free course