Baze Podataka - Uvodni Pojmovi

In relational databases, tables are connected to each other using primary and foreign keys through relationships or "veze" in Croatian. These relationships establish connections between the data in different tables, allowing for efficient data retrieval and manipulation. By using these relationships, data can be linked and accessed across multiple tables, ensuring data integrity and consistency in the database.

The correct answer is "zalihost ili redundancija" which translates to "redundancy or duplication" in English. This refers to the unnecessary repetition of the same data within a database. Redundancy can lead to data inconsistencies and inefficiencies in storage and retrieval. Normalization, optimization, and hyperinflation are not relevant to this concept.

The correct answer is "Netočno" (False). This is because the statement suggests that we should use the data type "Short text" for entering data up to 655 characters, but the correct data type for this purpose would be "Long text" or "Text". The "Short text" data type typically allows for a shorter character limit, such as 255 characters.

The correct answer is DBMS. DBMS stands for Database Management System, which is a software program that allows users to create and maintain a database, as well as control access to the data. It provides an interface for users to interact with the database, allowing them to perform tasks such as creating tables, inserting data, querying the database, and managing security and permissions. DBMS is essential for organizing and managing large amounts of data efficiently and securely.

The correct answer is "Kratki tekst (Short text)". This is because the given options are different types of data fields that can be used to input textual data. Among these options, "Kratki tekst (Short text)" is the most suitable for entering textual data of up to 255 characters. The other options, such as "Dugi tekst (long text)" and "Privitak (Attachment)" are not specifically designed for inputting short textual data.

A skup logički organiziranih i međusobno povezanih podataka koji čine neku cjelinu nazivamo baza podataka.

Normalizacija je postupak organiziranja podataka u bazi podataka radi eliminacije redundancije i postizanja veće efikasnosti, pouzdanosti i fleksibilnosti. Ovaj postupak pomaže u održavanju integriteta baze podataka i smanjuje potrebu za ponavljanjem istih podataka u različitim tabelama. Normalizacija se koristi kako bi se osiguralo da svaki podatak bude zapisan samo jednom i da se veze između podataka jasno definišu.

A primarni (glavni) ključ is a field (or fields) that uniquely identifies each record stored in a table and has a unique value. It is used to ensure the integrity and uniqueness of the data in the table.

In the context of a database table, a "stupac" refers to a column. A column represents a specific attribute or characteristic of the data being stored in the table. The term "polje" is the Croatian translation for "field," which is commonly used to describe a column in a database table. Therefore, the correct answer is "polje" or "field."

The given statement states that the field "Prezime" in a table can be defined as a primary key. However, this statement is incorrect. A primary key is a unique identifier for each record in a table, and it cannot contain duplicate or null values. In most cases, a field like "Prezime" (which translates to "Last Name") would not be suitable as a primary key because multiple people can have the same last name. Therefore, the correct answer is "Netočno" (False).

The correct answer is "tablica". In a database, a table is the basic object that stores data and serves as the foundation for creating other objects. It organizes data into rows and columns, allowing for efficient storage and retrieval of information. Tables are essential for structuring and managing data in a database system, and they are used to represent entities and their relationships in a relational database model.

The correct answer is "podatak" because it refers to a fact presented in the form of sound, text, or numbers that may not have any meaning on its own.

The given correct answer is "informacija". In the context of the question, it is stated that we add meaning and context to a set of data in order to learn something new. This aligns with the definition of "informacija", which means information in Croatian. Therefore, it can be concluded that the correct term for the described situation is "informacija".

In the Design view, we can define, add, and delete fields, as well as modify field properties and perform other actions related to the design of the table. This view allows us to make structural changes to the table, such as adding or removing fields, and also modify the properties of the fields. Therefore, it is the correct answer for the given question.

The given statement is incorrect. The correct answer is "Netočno" which means "False" in English. The statement implies that data entry in a table is done in the Design View of the table, but this is not true. Data entry in a table is typically done in the Datasheet View or Form View of the table.

When we want Access to automatically assign unique numerical values to a field so that we can use it for purposes like product codes, we would choose the field type as Autonumber.

The correct answer for this question is "zapis, record". In a database table, a record refers to a complete set of information about a specific entity or item. It is a collection of related data fields that are grouped together to represent a single entity. In Croatian, the term for record is "zapis". Therefore, both "zapis" and "record" are correct terms to describe a row or entry in a database table.

The given answer lists various examples of fields that can be used as the primary key in a table. These fields include OIB (personal identification number), JMBG (unique master citizen number), car chassis number, student ID number, product code in a warehouse, and passport number. A primary key is a unique identifier for each record in a table, and it ensures that there are no duplicate records. In this case, any of the listed fields can serve as a primary key, depending on the specific requirements and characteristics of the table.

Indexes are used to speed up the search and retrieval of data by storing the location of records on a field or fields. They work based on the principle of an index in a book. Therefore, the correct answer is "indeksi".

The correct answer includes the elements that are present in the design view of a table, which are the field name, description, data type, and field properties.

MS Access is a commercial software that is used as a desktop database management system (DBMS). It supports SQL, which stands for Structured Query Language, allowing users to interact with and manipulate the database.

The individuals involved in a database system are programmers of applications, users, database administrators, and end-users. These individuals play different roles in the database system. Programmers of applications develop the software that interacts with the database. Users are individuals who interact with the database system to perform various tasks. Database administrators are responsible for managing and maintaining the database system. End-users are the ultimate consumers of the data stored in the database. Therefore, the correct answer includes all these individuals.

The correct answer is tablica, upit, obrazac, izvješće. In a database, the basic objects are tables, queries, forms, and reports. Tables store the actual data in a structured format, queries are used to retrieve specific data from the tables, forms provide a user-friendly interface for entering and viewing data, and reports are used to present data in a formatted and organized manner. These objects are essential components of a database system and are used for various purposes in managing and analyzing data.

The correct answer is "database management system". This is the correct term for the English abbreviation "DBMS" which stands for "database management system". The answer options "Database Management System", "Database management System", and "Database management system" are all variations of the correct term, but they are not written in the correct capitalization format.

The correct answer includes the terms "relacijske," "mrežne," and "hijerarhijske," which are all types or models of databases that are commonly used today. Relational databases organize data into tables with rows and columns, while network databases organize data using a network structure, and hierarchical databases organize data in a tree-like structure. These three types of databases are widely used in various industries and applications for efficient data management and retrieval.

The given answer lists the different types of data that can be defined in fields. These include short text, long text, number, currency, yes/no, date/time, autonumber, hyperlink.

The correct answer states that the third normal form (3NF) requires the satisfaction of the first normal form (1NF), the second normal form (2NF), and that all fields must be unique and fully dependent on the primary key. This means that the data must be organized into tables with atomic values, there should be no partial dependencies, and all non-key fields should depend on the entire primary key.

The correct answer is that the second normal form (2NF) requires that the first normal form (1NF) is satisfied, and that all fields must be unique and fully dependent on the primary key. This means that each field in the table must have a unique value and the value of each field should be determined by the primary key. This ensures that the table is properly organized and eliminates any potential data redundancy or anomalies.

The correct answer is that 1NF requires atomicity of table fields, that all records must have the same number of fields, and that it should not contain repeating values. This means that each field in the table should contain a single value, records should have a consistent structure, and there should be no duplicate values within the table. These requirements help ensure data integrity and eliminate data redundancy in the table.