UML Lec3 Quiz

Pregunta 1 de 16

1

Which are TRUE in Database Development Process?

Selecciona una o más de las siguientes respuestas posibles:

Conceptual Data Model: Data analysis identify data requirements and capture them graphically
Logical Model: Convert the conceptual data model into the chosen data model for implementation, e.g. Relational model
Implementation: Implement the design using chosen DBMS software
Data Modeller: Use the software to design the database

Explicación

Pregunta 2 de 16

1

Design Methodology: A structured approach that uses procedures, techniques, tools, and documentation aids to support and facilitate the process of design?

Selecciona uno de los siguientes:

VERDADERO
FALSO

Explicación

Pregunta 3 de 16

1

Which is NOT True regarding Database Design Phases?

Selecciona una de las siguientes respuestas posibles:

Phase 1: Conceptual design (The process of constructing a model of the information used in an enterprise, independent of all physical consideration)
Phase 2: Logical design (The process of constructing a model of data used in an organization based on a specific data model, but independent of a particular DBMS and other physical considerations)
Phase 3: Physical design (The process of producing a description of the implementation of the database considering the target DBMS and other physical representations)
Phase 4: Deployment design (Deploy the database on the chosen DBMS)

Explicación

Pregunta 4 de 16

1

An Entity is an object or thing we wish to store information about, and when we group a set of objects with the same properties, having an independent existence as an entity

Selecciona uno de los siguientes:

VERDADERO
FALSO

Explicación

Pregunta 5 de 16

1

Relationships are associations between entities and are given a name to represent its function

Selecciona uno de los siguientes:

VERDADERO
FALSO

Explicación

Pregunta 6 de 16

1

Which is the correct Multiplicity for a One to One (1:1) relationship?

Selecciona una de las siguientes respuestas posibles:

An employ has one or less than one cars, a car belongs to only one or less employees
An employ has one car, a car belongs to only one employee
An employ must have one car, a car must belong to only one employee

Explicación

Pregunta 7 de 16

1

Which is the correct Multiplicity for a One to Many (1:*) relationship?

Selecciona una de las siguientes respuestas posibles:

A student must enrol into one or many modules
A student enrols into one module
A student may enrols into many modules

Explicación

Pregunta 8 de 16

1

Which is the correct Multiplicity for a Many to Many (:) relationship?

Selecciona una de las siguientes respuestas posibles:

A member of staff manage many properties
Many members of staff manage many properties
None or many members of staff manage none or many properties

Explicación

Pregunta 9 de 16

1

What's the correct relationship?

Selecciona una de las siguientes respuestas posibles:

Person doesn't have a car. A car is owned by no people
Person may have a car. A car is owned by one person
Person may have a car. A car is owned by one or more people

Explicación

Pregunta 10 de 16

1

Entity attributes can be simple or composite, single or multi-valued and derived?

Selecciona uno de los siguientes:

VERDADERO
FALSO

Explicación

Pregunta 11 de 16

1

A primary key must be made of two columns that are unique within that table

Selecciona uno de los siguientes:

VERDADERO
FALSO

Explicación

Pregunta 12 de 16

1

In a relational database, relationships are expressed by foreign keys, linking one entity instance to another

Selecciona uno de los siguientes:

VERDADERO
FALSO

Explicación

Pregunta 13 de 16

1

A many-to-many relationship does not allow this relationship expression, because each record in each table may point to multiple records in the other table.

Selecciona uno de los siguientes:

VERDADERO
FALSO

Explicación

Pregunta 14 de 16

1

How would you resolve a many to many relationship?

Selecciona una o más de las siguientes respuestas posibles:

Introduce a third table
Third table should have primary keys of both tables as foreign keys
This third table will have two composite primary keys
This third table will have a composite primary key

Explicación

Pregunta 15 de 16

1

The following is an example of a...

Selecciona una o más de las siguientes respuestas posibles:

Relationship Trap
Fan Trap
Entity Trap
Ambiguous Trap

Explicación

Pregunta 16 de 16

1

Developing an ER Model involves the following steps:
Step 1 – Identify entities,
Step 2 – Work out relationships,
Step 3 – Identify attributes,
Step 4 – Identify optionality,
Step 5 – Identify key attributes,
Step 6 – Create data dictionary

Selecciona uno de los siguientes:

VERDADERO
FALSO

	Creado por Ray Welland hace más de 10 años

Data Modelling

UML Lec3 Quiz

Pregunta 1 de 16

Which are TRUE in Database Development Process?

Selecciona una o más de las siguientes respuestas posibles:

Explicación

Pregunta 2 de 16

Design Methodology: A structured approach that uses procedures, techniques, tools, and documentation aids to support and facilitate the process of design?

Selecciona uno de los siguientes:

Explicación

Pregunta 3 de 16

Which is NOT True regarding Database Design Phases?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 4 de 16

An Entity is an object or thing we wish to store information about, and when we group a set of objects with the same properties, having an independent existence as an entity

Selecciona uno de los siguientes:

Explicación

Pregunta 5 de 16

Relationships are associations between entities and are given a name to represent its function

Selecciona uno de los siguientes:

Explicación

Pregunta 6 de 16

Which is the correct Multiplicity for a One to One (1:1) relationship?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 7 de 16

Which is the correct Multiplicity for a One to Many (1:*) relationship?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 8 de 16

Which is the correct Multiplicity for a Many to Many (*:*) relationship?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 9 de 16

What's the correct relationship?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 10 de 16

Entity attributes can be simple or composite, single or multi-valued and derived?

Selecciona uno de los siguientes:

Explicación

Pregunta 11 de 16

A primary key must be made of two columns that are unique within that table

Selecciona uno de los siguientes:

Explicación

Pregunta 12 de 16

In a relational database, relationships are expressed by foreign keys, linking one entity instance to another

Selecciona uno de los siguientes:

Explicación

Pregunta 13 de 16

A many-to-many relationship does not allow this relationship expression, because each record in each table may point to multiple records in the other table.

Selecciona uno de los siguientes:

Explicación

Pregunta 14 de 16

How would you resolve a many to many relationship?

Selecciona una o más de las siguientes respuestas posibles:

Explicación

Pregunta 15 de 16

The following is an example of a...

Selecciona una o más de las siguientes respuestas posibles:

Explicación

Pregunta 16 de 16

Developing an ER Model involves the following steps: Step 1 – Identify entities, Step 2 – Work out relationships, Step 3 – Identify attributes, Step 4 – Identify optionality, Step 5 – Identify key attributes, Step 6 – Create data dictionary

Selecciona uno de los siguientes:

Explicación

Which is the correct Multiplicity for a Many to Many (:) relationship?

Developing an ER Model involves the following steps:
Step 1 – Identify entities,
Step 2 – Work out relationships,
Step 3 – Identify attributes,
Step 4 – Identify optionality,
Step 5 – Identify key attributes,
Step 6 – Create data dictionary