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

What is DDL --Data Definition language and DML -Data manipulation language

DDL --Data Definition language

DML -Data manipulation language

DDL --Data Definition language:-To create alter drop the table in or  database we use data Definition language. The DDL command is used to built or modify the structure of a database or a object in that for the database object are any data that store and create in database    For-tables, Rows and View 

1.Create Command

2.Alter Command

3.Drop Command

4.Rename Command

1.Create Command:-To create database objects like table or modify database we used create command, The create statement is use to the create any types of objects.
 
Syntax-Create table table name (column 1 data type (size), Column 2 datatype (size) ).

Create table students (Id int , name varchar (255));

To view the create structure we use describe command " describe the table name.

2.Alter Command:-One there table or database create we required to change a structure of the database or class object we use into the alter command. The key constant can also change by using alter command

syntax-Alter table table name add column datatype (size);

Eg-Alter table study add int (4). To view the change that we mode to than we use describe command.

3.Drop Command:-This command can be use to remove database or database objects permentantly, Drop command use the delete table to structure as will as table data.
 
Syntax-Drop table table name. Drop table study.

4.Rename Command:-By using rename command we can rename any table object any time.

Syntax-Rename table table name to new table name. Alter table employee rename column age to solar. 

DML -Data manipulation language:-Data manipulation language command is used to insert data into table. delete data from table update table data in DML there manly there command.

1.Insert Command

2.Delete Command

3.Update Command

1.Insert Command:-The insert command is use to add record in the exsistance table.

Syntax-Insert into table name (column) column 2 column 3 ) values (value1 value2 value3).

insert into employee (id, name) values (1,'xyz') 2 insert into employee values (1,'xyz').

To display a record we use select statement
 
Syntax-Select *from employee.

2.Delete Command:-The delete statement is use to delete one or more rows from the existing table 

Syntax:-Delete from table name where
 
Delete from employee where id=2;

Where we not write where condition then. All the record of table in delete

3.Update Command:-The update statement is use to modify the record present in existing table.

Syntax:-Update table name set column name value where condition.

Update employee set id=3 where id=2.

When we not write where condition then all data of this column is update.

Comments

Post a Comment

Popular posts from this blog

What is Computer engineering, complete information

Image
                                                                           Computer Engineering Computer Engineering is an engineering branch that is a combination of Computer Science and Electronics Engineering. Digital logic in design computer organization and architecture microprocessor in the system and interfacing computer networks and operating system. In this you learn the design, development and maintenance of both hardware (physical parts of the computer) and software (programs, applications, operating systems). 1.Scope of Computer Engineering    . Computer Engineering students are taught these things: . Computer Hardware Design :-CPU circuit boards microcontrollers,    embedded systems.                        ...
Read more

What is Constants, Variables, and Data Types

Image
                                          Constants   Constants in java refer to fixed values do not change during the execution of a program , Java support several types  of constants as illustrated. .Integer  Constants      An integer constant refer to a sequence of digits , There are three types integers .namely decimal imager octal integers and hexadecimals integers . Decimal integers consist of a set of thing preceded by an optional minus sign Valid of decimals integer constant  .Variables  A variable is an identifier that denotes a storage location seed to store a data value unlike constant that remain unchanged during the execution of a program , a variable may take different values at different times during the execution of the program ,we had used several variable for instance , we used variables length and breath to store the values o...
Read more

What is Diploma Engineering and How to Diploma engineering free course

Image
What is diploma in engineering is  a 3 year  course .All India  It is designed to students with practical skills and knowledge in a engineering.  After completing the diploma, students further education through into a bachelor's degree program or enter the diploma in engineering course   1.School Level (Class 10 )   .Focus on Math Science Physics and Chemistry - MSPC   . After class 10, you will have to take science stream. 2 .11th-12th Science Stream (MSPC Group)    .Physics, Chemistry, Mathematics (PCM) are compulsory subjects.    .You should prepare for entrance exams like JEE, MAHT-SET, VIT, BITSAT.   .You have to clear these exams after class 12. 3.Duration: 4 years   .Popular branches:   . Diploma in computer Science (CSE)   .  Diploma in m echanical   . Diploma in  civil   . Diploma in  electrical   . Diploma in  Electronics & Communication   . Diploma in...
Read more