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
Normalization is the process of efficiently organizing data in a database. There are two goals of the normalization process: eliminating redundant data (for example, storing the same data in more than one table) and ensuring data dependencies make sense (only storing related data in a table). Both of these are worthy goals as they reduce the amount of space a database consumes and ensure that data is logically stored.
Why is data important to an organization?
Data is crucial for organizations as it drives informed decision-making, enabling leaders to identify trends, measure performance, and optimize operations. It enhances customer understanding, allowing for personalized experiences and improved service. Additionally, data supports strategic planning and innovation by providing insights that guide product development and market positioning. Ultimately, leveraging data effectively can lead to competitive advantages and increased profitability.
business man/women might use it so they can manage there paper work shop keepers might you it to organize there work and the profit and loss
What does a college use a database for?
Colleges use databases to store and recall info based on student numbers, names, phones and so on.
What are the advantages of replacing a paper-based sysytem with a computerised system in a hotel?
faster preformance
What is a non-physical attribute?
A non-physical attribute refers to a characteristic or quality that is not tangible or material in nature. Examples include emotions, thoughts, beliefs, values, and personality traits. These attributes are internal and subjective, making them distinct from physical traits such as height or weight.
What is sequential data mining?
Sequence mining is a topic of data mining concerned with finding statistically relevant patterns between data examples where the values are delivered in a sequence.[1] It is usually presumed that the values are discrete, and thus time series mining is closely related, but usually considered a different activity. Sequence mining is a special case of structured data mining.
There are several key traditional computational problems addressed within this field. These include building efficient databases and indexes for sequence information, extracting the frequently occurring patterns, comparing sequences for similarity, and recovering missing sequence members. In general, sequence mining problems can be classified as string mining which is typically based on string processing algorithms and itemset mining which is typically based on association rule learning.
Advantages and disadvantages of a systems review committee?
An advantage to having a system's review committee is their ability to catch problems that may affect the system. A disadvantage is the fact that the committee may tend to be too strict and delay production.
Organisations that store personal data?
i do not know Cameron but i would say pen drive, utility program and interface.
What is the use of Database management system in the banking sector?
This helps bankers to keep information in order. They can use it to put all of their customers information in one place to access easily.
Identify 4 advantages of periodic review system?
Helps to control "A" items
Inventory need not be monitored continually
Useful when a large number of items is ordered from the same supplier
Consolidated shipments lower freight costs
What are the advantages of the putting out system?
One advantage was there were only the merchant and the rural worker in the partnership. This allowed their relationship to be simpler and share a common goal: to make profit and increase capital. There were also no regulations which allowed the workers and merchants change procedures as they saw fit. But a disadvantage of this was it discouraged the development of new methods
Before you enter data into a database what do you do?
Before data can be entered into a database, the storage structure needs to be defined. As a minimum, a database would need at least one table.
is a program that allows you to create and managedatabases. Adatabase is a place where you can store information related to a specific topic. How you intend to use the information will determine whether you need an Access database or a different program to create and manage your data
The relationship between a database and application is?
Databases are independent of the applications that use the data.
Distinguish between a relation and a relationship in database?
Relation is one record in the database or a tuple.
Relationship is that how tables are connected to each other.
How many layers of data can be stored on one side of a BD-ROM?
2 layers but up to 20 layers are expected in the near future
Correct difference between file and database?
A file is a record. A record is comprised of a bunch of fields. Files are the subject of some thing. For example, if you are on a mailing list, it has your name, address.
A database contains files - think of a file cabinet.
