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
Discuss data mining and its role in database systems?
Data mining involves uncovering insights and patterns from large datasets to help make informed business decisions. It plays a crucial role in database systems by extracting valuable information from the stored data and discovering hidden patterns, trends, and relationships. This process helps businesses identify opportunities, predict future outcomes, and optimize decision-making.
What are the advantages of paper based documentation?
Advantages:
- Information can be filled in quickly by the customer.
- A computer isn't needed to read it.
Disadvantages:
- Paper-based documents can be lost or destroyed.
- Takes up space in the premises to store for reference.
- Can not be easily modified.
Advantages of direct cut-over in information systems?
Advantages:
Cheap, cost effective, efficient with time.
Disadvantages:
Can lead to system failure, risky, would need to be updated frequently (in early stages) for system maintenance etc
Which are the procedures of database?
Procedures in a database are stored code segments, which can be executed. This is a good way of holding any business logic in a single place. A procedure could be very simple and return the value of the square of two number, or be very complicated, and perform a lot of data validation before inserting data into a table or updating a table for example.
What are the uses of table in data presentation?
Tables or charts are just an easy way to organize data. So in terms of a presentation a table makes it easier for the audience to understand it. If you didn't have a data table, chart, or graph what would you have? random numbers on the board?
Why is it important to learn SQL?
SQL is the language used to access a database. So if you want to work with databases, especially to query or manipulate data, then it is important that you learn SQL. Even if you use other APIs, you will still need to use SQL queries.
A database of information used for research patient follow-up and improving public health?
This database collects and stores data on patient follow-up to track health outcomes and trends over time. By analyzing the data, public health professionals can identify patterns, assess interventions, and make informed decisions to improve public health outcomes.
How do you draw an Er diagram on school management system?
An ER diagram of a library database management system helps to keep all aspects of running a library organized. The diagram should include the books and publishers, as well as members of the library and who has checked out which books.
What is data isolation in DBMS?
Data isolation refers to the concept of keeping data separated and protected from unauthorized access or modification within a database management system. It ensures that each transaction in the database is independent and operates as if no other transactions are occurring simultaneously, preventing interference and maintaining data integrity. Data isolation is crucial for ensuring the consistency, reliability, and security of the database.
Representation and education are the two main functions of?
Representation and education are the two main functions of museums. Museums represent cultural heritage and history through their collections and exhibitions, providing a platform for learning and understanding. Additionally, they serve as educational institutions by offering interpretation and context to help the public engage with and appreciate the artifacts and stories on display.
What is Data redundancy in DBMS?
In database we store data however the can be redundant. Redundancy means repetitive data that is taking extra storage space . So to reduce or prevent the storage space we should eliminate redundancy or just reduce it.
A row in a database represents a single record or entry within a table. It contains a set of related data fields that are organized into columns, with each column representing a different attribute or variable associated with that record. Rows are used to store and retrieve information in a structured manner within a database.
Data refers to raw facts or figures that are collected, while information is data that has been processed or organized in a way that gives it meaning or context. In essence, data is the foundation on which information is built.
What are the levels of data mining?
Data mining l The non-trivial extraction of novel, implicit, and actionable knowledge from large datasets. l Extremely large datasets l Discovery of the non-obvious l Useful knowledge that can improve processes l Can not be done manually l Technology to enable data exploration, data analysis, and data visualization of very large databases at a high level of abstraction, without a specific hypothesis in mind. l Sophisticated data search capability that uses statistical algorithms to discover patterns and correlations in data. Data Mining is a step of Knowledge Discovery in Databases (KDD) Process l Data Warehousing l Data Selection l Data Preprocessing l Data Transformation l Data Mining l Interpretation/Evaluation l Data Mining is sometimes referred to as KDD and DM and KDD tend to be used as synonyms Data Mining in CRM l DM helps to l Determine the behavior surrounding a particular lifecycle event l Find other people in similar life stages and determine which customers are following similar behavior patterns more l Building Data Mining Applications for CRM by Alex Berson, Stephen Smith, Kurt Thearling (McGraw Hill, 2000). Data Minin Customer Life Cycle Info. g
Levels of data mining Macro level Mining at the macro level gives us a broad overview of the data. This is used under following circumstance # when we are dealing with the customers for the first time. # when the co. is enterning a new market with a new product. # we are dealing aspects of services which influence a majority of the customer # predicting the possibility of an action that the customer has never taken. Micro (individual level) Relationship with individual customer can be strengthen by offering customized value proposition witch you get from micro level scanning knowledge obtained is useful when the company wants to provide customized service Example: When the firm wants to take advantage of personal events like birthday in a customers life.
Discuss the relative advantages of centralized and distributed databases?
Answer:
Advantages of Distributed Systems over Centralized ones
1:Incremental growth:Computing power can be added in small
increments
2:Reliability:If one machine crashes, the system as a whole can
still survive
3:Speed:
A distributed system may have more total computing power than a
mainframe
4:Open system:
This is the most important point and themost characteristic point
of a distributed system.
Since it is an open system it is always ready to communicate with
other systems.
an open system that scales has an advantage over a perfectly closed
and self-contained system.
Economic:ANd Microprocessors offer a better price/performance than
mainframes
Disadvantages of Distributed Systems over Centralized ones
1:As i previously told you distributed systems will have an
inherent security issue.
2:Networking:If the network gets saturated then problems with
transmission will surface.
3:Software:There is currently very little less software support for
Distributed system.
4:Troubleshooting:Troubleshooting and diagnosing problems in a
distributed system can also become more difficult, because the
analysis may require connecting to remote nodes or inspecting
communication between nodes.
What is logical data independence and why is it important?
Logical data independence refers to the key feature of database management system that helps maintain data integrity and the overall effectiveness of the data usage. It is very important as it allows for the modification of the conceptual schema without disturbing the external schema.
Explain the term field in a database?
In a database, a field is any area that can be filled in with different kinds of data that are relating to one thing. For example, in a database to do with population, there is likely to be an age field.
File oriented system vs database oriented system?
file oriented system is manual file maintain system that keep records in hard bind documents.
database is computer based structurally logically ordered data with the help of DBMS.
This prior answer is partially incorrect. File oriented systems are data systems that depended on sequential, ISAM(indexed sequential access method), and VSAM(visual storage access method) files without the benefits of database technology.
The Entity-Relationship diagram is the most helpful in designing a relational database to store object data. It visually represents entities, their attributes, and the relationships between them, providing a clear understanding of the database structure and enabling effective planning of tables and relationships.
What are the different types of rdbms available?
Some common types of relational database management systems (RDBMS) include MySQL, PostgreSQL, Oracle Database, SQL Server, and SQLite. Each has its own features, strengths, and target use cases. Users can choose an RDBMS based on factors such as scalability, performance, cost, and specific requirements of their applications.
How do you do query based information extraction?
Query-based information extraction involves extracting specific information from a text based on a predefined query. This can be done using techniques such as named entity recognition, part-of-speech tagging, and syntactic parsing to identify relevant information based on the query parameters. Natural language processing or machine learning algorithms can be used to match the query with the text and extract the required information.
To select all records from the "Persons" table where the value of the column "FirstName" starts with 'a', you can use the following SQL query:
SELECT * FROM Persons WHERE FirstName LIKE 'a%';
This query will retrieve all records where the "FirstName" column starts with the letter 'a'.
- How does the hierarchical data model address the problem of data redundancy?
The hierarchical model divides the data into parents and children with the system working on the principle that each child can have only one parent but each parent can have an infinate number of children - thus supporting one-to-manyrelationships.
This means that data redundency is reduced as a relationship can be established between entities e.g. in a school system each course would be a parent, with each student being the child, and each grade being the child of the student.
This would allow you to createa one-to-many relationship between the students on each course and the grades for each pupil.
However this system is not ideal for this scenario, as if a student was enrolled on more than one course their details would have to be duplicated for each course.
To deal with this many-to-many relationship you would need to create a relational database, creating a studentcourses entity with a one to many relationship occurring between both it and a student entity and it and a courses entity
What are searchable database part of?
Searchable databases are typically composed of three main parts: a database management system (DBMS) that stores and organizes data, a user interface that allows users to search and retrieve information, and a search engine that facilitates querying and retrieving data based on specific criteria.
Databases store electronic representations of data, but traditional file systems generally store paper with data written on it. In a traditional file system a file folder is the the way records are grouped, but in a database records are indexed in many ways, both by "file folder" and by record or data field. With relational database approaches relationships can be established between data in records and new records can be created from crossing files and even databases.
