answersLogoWhite

0

Database Design

Database design is the process of creating a detailed data model of a database. It is the next step after requirement gathering and before coding begins. A good database design can save a lot of time during the database development.

500 Questions

What is Data redundancy in DBMS?

User Avatar

Asked by Wiki User

Data redundancy in DBMS refers to the duplication of data within a database system. This can result in inconsistencies and inefficiencies, as well as consuming more storage space. It is important to minimize data redundancy in order to maintain data integrity and improve performance.

Characteristics of good information in computer?

User Avatar

Asked by Wiki User

Good information in computer systems should be accurate, timely, relevant, complete, and easily accessible. It should also be reliable, consistent, and secure to ensure data integrity and proper decision-making. Additionally, good information should be presented in a user-friendly format that makes it easy to understand and analyze.

What is logical data independence and why is it important?

User Avatar

Asked by Wiki User

Logical data independence refers to the ability to make changes to the conceptual schema of a database system without affecting the external schema or applications that access the data. It is important because it allows for flexibility in adapting the database structure to evolving business requirements without disrupting existing applications or users. This separation of logical layers simplifies maintenance, enhances system scalability, and reduces the risk of data inconsistencies during schema modifications.

What is a imformation report?

User Avatar

Asked by Wiki User

An information report is a type of writing that presents factual information about a specific topic. It typically includes an introduction, body paragraphs with relevant details, and a conclusion summarizing key points. The purpose of an information report is to inform the reader about a subject using clear and concise language.

Discuss the main characteristics of the database approach and how it differs from traditional file system?

User Avatar

Asked by Wiki User

The database approach centralizes data storage and management in a structured manner using tables and relationships, promoting data integrity and security. It supports complex queries and transactions. In contrast, traditional file systems store data in separate files without inherent relationships, making it less efficient for managing complex data and ensuring consistency.

What processes in informatica use unit test cases?

User Avatar

Asked by Wiki User

In Informatica, unit test cases are commonly used to test individual mapping logic or transformations within a workflow. Unit tests help verify the accuracy and integrity of data transformation processes, ensuring that data is processed correctly before moving to downstream systems. These tests can be automated to run on a regular basis to validate that the mappings are functioning as expected.

How do you use a DFD Model?

User Avatar

Asked by Wiki User

A DFD (Data Flow Diagram) model is used to show the flow of data within a system. To use it, you start by identifying the external entities interacting with the system, then define the processes that transform the data, and finally show the data stores where information is stored. This helps in understanding how data moves through the system and can be used for system analysis, design, and documentation.

What is the characteristic of good information?

User Avatar

Asked by Wiki User

Good information is accurate, relevant, timely, and easily understandable. It should be reliable, coming from credible sources and free from bias. Additionally, good information should be able to help in making informed decisions or solving problems.

Two disadvantages of a paper based database?

User Avatar

Asked by Wiki User

  1. Limited storage capacity compared to digital databases, making it difficult to scale as data grows.
  2. Susceptibility to physical damage, such as fire or water damage, risking loss of important information.

What are the qualities of a good information system?

User Avatar

Asked by Wiki User

A good information system should be reliable, accurate, secure, user-friendly, and timely. It should also be able to efficiently collect, store, process, and distribute information to support the organization's goals and decision-making processes.

Set and get session attributes syntax in servlets and java script?

User Avatar

Asked by Wiki User

Setting and getting session attributes is fairly easy. It is the same in both Servlets and JSPs with one exception. In a JSP, you already have access to the session object, and you do not have to declare it. In a Servlet, you must get the session like this: javax.servlet.http.HttpSession session = request.getSession(); Once you have done that, you can set a session object like this: session.setAttribute("name","value"); To retrieve the value, do this: String foo = (String) session.getAttribute("name"); A couple of things to keep in mind: * The second parameter in the setAttribute method is an Object, not a String. When you retrieve the value, you have to cast it. In the example above, I am casting it to a String. * If you try to perform a getAttribute on a session attribute that does not exist, or was not set, it will return a null. * Session attributes are not available using JavaScript. You can not set or get an attribute in JavaScript. * You do NOT need to do the 'session = request.getSession() in a JSP. It is only necessary in a Servlet.

Concept of data independence?

User Avatar

Asked by Wiki User

