Posts

Showing posts from September, 2025

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...
Post a Comment
Read more

DCL-Data Control Language And TCL -Transaction Control language

DCL-Data Control Language  TCL -Transaction Control language DCL-Data Control Language:- The data control language is use to give permition and revoke the permition, To perform any for operation in the database then user need permition like inserting data of reating record deleting data or view record. The record for  In data control language there are mainly two command. 1.Greant command 2.Revoke command 1.Greant command:- The Greants command is use to given in the permission to user after that this user perform operation on database generally a grent statement is use by owner of table.  When we give permission to that user then this user must be present in the database. Syntax-Grent permission on table name to user name.  There are various permission that is given below  2.Revoke command:- W e can reject the permission given to database particulars user with the help revoke command. Syntax-Revoke permission on table name from username.  To remove the perm...
Post a Comment
Read more

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  Tuple s 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  .Type...
Post a Comment
Read more

What is Database Schema

Image
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 interac...
Post a Comment
Read more