ERWIN Quiz
ERWIN Quiz : This ERWIN Beginner Quiz contains set of 150 ERWIN Quiz which will help to clear any exam which is designed for Beginner.
1) The property of data elements which indicates the number of allowable entries in that element is called
- Data Cardinality
- Fast Changing Property
- Data Repeatability
- Data Rationality
2) What is the overlap between Optionality and Cardinality?
- both represents maximum number of occurrences
- both represents minimum number of occurrences
- both represents minimum and maximum number of occurrences
- No overlap
3) What is the cardinality ratio for a binary relationship of type M:N ?
- One or more
- More than One
- Zero or more
- Infinite
4) —————– is an entity that cannot be uniquely identified by its own attributes alone
- sub entity
- weak entity
- minor entity
- None of the above
5) Fact table in dimensional modeling is an example of
- weak entity
- strong entity
- sub entity
- None of the above
6) What do you mean by Dependency of Entity?
- Entity is dependent or independent of other entity.
- Entity is Independent of other entity.
- Entity is dependent on other entity.
- None of the above.
7) Which of the following can NOT be an Entity type?
- Employee
- Customer
- Employer
- Emloyee Id
8) —————– is an entity that can be uniquely identified by its own attributes alone
- sub entity
- weak entity
- minor entity
- Strong entity
9) Weak entity is also referred as
- Major entity
- Minor entity
- Dependent entity
- Independent entity
10) Which of the following are not properties of entities
- Entities are usually recognizable concepts
- They are either concrete or abstract
- Entities are classified as independent only
- Entities are classified as independent or dependent
11) What is Data Model ?
- A collection of concepts that can be used to describe the structure of a database
- Representation of a set of business requirements in a standard structured framework understood by the users
- Both A and B
- None
12) Choose the most correct option of the 4 available options
- Ralph Kimball believes that portions of data can be combined based on relevance of data and can be used for reporting
- Inmon believes that portions of data can be combined based on relevance of data and can be used for reporting
- Ralph Kimball believes that DW is built and should be used for reporting.
- Both B & C
13) The process of combining two tables in a relational database is known as
- a Join
- a Combine
- a Relate
- a Construct
14) The Union of a table of N rows and of a table of M rows (M<=N) has the following number of rows:
- M+N
- A number in the range N to M+N
- N
- A number in the range 0 to M
15) An alternate key is also a
- Primary Key
- Candidate Key
- Foreign Key
- None of the Above
16) Which attribute would make the best primary key?
- Social security number
- Last name
- First name
- Age
17) Which can be a Primary Key for Employee table?
- Employee Name
- Employee Role
- Employee Number
- Employee first name
18) Which can Never be implemented as a Primary Key for Customer table?
- Customer Id
- Customer Number
- Account Number
- ZIP Code
19) Which of the following is a valid key field
- A Book Title
- House number + Street Name
- Car Registration number
- Initials + Family Name + Date of Birth
20) Which is not True about surrogate key
- Unique identifier for entity
- Unique identifier for DB object
- derived from application data
- not derived from application data
21) Maximum modeling effort needs to be on
- Conceptual Data Model
- Logical Data Model
- Physical Data Model
- Metadata model
22) How do you resolve Many-to-Many relations in the logical design?
- by adding one more orphan entity
- by adding one more relation
- by removing one entity from the model
- none of the above
23) How do you resolve One-to-One relationships while doing the logical design ?
- by merging both the entities as one entity without loosing any attribute.
- by removing one entity
- by adding one more entity and creating one-to-one relation between them.
- depends on a particular situation
24) A puristic Business Representation of data with entity and relationships only is called as
- Logical Model
- Conceptual Model
- Business Model
- None of the above
25) The ____ data model follows a treelike structure.
- distributed
- hierarchical
- network
- relational
26) The data model that captures the business rules of the orgranization
- Conceptual
- Logical
- Physical
27) The data model that captures the business view
- Conceptual
- Logical
- Physical
28) The data model that is dependant on the technology & database
- Conceptual
- Logical
- Physical
- Business model
29) The data model wherein most of the modeling effort is contributed
- Conceptual
- Logical
- Physical
30) The data model which the desginers look for
- Conceptual
- Logical
- Physical
- None of the above
31) The data model which the implementors look for
- Conceptual
- Logical
- Physical
- None of the above
32) The Entity Relation Model models
- Entities
- Relationships
- Entities, Relationships and Processes
- Entities and Relationships
33) The ER model is meant to
- enable low level descriptions of data
- replace relational design
- be close to a users perception of the data
- enable detailed descriptions of data query processing
34) The type of data model which the business users look for
- Conceptual
- Logical
- Physical
- None of the above
35) What are different types of Data Model ?
- Physical model, Logical model
- Hybrid model
- Conceptual model
- Both A and C
36) What comes before the Logical DM?
- PDM
- LDM
- Conceptual Data Model
37) Which data model depicts a semantic layer representing business view?
- Conceptual
- Logical
- Physical
- None of these
38) Which data model depicts the business rules of an organization?
- Conceptual Data Model
- Subject Area Data Model
- Logical Data Model
- Physical Data Model
39) Which data model is not independent of the database technology?
- Conceptual Data Model
- Logical Data Model
- Physical Data Model
- Metadata model
40) Which data model is RDBMS dependent?
- Conceptual Data Model
- Logical Data Model
- Physical Data Model
- Subject Area data model
41) Which data model is the most detailed specific one?
- Conceptual
- Logical
- Physical
- None of these
42) Which data model is the most generic and abstract?
- Conceptual
- Logical
- Physical
- None of these
43) Which is the detailed specific data model amongst the mentioned ones?
- Conceptual Data Model
- Subject Area Data Model
- Metadata model
- Physical Data Model
44) Which is traditional modeling approach?
- Entity Relational Modeling
- Dimensional Modeling
- Snow flake Modeling
- None of these
45) Which step is done first in a Data Modeling development life cycle?
- Logical Modeling
- Physical Modeling
- Conceptual Modeling
- None of the choices
46) After which stage will you carry out the data staging design and development?
- Dimensional modeling
- Physical design
- Technical architecture design
- Requirements definition
47) What is the correct sequence of data modeling phases?
- Conceptual data modeling -> logical data modeling -> physical data modeling
- Physical data modeling -> conceptual data modeling -> logical data modeling
- Conceptual data modeling -> physical data modeling -> logical data modeling
- None of these
48) Which data model is independent of Physical, data storage device.
- Logical Model
- Physical Moddel
- Both A & B
- None of these
49) Which model will define how the business operates?
- Data Model
- Metadata model
- Process Model
- None of these
50) What are the different types of relationship notations ?
- IEX
- IDFIX
- IE
- Both B and C
51) In this notation, entities are represented by boxes, and relationships by labelled arcs
- Crow’s foot
- UML
- Bachman
- IDEF
52) Which is the correct Data Modeling notation?
- ER Model
- Information Engineering (IE)
- Star schema
- None of these
53) _____ ensure that attributes are allocated to the correct entity type.
- Normalization
- De-Normalization
- Datamodeling
- Optimization
54) ______ is the lowest normal form requiring Primary Key identification
- 1NF
- 2NF
- 3NF
- 4NF
55) A goal of normalization is to
- minimize the number of relationships
- minimize the number of entities
- minimize the number of tables
- minimize data redundancy
56) A table MOVIES in an object-oriented database consists of the attributes title (the primary key), year-produced, and actor-name; actor-name is a repeating group; different movies may have different numbers of actors. The table MOVIES violates the followin
- 1NF
- 2NF
- 3NF
- 4NF
57) A table that satisfies 2NF:
- Always satisfies 1NF
- May violate 1NF
- Always satisfies 3NF
- None of the above
58) A table that satisfies 3NF:
- Always satisfies 2NF
- May violate 2NF
- May satisfy 2NF
- None of the above
59) A table with a unique key and without any repeatable columns is in _NF
- 5th
- 6th
- 3rd
- 1st
60) Characteristics of Third Normal Form
- Table should be in 2nd NF
- no transitive dependencies
- Partial functional dependency
- a and b
61) OLTP(Online transaction Processing) Data Models are mostly designed using
- 1NF
- 2NF
- 3NF
- 4NF
62) If columns in a relational table are not repeating group or arrays then the table is in
- first normal form
- second normal form
- third normal form
- 4th normal form
63) In a 2ND NORMAL FORM (2NF) relation
- all non-key attributes are dependent only on the key
- all non-key attributes are functionally dependent on every attribute value making up the key
- All the key attributes are atomic
- None of the above
64) In which normal form we remove non-key attributes that are partially dependent on the primary key.
- 1 NF
- 3 NF
- 2 NF
- BCF
65) Move attributes that are not functionally dependent on the entire primary key to their own entity type. This happens in which normal form?
- 1NF
- 2NF
- 3NF
- BCNF
66) Primary Key are identified in which form
- 1NF
- 2NF
- 3NF
- 4NF
67) Removing Partial Dependencies is a step towards getting to
- 1NF
- 2NF
- 3NF
- BCNF
68) The rule that prohibits transitive dependencies is
- third normal form
- first normal form
- second normal form
- None of the Above
69) The rule that requires that each non-key field (attribute) should be fully functionally dependent on the primary key is
- Third Normal Form
- First Normal Form
- Second Normal Form
- None of the Above
70) The rule that specifies that there should be no repeating fields and that fields should be atomic is
- third normal form
- second normal form
- first normal form
- None of the Above
71) Which normal form is used for most data model development?
- 1NF
- 2NF
- 3NF
- 4NF
72) Which normalization form recommend: “Eliminate Columns Not Dependent On Key”?
- 1NF
- 2NF
- 3NF
- 4NF
73) An object/entity in an application contains an array of values (among other properties). Referring to the scenario above, storing this object in a single column of a single table violates which normal form?
- 1st
- 2nd
- 3rd
- 4th
74) Every non key attribute is non transitively dependent on the primary key – which level of Normalization are we in?
- 1
- 3
- 2
- Boyce Codd
75) What may be the result of over normalization?
- It will improve database performance
- It may degrade database performance
- No impact on performance
- None of the above
76) Which is NOT true for Normalization?
- Normalization can validate the accuracy of a model in reflecting business requirement.
- Normalization ensures that attributes are allocated to the correct entity type.
- Normalization ensures that entity types contain data about only one thing.
- Normalization verifies structural correctness.
77) Column data type finalization takes place during
- Conceptual Data Modeling
- Logical Data Modeling
- Physical Data Modeling
- None of these
78) Database schema (DDL) is generated from
- Physical Data Model
- Logical Data Model
- Conceptual Data Model
- Subject Area data model
79) Database schema is implemented from
- Conceptual Data Model
- Logical Data Model
- Physical Data Model
- Metadata model
80) RDBMS specific features are implemented in
- Physical Data Model
- Metadata model
- Conceptual Data Model
- Logical Data Model
81) What is Physical Data Model ?
- Conceptual
- Geared for performance and may consists of redundant data
- Both A and B
- None
82) When transforming a Logical Model to a Physical model what technique is used
- Dimensional Modeling
- Normalization
- Denormalization
- None of the above.
83) Bit mapped indexing can be used
- When the distinct value of a column is high
- When the distinct value of a column is low
- When the storage space available is less
- When the table has a few rows
84) Correct attribute / column data type selection is done during
- Conceptual Data Modeling
- Logical Data Modeling
- Physical Data Modeling
- None of these
85) DBAs typically get involved during ____ phase
- Conceptual Data Modeling
- Logical Data Modeling
- Physical Data Modeling
- Subject Area Data Modeling phase
86) IF I want to store true / false in sql values from my frontend which datatype should I use at the best level interms of minimum storage?
- Char
- Varchar
- Bit
- Int
87) In which model do you define a Database View object?
- Conceptual Data Model
- Logical Data Model
- Physical Data Model
- None of the above
88) In which model do you define database partitioning strategy?
- Conceptual Model
- Logical Model
- Physical Model
- None of the above
89) What are Default Values in Data Model?
- The physical value a column is defaulted to
- The logical value a column is defaulted to
- Default Values are associated with entities in logical design
- None of the above
90) Which of the following data model is used for creating Database Objects ?
- Conceptual Model
- Logical Model
- Physical Model
- None of the above
91) You are in the process of deciding the indexes required for your application DB.
This process belong to which of the following phase ?
- Physical design
- Logical design
- Optimization plan
- Fall back plan
92) Cross-reference (X-Ref) table design is part of
- Conceptual Data Model
- Logical data model
- Physical data model
- None of these
93) How do you define the below scenario/action in physical data model ?
Scenario/action: Each time an instance in the parent entity is deleted, the foreign key
attribute(s) in each related instance in the child entity are set to NULL
- By Using Cascade option
- By Using Restrict option
- By Using Set Null
- By Using Set Default
94) How do you define the below scenario/action in physical data model ?
Scenario/action: Each time an instance in the parent entity is deleted, the foreign
key attribute(s) in each related instance in the child entity are set to the
specified default value.
- By Using Cascade option
- By Using Restrict option
- By Using Set Null
- By Using Set Default
95) How do you define the below scenario/action in physical data model?
Scenario/action: Deletion of an instance in the parent entity is prohibited if there are one or more related instances in the child entity.
- By Using Cascade option
- By Using Restrict option
- By Using Set Null
- By Using Set Default
96) How do you define the below scenario/action in physical data model?
Scenario/action: Each time an instance in the parent entity is deleted, each related instance in the child entity must also be deleted.
- By Using Cascade option
- By Using Restrict option
- By Using Set Null
- By Using Set Default
97) How do you prevent users from adding records to a related table if there is no associated record in the primary table?
- By enforcing Referencial integrity
- By Data integrity
- By Unique Constraint
- None
98) The entity integrity rule states that the value of the primary key can never be ———
- infinity
- null
- blank
- None of the above
99) Unique Constraint enforces
- single number value to be entered
- single character to be entered
- multiple values in set of columns
- uniqueness of the values
- in a set of columns
100) When the referential integrity rule is enforced, which one is usually not a valid action in response to the deletion of a row that contains a primary key value referenced elsewhere?
- Do not allow the deletion
- Accept the deletion without any other action
- Delete the related rows
- Set the foreign keys of related rows to null
101) User-Defined Integrity enforces
- null constraints
- some specific business
- rules
- check contraints
- entity integrity
102) What is meaning of Soft Referential Integrity?
- Referential integrity rules implemented in ETL process only
- Referential integrity rules implemented at the database (DBMS) level only
- Referential integrity rules implemented either at ETL or database level
- None of these
103) What is the meaning of Hard Referential Integrity?
- Referential integrity rules implemented in ETL process only
- Referential integrity rules implemented at the database (DBMS) level only
- Referential integrity rules implemented either at ETL or database level
- None of these
104) How is ER data modeling approach different from Dimensional Modeling approach?
- Normalized; goal is to eliminate redundancy; look for transaction efficiency
- Star schema, query processing
- Ease of understanding & use
- None of the above
105) In ER notation entities as represented by
- circular boxes
- diamond boxes
- rectangular boxes
- oval boxes
106) The most popular database model currently in use is the ____.
- relational model
- hierarchical model
- network model
- object model
107) What is a technique for documenting the relationships between entities in a database environment?
- Attributes
- Entity identifier
- Data model
- Entity-relationship diagram
108) What is the goal of relational data modeling?
- De-normalize data
- Normalize data
- Segregate data
- Integrate data
109) Which of the following is not an step in defining a ER model
- Defining Entities and Relationships
- Add key attributes to the diagram
- Adding business and integrity rules
- None of the above
110) Which is NOT an objective of Entity Relational Modeling approach?
- Eliminate Redundancy
- Transaction Efficiency
- Query Performance
- None of these
111) For a Weak entity to be meaningful, it must be part of a
- one-to-one relationship
- one-to-many relationship
- many-to-many relationship
- depends on a particular situation
112) Good approach to normalize many to many relationship?
- create view
- create materialized view
- create dimension table
- third table containing the primary keys of both the tables
113) Helper tables are used
- For handling one to many relationships
- For handling many to one relationships
- For handling many to many relationships
- None of the above
114) How do you define an Orphan Entity?
- An entity that has one to one relationship with another entity
- An entity in a Logical Data Model that has no relationship to any other entity.
- An entity that has many to many relationship with another entity
- None of the above
115) Which of the following statements best decribes the function of an entity relation model?
- An ER model provides a view of the logic of the data and not the physical implementation.
- An ER model is concerned primarily with a physical implementation of the data and secondly with the logical view
- An ER model is entirely concerned with modelling the physical implemetation
- An ER model is concerned primarily with a logical view of the data and secondly with the physical implementation
116) “some employees are married to other employees” is an example of
- Binary relation ship
- recursive binary relationship
- ternary relationship
- None of the above
117) __________ in a database is a unique identifier for either an entity in the modeled world or an object in the database
- Primay Key
- Foreign Key
- Surrogate key
- Composite key
118) A CHECK constraint is used to limit the values that can be placed in a column. Check Constraints are used to enforce
- user defined integrity
- domain integrity
- entity integrity
- referential integrity
119) A foreign key constraint prevents any action that would destroys the relation between data between two tables. A foreign key constraint is useful to enforce the
- referential integrity
- domain integrity
- entity integrity
- user defined integrity
120) Candidate Key could be a
- Primary Key, Foreign Key
- Alternate Key, Foreign Key
- Primary Key, Alternate Key
- Foreign Key
121) Cardinality can never be
- One
- Zero
- Less than 1
- Greater than 1
122) Cardinality is applicable to which data modeling constuct?
- Entity
- Attribute
- Smart Key
- Relationship
123) Define cardinality
- Min and max no. of occurrences between two related entity types
- relationship between entities
- 1:1, 1:many, many:many relationship
- None of the above
124) Entity level data quality issues are typically resolved using
- Check constraints
- Referential Integrity Constraints
- Primary Key and Alternate key identification
- None of these
125) How are the identifier attribute commanly known as?
- Primary key
- Foreign key
- Non-key
- None of the above
126) How do you enforce domain integrity in the RDBMS by restricting the range of possible values the user can input?
- Primary Key Constraints
- Check Constraints
- Default Definitions
- Check and Default Defintions
127) If an attribute A is related to the primary key of the table through another non-key attribute B, it is called as
- Partial Dependency
- Functional Dependency
- Transitive Dependency
- None of the above
128) If an attribute A is related to the primary key of the table through attribute B, it is called as
- Partial Dependency
- Functional Dependency
- Transitive Dependency
- None of the above
129) If an entity is related to itself through different roles, it is an Example of
- Role Based Association
- Recursive Hierarchy
- Recursive Network
- Association
130) In Many to Many relationship, migrate the primary key
- from any side to the other side
- resolve the relationship first then migrate
- Do not migrate the primary key
- None of these
131) In One to Many relationships, migrate the primary key from
- one side to many side
- many side to one side
- Do not migrate the primary key
- None of these
132) In One to One relationship, migrate the primary key from
- mandatory side to optional side
- optional side to mandatoy side
- Do not migrate the primary key
- None of these
133) Order-Sales relationship is
- SuperType-Sub Type
- Recursive relationship
- Dependency
- Transactional
134) Recursive Hierarchy has ____ type of relationship
- 1:M
- M:M
- either 1:M or M:M
- Both 1:M and M:M
135) Recursive Network has ____ type of relationship
- 1:M
- M:M
- either 1:M or M:M
- Both 1:M and M:M
136) Referential integrity ensures that
- rows cannot be deleted,
- which are used by other records
- table contains duplicate records
- a column contains a particular value
- column doesn’t contain null values
137) Surrogate key is not related to
- Performance
- Storage space
- History
- Integer data type
138) The relationship between dimension tables and fact table in a star-schema is of the type
- Many-to-Many
- One-to-Many
- one-to-one
- None of the above
139) This occurs when there is a relationship between an entity and itself.
- Recursive Relationship
- Circular relationship
- Dependent relationship
140) What are the benefits of Association relationships?
- Optimization
- Performance
- Tracking
- Recognition
141) What is a degree of relation type?
- Number of entity types participating
- Number of attributes of the relation
- Assoication of one or more attributes
- None of the above
142) What would one call the number of entities associated with the relationship?
- Cardinality
- Degree
- Attribute
- Tuple
143) When the relationship between entities A and B will be optional?
- A has one or more occurrences per B
- A has exactly one occurrence per B
- A has zero or one occurrence per B
- None of these
144) Which is a common application of Recursive Hierarchy?
- General Ledger
- Organizational Structure
- Medical procedures
- A and B
145) Which is an example of Recursive Hierarchy?
- Employee managing other employees
- Customer holding multiple accounts
- Ordering multiple products at the same time
- None of these
146) Which is NOT a rule for Primary Key?
- must uniquely identify only one record in an entity
- Primary key column can not be null
- Entity can hav only one primary key
- Primary key can not be made of multiple columns
147) Which relationship is between two entities in which an instance of entity A can be related to zero, one, or more instances of entity B and entity B can be related to zero, one, or more instances of entity A?
- One-to-many relationship
- One-to-one relationship
- Many-to-many relationship
- Many-to-one relationship
148) A _____ represents a structured grouping of entities that share common characteristics but maintain their unique differences.
- Supertype – Subtype
- FK
- PK
- B and C Both
149) A Subtype must be associated with the SuperType in a ______ Relationship
- One to One
- One to One Optional
- Many to One Optional
- One to Many Optional
150) An entity in ER modeling is analogous to a ——– in the relational model
- relation
- attribute
- tuple
- None of the above
151) Association is used to resolve
- One to Many
- May to Many
- Many to One
- One to Many
152) Association pattern is used for
- Looking up data
- Implementing Referential Integrity
- Resolving Many – Many relationship (M:M)
- None of these
153) Associative entities are entities used to associate two or more entities in order to resolve a ——– relationship
- One to many
- one to one
- many to many
- None of the above
154) Dependency is indicated by _________ each relationship
- cardinality of
- optionality of
- integrity of
- dependency on
155) Dependency pattern is closely associated to
- Relationship Cardinality
- Relationship Optionality
- Referential Integrity
- None of these
156) Derived key
- is not artificially created
- is created when unique identifier is not availbale for all the records
- is a foreign key
- hidden key
157) What is best practice in defining Primary key?
- Define composite key as primary key
- Define smart code as primary key
- Define surrogate key (running number) as primay key
- None of these
158) What is true about Subtype Relationship?
- Is a way to group a set of
- entities that share common characteristics.
- To take care of inheritance hierarchy
- A & B
- None of the above
159) Column level source data quality issues are resolved using
- Check constraints
- Data type mismatch resolution
- Both A & B
- Referential integrity constraints
160) Employee can be related to multiple departments performing various roles. Which data modeling pattern can be used in such case to capture role specific details of the employee?
- Recursive Hierarchy
- Super type – sub type
- Role Based Association
- None of these
161) What is Identifying Relationship?
- A child table can be uniquely identified without the parent table
- A child table cannot be uniquely identified without the parent table
- All of the above
- None of the above
162) What is Non-Identifying Relationship?
- A child can be identified independently of the parent
- A child table cannot be uniquely identified without the parent
- All of the above
- None of the above
163) What problem you may encounter if you have many to many relationship in physical model?
- You may encounter performance problems
- You may not be able to enter data into them with out disabling constraints
- No problem in having many to many relationship
- None of the above
164) Refer the below Table structures and specify what is the relationship between Account to PersonAccount
Account (AccountID, AccountNum, AccountTypeID), AccountID is PK
PersonAccount (AccountPersonSequence, PersonID, AccountID, Balance), (AccountPersonS
- Optional
- Non-Identifying
- Identifying
- None of the above
165) Refer to the below Table structures and specify what is the relationship between Account to PersonAccount .
Account (AccountID, AccountNum, AccountTypeID), AccountID is PK
PersonAccount (AccountID, PersonID, Balance), (AccountID, PersonID) is PK.
- Optional
- Non-Identifying
- Identifying
- None of the above
166) What trade-offs typically take place while converting from Logical Data Model to Physical Data Model?
- Controlled de-normalization
- Derived Aggregate table structures
- Both of these
- None of these
167) Which of the following is NOT TRUE regarding Relationship implementation in database design?
- One-to-One relationship can be implemented as a single table and rarely as two tables with primary and foreign key relationships
- One-to-Many relationships are implemented by splitting the data into two tables with primary key and foreign key relationships
- Many-to-Many relationships are implemented using a helper table with the keys from both the tables forming the composite primary key of the junction table
- None of the above
168) Entity types identified by relating to specific entities from another entity type is
- Strong Entity
- ans) Weak Entity
- Owner Entity
- Independent Entity
169) A(n) ____ is a generalized class of people, places, or things for which data is collected, stored, and maintained
- record
- ans) entity
- attribute
- file
170) In a M:N relationship WORKS_ON between EMPLOYEE and PROJECT entity types can be determined by
- EMPLOYEE only
- PROJECT only
- EMPLOYEE or PROJECT
- ans) EMPLOYEE & PROJECT COMBINATION
171) Refer the below Table structures and specify what is the relationship between Account to PersonAccount
Account (AccountID, AccountNum, AccountTypeID), AccountID is PK
PersonAccount (AccountPersonSequence, PersonID, AccountID, Balance), AccountPersonSe
- Optional
- ans) Non-Identifying
- Identifying
- None of the above
172) Relationship (Cardinality) between a Fact and a Dimension in a Dimensional Model is
- ans) Many-To-One
- Many-To-Many
- One-To-One
- One-To-Many
173) Relationship between Hierarchical Data Instances represented in a single entity is called as
- Many-To-Many Relationships
- Generic Relationship
- ans) Recursive relationships
- Time Dependent Relations
174) The Start_Date attribute for the WORKS_FOR (N:1) relationship between EMPLOYEE and DEPARTMENT can be an attribute of
- ans) EMPLOYEE only
- DEPARTMENT only
- EMPLOYEE or DEPARTMENT
- EMPLOYEE & DEPARTMENT COMBINATION
175) Relationships between entities are classified in terms of
- Degree
- Cardinality
- Type
- ans) All of the above