dbms design process

mcqspedia.com has 5 Question/Answers about Topic dbms design process

Initial phase of database design is to

Initial phase of database design is to
  • A. Choosing data model
  • B. Conceptual design
  • C. Characterize data needs
  • D. Conceptual schema
  • Correct Answer: Option C

An entity-relationship diagram provides a graphical representation of the

An entity-relationship diagram provides a graphical representation of the
  • A. Context
  • B. Framework
  • C. Schema
  • D. Modules
  • Correct Answer: Option C

In a database design, gathering data needs of prospective database users, comes at stage?

In a database design, gathering data needs of prospective database users, comes at stage?
  • A. First stage
  • B. Second stage
  • C. Third stage
  • D. Fourth stage
  • Correct Answer: Option A

Designer maps high-level conceptual schema onto implementation data model, at level

Designer maps high-level conceptual schema onto implementation data model, at level
  • A. Contextual-design phase
  • B. Physical-design phase
  • C. Logical-design phase
  • D. Virtual-design phase
  • Correct Answer: Option C

Mapping of conceptual schema using entity-relationship model into a relation schema, is achieved at stage

Mapping of conceptual schema using entity-relationship model into a relation schema, is achieved at stage
  • A. Physical-design phase
  • B. Contextual-design phase
  • C. Virtual-design phase
  • D. Logical-design phase
  • Correct Answer: Option D