Today's Topic DataBase Design Process Solved Conceptual MCQs

DataBase Design Process Solved Conceptual MCQs

What is database design?

The design process. Determining the purpose of your database. Finding and organizing the required information. Dividing the information into tables. Turning information items into columns.

Q01) In E-R diagram, a diamond represent a

1. Attributes
2. Relationship
3. Entity
4. Modality

Answer:Relationship

Explanation:An Entity Relationship (ER) Diagram is a type of flowchart that illustrates how “entities” such as people, objects or concepts relate to each other within a system.

Q02) In ERD model, the relationship between two entities is represented by

1. Diamond Symbol
2. Rectangular box
3. Oval Symbol
4. Line

Answer:Diamond Symbol

Explanation:In the ER diagram the relationship between two strong entity set shown by using a diamond symbol. The relationship between one strong and a weak entity set shown by using the double diamond symbol.

Q03) Merging the relation is also known as

1. View integration
2. View entities
3. View relations
4. View tables

Answer: View integration

Explanation: View-based Data Integration is a framework that solves the data integration problem for structured data by integrating sources into a single unified view

Q04) Organizing the database in computer disk storage is done in

1. Logical design
2. Physical design
3. Analysis
4. Conceptual design

Answer:Physical design

Explanation:Physical database design is the process of transforming a data model into the physical data structure of a particular database management system (DBMS)

Q05) All the hardware cost are considered during

1. Project planning.
2. Requirements analysis
3. Data analysis
4. Feasibility study

Answer: Project planning.

Explanation: Project planning is a discipline addressing how to complete a project in a certain timeframe, usually with defined stages and designated resources.

Q06) Which of the following is not included is the definition of entity?

1. Person
2. Object
3. Concept
4. Action

Answer:Concept

Explanation:Concept

Q07) The degree of relation refers to the number of

1. Rows
2. Tables
3. Data
4. Columns

Answer:Columns

Explanation:The degree of a relationship is the number of entity types or Columns that participate(associate) in a relationship.

Q08) The relationship between teacher and students is

1. One to One
2. One to Many
3. Many to Many
4. Many to One

Answer:One to Many

Explanation:Since a teacher can teach many students at a time so teacher share a one-to-many relationship.

Q09) An entity related to itself in an ERD model refers to relationship

1. One to many
2. Recursive
3. Many to many
4. One to one

Answer:Recursive

Explanation:A recursive relationship is a non-identifying relationship between two entities or tables that represents the fact that one company can own another company.

Q10) In an E-R Diagram, a rectangle represents a (n):

1. Entity
2. Attributes
3. Relationship
4. Field

Answer:Entity

Explanation:An entity is an object or component of data. An entity is represented as rectangle in an ER diagram.

Q11) ________ is used to define / describe characteristics of.an entity / object

1. Objects
2. Attributes
3. Records
4. Files

Answer:Attributes

Explanation:Attributes

Q12) A person's name, birthday and social security number are examples of:

1. Attributes
2. Entities
3. Relationships
4. Descriptors

Answer:Attributes

Explanation:Attributes

Q13) Which of the following is a one- to - many relations?

1. (A) Student- Reg No
2. Mother -daughter
3. Person- Date of Birth
4. Country- Capital

Answer: Mother -daughter

Explanation: Mother -daughter

Q14) Which of the following Is not a basic data distribution strategy?

1. Centralized
2. partitioned
3. Replicated
4. Duplicated

Answer:Duplicated

Explanation:Duplicated

Q15) Which of the following is used to associate entities with one another?

1. Entity
2. Relation
3. Relationship
4. Attribute

Answer:Relationship

Explanation:Relationship

Q16) Customers, Cars are example of:

1. Entities
2. Attributes
3. Cardinals
4. Relationship

Answer:Entities

Explanation:Entities

Q17) Color of car is an example of:

1. Entity
2. Relation
3. Relationship
4. Attributes

Answer:Attributes

Explanation:Attributes

Q18) Which of the following defines the nature of relationship?

1. Modality
2. Decision tree os
3. Attribute
4. None of the above

Answer:Modality

Explanation:Modality

Q19) A set of related item in a table is called:

1. Fille
2. Record
3. Query
4. Report

Answer:Record

Explanation:Record

Q20) Duplicate data in multiple data files is called:

1. Data Consistency
2. Data Integrity
3. Data Redundancy
4. Program Dependency

Answer:Data Redundancy

Explanation:Data Redundancy

Q00)

Answer:

Explanation: