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
On the Home Tab, in the Styles section. Click on the Format as Table button.
A stack is a data structure in which last item inserted is taken out first . That's why they are known as LIFO (last in first out). Inserting an item in stack is termed as push and taking an item out from stack I s termed as pop. Some applications of stack are : Polish notation, reversing string, backtracking , quick sort algorithm etc. The queue is a linear data structure where operations od 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. Whenever a new item is added to queue, rear pointer is used. and the front pointer is used when an item is deleted from the queue.
What is the meaning of normalized data in data warehouse?
Data warehouses are designed for quick access to large amounts of historical data. Read operations dominate over write operations. Under these conditions, normalization takes a back seat to performance optimization. A different design methodology, called dimensional design is used when planning a data warehouse.
There are two common categories of schemas used in data warehousing: star schemas and snow flake schemas. A star schema has a central fact table, surrounded by dimension tables. The fact table contains columns called measures, which are aggregated in queries. The fact table is related to the dimension tables. The dimension tables may have levels, which are implemented as columns. For example, a dimension table named Location may contain columns for Continent, Country, StateProvince and City. This dimension table is not normalized. If you normalize the dimension tables, then each level is placed in its own table. Normalizing the dimension tables results in a snow flake schema.
What do you mean by degree of relation in relational data base management system?
The degree of a relation is the number of attributes the relation has in it.
The degree of a relation can be zero or more integer. An n-ary relation is a relation in which its degree is n in turn a relation of n attribute(s).
$1,000.50 (depending on how you configure comma and currency symbol)
What is a sentence for overlapping?
It might be "I could not come to my friend's party because it was overlapping my dental appointment"
Discuss how messages include both a content and relational dimension?
Messages can contain both a content and relational dimension. The content dimension is literally what is said through the use of language. The relational dimension is the nonverbal component of the message. It usually is conveyed through tone of voice, eye contact and facial expression, and gestures.
Let's imagine you say to your roommate, "I told you I didn't care!" The words that you used are the content dimension. How you say it (nonverbal) will communicate the relational dimension. You can say it in an angry way, a caring way, etc. Common relational messages are affinity (degree of liking), immediacy (amount of attention or interest), respect, and control.
How do you delete the data without making any changes to cell?
This is a bad question. The direct answer to this question is that it is not possible to delete data without making changes, since that is the definition of change. However, you can click the undo button to change things back to the way they were before you started making changes in the first place.
What are the steps in creating a report in a database?
Steps involve in creating report. 1. Open the database window (F11) and click on the Report tab.
* 2. Click New. A dialog box appears. * 3. Choose between Columnar and Tabular.
* 4. Select the table or query that you want to use for your report. * 5. Click OK. * ** 6. Repeat the first two steps above.
** 7. When the dialog box appears, click Design View.
** 8. Select the table or query that you intend to use.
** 9. Click OK.
*
Difference between cartesian product and full outer join?
Full outer join will fetch at maximum 'addition of 2 tables'
Ex: Table A - 2 rows; Table B - 3 rows.
Full outer join will fetch in 2+3 = 5 rows.
Where as in Cartesian product will fetch in 'product of 2 tables'.
Ex: Table A - 2 rows; Table B - 3 rows.
Full outer join will fetch in 2x3 = 6 rows
Advantages of vector data models over raster model?
• Data can be represented at its original resolution and form without generalization.
• Graphic output is usually more aesthetically pleasing (traditional cartographic representation);
• Since most data, e.g. hard copy maps, is in vector form no data conversion is required.
• Accurate geographic location of data is maintained.
• Allows for efficient encoding of topology, and as a result more efficient operations that require topological information, e.g. proximity, network analysis.
• Compact data structure; requires less space to store data
Field size automatically fills in a certain value in new records as you add to the table.
Its called hashing. An example of such process is MD5 and SHA. For more information look it up.
Why are naming conventions so important when working with database?
As your databases grow in size and complexity, the need to establish a naming convention for the objects in your databases increases. As you already know, changes to the name of an object are not propagated throughout the database . Even with the Name Auto-Correct option turned on (Office Button Access Options Current Database Name Auto-Correct Options), Access only corrects the most obvious name changes.
Primary key
