Monday 25 June 2018

SQL Server

SQL Synatx:
 Create Database Database Name

Use Database Database Name

Create Table {Table Name}
(
    TableId int Primary Key Identiry,
    Name varchar(50),
     Address varchar(50),
     Roll int
)

SQL Server

SQL is a standard language for storing, manipulating and retrieving data in databases.

Our SQL tutorial will teach you how to use SQL in: MySQL, SQL Server, MS Access, Oracle, Sybase, Informix, Postgres, and other database systems.

Saturday 10 February 2018

CISC ALSO CAN BE IMPLEMENTED BY USING HARDWIRED CONTROL

In the above sense, micro programmed control is not always necessary to implement CISC machines. Hardwired control also can be used for implementing sophisticated CISC machines. The bases of this opinion are as follows:

1. The same field configuration (state assignment) can be used for both of these two types of control. This is clear because of the above identification.

2. We can use any large FSM, that has horizontal microcode like state assignment, since the delay for the FSM does not matter at all so long as it is less than or equal to the delay for the data-path that includes adders, shifters and so on, since the FSM works in parallel with the data-path.

3. The horizontal microcode like state assignment has become very easy to be implemented because of the spread of the hardware description language (HDL). In Verilog HDL, g`defineh statements enable us to get perfect net-list for any large FSMs in a very short time by using appropriate logic synthesizers. “Parameter” statements also can be used for the state assignment in Verilog HDL.

4. CISCs and RISCs are two major different types of ordinary SISD machines. Since hardwired control has been historically faster, both of these two types of machines are implemented by using hardwired control in our microcomputer design educational environment City-1.

5. In 1996, that was the first year of City-1, an example description named CISC-1 with an FSM that uses a horizontal microcode like state assignment was given to all of junior students of the Department of Computer Engineering, Faculty of Information Sciences, Hiroshima City University. They succeeded.

Advantage of Hardwired Control unit

1. Advantage of Hardwired Control unit

2. Faster mode of operation.

3. Faster than Micro programmed Control unit

4. Used in RISC processor.

5. Inflexible to modify.

6. It is also flexible as changes could be easily made to the design.

7. It simplifies the design of the control unit.

8. Simpler design means the control unit ischeaper and less error-prone to implement

9. Can be optimized to produce fast mode of operation.

10. On the basis of input Signal output is generated.

 11. As name implies it is a hardware control unit.

Hardwired Control Unit



  1. It is implemented with the help of gates, flip flops, decoders etc. in the hardware. The inputs to control unit are the instruction register, flags, timing signals etc. This organization can be very complicated if we have to make the control unit large. If the design has to be modified or changed, all the combinational circuits have to be modified which is a very difficult task.
  2. Hardwired control units are generally faster. 
  3. The relationship between control inputs and control outputs is a series of Boolean functions.