by Dinesh Thakur Category: DBMS & RDBMS

A database instance controls 0 or more databases. A database contains 0 or more database application schemas. A database application schema is the set of database objects that apply to a specific application. These objects are relational in nature, and are related to each other, within a database to serve a specific functionality. 



 
by Dinesh Thakur Category: DBMS & RDBMS

The related information when placed is an organized form makes a database. In simple words, an organized collection of related information is known as database. The organization of data/information is necessary because unorganized information has no meaning. There are so many examples of organized information, more precisely and the most common are, the dictionary, the telephone directory, student record register, your own address book and many more. In each of these the data is stored in some particular order i.e. in an organized form.



 
by Dinesh Thakur Category: DBMS & RDBMS

An early proposal for a standard terminology and general architecture for database systems was produced in 1971 by the DBTG (Data Base Task Group) appointed by the Conference on Data Systems and Languages (CODASYL, 1971). The DBTG recognized the need for a two level approach with a system view called the schema and user views called subschema. The American National Standards Institute (ANSI) Standards Planning and Requirements Committee (SPARC) produced a similar terminology mid architecture in 1975 (ANSI 1975). ANSI-SPARC recognized the need for a three level approach with a system catalog.



 
by Dinesh Thakur Category: DBMS & RDBMS

Normalization is the process of removing redundant data from your tables in order to improve storage efficiency, data integrity and scalability. This improvement is balanced against an increase in complexity and potential performance losses from the joining of the normalized tables at query-time. There are two goals of the normalization process: eliminating redundant data (for example, storing the same data in more than one table) and ensuring data dependencies make sense (only storing related data in a table). Both of these are worthy goals as they reduce the amount of space a database consumes and ensure that data is logically stored.



 
by Dinesh Thakur Category: DBMS & RDBMS

When a company asks you to make them a working, functional Database Management System (DBMS) which they can work with, there are certain steps to follow. Let us summarize them here:



 
by Dinesh Thakur Category: DBMS & RDBMS

DBMS stand for Database Management System, which consist n number of tables there is no relationship between another table. RDMBS stand for Relational Database Management System, which having the relationship with other tables. The Relationship between tables in DBMS is Physical and the relationship in RDBMS is Logical.



 
by Dinesh Thakur Category: Computer Terms

• Switched-Mode Power Supply (SMPS) is an electronic circuit which converts the power using switching devices that are turned on and off at high frequencies, and storage components such as indicators or capacitors to supply power when the switching device is in its non-conduction state. It can be abbreviated as SMPS.
• The switched-mode power supply is also called switch-mode power supply or switching-mode power supply. Its efficiency is high. That’s why we use it in the variety of electronic types of equipment which require a stable and efficient power supply.

 
by Dinesh Thakur Category: Computer Terms

An embedded system is a complex system also known as an integrated system; It has software embedded into hardware (also known as Firmware) to perform specific tasks or a single task. It typically contains one or more microprocessors for executing a set of programs defined at design time and stored in memory. Which makes a system dedicated to a specific function, within a more extensive system. It is a low-power Microcontroller/Microprocessor based computer system, which dedicated to providing specific functionality.



 
by Dinesh Thakur Category: Computer Terms

Moving from a hard drive to an SSD is a fairly straightforward procedure that you can perform in less than an hour. Here, we’ll cover the steps you’ll need to take in order to install an SSD in a desktop PC.

 
by Dinesh Thakur Category: Computer Terms

eSATA. The external SATA interface has been around longer than most of the ports we just described. Until USB 3.0 came along, this port was the fastest link to consumer storage peripherals such as external hard drives.

 
by Dinesh Thakur Category: Computer Terms

HDMI. The High-Definition Multimedia Interface has been around since the early 2000s, and was developed for consumer electronics devices such as Blu-ray Disc players and HDTVs. However, HDMI has also seen wide use in graphics cards and computer displays. Its connector’s wide rectangle with two beveled corners can be adapted to DVI.



 
by Dinesh Thakur Category: Computer Terms

