Kuis #1 Basis Data

The correct answer is "ATRIBUT PRIMARY KEY" because a primary key is a unique identifier for each record in a database table. It ensures that each record can be uniquely identified and helps maintain data integrity. The other options mentioned, such as "ATRIBUT MULTI KEY" and "ATRIBUT DERIVATIF," are not valid terms in the context of ER symbols.

The given correct answer for this question is "Partialy conneted network". This type of network topology refers to a network where some nodes are directly connected to each other while others are connected through intermediate nodes. In this topology, data can be distributed efficiently as it allows for multiple paths between nodes.

SQL (Structured Query Language) is a programming language used for managing relational databases. It is a non-procedural DML (Data Manipulation Language) because it allows users to specify what data they want to retrieve or modify, without specifying how to do it. In other words, SQL allows users to focus on the desired outcome rather than the specific steps to achieve it. This makes SQL a powerful and efficient language for working with databases.

An object that can be distinguished from other objects is referred to as an "entitas" in Indonesian. This term is commonly used in the context of data modeling and database systems, where entities represent real-world objects or concepts that have distinct characteristics and can be uniquely identified.

The correct answer is "Bersifat luwes/fleksible." This is because one of the characteristics of traditional file management is that it is rigid and inflexible. Traditional file management systems have fixed structures and formats for storing and organizing data, which makes it difficult to adapt to changing needs or accommodate different types of data. In contrast, modern database management systems are more flexible and can easily handle diverse data types and structures.

The correct answer is "Menunjukan adanya relasi". This is because a straight line symbol in an Entity-Relationship Model (ERM) is used to represent a relationship between entities. It shows that there is a connection or association between two or more entities in the database.

A group of similar records with the same length and attributes but different data values is referred to as a file.

Aljabar Relational adalah kumpulan operasi terhadap relasi, dimana setiap operasi menggunakan satu atau lebih relasi untuk menghasilkan satu relasi yang baru.

The given correct answer is "Semantic model". The explanation for this answer is that the picture below represents a data model known as the semantic model. The semantic model is a conceptual model that focuses on the meaning and relationships between data elements. It is used to describe the semantics, or meaning, of data in a system. This model is often used in database design to ensure that data is organized and structured in a way that accurately represents the real-world entities and their relationships.

The given options represent different database models. The infological model, semantic data model, binary model, and entity relationship model are all examples of object database models. However, the physical data model is not an object database model. It is a representation of how data is stored and organized in a database system, focusing on the physical aspects such as tables, columns, and indexes. Therefore, the physical data model is the exception in this list.

The correct answer is "Shared." Each part of the database can be accessed by users simultaneously, for different applications. This means that multiple users can access and modify the database at the same time, allowing for efficient collaboration and utilization of the database resources.

The correct answer is Internal level. The internal level of a database describes the physical storage structure and file organization used in a database system. It deals with how data is stored on the storage media, such as disks or tapes, and how it is accessed and manipulated at the lowest level. It focuses on the implementation details and is closer to the physical representation of the data.

Model Data adalah sekumpulan konsep-konsep untuk menerangkan data, hubungan-hubungan antara data, dan batasan-batasan data yang terintegrasi di dalam suatu organisasi. Model Data digunakan untuk menggambarkan struktur data, hubungan antara entitas, atribut-atribut yang dimiliki oleh entitas, dan batasan-batasan yang ada dalam pengelolaan data di dalam suatu organisasi. Dengan menggunakan Model Data, organisasi dapat merencanakan dan mengorganisir data mereka dengan lebih efisien dan efektif.

The operation that combines the cartesian product operation with the selection operation based on a certain criteria is called a theta join. In a theta join, the join condition can be any condition using comparison operators such as greater than, less than, equal to, etc. This allows for more flexibility in joining tables compared to other join operations like natural join or set intersection.

The correct answer is Union. Union is the operation used to combine two tables where the attributes in both tables have the same domain. It takes the rows from both tables and creates a new table that contains all the rows from both tables, without any duplicates.