Tag: databases

Questions Related to databases

Data architecture document does not include:
technology databases

  1. Business Data Model

  2. Logical Data Model

  3. Data Management Process Model

  4. Data entity/business function Matrix

  5. Data Interface requirements

Show answer
Correct Option: E

Students -------------< Cars, This graphic indicates
technology databases

  1. that a student can own 0, 1 or many cars

  2. a car can be owned by many students

  3. a student cannot own a car

  4. a stundent can own many cars and a car can be owned by many students

Show answer
Correct Option: A

What is a 'tuple' ?

technology databases

  1. another name for the key linking different tables in a database

  2. another name for a table in an RDBMS

  3. an attribute attached to a record

  4. a row or record in a database table

Show answer
Correct Option: D

A detailed, logical, and graphical representation of the entities, associations, and data elements for an organization or business area best describes:
technology databases

  1. logical model

  2. data flow diagram

  3. entity-relationship diagram

  4. data tree

Show answer
Correct Option: C

A company has a model consisting of eight entities. The parent entity, "Company," has three child entities: "Employee," "Product," and "Order." The Product entity has a categorization of four entities: "Computer," "Software," "Accessory," and "Clearance." Each entity has only one attribute making up the key attribute. Based on the scenario above, what foreign key appears in the model exactly three times ?

technology databases

  1. computer_id

  2. product_id

  3. company_id

  4. employee_id

  5. order_id

Show answer
Correct Option: C

What is a schema ?

technology databases

  1. A diagram showing the domains of all attributes in the data model

  2. A schedule of data modeling steps

  3. A plan of action for database design

  4. A diagram showing the flow of data in an application

  5. A graphical or language representation of a data model or database

Show answer
Correct Option: E

AI Explanation

To answer this question, you need to understand the concept of a schema. Let's go through each option to understand why it is correct or incorrect:

Option A) A diagram showing the domains of all attributes in the data model - This option is incorrect because a schema does not specifically refer to a diagram showing the domains of all attributes in the data model. While a schema may include information about attribute domains, it is not limited to just this aspect.

Option B) A schedule of data modeling steps - This option is incorrect because a schema is not a schedule of data modeling steps. A schema is a representation of a data model or database, not a schedule or plan.

Option C) A plan of action for database design - This option is incorrect because a schema is not a plan of action for database design. It is a representation of the database structure or data model, not a plan for how to design the database.

Option D) A diagram showing the flow of data in an application - This option is incorrect because a schema is not specifically a diagram showing the flow of data in an application. While a schema may include information about data flow, it is not limited to just this aspect.

Option E) A graphical or language representation of a data model or database - This option is correct because a schema is indeed a graphical or language representation of a data model or database. It describes the structure and organization of the data, including tables, columns, relationships, and constraints.

The correct answer is Option E. This option is correct because it accurately describes what a schema is, which is a graphical or language representation of a data model or database.

Several pieces of information are captured about a book. This information includes: Title, Author First Name, Author Last Name, Book Genre, and Date Published.   Based on the scenario above, what part of the entity relationship is the Title?

technology databases

  1. Entity

  2. Category

  3. Hierarchy

  4. Relationship

  5. Atttibute

Show answer
Correct Option: E

Which one of the following is NOT a characteristic of metadata?
technology databases

  1. Data about data

  2. Describe a data dictionary

  3. Self-describing

  4. Includes user data

  5. Supports its own structure

Show answer
Correct Option: D

Which data model represents how the business world sees the information?

technology databases

  1. Logical Data Model

  2. Physical Data Model

  3. Network Data Model

  4. Conceptual Data Model

Show answer
Correct Option: D

Most RDB designers will accept that in order to deal with the complexities of "real life" transactions, a design needs to reach

technology databases

  1. third normal form

  2. the standard of a flat file

  3. second normal form

  4. first normal form

Show answer
Correct Option: A