CASE tools do not include which of the following features?
Answer: C
Correct answer: Help to manage people
CASE tools work on the model and the code: drawing diagrams, generating code, maintaining a repository of metadata, checking consistency. Managing people is a project management function, served by different tools and by different disciplines altogether.
Please log in or register to report this question.
Which of the following database activities require a specific knowledge of a DBMS?
Answer: D
Correct answer: Physical database design and definition
Physical design is where the choice of product finally matters: indexes, file organisations, data types, storage parameters and tuning options are all specific to the DBMS in use. Everything above it - enterprise, conceptual and logical design - is deliberately kept independent of any particular product.
Please log in or register to report this question.
With an enterprise data model, it is much easier to build applications because you know exactly what data exist and what needs to be added.
Answer: A
Correct answer: True
An enterprise data model shows what data the organisation already holds and where, so a new application can be built on what exists rather than duplicating it, and the gaps are visible from the outset. That is the practical return on the modelling effort.
Please log in or register to report this question.
Which is not a relevant feature of CASE tools?
Answer: D
Correct answer: Access to a DB via the Internet
CASE tools support the development of the system: drawing data models, generating code, and holding the metadata in a repository. Providing users with internet access to a running database is an application function, delivered by the system that was built rather than by the tool that built it.
Please log in or register to report this question.
Whose role is it to determine the requirements and design for a database?
Answer: A
Correct answer: Database analysts
Determining requirements and producing the design is analysis and design work, and it is the database analyst’s role. The database administrator is responsible for the database in operation - installation, security, backup, tuning and availability - which is a distinct set of duties.
Please log in or register to report this question.
During logical database design, the conceptual data model is transformed into a logical data model which describes the data in terms of a specific data management technology.
Answer: A
Correct answer: True
This is exactly the boundary between the two stages. The conceptual model is independent of any technology; logical design converts it into the structures of a particular technology - relations for a relational database, classes for an object one - but still without regard to a specific product’s physical options.
Please log in or register to report this question.
Which is not a type of data management technology?
Answer: B
Correct answer: Rational
Relational, object-oriented and dimensional are the three data management technologies a logical design may target, each with its own structures and its own products. Rational is not one of them - the similarity of the word to relational is the whole of the trap.
Please log in or register to report this question.
There are three stages involved when analyzing the initiation of an information systems project.
Answer: B
Correct answer: False
The stages recognised in analysing a project’s initiation are not three. The point of the item is the count rather than the content, and the correct figure is different - which is worth checking against the source rather than assuming the round number offered.
Please log in or register to report this question.
User views are included as part of which schema?
Answer: C
Correct answer: External
An external schema is the view a particular user group has of the database - the subset they may see, presented in the form that suits them. Several external schemas sit over one conceptual schema, which is what allows different groups to be given different views of the same data.
Please log in or register to report this question.
Packaged data models can reduce implementation times and costs.
Answer: A
Correct answer: True
A packaged model is a structure already worked out and tested in the industry, so a project starting from it skips a good deal of analysis and avoids some known mistakes. The saving is real, provided the effort of tailoring it to the organisation is not underestimated.
Please log in or register to report this question.
