answersLogoWhite

0

📱

Software Engineering

Software engineering is the process of applying well-developed techniques and practices in order to create new software products. Questions about everything from design patterns to requirements and specification belong here.

1,663 Questions

Difference between select and inner join?

The select command is the mechanism for retrieving records from a SQL database. In it's simplest form, this would be FROM a single table, for example - select * from CustomerTable.

When data is needed from multiple tables, each pair of tables has to be linked together using a JOIN. The easiest type of join is an INNER JOIN, which expects the data to be in both tables. For example, if a customer record had a 'STATE' code which looked up against the US States and we want our SELECT to return the State name as well as the customer code, it would look something like this;

SELECT CustomerCode, CustomerName, StateName FROM Customer INNER JOIN State on (State.ID = Customer.StateCode)

What are the advantages and disadvantages of pairwise programming?

Assuming you understand what Pair-wise programming is, we can in general say that it is advantageous because the overall logic of the code written, the idea behind using certain constructs in the code, etc. are known to different people rather than a single head. Since, two or more heads is obviously better than one, we see that Pair-wise programming is certainly advantageous. But, the flip-side is say you are stuck in a situation in the code-development and one fine afternoon you get a flash but you cannot code because your partner is not there. Also, increased costs is another disadvantage. These are the basic points and I can assure you that there are several subtleties involved.

Can you use linear sequential model in RAD?

In RAD, the project is divided into modules and each module is alloted to different team. Each team work on the module in a sequential manner.

ER model for project management systems?

A university has a large number of courses in catalog.Attributes of COURSE include Course_Number(identifier),Course_Name and Units.Each course may have one or more course as prerequisties or may have no prerequisties.Similarly,a particular course may be a prerequisties for any number of courses or may not be prerequities for any other course.

What does restricted access major mean?

It means you must meet the requirements for entrance to the major. Its not open to all students but only those who qualify. You will usually find this in the health related majors.

What is ASi module?

Automatic Switch Interface (ASI)

The CAIRS OSS ASI module is a multiple switching platform provisioning tool that increases the power and accuracy of the CAIRS system substantially. Working in either a single or multiple switch environment, the ASI module is a cross platform scripting language that can communicate to any switch that utilizes ASCII, Binary, XML file configuration commands (i.e. Nortel, Avaya, Lucent, Siemens & Redcom). Although the ASI module carries the complexities of a programming language, all of the hard work is done behind the scenes. When CAIRS users open a work order that requires a switch assignment, CAIRS writes a change request to the ASI sub-folder in the CAIRS database. Watching the CAIRS database real time for new work orders requests, the ASI module interprets each new work order to determine the assignment type. Once the ASI module has successfully programmed the switch it returns an assignment summary to the CAIRS users. The assignment summary notifies the CAIRS user that the assignment has been completed successfully.

What are mental models and why are they important in interface design?

Mental models are the theories people build to understand the causal behavior of systems. These are often partial, unstable and subject to change. They may be internally inconsistent. They may be superstitious and based on incorrect interpretation of evidence. They are important, as errors can occur if the user's model is incorrect or if the designer has a different model than the user. One way of minimizing problems is supporting conventions - another is to make the correct model explicit.

Program of swapping two no?

There are several ways to do this in C:

// nums to swap

int a = 5;

int b = 10;

// using a temporary variable - often the fastest method

int temp;

temp = a;

a = b;

b = temp;

// using addition (no additional storage needed)

a = a + b;

b = a - b;

a = a - b;

// using xor (no additional storage needed)

a = a^b;

b = a^b;

a = a^b;

// using only one line (no additional storage needed) // note, this appears to be a compiler-dependent way to swap variables

a = a + b - (b=a);

Different activities in the 6 phases in classical waterfall model?

1) Identify client requirements

2) Identify system requirements

3) Create an overall design

4) Create a detailed design

5) Develop product

6) Test product

What is prototype model in manual testing?

The Prototyping Model is a frameworks improvement technique (SDM) in which a model (an early guess of a last framework or item) is assembled, tried, and after that revised as vital until the point when a worthy model is at last accomplished from which the total framework or item would now be able to be created. This model works best in situations where not the majority of the undertaking prerequisites are known in detail early. It is an iterative, experimentation process that happens between the engineers and the clients.

What is the difference between a persistent object and a transient object?

a persitent object is the one that is stored permanently on the disk......whereas a transient object is stored temporarily on the ram....

What is the Difference between physical DFD and logical DFD?

For a physical Data Flow Diagram you explore into the logical DFD. for example, if you have a data flow arrow declared as "customer information" now the physical DFD would include in that data flow arrow "customer information = customer_name + customer_address". something along these lines

Physical DFD shows how various functions are performed and who does them but Logical DFD strips away all physical constraints but does not restrict physical happenings from taking place.

Why there is not a universal agreement on system life cycle?

because some people think the egg came first, some think the chikin did

(excuse my spelling)

What are the example of prototype model?

When you customer has a legitimate need bit is clueless about details/ requirements then develop a prototype as a first step.