Quiz
UML Lec3 Quiz
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