Tag: architecture

Questions Related to architecture

An atomic field is

  1. a key that contains only a single field

  2. a key field

  3. a numerical field

  4. a single valued field


Correct Option: D
  1. replace relational design

  2. be close to a users perception of the data

  3. enable detailed descriptions of data query processing

  4. enable low level descriptions of data


Correct Option: B
  1. that a student can own 0, 1 or many cars

  2. a car can be owned by many students

  3. a student cannot own a car

  4. a stundent can own many cars and a car can be owned by many students


Correct Option: A
  1. An ER model is concerned primarily with a physical implementation of the data and secondly with a logical view

  2. An ER model provides a view of the logic of the data and not the physical implementation

  3. An ER model is concerned primarily with a logical view of the data and secondly with the physical implementation

  4. An ER model is entirely concerned with modelling the physical implementation


Correct Option: B
Explanation:

To solve this question, the user needs to understand what an entity-relationship (ER) model is and its primary function.

An ER model is a graphical representation of the entities and their relationships to each other. It provides a logical view of the data, which means that it focuses on the conceptual and semantic understanding of the data rather than its physical implementation.

Now, let's go through each option and explain why it is right or wrong:

A. An ER model is concerned primarily with a physical implementation of the data and secondly with a logical view. This statement is incorrect because ER models are primarily concerned with the logical view of the data, not the physical implementation. While a physical implementation may be considered, it is not the primary focus of an ER model.

B. An ER model provides a view of the logic of the data and not the physical implementation. This statement is correct. ER models provide a logical view of the data, which means they focus on the conceptual and semantic understanding of the data rather than its physical implementation.

C. An ER model is concerned primarily with a logical view of the data and secondly with the physical implementation. This statement is correct. ER models are primarily concerned with the logical view of the data and secondarily with the physical implementation. However, it is important to note that the physical implementation is only considered after the logical view has been established.

D. An ER model is entirely concerned with modelling the physical implementation. This statement is incorrect. ER models are concerned with the logical view of the data, not the physical implementation.

Therefore, the correct answer is: The Answer is: B. An ER model provides a view of the logic of the data and not the physical implementation.

An instance is

  1. an attribute of an entity

  2. a special type of relation

  3. a particular occurance of an entity (e.g. Tom Osman is an instance of the entity STUDENT)

  4. any particular entity


Correct Option: C
  1. another name for the key linking different tables in a database

  2. another name for a table in an RDBMS

  3. an attribute attached to a record

  4. a row or record in a database table


Correct Option: D
  1. is achieved using an information flow digram

  2. uses a dataflow diagram

  3. is necessary to remove database anomalies through normalization

  4. is the same as process modelling

  5. is all of the above


Correct Option: C

Conceptual data modeling is typically done in parallel with other requirements analysis and structuring steps during:

  1. system planning and selection

  2. systems design

  3. systems analysis

  4. systems implementation and operation

  5. systems evaluation


Correct Option: C