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 Database Schema

Database Schema



Database Schema:-The description of data in terms of data model of called as database schema. Which is specified unique database design and it does not expect to change frequently. A Database schema is the structure of database which represent physical view a logical view and entire database. It define how the data is arranged and how the relations among them are associated.

.Types of Schema 

1.Physical schema

2.Logical schema

3.View Schema 

1.Physical schema:-Physical schema is also known internal schema the design of the database at a physical level is called as Physical schema . How the data is stored in storage is explained at this level

 2.Logical schema:-The design of database at logical level is called as logical. The level gives a tabular structure of data 

 3.View Schema:-It is also known as external schema. The design of database at view level is called as view schema. This generally refer user and database system interaction 



.Create Database, Database Name

 QU-Show Databases

QU-Use Database name 

QU-Show Tables

QU-Create table table name (column name datatype (size) column name datatype (size);

When we it to comes choosing a database management system architecture. It all comes down to how complex and scalable the system is the three level structure has the best features and it is perfect for modern big database system  

        

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