Information Management - Part 1/2

Information Management, FHNW 2020 Digitalization, Database Management, Technical Foundations

108

0.0 (0)

Marco Kofel

Set of flashcards Details

Flashcards	108
Students	25
Language	English
Category	Technology
Level	University
Created / Updated	08.06.2020 / 12.05.2025
Weblink	https://card2brain.ch/box/20200608_information_management
Embed	<iframe src="https://card2brain.ch/box/20200608_information_management/embed" width="780" height="150" scrolling="no" frameborder="0"></iframe>

Card list

Study

Which statements to the normal forms one to three are correct?

A relation with only one attribute, which is also the primary key, is in the third normal form.

To be a relation in the second normal form, each non-key attribute must be indirectly dependent on each other non-key attribute.

An attribute that is not part of the primary key must be independent from the primary key.

In order to be a relation in the third normal form, each non-key attribute must not be transitive dependent on the primary key.

Which statements describe properties of a relation (table)?

A column of the relation corresponds to an attribute.

An entire line corresponds to an attribute.

A relation has a defined number of rows and any number of columns.

Each record of a relation has the same attributes.

Which of the following statements on recursive relationships and part lists are correct?

The recursive relationship types do not have the same rules as the relationship types between different object types.

A parts list describes how a product is made up of other products that have lower production steps.

The "recursive relationship" is a relationship type of and to the same object type.

A recursive relationship always has the cardinality 1:n.

Which statements on "referential integrity" are correct?

The referential integrity prevents all changes that cause foreign keys to reference non-existent data records (primary key values).

Data set A can be deleted if referential integrity is enabled, even if data set B references A (primary key value of A is entered as foreign key value for B, update and delete transfer are disabled).

The referential integrity ensures that references between data records (via primary and foreign key values) are retained.

Data set B cannot be deleted with referential integrity enabled if data set B references A (primary key value of A is entered as foreign key value for B, update and delete transfer are disabled).

Which statements to transform relations from the semantic model into the logical model are correct?

In a 1:n relationship, the primary key is with " 1" and the foreign key is with "n".

In a 1:1 relationship, it is possible to make the primary keys of both relations a foreign key in the other relationship. However, only one variant should be selected.

In an n:m relationship, the primary key with "n" is in relation to the foreign key with "m" is and vice versa.

In an n:m relationship, no primary key becomes the foreign key in the other relation. A new relation is needed that is derived from the relationship type.

Which statements regarding the criteria in the query dialog (e.g. from Microsoft Access) are correct?

No operators like (<), (>) and (=) can be used for criteria in the query dialog.

In the query dialog operators like (<), (>) and (=) can be used for criteria.

Only comparative operators like (<), (>) and (=) criteria can be used in the query dialog.

In the query dialog operators like AND and OR can be used for criteria.

This specifies which conditions a data set must fulfill in a combination.

AND

WHERE

HAVING

This specifies which conditions a data record must partially fulfill in a combination.

AND

WHERE

HAVING

This specifies which conditions a data record must fulfill in order to be processed.

AND

WHERE

HAVING

This specifies which conditions a group of data records must fulfill in order to continue to be used.

AND

WHERE

HAVING

All tables that are to be merged in the query are listed after the SQL query element "JOIN".

Combination

Projection

Selection

The term refers to the selection of single attributes (columns) of a table or stored query.

Combination

Projection

Selection

The SQL query element "WHERE" is mostly used to choose records.

Combination

Projection

Selection

The attributes that are to be displayed must be listed after the SQL query element "SELECT".

Combination

Projection

Selection

The term refers to the selection of certain rows (data records) as a subset of a table or stored query.

Combination

Projection

Selection

Which statements about SQL in general are correct?

Manufacturers of database systems strictly adhere to the pure SQL standard. There are no proprietary extensions.

SQL queries return the results in table form.

SQL is the most common language for database systems.

SQL has a relatively low instruction set.

Which statements about SQL commands are correct?

SELECT is the command for data queries.

Database tables can be created with INSERT INTO.

The age of a table can be queried with ALTER TABLE.

DROP TABLE deletes a data record from a table.

Which statements about the query concepts "projection" and "selection" are correct?

Projection and selection can be combined.

A projection always shows a subset of the existing data records in the result.

A projection is achieved by column selection (attribute selection).

A selection always results in a grouping of data records (functions).

Which statements on the query concept "JOIN" are correct?

JOIN can be combined with restricting criteria (selection).

JOIN is a query concept that makes data denormalization.

JOIN is a query concept that cannot be combined with other concepts.

You can query data records from two or more tables with JOIN.

Which statements about grouping records in SQL queries are correct??

The grouping of data records is only possible with two attribute values.

The minimum value (minimum) and the maximum value (maximum) for attributes can be output via the grouping.

The grouping allows the calculation of statistical values such as "average" and "standard deviation".

The grouping function "Count " can only be applied to numbers.

What does the abbreviation SQL stand for?

Simple Query Language

Simplified Question Language

Structured Query Language

Stored Question Language

Which statements to the elements of the SQL command SELECT are correct?

The attributes to be output in the result are specified directly after SELECT.

JOIN specifies which conditions a data record must fulfill in order to be processed.

FROM specifies from which tables data records are queried.

DISTINCT always outputs multiple identical data records.

Allows data records to be grouped and processed with special functions.

GROUP BY

JOIN

ORDER BY

SELECT

FROM

Allows to sort the resulting records in ascending or descending order.

GROUP BY

ORDER BY

JOIN

SELECT

FROM

Declares which tables in the query are linked and how they are linked.

GROUP BY

ORDER BY

JOIN

SELECT

FROM

Indicates which attributes should be displayed and how they should be used in calculations and functions.

GROUP BY

ORDER BY

JOIN

SELECT

FROM

Indicates from which tables or saved queries records are retrieved.

GROUP BY

ORDER BY

JOIN

SELECT

FROM

Which statements about nested queries are correct?

A previously saved query can be specified as data source as a table (relation).

Queries cannot be connected (JOIN) like "normal" tables (relations) in a query.

A query can be used as a filter (criterion) in a query.

A query can be completely inserted after FROM in the query (in the SQL editor).

Kartenliste

Lernen

Information Management - Part 1/2

Create or copy sets of flashcards

Create or copy sets of flashcards

Log in to see all the cards.

SWITCHaai

Office 365

Edulog

Apple ID

Google