0
Database Design
Database design is the process of creating a detailed data model of a database. It is the next step after requirement gathering and before coding begins. A good database design can save a lot of time during the database development.
1,295 Questions
How you create a table in C programming language?
Well, I don't know what do you mean by table, but here you are:
int main (void)
{
puts ("A3 B3 C3");
puts ("A2 B2 C2");
puts ("A1 B1 C1");
return 0;
}
What are the objectives of system analysis and design?
Answer
System development can generally be thought of having two major components: systems analysis and systems design.In System Analysis more emphasis is given to understanding the details of an existing system or a proposed one and then deciding whether the proposed system is desirable or not and whether the existing system needs improvements. Thus, system analysis is the process of investigating a system, identifying problems, and using the information to recommend improvements to the system.
For more http://www.freetutes.com/systemanalysis
What motivates you to apply for this job?
Sales Job: "The money."
HR Job: "I like helping people."
Teaching Job: "I want to give others the same sort of education I had"
Mechanic Job: "I like cars."
Summary: There are as many answers as there are jobs and the answer is always glib and obvious.
Explain different parts of an instruction format?
Instruction FormatThe information encoded in an 80386 instruction includes a specification of the operation to be performed, the type of the operands to be manipulated, and the location of these operands. If an operand is located in memory, the instruction must also select, explicitly or implicitly, which of the currently addressable segments contains the operand.
80386 instructions are composed of various elements and have various formats. The exact format of instructions is shown in Appendix B; the elements of instructions are described below. Of these instruction elements, only one, the opcode, is always present. The other elements may or may not be present, depending on the particular operation involved and on the location and type of the operands. The elements of an instruction, in order of occurrence are as follows:
- Prefixes -- one or more bytes preceding an instruction that modify the operation of the instruction. The following types of prefixes can be used by applications programs:
- Segment override -- explicitly specifies which segment register an instruction should use, thereby overriding the default segment-register selection used by the 80386 for that instruction.
- Address size -- switches between 32-bit and 16-bit address generation.
- Operand size -- switches between 32-bit and 16-bit operands.
- Repeat -- used with a string instruction to cause the instruction to act on each element of the string.
- Opcode -- specifies the operation performed by the instruction. Some operations have several different opcodes, each specifying a different variant of the operation.
- Register specifier -- an instruction may specify one or two register operands. Register specifiers may occur either in the same byte as the opcode or in the same byte as the addressing-mode specifier.
- Addressing-mode specifier -- when present, specifies whether an operand is a register or memory location; if in memory, specifies whether a displacement, a base register, an index register, and scaling are to be used.
- SIB (scale, index, base) byte -- when the addressing-mode specifier indicates that an index register will be used to compute the address of an operand, an SIB byte is included in the instruction to encode the base register, the index register, and a scaling factor.
- Displacement -- when the addressing-mode specifier indicates that a displacement will be used to compute the address of an operand, the displacement is encoded in the instruction. A displacement is a signed integer of 32, 16, or eight bits. The eight-bit form is used in the common case when the displacement is sufficiently small. The processor extends an eight-bit displacement to 16 or 32 bits, taking into account the sign.
- Immediate operand -- when present, directly provides the value of an operand of the instruction. Immediate operands may be 8, 16, or 32 bits wide. In cases where an eight-bit immediate operand is combined in some way with a 16- or 32-bit operand, the processor automatically extends the size of the eight-bit operand, taking into account the sign.
What are the advantage of database?
In every field of work there is a need of maintaining database to store records . The major advantages of the DBMS are the speed , flexibility, ease , and that it can be stored anywhere. Also the data is very consistent and integrated.
Why should database be protected?
Database contains data which might be confidential. Data in any organization is confidential. To prevent confidentiality of the firm security need to be implemented.
So that information can not be stolen.
What are the characteristics of object oriented systems?
the three main design principles of object oriented programming are the following:
- encapsulation - this allows the user to hide the information for outside world and doesn't allow the other user to change or modify the internal values of class.
- polymorphism - one term in many forms
- inheritance - offers to derive a new class from an existing one and acquire all the feature of the existing class. The new class which get the feature from the existing class is called the derived class and other class is called the base class.
Difference between file processing and dbms?
File based approach can be attributed to two factors:
1. the definition of the data is embedded in the application programs, rather than being stored separately and independently.
2. there is no control over the access and manipulation of data beyond that imposed by the application programs.
To become more effective, a new approach was required. What emerged were the database and the DBMS (Database management system).
Full subtractor using 2 half subtractor?
The half adder is an example of a simple, functional digital circuit built from two logic gates. A half adder adds two one-bit binary numbers A and B. It has two outputs, S and C (the value theoretically carried on to the next addition); the final sum is 2C + S.
What is the equivalent of JIS for Q345B?
low alloyed steel plate Material: Q345B (which is equivalent to S335JR,JIS G3135 , DIN EN10025) Size: Thickness: 8-200mm Width: 1800mm up Length: 6000-12000mm
1 What are the three basic functional blocks of a computer?
Binary bits. This is 0s and 1s. Everything else is built up from these 0s and 1s to make more human-understandable language.
0s and 1s are used because it is very easy to make clear, definable electrical signals for 0 and 1. It is simply "on" and "off".
Algorithm can be defined as an interpretable, finite set of instructions for dealing with contigencies and accompanying task that has recognizable end-points for given inputs. It is a tool for solving a well computational problem. A recursive algorithm is one which calls itself.
A soft start is a starter that bring a motor from the starting point of a slow speed in to a multiple speed that can be programmed in the starter
Imagine you have a big plant in your factory, the voltage will go down/up when the plant start/stop, cause the sharp start/stop
The soft starter is controlling AC motor in soft start/stop to eliminate such problems.
Reference: http://www.softstarter.org
What is a finite and infinite set?
A set which containing $and pi are the end blocks are the finite and without these are infinite
There are a number of data types that we use in computer science. Bool data type stands for boolean data type. In boolean data type the data is stored in form of 0 ans 1s. On boolean data type logical functions like AND, OR ,NOT ,XOR etc functions can be performed.
Design a non recursive algorithm for the towers of hanoi puzzle?
public class TowersOfHanoi{
public static void main(String []args){
new TowersOfHanoi().start();
}
public void start(){
String []tOH=showSteps(4);//if there are 4 disks
System.out.println("Towers of Hanoi step by step!");
for(int k=0;k<tOH.length;k++){
System.out.println("Step "+(k+1)+": Move a disk from "+tOH[k].charAt(0)+" to "+tOH[k].charAt(1));
}
}
public String []changeString(String []array,char a, char b){
for(int i=0;i<array.length;i++){
for(int j=0;j<array[i].length();j++){
if(array[i].charAt(j)==b){
array[i]=array[i].substring(0,j)+a+array[i].substring(j+1);
} else if(array[i].charAt(j)==a){
array[i]=array[i].substring(0,j)+b+array[i].substring(j+1);
}
}
}
return array;
}
public String []showSteps(int n){//how many n disks are there?
String []data={"A","B","C"};
String []Array=new String[(int)(Math.pow(2,n))-1];
for(int i=1;i<=Array.length;i=i*2+1){
int middle=(i-1)/2;
Array[middle]="AC";
String []tempArray=new String[middle];
for(int left=0;left<middle;left++){
tempArray[left]=Array[left];
}
tempArray=changeString(tempArray,'C','B');
for(int o=0;o<middle;o++){
Array[o]=tempArray[o];
}
tempArray=changeString(tempArray,'B','A');
tempArray=changeString(tempArray,'A','C');
for(int o=middle+1;o<i;o++){
Array[o]=tempArray[o-middle-1];
}
}
return Array;
}
}
Data flow diagram for online banking system?
E Rmodel for banking system means the working process of the bank
Is it bad to use a laptop on the bed?
Few points
1. If used on bed without any hard flat surface under the laptop, primarily you should be concerned about heat the laptop generates. With insufficient cooling, the laptop may shutdown when it gets overheated.
2. You may also sleep while using the laptop and may drop the laptop on the floor and damage it.
3. If you eat and drink while using laptop on bed, chances are more that you may spil some thing on the machine.
4. If you have no other option but to use the machine on bed, make sure you use some large wooden board or any large hard book under the machine to allow for air circulation under the laptop.
-----
It's OK to use your laptop on the bed if you have something underneath it. For example, a book underneath your laptop will do good. The reason for this is, the heat produced by the laptop is really hot, and when there is nothing shielding the sheets ( they are highly flammable), it might catch on fire.
IMPORTANT: Do not put your laptop on your lap because:
1. If you're a guy, you have a high risk of catching prostate cancer.
2. If you're a female/girl, you have a high risk of catching any other form of cancer.
____________________________________________________________
Well, i think the main reason is, the laptop cooling fan. Actually mostly laptops has cooling fans on it's base. Fan takes the air from it, and if it is on bed, then no air gets in the laptop. So it becomes hot. This is the main reason manufacturers suggests not to use laptops on bed.
That's it.
A data warehouse is a centralized pool of data. Data warehouse is basically a repository where large amount of data is stored . The advantage of data warehouse is that we can archive the data that is not used in a long time.
How do you create operating system?
An operating system is a company's unique way of doing things, which includes how its production, marketing, and recruiting policies and procedures. Documented, the OS helps to collect and share tribal knowledge and get team members on the same page.
It organizes your business’ different functions, enabling easier delegation of duties and assignment of tasks and ensuring smoother communication between management and staff. A documented OS enforces order, which enables the business to run even in your absence.
Steps to make an Operating system for the company:-
1. Document the processes:- Start by documenting, in as much detail as possible, all your most important processes and procedures. For example, you'll want to write an SOP for things like closing your monthly budget, your review cycle, and fielding complaints.
2. Document your systems:- start sorting each process and procedure into the appropriate system. All of these should be smaller parts that help build your larger systems.
3. Differentiate the roles:- Write a job description for each role. That way, you really understand what each spot of your team should look like. Key responsibilities, expectations, and non-negotiable skills included.
4. Assign people to each role:- Take everyone on your team and assign one person to one job description. But make sure you don't fall into the trap of putting someone somewhere just because that's where they've always been.
5. Train on your OS:- Simply put, you can't put your OS to work if your team doesn’t know about it - or what it means. So they need to be trained on it. But with that being said, not everyone needs to know everything about your operating system.
Creating an operating system for your company might be a lengthy and time taking process. If you are looking to create an operating system for your company then Jamie Stenhouse is the best one providing the quality and efficient operating system for your company at affordable prices.
Data handling is the process of ensuring that research data is stored, archived or disposed off in a safe and secure manner during and after the conclusion of a research project. This includes the development of policies and procedures to manage data handled electronically as well as through non-electronic means .
What are the outcomes of a poor design interface?
A poor design interface can have several negative outcomes, including:
User frustration: A poorly designed interface can frustrate users who may have difficulty understanding how to interact with the interface or complete tasks.
Decreased user satisfaction: If users are unable to accomplish their goals or find it challenging to use the interface, they may be dissatisfied with the product or service.
Reduced user engagement: Users may become disengaged with the interface if it's confusing or challenging to use, resulting in lower user engagement.
Increased support costs: A poorly designed interface can lead to an increased demand for customer support or help resources, as users may need assistance in understanding how to use the interface.
Lost sales or revenue: If users are unable to complete transactions or perform actions that generate revenue, the organization may experience a loss in sales or revenue.
Damage to brand reputation: A poorly designed interface can harm the brand reputation, as users may perceive the product or service as low quality or unprofessional.
Increased development costs: If design flaws are identified after the product has been developed, it may require additional development work to address the issues.
In summary, a poor design interface can lead to a range of negative outcomes, including user frustration, reduced satisfaction and engagement, increased support costs, lost sales or revenue, damage to brand reputation, and increased development costs.
