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
What are the difference between information processing cycle and information cycle?
"Data processing is simply the conversion of raw data into meaningful information through a process."
& Data Processing Cycle is described by following image
Image source: jhigh.co.ukWhat are the benefits and limitations of the relational database model for business applications?
In theory, relational databases (RDBMS) probably have no "hard" limits. In practice, existing products tend not to perform very well at certain kinds of processing. RDBMS are optimized to perform many different kinds of queries on the same data fairly well. This keeps them flexible, able to handle unanticipated uses.
But some applications require very specific kinds of queries and need these specific queries to be as fast as possible (or at least have well-known response characteristics). Sometimes niche or custom databases perform sufficiently better than existing RDBMS that it warrants such solutions.
Some also suggest that RDBMS don't fit object-oriented applications very well. This is a contentious topic with no easy answer. RDBMS and object-centric designs tend to use conflicting philosophies such that mixing and coordinating them can be difficult and expensive. Some commercial products claim to bridge the gap.
What is difference between data integrity and data security?
Data integrity = making sure the data is correct and not corrupt
Data security = making sure only the people who should have access to the data are the only ones who can access the data. also, keeping straight who can read the data and who can write data.
What are the Disadvantages of digital data storage and transmission?
Digital technology refers to a process of storing, transmitting, and processing of information through the use of binary pulses.
As much as there are so many merits regarding digital technology, there are several setbacks to it.
Digital technology is expensive. Electronic transmissions from analogue to digital signals requires a large bandwidth and appropriate electronic signals. This infers a cost to users especially in third world countries where electricity costs a lot.
In addition to the above, digital technology uses a lot of power because it takes analogue signals and transmits them to digital binary codes using the Analogue-Digital Converter.
In case of storage medium crashes, digital technology can cause large amounts of data loss. This can be fatal to organisations and businesses.
Digital technology keeps evolving from year to year, thence it is difficult to customise to it. This leaves a lot to be desired for end users who have limited access to internet and the world wide web.
Using digital technology requires skills and knowledge to adequately deliver prompt services and products. These kind of skills are inadequate in the business world today which leaves a loophole int he digital world.
Digital technology also requires high bandwidth to transmit binary codes from one point to another. This is not provisional in third wolrd countries since dial-up modems are widely in use.
System errors easily affect digitization which makes it fragile to attacks and intrusion. This also leaves a gap in the security factor of the digital technology.
What are the advantages of system?
The advantage of system software is it is made for the os. so it will run smother than some others.
A DBA is a Database Administrator. It is the person who looks after the Database Management System. They may be part of the design team. They can look after who has access to the system and what levels of privilege. They will help people with any problems they are having. They may get the database to do more things and redesign it. They will maintain the database to make sure it works efficiently and it does not crash and no data is lost.
What are the capabilities of SQL?
Data Definition Facilities - CREATE and DROP. Data Manipulation Facilities - SELECT, INSERT, UPDATE and DELETE. Help Facilities - MS Access provides helpful wizards to allow 'novice' users to do a task or even 'expert' users to do it easier. Reporting Facilities - Creating professional looking reports from SELECT statements, another good example of this is MS Access. Data Control Facilities - Permissions, GRANT. Views, CREATE VIEW, etc. Multi-user Functionality - Allowing more than one user to access the database simultaneously. Including concurrency controls such as locking part of the database that is being updated. Distributed Databases - Distribute the database over several sites. CASE Tools - Computer-aided Software Engineering is the automation of the development of software systems. An example of this are the easy tools provided in MS Access and Oracle to create forms for a database. I'm sure people can add more, but these are what I see as the main functions.
Advantages of sybase database?
1.support recover and backup procedures
2.support account setup and high security
What are the advantages that databases have over spreadsheets?
A spreadsheet is just one document file which can store information. A database consists of many other files which can be used in collaboration. It becomes easier to get more information regarding one business from different files within a database. A good example of such database information is the financial position of a business.
How do you remove Trojan win32 system crash?
Click start>click run type in msconfig and then press enter. Goto the start up tab and uncheck everything except your anti virus.click ok and reboot. When you come back to the desktop check the box 'do not show this message again" and click ok .
You need to run these 5 essential steps to remove all the spyware on your computer.
1. Run Deckard's System Scanner (DSS)
2. Run Malwarebytes Anti-Malware
3. Run the anti spyware removal programs spybot
4 Run Superantispyware
5. Run a complete scan with free curing utility Dr.Web CureIt!
Install ThreatFire
ThreatFire, features innovative real-time behavioral protection technology that provides powerful standalone protection or the perfect complement to traditional signature-based antivirus programs offers unsurpassed protection against both known and unknown zero-day viruses, worms, trojans, rootkits, buffer overflows, spyware, adware and other malware.
Install a good antivirus in your computer.
Keep your antivirus updated. If automatic updates are available, configure your antivirus to use them.
Keep your permanent antivirus protection enabled at all times.
A node (knot) is a point along a standing wave where the wave has minimal amplitude. The opposite of a node is an antinode, a point where the amplitude of the standing wave is a maximum. These occur midway between the nodes
What type information system would be recognized by digital system?
A digital system can recognize digital data i.e. data only in form of 0 & 1, if data is not in digital form we have to convert it using analog to digital converters.
What are the advantages of computer processing over manual processing?
Well, the main advantage is that computers are very good at doing boring, repetitive calculations very quickly. Modern computers can perform trillions of calculations per second. A normal human is lucky if they can average one calculation per second manually. they are accurate ,
What is utility in a computer?
There are two besic utilities of an computer.
1>assist the human brain.
2>any types of data or information related jobs done easily,quickly,properly here.
What are the diffeneces between a files processing system and a Data base management system?
- A database coordinates the physical and logical access to the data; a file-processing system only coordinates physical access to the data
- A DBMS reduces the amount of data duplication
- A DBMS is designed to allow flexibility in what queries give access to the data, where a file-processing system only allows pre-determined access to data (by specific compiled programs)
- A DBMS is designed to coordinate and permit multiple users to access data at the same time. A file processing system is much more restrictive in simultaneous data access
What are the different relationships in Access table?
One-to-many Relationship
This kind of relationship allows one field to be related to many separate fields. For instance, one customer in a database may have multiple orders. Therefore, one field, the customer, will be related to multiple fields, the orders.
Many-to-many Relationship
This kind of relationships allows many fields to be related to many other fields. For instance, an order can contain many products. Also, a single product may be on multiple different orders. In this case, you would have to use a many-to-many relationship.
One-to-one Relationship
In this relationship, one entry in a given field is can only have one related entry in the second field. This can be used for matching customers to other information about that customer, such as phone numbers and mailing information.
What is the purpose of a table in a database?
to hold information of different domain. without it, all data would have been scattered around every fields. it would have been a choase
istiak
www.databizsoftware.com
A repository is a collection of all data definition, data relationships and report formats, i,e; meta data of a database.
What is the Difference between a database and a database server?
A database is a file. A database server is a computer that shares that file over a network.
Is there a database program similar to Microsoft Access for Linux?
They also have a developer version that you can create databases to give to anyone that will work without them having to purchase the full version. The version it creates to give away has some limitations, but it works great.
I use it for some pretty sophisticated stuff.
What is database server and how they works?
A database is a collection of tables in which large quantities of data (information) can be stored. The question and answer you are looking at right now are both stored in a database, for example.
Databases are used by applications (like websites) to store and retrieve data.
1.
Example usages: "MPEG encoder", "NTSC encoder", "RealAudio encoder".
2.
An encoder is a device used to change a signal (such as a bitstream) or data into a code. The code may serve any of a number of purposes such as compressing information for transmission or storage, encrypting or adding redundancies to the input code, or translating from one code to another. This is usually done by means of a programmed algorithm, especially if any part is digital, while most analog encoding is done with analog circuitry.
* A compressor is used to encode data into a smaller form.
* A multiplexer combines multiple inputs into one output.
* A rotary encoder is a sensor, transducer for converting rotary motion or position to a code of electronic pulses.
* A linear encoder is a sensor, transducer or readhead paired with a scale that encodes position. The sensor reads the scale in order to convert the encoded position into an analog or digital signal, which can then be decoded into position by a digital readout (DRO). Motion can be determined by change in position over time. Linear encoder technologies include capacitive, inductive, eddy current, magnetic, and optical. Optical technologies include shadow, self imaging and interferometric. Linear encoders are used in metrology instruments and high precision machining tools ranging from digital calipers to coordinate measuring machines.
In digital audio technology, an encoder is a program that converts an audio WAV file into an MP3 file, a highly-compressed sound file that preserves the quality of a CD recording. (The program that gets the sound selection from a CD and stores it as a WAV file on a hard drive is called a ripper.) An MP3 encoder compresses the WAV file so that it is about one-twelfth the size of the original digital sound file. The quality is maintained by an algorithm that optimizes for audio perception, losing data that will not contribute to perception. The program that plays the MP3 file is called a player. Some audio products provide all three programs together as a package.
In computer technology, encoding is the process of putting a sequence of characters into a special format for transmission or storage purposes.
