COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
to organize, scope and define business concepts and rules.
|
|
|
to develop technical map of rules and data structures.
|
|
|
actual implementation of the database.
|
|
|
To ensure that all data objects required by the database are accurately represented.
|
Detailed explanation-1: -The primary goal of using data model are: Ensures that all data objects required by the database are accurately represented. Omission of data will lead to creation of faulty reports and produce incorrect results. A data model helps design the database at the conceptual, physical and logical levels.
Detailed explanation-2: -The goal is to illustrate the types of data used and stored within the system, the relationships among these data types, the ways the data can be grouped and organized and its formats and attributes. Data models are built around business needs.
Detailed explanation-3: -Data models describe how a database’s logical structure is represented. In a database management system, data models are essential for introducing abstraction. Data models specify how data is linked to one another, as well as how it is handled and stored within the system.
Detailed explanation-4: -Entity-relationship Model This conceptual design provides a better view of the data that helps us easy to understand. In this model, the entire database is represented in a diagram called an entity-relationship diagram, consisting of Entities, Attributes, and Relationships.
Detailed explanation-5: -Relational data model In this model, data is stored in tables and columns and the relationships between the data elements in them are identified. It also incorporates database management features such as constraints and triggers. The relational approach became the dominant data modeling technique during the 1980s.