by Dinesh Thakur Category: DBMS & RDBMS

In Entity-Relationship model a database is modeled as a collection of entities and relationship among entities. The ER model views the real world as a construct of entities and association between entities.



 
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

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

What is a Database View, A view can join information from several tables together, or we can say that Views are useful for Hiding unwanted information for example adding the ename field to the Order information. Database View is a subset of the database sorted and displayed in a particular way. A database view displays one or more database records on the same page. A view can display some or all of the database fields.



 
by Dinesh Thakur Category: DBMS & RDBMS

Any access to the stored data is done by the data manager. A user's request for data is-received by the data manager, which detern1ines the physical record required. The decision as 10 which physical record is needed may require some preliminary consultation of the database and/or the data dictionary prior to the access of the actual data itself.



 
by Dinesh Thakur Category: DBMS & RDBMS

Attributes means characteristics. For instance, in a database or a spreadsheet you can apply attributes to each field or cell to customize your document. As a general attribute, you can choose whether it is to be a text field or a numeric field or perhaps a computed field, whose value the application calculates for you.



 
by Dinesh Thakur Category: DBMS & RDBMS

A database object in a relational database is a data structure used to either store or reference data. The most common object that most people interact with is the table. Other objects are indexes, stored procedures, sequences, views and many more.



 
by Dinesh Thakur Category: DBMS & RDBMS

A database document is just a collection of information stored in computerized form. The simplest way to understand a database is to think of it like a set of 3 x 5 cards. Since the information is on your computer, though, a dick of the mouse or the stroke of a key can alphabetize those "cards," or find just the names of the people on the cards who live in a certain town, or tell you who owes how much money, and so on.



 
by Dinesh Thakur Category: DBMS & RDBMS

Data recovery is the art of restoring lost or damaged files. This damage can occur when your computer crashes, a virus infects, you accidentally reformat a disk that contains precious data, or you experience some other catastrophe of considerable dimension. And, at some point in your life, you're going to delete a file you really didn't mean to (believe me). The next time tragedy strikes, try running one of the many data recovery applications (powerful software written specifically for data recovery purposes) to see if it can correct the situation. Often these little jewels work magic and save your day-and your files.



 
by Dinesh Thakur Category: DBMS & RDBMS

dBase is a specific software product used for creating and manipulating relational databases. The term can also refer to the dBase database programming language that first appeared in the dBase product, but which is now available in many other database forms.



 
by Dinesh Thakur Category: DBMS & RDBMS

In a computer database, the database engine is the software that does the real work of sorting the information, finding specific data that you request, and so on. The term used to refer to a separate piece of software that ran on a central computer (in this case, it is more or less synonymous with the term "back-end"). Widely used database engines include Oracle, DB2, and Sybase. Separate front-end software running on your own computer lets you tell the database engine what to do (how to sort the data, what data to find), and displays the results of your commands.



 
by Dinesh Thakur Category: DBMS & RDBMS

Relation Algebra is a procedural query language for RDBMS (Relational Database Management System). An Algebra based on the set of operators (like Arithmetic operator, union, intersection relational operator, etc.) and operand. Edgar F. Codd created it for a relational database. Relational Algebra provides a fundamental query for retrieving data from databases. The retrieved result from algebra expression is a relation which formed from one or more relations. Relational Algebra specifies many operations to manipulate relations.



 
by Dinesh Thakur Category: DBMS & RDBMS

The database is the location to store the data. Firstly we used excel sheet to store the data. However, it has some problem with data integrity and redundancy problem. This problem solved by E.F. Codd proposed a model in 1970. This model was straightforward. It used the concept of mathematical relation which looks like a table.



 
by Dinesh Thakur Category: DBMS & RDBMS

The database is a repository of all types of data. After storing it, there should be a mechanism to access, manipulate and update it. For this, we have a tool in the form of a query to perform all these operations. There are many query language like SQL, Search Engine Query Language (Google, Bing), DMX (Data Mining Language), etc. All these languages have different function and their function structure used for the different data model.



 
by Dinesh Thakur Category: DBMS & RDBMS

The database schema is a structure or architecture to store data in the database. It creates abstraction(hide the lowest level the detail from the user) between application and physical database. A user creates a relationship with the help of Database Management System.But a user can’t see which type of data structure is used by the system to store the data in it.This data structure may be linear and may be non-linear, we don’t know. This is known as Abstraction. The database divided into three-level architecture is also known as three; schema architecture.



 
by Dinesh Thakur Category: DBMS & RDBMS

Data base management system (DBMS) represent the management of data which includes various processes like collection of related data , storing and retrieving them, using set of programs for easy and effective manner.   While it may sound quit simple and easy but in reality it is not. As the bulk of data increases with the complexity of systems and multiple process running head to head it leads to most feared complication called Deadlock. It is nightmare for the developers and programmers. We will be discussing in detail everything about this evil Deadlock in our following article below. Starting with the definition first.



 
by Dinesh Thakur Category: Computer Terms

Processor decides the speed of the computer that it will execute the instruction fast or it will process slow. When a user thinks about to purchase a system the first question is in mind is processor. The first commercial microprocessor was the Intel 4004 launched in 1971, which was designed to be used in a Japanese desk calculator.



 
by Dinesh Thakur Category: Computer Terms

A scanner is a device that takes a picture of an image that exists outside the computer, such as a photograph or a drawing on paper. As the scanner takes the picture, it digitizes the image (breaks it up into dots that can be recreated on the computer screen with electronic signals), and send this digital information to the computer as a file. Then you can take this file of the scanned image and use it in your work.



 
by Dinesh Thakur Category: Computer Terms

Bootstrap: To start a computer by loading its OPERATING SYSTEM from disk storage into memory. The name alludes to the seeming absurdity of trying to lift oneself off the floor by pulling on one's own bootstraps - since it is the operating system that enables a computer to read disks, then loading itself from disk would seem to be a similar impossibility. This paradox is resolved by the presence of a small program called the BOOTSTRAP LOADER, which resides permanently in the computer (stored in a ROM chip) and contains just sufficient code to read the rest of the operating system from disk. This process is informally called 'booting' or 'booting up' the computer.



 
by Dinesh Thakur Category: Computer Terms

Seek Time refers to how long it takes the read/ write head on a hard disk to move from one track to another. Technically, seek time is only one factor affecting "average" access time, and is not the same as access time. Because it sounds faster, certain disk vendors may try to woo you by quoting seek time specifications for their disks, but you should really base your comparisons on average access time.

 

Page 12 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.