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 is the difference between an information process model and an information process?
An information process is a computer applicationor portion of an application which processes numerical, graphical, or textual data.
An information process model is a description of how some information could or should be processed to yield a desired result.
What is a learning management system?
A learning management system (LMS) is a software application that manages educational courses, training programs, or learning and development programs through administration, documentation, tracking, reporting, automation, and delivery. An LMS gives you the ability to track every aspect of learning. LMS reports allow you to track and measure training outcomes.
To clarify the question: "The senior managers of a large business organization want to know whether they should use [thier organization's] information system[s] to support [strategic decisions].
Answer - Yes if
1) they trust the information their organization's information systems contain (bad
input = bad output)
2) there are individuals who
a) understand the data their systems contain
b) are competent enough with the system to extract that data to present an
accurate picture of the organization and its transactions
c) are able to communicate that data effectively to senior management.
Explain listing process with suitable example and Diagram?
Where can you design and modify tables in database?
Table design in Microsoft Access can be performed by right clicking the table name in navigation view (column that runs down the left hand side of Access that is headed 'All Access Objects' by default) or by clicking the "geometry set" icon on the far left hand side of the ribbon called "View" with the table actually open. In Design view you can create and rename fields and assign a "Data Type" to represent the type of data being entered into each field such as Text, Date, Number etc. Hope this helps.
Data flow diagramm level 1 of senior tutor office management system?
How it is possible that one is so free for you that he/she start designing on behalf of you !
I know it is very important for you , but this world is selfish , they can waste their time with their girl friend but dont have any time to make diagram for you !
Sample DFDs for college management?
Sample DFDs for college management and college and University website
The most widely used coding scheme used to represent data?
Binary is the base for all coding in a PC.
Difference between schema sub schema and instance in DBMS in detail?
the overall logical data base description is referred to as a schema. it is sometimes also referred to as an overall modal of the data, a conceptual modal of the data, a conceptual schema
How many types of functional dependencies in DBMS?
In DBMS there is three type of functional dependency
1 FULL FUNCTION DEPENDENCY.
2 PARTIALLY FUNCTION DEPENDENCY.
3 TRACIENT FUNCTION DEPENDENCY.
Functional Dependency can be classified as follows:
Full Functional dependency Indicates that if A and B are attributes(columns)of a table, B is fully functionally dependent on A if B is functionally dependent on A ,but not on any proper subset of A.
Partial Functional Dependency Indicates that if Aand B are attributes of a table , B is partially dependent on A if there is some attribute that can be removed from A and yet the dependency still holds.
Transitive Functional Dependency: A condition where A , B and C are attributes of a table such that if A is functionally dependent on B and Bis functionally dependent on C then C is Transitively dependent on A via B
For Detailed explanation with example visit Authors original Posting
http://www.mahipalreddy.com/dbdesign/dbqa.htm
Heterogeneous Data is data from any number of sources, largely unknown and unlimited, and in many varying formats. In essence, it is a way to refer to data that id of an unknown format and/or content.
Data saturation is the situation in which the data has been heard before. For example, a reseacher might interview 23 people that all had the same experience (same disease, same job, same lifestyle, etc.), if the researcher only interviews a few people, their personal nuances and characteristics will color the findings. On the other hand, there is no need to continue interviewing people once the researcher finds that further interviews are not adding to the findings or repeating what was already found in the previous interviews.
How will add additional conditions in SQL?
This question needs some context in order to give a reasonable answer. Please provide a bit more info
Data flow diagram for travel and tourism how to draw dfd for travel and tourism management system?
The data flow diagram for travel and tourism basically shows the relationship between the tourism and the travel trends. The travel trends and tourism are then used in the creation of the tourism management system.
Why would you use a form for entering data into a database?
Field/column names in a data table are often cryptic. Because a form can have labels and can contain descriptions for each input field of the table, the data input clerk can more easily input the data without having to know what the cryptic names mean. Forms also allow flow control for the data. If one field contains a specific entry, the form can disable other input fields if they are not necessary. For example, if the country field of a record indicates that the location is outside of the United States, then the state field can be disabled or even modified to provide a selection list of states/provinces in that country.
What problems are caused by data redundancy?
Data redundancy is a data organization issue that allows the unnecessary
duplication of data within your Microsoft Access database. A change
or modification, to redundant data, requires that you make changes
to multiple fields of a database. While this is the expected behaviour
for flat file database designs and spreadsheets, it defeats the purpose
of relational database designs. The data relationships, inherent in
a relational database, should allow you to maintain a single data
field, at one location, and make the database's relational model
responsible to port any changes, to that data field, across the database.
Redundant data wastes valuable space and creates troubling database
maintenance problems
How can you fix a spreadsheet if the user has forgotten to enter some important data?
It depends on what is missing. It might be a case of inserting a few blank rows or columns to enter the data in. You can do that by putting the cursor where you want the extra rows or columns to be and go to the Insert menu and pick Rows or pick Columns. You can then enter the data that is missing and redo the formulas. Whatever is missing, all you can do is enter it and fix up the spreadsheet. If you know what is missing and where you want to put it, then it is not a major problem. Before doing it, save a copy of the file as it is, with a different name, in case you need to go back to it and start again.
Online processing is used when in data handling is not possible?
online processing is done when--------------is not possible in data handling.
