Question

1.1) A data model is a collection of conceptual tools for describing data, data relationships, data semantics, and data constraints: a) True b) False 1.2) The three levels of data abstractions provided by a DBMS are a) Users, query processor, storage manager b) Logical design, physical design, indexes c) Logical design, physical design, views d) None of the above 1.3) Johnson wants to store information (names, addresses, descriptions of embarrassing moments, etc.) about his employees. Not surprisingly, the volume of data compels him to buy a database management system. To save money, he wants to buy one with the fewest possible features, and he plans to run it as a stand-alone application on his PC. Of course, Johnson does not plan to share his list with anyone. The following questions (1.3.1)-(1.3.3) are about which DBMS features Johnson should 1.3.1) Johnson should buy the Concurrency Control feature: a) True b) False 1.3.2) Johnson should buy the Query Processing feature: a) True b) False 1.3.3) Johnson should buy the Security feature: a) True b) False

Answer 1

1.1)
a. True

Data model is a collection of tools for describing data, it's relationships, semantics and constraints.

1.2)

Physical Level, Logical Level and Views are the 3 data abstractions provided by DBMS ---> Option(c)

1.3)

1.3.1 : False
He needn't buy it because only he uses the database
1.3.2: True
A query language is necessary since Johnson must be able to analyze the dark secrets of his employees or a particular employee

1.3.3: True
As he is not planning to share the data with anyone, he needs security to keep the data safe.

PLEASE UPVOTE IF THE ANSWER WAS HELPFUL!!!