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
ER Diagram for a railway management system?
there are three entities involved station railway and passengers railway has station nd attributes of railway are railway no. railway name railway type and railway seats and station attributes are waiting room,office,canteen,station id
Access is what kind of database?
Microsoft Access is a relational database that can run from it's own internal table structure, or link to a variety of external data sources
What is the difference between database and table?
A table is an object inside a database. A database has tables of data, views, indexes and programs. A database can have 10 or thousands of tables.
More specifically, a table is a collection (rows) of data on a single related topic. For example, the Employees table would have employee data, each row being a different employee, but it would not have Inventory data. That would be in the Inventory table.
A database is a collection of objects, primarily tables, but also indexes to help search the tables, views that filter, select and combine the data in the tables, and stored procedures (pre-defined programs that perform specific actions on the database).
What are the functions of a primary key?
It is a contraint(checks) provided by DBMS. if we want to make a coumn unique and not null then the column is defined as primary key. it is used to create relations among the tables.
For any further detail, please visit the following links:http://www.iyogibusiness.com
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.
