What will be the right sequence of the phases of database design- A. Physical Design B. Conceptual Design C. Logical Design D. Requirement collection and analysis Choose the correct answer from the options given below:
D, B, C, A
Database design (Elmasri & Navathe) moves from the users’ needs to an implementation in a fixed order, each phase taking the output of the previous one.
Step 1 — requirement collection and analysis (D): interview users and document data and functional requirements.
Step 2 — conceptual design (B): build a high-level, DBMS-independent schema such as an ER diagram.
Step 3 — logical design, or data-model mapping (C): convert the conceptual schema into the data model of the chosen DBMS, for example relations with keys.
Step 4 — physical design (A): choose storage structures, indexes and access paths for performance.
The order is D, B, C, A. The other sequences place physical design before conceptual or logical design, which is impossible because physical design needs the logical schema.
D, B, C, A option is correct.
Similar Questions
A computer based information system is needed :
I. as it is difficult for administrative staff to process data.
II. due to rapid growth of information and communication technology.
III. due to growing size of organizations which need to process large volume of data.
IV. as timely and accurate decisions are to be taken.
Which of the above statement(s) is/are true ?
Location transparency allows :
I. Users to treat the data as if it is done at one location.
II. Programmers to treat the data as if it is at one location.
III. Managers to treat the data as if it is at one location.
Which one of the following is correct ?
Which of the following statements regarding the features of the object-oriented approach to databases are true ?
(a) The ability to develop more realistic models of the real world.
(b) The ability to represent the world in a non-geometric way.
(c) The ability to develop databases using natural language approaches.
(d) The need to split objects into their component parts.
(e) The ability to develop database models based on location rather than state and behaviour.
Codes :
Match the following database terms to their functions :
List - I List - II (a) Normalization (i) Enforces match of primary key to foreign key (b) Data Dictionary (ii) Reduces data redundancy in a database (c) Referential Integrity (iii) Defines view(s) of the database for particular user(s) (d) External Schema (iv) Contains metadata describing database structure Codes :
Database applications were built directly on top of file system to overcome the following drawbacks of using file-systems :
(a) Data redundancy and inconsistency
(b) Difficulty in accessing Data
(c) Data isolation
(d) Integrity problems
Manager’s salary details are hidden from the employee. This is called as
Match the LIST-I with LIST-II
LIST-I LIST-II A. Project Join Normal Form I. Concurrency B. The lost update problem II. Fifth Normal Form C. Discretionary Access Control III. SQL D. Data manipulation Language IV. Security Choose the correct answer from the options given below:
Arrange the following phases of database design in the correct order :
(A) Physical Design
(B) Conceptual Design
(C) Logical Design
(D) Requirement Analysis
Choose the correct answer from the options given below :
Which of the following statements is/are true w.r.t. Enterprise Resource Planning (ERP) ?
(A) ERP automates and integrates majority of business processes.
(B) ERP provides access to information in a Real Time Environment.
(C) ERP is inexpensive to implement.
Semi-join strategies are techniques for query processing in distributed database system. Which of the following is a semi-join technique ?
Important Questions from Database Introduction
DBMS does not serve as a tool for which of the following?
Which of the following is an advantage of ‘server-database’?
Which one of the following is considered as a threat to database and DBMS ?
Deductive model of DBMS is also known as ______.
_____ is a system database that contains description of the data in the database.
