Database Programming

Paper-based storage systems are cost-effective, easy to use, and do not require electricity or specialized equipment to access information. Additionally, paper documents provide a physical backup in case of technology failures or cyber attacks. They also offer a sense of security and permanence for important records.

Offline website data refers to information stored on a user's device when they visit a website, often to allow the website to function properly even when the user is not connected to the internet. This data can include cached files, scripts, images, and other elements that can be accessed locally without needing to be downloaded from the web server every time.

Advantages of data merging include creating a comprehensive dataset, reducing redundancy, and improving data analysis. Limitations may include data inconsistencies, potential errors in merging, and increased complexity in managing the merged data. It's important to carefully plan and execute data merging to maximize its benefits and minimize its limitations.

The hierarchical data model organizes data in a tree-like structure with a single parent for each child record. On the other hand, the network data model allows for multiple parent-child relationships, creating a more flexible and complex network of interconnected records. In the hierarchical model, relationships are one-to-many, while in the network model, relationships can be many-to-many.

The data integrity is important in a database because it assures that all data in it can be traced and link to other data. This ensures that all the data can be searched and recover. It increases the stability , the performance and the reliability of a database.

Advantage: Databases allow for efficient storage and retrieval of large amounts of data, enabling quick access to information and supporting complex queries and analysis.

Disadvantage: Databases can be complex to set up and maintain, requiring specialized knowledge and resources. Additionally, databases can be susceptible to security breaches and data loss if not properly managed.

Proprietary data refers to information that is owned and controlled by a specific organization, usually confidential or sensitive in nature. This data is not meant to be shared with the public or competitors and is protected by intellectual property laws or agreements.

Data redundancy does not have specific advantages. It only causes disturbance to our applications. Seeing duplicate entries on screen is a bad experience for the users and also multiple entries of the same data may affect our calculations sometimes badly.

A request for data from a database is called a query. It is a command that is used to retrieve specific information from the database based on certain criteria.

A "schema-on-read" database is one that allows users to define the structure of the data as they access it, rather than enforcing a predefined schema. This approach allows for flexibility in data organization and analysis, making it a popular choice for big data and analytics applications.

The RELATION/table has 9 ATTRIBUTES/columns, and there are 200 TUPLES /rows in the RELATION/table.

A data model is a collection of concepts that can be used to describe the structure of a database and provides the necessary means to achieve this abstraction whereas structure of a database means the data types,relationships and constraints that should hold on the data.

Data model are divided into three different groups

they are

1)object based logical model

2)record based logical models

3)physical models

Types:

Entity-Relationship (E-R) Data Model

Object-Oriented Data Model

Physical Data Model

functional data model

A "query" is usually a programmatic statement that is understand by a DBMS(Database management system) that understands how to access and manipulate data within a database. The primary operations of a query are referred to as CRUD(Create, Read, Update, Delete) and the main programming language for writing queries is ANSI SQL.

Searching a database involves looking for specific information or records within a structured collection of data. This usually involves using keywords, queries, or filters to retrieve relevant results that meet the search criteria. The goal is to efficiently locate and retrieve the desired information from a large dataset.

Redundancy is the state where duplicate rows of the same data is available in a database.

Lets say we have an employee database which contains 2 rows of the following data

Emp num Emp Name Age

12345 John 25

12345 John 25

This is data redundancy.

Data redundancy can be avoided by the use of keys in tables. If in the employee table we had defined a primary key condition for employee number, then the system would not allow us to enter 2 rows of the same data.

An object-oriented database (OODB) is a type of database that stores data in objects rather than in tables, making it easier to represent complex relationships and hierarchies in data. OODBs are designed to work well with object-oriented programming languages and frameworks.

Yes, that is correct. A query datasheet presents a logical view of the data because it displays the information based on the query conditions without physically storing it. The data itself remains stored in the underlying tables of the database.

• Selection: Filters rows in a table based on a specified condition, creating a subset of rows that meet the criteria.
• Union: Combines the results of two or more SELECT statements into a single result set, removing duplicates.
• Projection: Selects specific columns from a table or result set, returning only the desired columns and discarding the rest.

A database is a searchable organized collection of information that is typically stored and accessed electronically. It allows for efficient data retrieval, storage, and management, making it easier to find specific information quickly.

In the context of a relational database, a file is commonly referred to as a table. A table is structured in rows and columns to store related data in a database system. Each table represents a specific entity or concept within the database.

Structured data.

Confidentiality is the protection and control of sensitive information from unauthorized access or disclosure. It ensures that only authorized individuals have access to confidential data, preventing unauthorized parties from obtaining or using the information. It is essential for maintaining the privacy and security of sensitive data.

A surrogate key is an artificial PK introduced by the designer with the purpose of simplifying the assignment of primary keys to tables.

Use a Surrogate when you do not want or need the key to have business meaning.

The data type of a field determines the kind of data it can contain. For example, a field with a data type of "Text" can contain letters and numbers, while a field with a data type of "Number" can only contain numerical values. The data type is set when designing the database schema.

Data integrity is important because it ensures that data is accurate, consistent, and trustworthy. It helps organizations make informed decisions based on reliable information and prevents errors or discrepancies that can lead to costly mistakes. Maintaining data integrity also helps to build trust with customers, partners, and stakeholders.