Unanswered | Answered

Database Programming

Parent Category: Computer 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.

Subcategories

The data type for 0.38 is double.
 Chapter 3 : Entity - Relationship Modelling   The aims of this chapter are:   To explain the need for entity-relationship modelling  To explain the terms entity-relationship model,  entity-relationship diagram  To define the terms entity type, entity, attribute, attribute  value,...
Layer 6 - Presentation Layer
A structured  complex object database differs from an unstructured complex object  database in that the object's structure is defined by repeated  application of the type constructors provided by the OODBMS. Hence,  the object structure is defined and known to the OODBMS. 
Important ways to access relational database:   1. Accessing the relational database using JDBC with Spring.   2. LIBNAME Statement for relational database.   3. Using HBase
Data is stored as objects and can be interpreted only using the  methods specified by its class.
A common field is a field of data that is shared among all forms in  a database. Without them, it would be difficult and/or  time-consuming to create other forms.
Since the conceptual design sets the direction for the management  information system (MIS). It is vital that managers participate  seriously and heavily at this stage. Conceptual design is sometimes  called feasibility design, gross design or high level design.     The conceptual design...
Maybe mean the data can change?
 Database is a collection of facts, figures and statistics related  to an object. Data can be processed to create useful  information.   A knowledge base is a special kind of database for knowledge  management. It provides the means for the computerized collection,  organization, and...
IN COMPUTER SCIENCE, A SPACE-TIME OR TIME-MEMORY TRADEOFF IS A SITUATION WHERE THE MEMORY USE CAN BE REDUCED AT THE COST OF SLOWER PROGRAM EXECUTION (OR, VICE VERSA, THE COMPUTATION TIME CAN BE REDUCED AT THE COST OF INCREASED MEMORY USE). AS THE RELATIVE COSTS OF CPU CYCLES, RAM SPACE, AND HARD...
Oracle sells many functional modules which use the Oracle RDBMS as  a back-end, notably Oracle Financials, Oracle HRMS, Oracle SCM,  Oracle Projects, Oracle CRM, Oracle Procurement.
Yes, You can show the railway reservation mini project using the  oracle and vb 6.0.
Microsoft Access is designed to scale to support more data andusers by linking to multiple Access databases or using a back-enddatabase like Microsoft SQL Server. With the latter design, theamount of data and users can scale to enterprise-level solutionsfor people.
  A university has a large number of courses in catalog.Attributes of COURSE include Course_Number(identifier),Course_Name and Units.Each course may have one or more course as prerequisties or may have no prerequisties.Similarly,a particular course may be a prerequisties for any number of...
PHP Vs. ASP.NET- What Serves Website Application Development  Better?
 1. Relational algebra operations  manipulate some relations and provide some expression in the form  of queries where as relational calculus are formed queries on the  basis of pairs of expressions.  2. RA have operator like join,  union, intersection, division, difference, projection,...
  Answer   You batch your jobs in order of shipping dates to eliminate back logs of work not done. Work that is done is put in another place to await shipping. The old batch system worked very well when there was a steady flow of work not caught up in bottle necks where everything stopped...