Data independence refers to the ability to make changes to the data storage structure without affecting the applications that use the data. There are two types of data independence: logical data independence, which insulates applications from changes to the logical structure of the data, and physical data independence, which shields applications from changes to the physical storage structure of the data. This concept is a key aspect of database design and helps to promote flexibility, scalability, and maintainability of data systems.

Two Disadvantages Of A Paper-Based Database?

User Avatar

Asked by Wiki User

Paper database is a traditional way of storing information. It has the following disadvantages :1) The data is not easy to handle , complete human effort required .

2) The data can be easily lost and also difficult to manage.

3) The data is difficult to access, everything has to be done manually.

What are all the major applications of network data model and hierarchical data model?

User Avatar

Asked by Wiki User

The network data model is commonly used in database management systems to represent complex relationships between data entities, such as in telecommunications and transportation systems. The hierarchical data model is often used in representing parent-child relationships in organizational structures, file systems, and XML documents. Both models are effective in handling data with hierarchical relationships but can be less flexible compared to newer data modeling approaches like relational databases.

What is stand alone information system used for?

User Avatar

Asked by Wiki User

Stand-alone information systems are used to perform specific tasks without needing to be connected to a network. They are typically employed in situations where data security, ease of use, or reliability is paramount. Examples include ATMs, point-of-sale systems, and personal devices like laptops or smartphones.

When was a data base invented?

User Avatar

Asked by Wiki User

The first database management system (DBMS), known as the Integrated Data Store, was developed by Charles Bachman in 1963. This marked the beginning of modern database systems.

Disadvantages of paper-based database?

User Avatar

Asked by Wiki User

Paper-based databases are prone to physical damage, such as fire or flood. They are difficult to scale and require manual management, which can be time-consuming and error-prone. Retrieving data from paper-based systems can be slow and inefficient compared to digital databases.

What kind of data should be stored?

User Avatar

Asked by Wiki User

Data that is necessary for achieving the objectives of a system or organization should be stored, such as customer information, product details, transaction records, and relevant metrics. It is important to consider data privacy and security regulations when determining what data to store. Additionally, only data that will be actively used or analyzed should be stored to prevent unnecessary clutter.

Differences between finite and infinite loop?

User Avatar

Asked by Wiki User

A finite loop executes a specific number of times based on its condition, while an infinite loop runs indefinitely without cessation. Finite loops have a predetermined endpoint, while infinite loops continue without a defined stopping condition until manually interrupted. Improperly written infinite loops can lead to system crashes or unresponsive programs.

Explain two disadvantages of a paper based database?

User Avatar

Asked by Wiki User

  1. Limited storage capacity: Paper-based databases have limited storage capacity and can become bulky and hard to manage as the amount of data grows.
  2. Lack of easy access and organization: Retrieving and organizing information from a paper-based database can be time-consuming and error-prone compared to digital databases that offer search and sort functionalities.

Disadvantages of a paper based database?

User Avatar

Asked by Wiki User

Some disadvantages of a paper-based database include limited storage capacity, vulnerability to physical damage (such as fire or water), difficulty in data retrieval and sharing, as well as increased risk of errors during data entry and maintenance. Additionally, paper-based databases can be time-consuming to update and maintain compared to digital databases.

Disadvantages of paper based database?

User Avatar

Asked by Wiki User

Some disadvantages of paper-based databases include limited storage capacity, difficulty in organizing and searching for information, susceptibility to damage or loss, and lack of security measures to protect sensitive data.

The purpose of a scanner?

User Avatar

Asked by Wiki User

A scanner is used to create digital copies of physical documents or images, which can then be stored, viewed, or manipulated electronically. It allows for easy sharing, editing, and organization of paper documents or pictures.

Difference between database and distributed database?

User Avatar

Asked by Wiki User

A database is a collection of related data organized for quick search and retrieval, usually stored on a single computer system. A distributed database is a database in which parts of the database are stored in multiple locations but managed by a centralized control. Distributed databases are used to improve performance, reliability, and scalability by allowing data to be spread across multiple servers or locations.

Why is a data base useful?

User Avatar

Asked by Wiki User

A database is useful because it provides a centralized system for storing, managing, and retrieving data efficiently. It helps maintain data integrity, enables data sharing among multiple users, enhances data security through access control, and supports complex queries and analysis.