Enterprise data modeling typically occurs during information systems planning.
Answer: A
Correct answer: True
Enterprise data modelling is part of information systems planning: it produces the high-level view of the organisation’s data and identifies which database projects should be undertaken. Doing it at planning time is what allows the projects that follow to fit together rather than overlap.
Please log in or register to report this question.
In enterprise data modeling, which is incorrect?
Answer: B
Correct answer: You implement the new database.
Enterprise data modelling is a planning activity: reviewing the current systems, describing the data at a high level of abstraction, and identifying the database projects worth doing. Implementation comes several steps later, after conceptual, logical and physical design, and is not part of it.
Please log in or register to report this question.
The Enterprise tier of the three-tiered database architecture includes:
Answer: B
Correct answer: managing the data.
The three tiers divide the work: the client tier manages the user-system interface, the department tier does the processing, and the enterprise tier manages the data. The enterprise tier is where the shared database lives, which is what makes it enterprise-wide rather than departmental.
Please log in or register to report this question.
A conceptual schema is usually depicted in graphical format using E-R or object-modeling notations.
Answer: A
Correct answer: True
A conceptual schema is drawn, not written, because its audience includes people who must validate it and who are not database specialists. Entity-relationship or object notation makes the entities, attributes and relationships visible at a glance, which is what makes review by users possible.
Please log in or register to report this question.
The first step in database development is which of the following?
Answer: A
Correct answer: Enterprise data modeling
Enterprise data modelling comes first because it establishes the scope: what data the organisation holds, at a high level, and which database projects are worth undertaking. The later steps - conceptual, logical and physical design, then implementation - all work within the boundaries it sets.
Please log in or register to report this question.
The most important reason for data architecture is reliability.
Answer: B
Correct answer: False
Data architecture exists chiefly to give the organisation a consistent, shared and integrated view of its data, so that the same fact means the same thing everywhere and systems can work together. Reliability is a property of the implementation, achieved by other means and not the reason for the architecture.
Please log in or register to report this question.
Functional decomposition is the process of breaking down the functions of an organization into greater levels of detail.
Answer: A
Correct answer: True
Functional decomposition breaks the organisation’s functions into sub-functions and then into activities, until the level is fine enough to plan work against. It is a standard planning technique, and it produces the framework within which the data requirements of each function can be identified.
Please log in or register to report this question.
There is one physical schema for each logical schema.
Answer: A
Correct answer: True
The three-schema architecture pairs one internal schema with one conceptual schema, so a single logical structure is realised by a single physical arrangement. Many external schemas may sit above the conceptual one, which is where the multiplicity in the architecture lies.
Please log in or register to report this question.
The goal of information systems planning is to align information technology with the business strategies of the organization.
Answer: A
Correct answer: True
Information systems planning exists to make sure the systems built support what the organisation is trying to do. Without that alignment a portfolio of individually sound systems can still fail to serve the business, which is why planning starts from the organisational goals rather than from technology.
Please log in or register to report this question.