The necessity of having information systems varies depending on thesector a system covers, but systems generally support operationsand decisions made within organizations as well as helping withdata storage and facilitating management. Information systems areused by a variety of organizations in...
A relation may be in 2NF if   1. it is in 1NF &   2. Every non prime attribute functional dependent on primary  attribute
You have to shut down for inventory and count everything.
waiting time =turn around time-burst time
A const data type is one which cannot be changed once initialized. A volatile data type is one which should never have its value locally cached. Note: Neither of them is data-type, they are modifiers.
according to definitions on secdatabase.com, here is difference: Form S-8 is the Registration Statement under the Securities Exchange Act of 1933. It is used by a publically traded company to register securities that will be offered to its employees via benefit or incentive plans. Form 8-K ...
Transaction processing systems date through the early 1970`s
Imports system.data  Imports system.data.oledb  Module Module1  Sub Main()  Dim con As New OleDbconnection  Dim cmd As New OleDbcommand  Dim dr As OleDbDataReader  con = New OleDbConnection("provider=microsoft.jet.oledb.4;data source=D:/student")  con.Open()  Console.WriteLine("connection...
A lot of companies in world that use transaction processing system  like Emvantage payments private limited, CCAvenue, PayPal, Atom ,  Citrus, Ebs, transecute and many more.
For a medical shop, The patient is directly connected with the shop  as well as a doctor. So make three entities: Patient, doctor and  shop. They have their own properties.
There are a variety of types of databases. These include online  databases, graph databases, public domain databases, and time  series databases.
Engineer requirements should be higher, on the  application of large databases to achieve proficiency or  proficiency level, so the relatively low level of development  engineers database, the cost is lower. Data architects, general  business needs one or two. Of employment database development ...
The method of logarithms was first publicly propounded in 1614, in a book entitled Mirifici Logarithmorum Canonis Descriptio, by John Napier, Baron of Merchiston, in Scotland (Joost Bürgi independently discovered logarithms; however, he did not publish his discovery until four years after Napier.)...
Some of the operations performed in DDL in sql are creation of table,alteration of table,truncate a table, drop a table
  what is mean by oracle?   == ==
Open the drawer containing the folder. Place the paper in the appropriate folder and then close the draw.
  SQl Server is a server based database. Access is used as local database.Access is used for small desktop size databases used by less then 5 users at the same time. It has a front end gui system to design applications quickly. SQL Server is a more robust system and is able to handle large...
Linear Queue C Program using structure    #include<stdio.h>   #include<conio.h>   #include<stdlib.h>   #define MAX 50   typedef enum{true,false} bool;   typedef struct{   int front,rear;   int elements[MAX];   }queue;   bool isfull(queue *);  ...
The round robin scheduling algorithm works by placing all processes  in a circular queue and allotting each process a single time slice  until all processes are completed. If process A required 2 time  slices, process B required 1 time slice, and process C required 3  time slices the queue would...
MyISAM is the default table engine in the MySQL database.
  dbms- database management systems............   it is a collection of interrelated data and the set of programs to access those datas.......   it is used to meet the disadvantages of the file systems.......   there are many disadvantages of filesystems.......   lik,, data...
It is used as the unique identifier for each record and is used to sort the data
The different types of relationships in a database are; one-to-many relationships, many-to-many relationships, one-to-one relationships. One to one is the most commonly used, a row in table A can have a lot of matching rows in table B but table B can only have one matching row in table A. Many to...
COBOL stands for CO mmon B usiness- O riented L anguage. Originally specified in 1959, COBOL is one of the earliest computer programming languages. The first compilers for COBOL were implemented in 1960. On December 6 and 7, 1960 COBOL ran on both an RCA and a Univac computer in the first example...
Naïve (or Parametric) end-users are the largest section of end-user population , they Use previously implemented and tested programs (called "canned transactions") to access/update the database . Stand-alone end-users Mostly maintain personal databases using ready-to-use packaged applications.
A hospital management system is an information system that manages  the aspects of a hospital. This may include the administrative,  financial, and medical processing.
database management is the organized data , today typically in digital form......
According to wikipedia: "sagan has been defined as a unit of measurement equal to at least four billion, since the smallest number that may be described as billions and billions must be two billion plus two billion". According to google calculator: "four billion bytes = 3.7252903 gigabytes".So sagan...
* DSS is the system for helping managers, administrators, high authority to take decision in any business organization. * KLS is a part of DSS (There are two parts of DSS as- Knowledge Lean System & Angie system)
Database security refers to the collective measures used to  protect and secure a database or database management software from  illegitimate use and malicious threats and attacks.  It is a broad term that includes a multitude of processes, tools  and methodologies that ensure security within a...
Payment gateways are used for transaction processing system.  Examples are PayU, Emvantage, CCAvenue, PayPal, Ebs etc.
I shall give you a solution to what i think it is, if i am wrong, post back with further queries.First of all what tables you need depend entirley on what information your company is interested in retaining. I will assume all and you can delete as nesseccaryFirst of all there should be a person and...
elementry data organisation is a way to put the position of special element
A junction table is added between the two tables involved in the relationship. The primary key from each table is added to the junction table and they are made a joint primary key in that table. Then two one-to-many relationships are set up between the junction table and each of the two other tables...
In order to access a base class member the base class member must be declared protected or public. Private data is only accessible to members of the same class and to friends of the class. I'm not entirely sure what you mean by accessing from a database. A derived class does not require a database...
To copy a structure you simply allocate the amount of memory  required to store the structure. For simple data structures like  arrays that's all you need to do (leaving the memory uninitialised  or set to some default value such as zero). But for complex  structures like lists, trees and graphs...
Data Warehouse delivery processIT strategyEducationTechnical blue printBuilding the visionHistory LoadAd-hoc queryAutomationBusiness case analysisBusiness requirementsR EQ EI vR lE uM tE i N oT nExtending scope Delivery Process The process that delivers a data warehouse has to be fundamentally...
some of database query languages are:-CQL(contextual query language),SQL,DMX,Datalogue etc.
A cluster is the smallest unit of space used to store a file.
a data mart typically focuses on a single subject area or line of business
  i don't know answer of this ques. properly
The size of a storage device can be measured using megabytes or  gigabytes. 1 gigabyte is approximately equal to 1024 megabytes.
    Cursors are database objects used to traverse the results of an SQL query. They point to a certain location within a recordset and allow the operator to move forward (and sometimes backward, depending upon the cursor type) through the results one record at a time. Cursors are often...
  init.ora and SPfile both contain information about DB parameters.   The database cannot start without an INIT.ORA but can start without an SPfile.   An SPfile cannot be edited directly , but one can be configured via the pfile (init.ora)   Init.ora is saved in ascii text format...
Data Glove is a device to interact with animated artificial objects. Consider a glove fitted with sensors and electrical wires hooked to a glove compatible computer. Here, we can see our hand inside the glove in the display monitor of the computer. As we rotate or move our hand and manipulate our...
The difference between distributed system and multiprocessor system is whether the processing units in the system share the main memory. If yes, then the system is multiprocessor system; otherwise, it's a distributed system.
it describes the instance of one entity is associated with each instances of an entitydepending upon the range of cardinality constraints are two typesthey areminimum cardinalitymaximum cardinality
All MySQL user accounts can be made by querying "CREATE '[username]' @ '[server]' IDENTIFIED BY '[password]'", where [username], [server], and [password] should be filled in with appropriate data. The two exceptions to this are usernames "admin" and "dummy" which have no passwords.
The question is not clear, but if you mean, "what is the advantage of a picture, versus a bunch of words," then I refer you to the age-old axiuim: A picture is worth a thousand words. Frequently, people can see trends and other information quickly by looking at a properly-formed chart, instead of...
Yes, but you must follow specific procedures when opening the database you want to protect. See related links for screen shots and details about how to protect an Access 2007 database. Of course, you always could use one of dozens of commercial applications to encrypt and password protect any file...
Other words for package are:parcelpacketbundle
There is a pretty solid tutorial herehttp://www.mysqltutorial.org/php-mysql-blob/ if you areusing PDO. Without seeing your database table structure, it is hardto know what the propoer approach would be for your situation
The queue is a linear data structure where operations of insertion and deletion are performed at separate ends also known as front and rear. Queue is a FIFO structure that is first in first out. A circular queue is similar to the normal queue with the difference that queue is circular queue ; that...