Thunderbolt. The Thunderbolt standard (formerly called Light Peak) is aimed at being able to use a single interface for multiple device connections. Thunderbolt is a 10Gbps (1.25GBps) interface that combines PCI-E (Peripheral Component Interconnect Express) with DisplayPort in a single, thin cable. It can daisy-chain compatible devices, and it supports hubs, which lets you use a single cable connection to link your computer to a mouse, keyboard, monitor, and external storage drive. Even data from an external RAID (redundant array of independent drives) array of SSDs wouldn’t hit a bottleneck on its way to your computer, thanks to Thunderbolt.



 
by Dinesh Thakur Category: Computer Terms

DisplayPort is a super-fast, 21.6Gbps interface designed to carry video to computer monitors. With this much bandwidth on tap, it’s able to accommodate greater resolution, faster refresh rates, and more color depth than HDMI (High-Definition Multimedia Interface). Besides professional media content generation applications, DisplayPort (sometimes abbreviated DP) is ideal for multiple-monitor setups.



 
by Dinesh Thakur Category: Computer Terms

The video card, as its name indicates is the component the computer whose role is to transmit data on the screen in the control of a microprocessor dedicated and integrated into the card. It is this microprocessor that calculates the position of points on the screen and processes the texture of restitution algorithms for display complex images such as those generated by video games.



 
by Dinesh Thakur Category: Computer Terms

A Browser is a piece of software that everybody needs if they want to surf the Internet for useful or interesting websites. Web pages are designed to be read by Browsers and Browsers are designed to read web pages. Fortunately, acquiring a Browser is slightly easier than catching the common cold. They are everywhere. Most computers now come with one pre-installed. A great many CD-ROMs are now designed to be read like a website and so include a Browser which can be installed onto a computer's hard drive and ISPs give them away free to anyone who signs up for their service. There is nothing difficult about acquiring a Browser.



 
by Dinesh Thakur Category: Computer Terms

Essentially these are extra programs that can be installed and used as part of a Browser i.e. they plug into it. Typically these would provide extra facilities like the ability to handle sound files or advanced graphics. What this means in practice is that, should a web page incorporate sound as well as text, the relevant plug-in will be needed before it can be read by any Browser and the sound played through the computer's own speakers.



 
by Dinesh Thakur Category: Computer Terms

In American homes, or so the story goes, when visitors arrive they are given a cookie which in Britain would be a biscuit. This philosophy has now been extended to the Internet. Whenever a visitor, better known as a Browser, arrives at certain sites a cookie is sent down the line and saves itself to the local computer's hard disk.



 
by Dinesh Thakur Category: Computer Terms

As all search engines are different they all operate in slightly different ways. The good news is that the same search techniques can be applied to them all, but, as might be expected, each one is a variation around the same theme. To make it even worse not all search engines actually search the Internet, some are what is known as web directories. Then, just to confuse the picture even more some engines do keyword searches while others are concept based.

 
by Dinesh Thakur Category: Computer Terms

Of all these error codes by far the most common is 404 which is also one of the few that can be worked around - always assuming the website has not simply ceased to exist. Everything else can be fixed although it would help to explain the difference between web names as they appear in the press and as they appear in a Browser.

 
by Dinesh Thakur Category: Computer Terms

Derived from Users Network this is, again, totally separate from the WWW. Briefly, the Internet is also home to what are called news groups which are broadly divided into several categories and which cater for every topic imaginable.

 

Page 13 of 17



About Dinesh Thakur

Dinesh ThakurDinesh Thakur holds an B.SC (Computer Science), MCSE, MCDBA, CCNA, CCNP, A+, SCJP certifications. Dinesh authors the hugely popular blog. Where he writes how-to guides around Computer fundamental , computer software, Computer programming, and web apps. For any type of query or something that you think is missing, please feel free to Contact us.