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
Which are the characteristics of data mart?
A data mart is a data repository that gathers data and similar items from certain users or workers. Its characteristics include being focused on one subject like finances or sales, only gathering data from a couple sources like the external data or central data warehouse, and being controlled by only one source.
What is multikey file organization?
to have a data file with multiple access path is known as multi key file organization
Assuming you're meaning to check if the program works - run it with some test data that you know what the solution should be be if the program works correctly. If you get the expected result, the program is fine - if not - it needs de-bugging.
What are the three general methods in implementing a programming language?
1- Compilation
2- Pure Interpretation
3- Hybrid Implementation System
Advantage of ms access to other database?
It is easy to use, and already comes installed on many machines.
However, it isn't a particularly powerful database. It might be used as a prototype, or for some small systems, but for professional development, it isn't the best option.
It is easy to use, and already comes installed on many machines.
However, it isn't a particularly powerful database. It might be used as a prototype, or for some small systems, but for professional development, it isn't the best option.
It is easy to use, and already comes installed on many machines.
However, it isn't a particularly powerful database. It might be used as a prototype, or for some small systems, but for professional development, it isn't the best option.
It is easy to use, and already comes installed on many machines.
However, it isn't a particularly powerful database. It might be used as a prototype, or for some small systems, but for professional development, it isn't the best option.
How is er diagram for email management system draw?
For email management system ER diagrams, Entities can be split like Important mails, FYI emails and client emails. A diagram can be drawn connecting these entities.
What are the early development in electronic data processing?
Electronic Data Processing (EDP) can refer to the use of automated methods to process commercial data. Typically, this uses relatively simple, repetitive activities to process large volumes of similar information. For example: stock updates applied to an inventory, banking transactions applied to account and customer master files, booking and ticketing transactions to an airline's reservation system, billing for utility services. Electronic data processing in the Volkswagen factory Wolfsburg, 1973 The first commercial business computer was developed in the United Kingdom in 1951, by the Joe Lyons catering organization. This was known as the 'Lyons Electronic Office' - or LEO for short. It was developed further and used widely during the 1960s and early 1970s. (Joe Lyons formed a separate company to develop the LEO computers and this subsequently merged to form English Electric Leo Marconi and then International Computers Ltd.)
Early commercial systems were installed exclusively by large organizations. These could afford to invest the time and capital necessary to purchase hardware, hire specialist staff to develop bespoke software and work through the consequent (and often unexpected) organizational and cultural changes. At first, individual organizations developed their own software, including data management utilities, themselves. Different products might also have 'one-off' bespoke software. This fragmented approach led to duplicated effort and the production of management information needed manual effort. High hardware costs and relatively slow processing speeds forced developers to use resources 'efficiently'. Data storage formats were heavily compacted, for example. A common example is the removal of the century from dates, which eventually lead to the 'millennium bug'. Data input required intermediate processing via punched paper tape or card and separate input to a repetitive, labor intensive task, removed from user control and error-prone. Invalid or incorrect data needed correction and resubmission with consequences for data and account reconciliation. Data storage was strictly serial on paper tape, and then later to magnetic tape: the use of data storage within readily accessible memory was not cost-effective. As with other industrial processes commercial IT has moved in all respects from a bespoke, craft-based industry where the product was tailored to fit the customer; to multi-use components taken off the shelf to find the best-fit in any situation. Mass-production has greatly reduced costs and IT is available to the smallest company. LEO was hardware tailored for a single client. Today, Intel Pentium and compatible chips are standard and become parts of other components which are combined as needed. One individual change of note was the freeing of computers and removable storage from protected, air-filtered environments. Microsoft and IBM at various times have been influential enough to impose order on IT and the resultant standardizations allowed specialist software to flourish. Software is available off the shelf: apart from Microsoft products such as Office, or Lotus, there are also specialist packages for payroll and personnel management, account maintenance and customer management, to name a few. These are highly specialized and intricate components of larger environments, but they rely upon common conventions and interfaces. Data storage has also standardized. Relational databases are developed by different suppliers to common formats and conventions. Common file formats can be shared by large main-frames and desk-top personal computers, allowing online, real time input and validation. In parallel, software development has fragmented. There are still specialist technicians, but these increasingly use standardized methodologies where outcomes are predictable and accessible. At the other end of the scale, any office manager can dabble in spreadsheets or databases and obtain acceptable results (but there are risks).
What is traditional file processing environment?
discuss abt traditional fie processing system? discuss abt traditional fie processing system? discuss abt traditional fie processing system? discuss abt traditional fie processing system?
Traditional approach, Current practice approach, reaction approach, cafeteria approach, human service approach
That's what you call 1:n relation. An example is the 'father of' relation: everyone has only one father, but any male can have zero, one or more children.
What are the Disadvantages of tabular presentation of data?
one of the major disadvantages of tabular presentation of data is that it does not give a detailed view of the diagram, unlike textual(descriptive) presentation
Which is transmittable data for data units 10101010 01010101 if system uses odd party?
101010100 010101011
ibby laksar does it and he eats handesh while doing it
What is Object Query Language OQL?
OQL is a database query language(related to ODMG) that is based on SQL and
supports the adding, retrieving, querying, and invocation of
objects. OQL is a version of the Structured Query Language. A object query language that supports complex data types such as multimedia, spatial, compound documents, etc., that are stored as objects. Standard SQL queries can still be used, and the OQL server process converts the objects into relational views. Sanjay
A data is known as the rowfact which is stored in computers memory and used by the user as the output
Draw an ER diagram for the following application from the manufacturing industry:
1. Each supplier has a unique name.
2. More than one supplier can be located in the same city.
3. Each part has a unique part number.
4. Each part has a colour.
5. A supplier can supply more than one part.
6. A part can be supplied by more than one supplier.
7. A supplier can supply a fixed quantity of each part.
Simply stated, that is an acronym for an advanced 'Database Management System', which is a software package that would facilitate the development of various applicable databases.
See the related link listed below for more information:
What factors influence the development of database concept?
Before the intruduction of this database concept many people used Manual Processing and File based systems.But there are some limitations.
Manual Processing-Time consuming
Does not support large volumes of data
File Based System-Data Inconsistency
Duplication of data
Security problems
And to overcome the limitations of these processing this Database processing was intruduced
Is address a user-defined data type?
You can define a data-type called 'address':
1. typedef void *address;
2. typedef struct address {
char country [32];
char state [32];
...
} address.
What are the benefits of data stuffing?
The following data fragment occurs in the middle of a data stream for which the byte-stuffing algorithm described in the text is used: A B ESC C ESC FLAG FLAG D. What is the output after stuffing?
What is data dictionary of c plus plus?
A data dictionary is structured data about data (metadata), typically employed by a DBMS, either passively (requiring manual, independant updating), or actively (automatically updated alongside and prior to DBMS updates). Data dictionarie's don't really apply to the C++ language as such, but you can model a data dictionary using C++ wherever you need structured data about data within your database programs.
