UML Lec3 Quiz

Description

Data Modelling
Ray Welland
Quiz by Ray Welland, updated more than 1 year ago
Ray Welland
Created by Ray Welland over 8 years ago
29
0

Resource summary

Question 1

Question
Which are TRUE in Database Development Process?
Answer
  • 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

Question 2

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

Question 3

Question
Which is NOT True regarding Database Design Phases?
Answer
  • 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)

Question 4

Question
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
Answer
  • True
  • False

Question 5

Question
Relationships are associations between entities and are given a name to represent its function
Answer
  • True
  • False

Question 6

Question
Which is the correct Multiplicity for a One to One (1:1) relationship?
Answer
  • 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

Question 7

Question
Which is the correct Multiplicity for a One to Many (1:*) relationship?
Answer
  • A student must enrol into one or many modules
  • A student enrols into one module
  • A student may enrols into many modules

Question 8

Question
Which is the correct Multiplicity for a Many to Many (*:*) relationship?
Answer
  • 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

Question 9

Question
What's the correct relationship?
Answer
  • 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

Question 10

Question
Entity attributes can be simple or composite, single or multi-valued and derived?
Answer
  • True
  • False

Question 11

Question
A primary key must be made of two columns that are unique within that table
Answer
  • True
  • False

Question 12

Question
In a relational database, relationships are expressed by foreign keys, linking one entity instance to another
Answer
  • True
  • False

Question 13

Question
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.
Answer
  • True
  • False

Question 14

Question
How would you resolve a many to many relationship?
Answer
  • 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

Question 15

Question
The following is an example of a...
Answer
  • Relationship Trap
  • Fan Trap
  • Entity Trap
  • Ambiguous Trap

Question 16

Question
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
Answer
  • True
  • False
Show full summary Hide full summary

Similar

UML Lec1 Quiz
Ray Welland
UML Lec2 Quiz
Ray Welland
Chapter 3 : Use Cases
Jo Hart
Chapter 6 – Essentials of Design and the Design Activities
Jo Hart
French Verbs
dylankhakh
Chapter 5: Extending the Requirements Model
Jo Hart
Basics in Object Oriented Programming
Bit buddy
Metodos y modelos para desarrollo de sofware
SERGIO GIL HERRERA
los diferentes diagramas en UML
Alexis Tamayo