Quiz
UML Lec3 Quiz
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (16)
1Which are TRUE in Database Development Process?
- AConceptual Data Model: Data analysis identify data requirements and capture them graphically
- BLogical Model: Convert the conceptual data model into the chosen data model for implementation, e.g. Relational model
- CImplementation: Implement the design using chosen DBMS software
- DData Modeller: Use the software to design the database
- AConceptual Data Model: Data analysis identify data requirements and capture them graphically
2Design Methodology: A structured approach that uses procedures, techniques, tools, and documentation aids to support and facilitate the process of design?
- ATrue
- BFalse
3Which is NOT True regarding Database Design Phases?
- APhase 1: Conceptual design (The process of constructing a model of the information used in an enterprise, independent of all physical consideration)
- BPhase 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)
- CPhase 3: Physical design (The process of producing a description of the implementation of the database considering the target DBMS and other physical representations)
- DPhase 4: Deployment design (Deploy the database on the chosen DBMS)
4An 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
- ATrue
- BFalse
5Relationships are associations between entities and are given a name to represent its function
- ATrue
- BFalse
6Which is the correct Multiplicity for a One to One (1:1) relationship?
- AAn employ has one or less than one cars, a car belongs to only one or less employees
- BAn employ has one car, a car belongs to only one employee
- CAn employ must have one car, a car must belong to only one employee
7Which is the correct Multiplicity for a One to Many (1:*) relationship?
- AA student must enrol into one or many modules
- BA student enrols into one module
- CA student may enrols into many modules
8Which is the correct Multiplicity for a Many to Many (*:*) relationship?
- AA member of staff manage many properties
- BMany members of staff manage many properties
- CNone or many members of staff manage none or many properties
9What's the correct relationship?
- APerson doesn't have a car. A car is owned by no people
- BPerson may have a car. A car is owned by one person
- CPerson may have a car. A car is owned by one or more people
10Entity attributes can be simple or composite, single or multi-valued and derived?
- ATrue
- BFalse
11A primary key must be made of two columns that are unique within that table
- ATrue
- BFalse
12In a relational database, relationships are expressed by foreign keys, linking one entity instance to another
- ATrue
- BFalse
13A 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.
- ATrue
- BFalse
14How would you resolve a many to many relationship?
- AIntroduce a third table
- BThird table should have primary keys of both tables as foreign keys
- CThis third table will have two composite primary keys
- DThis third table will have a composite primary key
15The following is an example of a...
- ARelationship Trap
- BFan Trap
- CEntity Trap
- DAmbiguous Trap
16Developing 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- ATrue
- BFalse
Information
- Description
- Data Modelling
- Author
- Ray Welland
- Language
- English
- Views
- 84
- Tags
- Rating
- No ratings yet Rate this quiz