Computer Based Test On Data-processing

Microsoft Power Point is not a database management system software. It is a presentation software used for creating slideshows and presentations. The other options listed, such as Microsoft Access, DBase III, FoxBase, and Oracle, are all examples of database management system software that are used for storing, managing, and manipulating data.

Edger F. Codd is credited with introducing the relational database model, where data is organized and stored in tables. This model revolutionized the way data is managed and allowed for efficient storage, retrieval, and manipulation of data. Codd's work laid the foundation for modern relational database management systems (RDBMS) and has had a significant impact on the field of database management.

Database normalization is the scientific process of breaking down a complex table into a simpler table in order to reduce redundancy and dependency. This process helps to eliminate data anomalies and inconsistencies by organizing data into separate tables with logical relationships. It involves dividing large tables into smaller ones, defining primary and foreign keys, and ensuring that each table has a single purpose. Normalization helps improve data integrity, query performance, and overall database efficiency.

In the relational database model, entities are used to define the object set. Entities represent real-world objects or concepts that have attributes and can be uniquely identified. They are used to organize and store data in a structured manner, allowing for efficient retrieval and manipulation of information. Entities form the basis for creating tables in a relational database, with each entity corresponding to a table and each attribute representing a column in that table.

In data modeling, "Data Structure" is not considered a data type when selecting value field values practically. Data Structure refers to the way data is organized and stored, such as arrays, linked lists, or trees, rather than the actual type of data being stored, like text, currency, date/time, or numerical values. Therefore, "Data Structure" does not fit into the list of data types that can be chosen as value fields in a data model.

When extending the database structure, the problem of table in First Normal form arises. First Normal form requires that each attribute in a table should have atomic values and there should be no repeating groups of attributes. Therefore, when extending the database structure, it is necessary to ensure that the table is in First Normal form by removing any repeating groups and ensuring that each attribute has atomic values.

When data is in the First Normal Form, it means that each attribute in a table contains only atomic values. In other words, there are no repeating groups or arrays of data within a single attribute. Therefore, when data is repeatedly typed into the database, it creates redundancy, which means that the same data is stored multiple times. This redundancy can lead to various issues such as data inconsistency, increased storage space, and difficulties in data manipulation. Hence, the correct answer is "Redundency".

In the relational model of a database, all data is represented in terms of tuples and grouped into relations. A tuple refers to a row or record in a table, which contains a collection of attributes or fields. These tuples are used to store and organize data in a structured manner within a database. Relations, on the other hand, are tables that consist of multiple tuples or rows. Therefore, the correct answer is "Tuple."

A query is a request for information from a database. When you ask specific questions about the data stored—such as filtering, sorting, or retrieving certain fields—you are performing a query. It allows users to extract useful information from large datasets based on specific conditions.

The correct answer is Primary Key and Attribute Key. Primary Key is a determinant of Normal form as it uniquely identifies each record in a table. Similarly, Attribute Key is also a determinant of Normal form as it helps in identifying and organizing data in a relational database. However, Candidate Key and Foreign Key are determinants of Normal form as well, as they play crucial roles in maintaining data integrity and relationships between tables in a database.