0
Database Programming
Databases are collections of tables that maintain and display information, often collaboratively; this information can be used for interaction with an application or gaining general knowledge. Questions about database engines and modifying or using them belong in this category.
8,803 Questions
sql allow their implementation using various sql commands
What are the computer measurements for bits bytes etc.?
Bit= a single 0 or 1,
Byte= 8 bits (any combination of 8 0's or 1's)
Kilobyte (KB)= 1024 bytes
Megabytes (MB)= 1024 KB
Gigabyte (GB)= 1024 MB
Terabyte (TB)= 1024 GB
Petabyte (PB)= 1024 TB
Exabyte (EB)= 1024 PB For a detailed answer cut and paste the following URL in your browser : http://www.smartftp.com/support/kb/bits-bytes-mega-giga-tera-f53.html
Wide area network (WAN) that is usually a larger network that covers a large geographic area.
What is the difference between data and information in DBMS?
Data is raw, unprocessed information. In and of itself it may not mean much.
Information, on the other hand, is processed data that has meaning.
Examples:
Data: A person's age, a person's gender, or the color of a car. Individually, it means not much.
Information: If a program takes the above data and processes it, now the results take meaning. Example: A 25 year old man likes to drive a red car.
Contrast of database and database system?
A database is simply a collection of pieces of information (data). A text file storing names and phone numbers is a database. A database management system (DBMS) is some software that manages the data within the database such as MySQL. Both the software and the database are considered together when thinking of a DBMS.
What is total participation in database management?
Participation (or optionality) concerns the involvement of entities i a relationship. Participation is about exceptions to the rule. An entity's participation is optional if there is a least one instance of an entity which does not participate in the relationship. An entity participation is mandatory if all instances of an entity must participate in the relationship.
What is the purpose of cascade update related fields according ms access?
Just like Cascade Update Related Fields updates any record you change to the other table you have made a relationship with, Delete does the same thing! Delete one record and the other table which you have also made a relationship with will be deleted aswell.
How do you get into your computer if you forgot pass and hint?
If I will forget my password then
1. I will go on loggin screen and prees ctrl + alt +del and open a screen .
2. Then login name is administrator and prees ENTER if the had not give any password of admin.
3. Then admin login and we can change the password of computer user.
In VHDL, entity is the keyword for defining a new object. In SGML and its derived markup languages HTML and XML, an entity is a named body of data associated with a document. Once defined, an entity can be referenced any number of times within the document, via entity references. An entity typically consists of a sequence of one or more characters, either encapsulated within a declaration of the entity's existence, or encoded and stored externally in a text file. Such entities and their references are comparable to macros and include files in programming languages. However, entities don't necessarily have to contain parseable text; they may also be binary files that are included in a document only by reference, with the entity name as the value of an ENTITY-type attribute.
Answer:
An entity is something that has a distinct, separate existence, though it need not be a material existence. In particular, abstractions and legal fictions are usually regarded as entities. In general, there is also no presumption that an entity is animate. Entities are used in system developmental models that display communications and internal processing of, say, documents compared to order processing.
An entity could be viewed as a set containing subsets. In philosophy, such sets are said to be abstract objects.
Sometimes, the word entity is used in a general sense of a being, whether or not the referent has material existence; e.g., is often referred to as an entity with no corporeal form, such as a language. It is also often used to refer to ghosts and other spirits. Taken further, entity sometimes refers to existence or being itself. For example, the former U.S. diplomat George F. Kennan once said that "the policy of the government of the United States is to seek . . . to preserve Chinese territorial and administrative entity.
Answer:
An entity is a legally recognized and formally structured grouping of people focused on some common cause or objective.
Examples
Here are some examples of entities:
SIL
an SIL branch
UNESCO
*Altibase
*Oracle
* SQL server
* Fox Pro
* MS-Access
* Sequel-Pro(mac)
Why YOU choose database system instead of simply storing data in OS?
Operating System (OS) files do NOT hold data for your personal use. Any data in an OS file is used STRICTLY by the OS.
A database system is used for storing data of any kind. A text file is not stored data, so you wouldn't use a database for THAT. But a dictionary of words used in the text file, along with their definitions, could use a database.
Even pics can be stored in a database, and even a list of other files can be stored in a database.
by:Mohammed Abu Lamdy
In what is a table represented as a collection of rows and columns?
It can be a table, or it could be a spreadsheet.
Which default Database roles are created when you create a Database?
To create a database you need to name a file and add that to Microsoft excel :) hope that helps :)
This is the place where all the static information are stored. The data store provides a repository of persistent information about the farm (Farm configuration information, Published Application configurations, Server configurations, Static policy configuration, XenApp administrator accounts, and Printer configurations) that all servers can refer.
Advantages of waterfall model in detail?
The waterfall model is the oldest and most widely used model in the field of software development. There are certain advantages of the waterfall model, which causes it to be the most widely used model as yet. Some of them can be listed as under.
- Needless to mention, it is a linear model and of course, linear models are the most simple to be implemented.
- The amount of resources required to implement this model is minimal.
- One great advantage of the waterfall model is that documentation is produced at every stage of the waterfall model development. This makes the understanding of the product designing procedure simpler.
- After every major stage of software coding, testing is done to check the correct running of the code.
What is the system board of the computer?
System Board is also called the Motherboard; A motherboard is the centra printed circuit board (PCB) in many modern computers and holds many of the crucial components of the system, while providing connectors for other peripherals. The motherboard is sometimes alternatively known as the main board, system board, or, on Apple computers, the logic board. It is also sometimes casually shortened to mobo.
Main circuit board into which components are attached?
The main circuit board into which components are attached to in a computer is known as the motherboard or main board. This is what will hold all the essential parts in a computer.
How can you type a smiley face on word?
First you hold down the shift button. Then you keep holding it down and press the the button to the right of the L it should look like this:. Then press 0 or 9. If you press 0 you will get a smiley. If you press 9 you will get a frowny.
What four functions must exist in an information processing cycle and what happens in each?
The four computer functions are:
- data input
-data processing
-data storage and
-data output
The relationship between these and processing is that when data is entered into a computer,that is input, then the computer fetches it,decodes it executes it and results are stored in the CPU registers or even the user can choose to store to any other storage media.Therefore,the four functions of a computer are stages of information processing.
What is an example of how a database can be queried?
In an inventory database, for example, a purchasing query could be done for all merchandise at or near the inventory minimum of the particular item.
The primary key of a table uniquely identifies each row in the table. It may also serve as a foreign key to other related tables. For example, a Customer table would use a CustomerID field (typically an autogenerated sequential integer) to uniquely identify each row in the table. This value would also appear in an Orders table as a foreign key to associate that customer with an order. Although unique individual values are best for primary keys, they may also be "compound" keys, that is, made up of two or more values in each row. For example, a table containing airline flight data might use a compound key of the flight number and the destination to uniquely identify the row.
What is the fullform of oracle?
Oak Ridge Automatic Computer and Logical Engine
Regards,
Manikandan Selvarajan
dB Professionals India Pvt Ltd,
Chennai-40,
India.
Error 1068 the dependency service or group failed to start sql server?
This error is caused by one or more Windows services being disabled. To fix it, you will need to go to Start > Run, and enter "services.msc" (without quotes). Here, you will see a list of services, their description, and whether or not they are running. The most common services that give people this error message are the "Help and Support Service" (for launching Help), Windows Image Acquisition Service (for cameras and scanners), and the Print Spooler service (for printers). Some programs and drivers, such as for Lexmark printers, may also have services that need turned on. Right-click the service you need, select "Properties", and use the drop box to change its starup type from "Disabled" to "Automatic." You can also start the service here, or you can reboot your computer.
What are the advantages and disadvantages of billing system?
Computerized billing systems:
Advantages:
Generates the claim
Records all charges & payments in the system
Automatically posts to patients accounts
Reduces paperwork
Minimized errors
Disadvantages:
High Initial Cost
Special Trainings for Personnel
Viruses
Losing data from power failure
Hackers
Computer fraud
