702096
Beschreibung
Quiz von Ray Welland, aktualisiert more than 1 year ago
|
Erstellt von Ray Welland
vor mehr als 10 Jahre
|
|
Frage 1
Frage
Which are TRUE in Database Development Process?
Antworten
-
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
Frage 2
Frage
Design Methodology: A structured approach that uses procedures, techniques, tools, and documentation aids to support and facilitate the process of design?
Antworten
- True
- False
Frage 3
Frage
Which is NOT True regarding Database Design Phases?
Antworten
-
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)
Frage 4
Frage
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
Antworten
- True
- False
Frage 5
Frage
Relationships are associations between entities and are given a name to represent its function
Antworten
- True
- False
Frage 6
Frage
Which is the correct Multiplicity for a One to One (1:1) relationship?
Antworten
-
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
Frage 7
Frage
Which is the correct Multiplicity for a One to Many (1:*) relationship?
Antworten
-
A student must enrol into one or many modules
-
A student enrols into one module
-
A student may enrols into many modules
Frage 8
Frage
Which is the correct Multiplicity for a Many to Many (*:*) relationship?
Antworten
-
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
Frage 9
Antworten
-
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
Frage 10
Frage
Entity attributes can be simple or composite, single or multi-valued and derived?
Antworten
- True
- False
Frage 11
Frage
A primary key must be made of two columns that are unique within that table
Antworten
- True
- False
Frage 12
Frage
In a relational database, relationships are expressed by foreign keys, linking one entity instance to another
Antworten
- True
- False
Frage 13
Frage
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.
Antworten
- True
- False
Frage 14
Frage
How would you resolve a many to many relationship?
Antworten
-
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
Frage 15
Antworten
-
Relationship Trap
-
Fan Trap
-
Entity Trap
-
Ambiguous Trap
Frage 16
Frage
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
Antworten
- True
- False
Möchten Sie mit GoConqr kostenlos Ihre eigenen Quiz erstellen? eigenen Mehr erfahren.