In mapping of ERD to DFD a) entities in ERD should correspond to an existing entity/store in DFD b) entity in DFD is converted to attributes of an entity in ERD c) relations in ERD has 1 to 1 correspondence to processes in DFD d) relationships in ERD has 1 to 1 correspondence to flows in DFD

In mapping of ERD to DFD
a) entities in ERD should correspond to an existing entity/store in DFD
b) entity in DFD is converted to attributes of an entity in ERD
c) relations in ERD has 1 to 1 correspondence to processes in DFD
d) relationships in ERD has 1 to 1 correspondence to flows in DFD
by

1 Answer

Answer :

a) entities in ERD should correspond to an existing entity/store in DFD
by

Related questions

A ………………. Does not have a distinguishing attribute if its own and mostly are dependent entities, which are part of some another entity. A) Weak entity B) Strong entity C) Non attributes entity D) Dependent entity

Description : A ………………. Does not have a distinguishing attribute if its own and mostly are dependent entities, which are part of some another entity. A) Weak entity B) Strong entity C) Non attributes entity D) Dependent entity

Last Answer : A) Weak entity

Which of the following statements is FALSE about weak entity set ? (A) Weak entities can be deleted automatically when their strong entity is deleted. (B) Weak entity set avoids the data duplication and consequent possible inconsistencies caused by duplicating the key of the strong entity. (C) A weak entity set has no primary keys unless attributes of the strong entity set on which it depends are included. (D) Tuples in a weak entity set are not partitioned according to their relationship with tuples in a strong entity set.

Description : Which of the following statements is FALSE about weak entity set ? (A) Weak entities can be deleted automatically when their strong entity is deleted. (B) Weak entity set avoids the data ... weak entity set are not partitioned according to their relationship with tuples in a strong entity set.

Last Answer : (D) Tuples in a weak entity set are not partitioned according to their relationship with tuples in a strong entity set.

Let E1 and E2 be two entities in E-R diagram with simple single valued attributes. R1 and R2 are two relationships between E1 and E2 where R1 is one-many and R2 is many-many. R1 and R2 do not have any attributes of their own. How many minimum number of tables are required to represent this situation in the Relational Model? (A) 4 (B) 3 (C) 2 (D) 1

Description : Let E1 and E2 be two entities in E-R diagram with simple single valued attributes. R1 and R2 are two relationships between E1 and E2 where R1 is one-many and R2 is many-many. R1 and R2 do not have any ... are required to represent this situation in the Relational Model? (A) 4 (B) 3 (C) 2 (D) 1

Last Answer : (B) 3 

In RDBMS, Data is presented as a collection of ............ A) Table B) Attributes C) Relations D) Entities

Description : In RDBMS, Data is presented as a collection of ............ A) Table B) Attributes C) Relations D) Entities

Last Answer : C) Relations

A rectangle in a DFD represents A) a process B) a data store C) an external entity D) an input unit

Description : A rectangle in a DFD represents A) a process B) a data store C) an external entity D) an input unit

Last Answer : C) an external entity

Tables derived from the ERD

Description : Tables derived from the ERD

Last Answer : a) Are totally unnormalised b) Are always in 1NF c) Can be further denormalised d) May have multi-valued attributes (b) Are always in 1NF

An ER Model includes I. An ER diagram portraying entity types. II. Attributes for each entity type III. Relationships among entity types. IV. Semantic integrity constraints that reflects the business rules about data not captured in the ER diagram. (A) I, II, III & IV (B) I&IV (C) I, II & IV (D) I & III

Description : An ER Model includes I. An ER diagram portraying entity types. II. Attributes for each entity type III. Relationships among entity types. IV. Semantic integrity constraints that reflects the business rules about data not ... ; IV (B) I&IV (C) I, II & IV (D) I & III

Last Answer : (A) I, II, III & IV

In a DFD external entities are represented by a A) Rectangle B) Ellipse C) Diamond shaped box D) Circle

Description : In a DFD external entities are represented by a A) Rectangle B) Ellipse C) Diamond shaped box D) Circle

Last Answer : A) Rectangle

By an external entity we mean a A) Unit outside the system being designed which can be controlled by an analyst. B) Unit outside the system whose behavior is independent of the system being designed C) A unit external to the system being designed D) A unit which is not part of a DFD

Description : By an external entity we mean a A) Unit outside the system being designed which can be controlled by an analyst. B) Unit outside the system whose behavior is independent of the system being designed C) A unit external to the system being designed D) A unit which is not part of a DFD

Last Answer : C) A unit external to the system being designed

Which entity oversees and regulates Florida's financial entities including state-chartered banks and securities industry participants?

Description : Which entity oversees and regulates Florida's financial entities including state-chartered banks and securities industry participants?

Last Answer : OFR

Let M and N be two entities in an E-R diagram with simple single vale attributes. R1 and R2 are two relationship between M and N, whereas R1 is one-to-many and R2 is many-to-many. The minimum number of tables required to represent M, N, R1 and R2 in the relational model are .......... (1) 4 (2) 6 (3) 7 (4) 3

Description : Let M and N be two entities in an E-R diagram with simple single vale attributes. R1 and R2 are two relationship between M and N, whereas R1 is one-to-many and R2 is many-to-many. The minimum number of tables required to ... and R2 in the relational model are .......... (1) 4 (2) 6 (3) 7 (4) 3

Last Answer : Answer: 4

How is mapping of name of DLL and function done?

Description : How is mapping of name of DLL and function done?

Last Answer : The dll can be created using the Visual C++ / Visual Basic Tools and then the dll is put in the path that is defined the registery.

Data cannot flow between two data stores because A) it is not allowed in DFD B) a data store is a passive repository of data C) data can get corrupted D) they will get merged

Description : Data cannot flow between two data stores because A) it is not allowed in DFD B) a data store is a passive repository of data C) data can get corrupted D) they will get merged

Last Answer : D) they will get merged

Data store in a DFD represents. A) a sequential file B) a disk store C) a repository of data

Description : Data store in a DFD represents. A) a sequential file B) a disk store C) a repository of data

Last Answer : C) a repository of data

ON WHICH ENTITY IS THE CROSS-VALIDATION RULE APPLICABLE?

Description : ON WHICH ENTITY IS THE CROSS-VALIDATION RULE APPLICABLE?

Last Answer : - It’s a feature of Key flexfield, applicable on Value Sets. 

ON WHICH ENTITY IS A SECURITY RULE APPLICABLE?

Description : ON WHICH ENTITY IS A SECURITY RULE APPLICABLE?

Last Answer : - It’s a feature of Key flexfield, applicable on Value Sets. 

A dominant entity is the entity a) on the N side in a 1 : N relationship b) on the 1 side in a 1 : N relationship c) on either side in a 1 : 1 relationship d) nothing to do with 1 : 1 or 1 : N relationship

Description : A dominant entity is the entity a) on the N side in a 1 : N relationship b) on the 1 side in a 1 : N relationship c) on either side in a 1 : 1 relationship d) nothing to do with 1 : 1 or 1 : N relationship

Last Answer : d) nothing to do with 1 : 1 or 1 : N relationship

What is Weak Entity set?

Description : What is Weak Entity set?

Last Answer : An entity set may not have sufficient attributes to form a primary key, and its primary key compromises of its partial key and primary key of its parent entity, then it is said to be Weak Entity set.

What is an Extension of entity type?

Description : What is an Extension of entity type?

Last Answer : The collections of entities of a particular entity type are grouped together into an entity set.

What is an Entity set?

Description : What is an Entity set?

Last Answer : It is a collection of all entities of particular entity type in the database.

What is an Entity type?

Description : What is an Entity type?

Last Answer : It is a collection (set) of entities that have same attributes.

What is an Entity?

Description : What is an Entity?

Last Answer : It is a ‘thing’ in the real world with an independent existence.

What is an Entity?

Description : What is an Entity?

Last Answer : An entity is a business object represents a group or category of data.

“Pakistan started the moment the first non-Muslim was converted to Islam in India long before the Muslims established their rule. Throughout the ages Hindus had remained Hindus and Muslims had remained Muslims, and they had not merged their entities A. Muhammad Ali Jinnah B. Fazal Haq C. Allama Iqbal D. All of them

Description : Pakistan started the moment the first non-Muslim was converted to Islam in India long before the Muslims established their rule. Throughout the ages Hindus had remained Hindus and Muslims had remained Muslims, ... their entities A. Muhammad Ali Jinnah B. Fazal Haq C. Allama Iqbal D. All of them

Last Answer : ANSWER: A

“Pakistan started the moment the first non-Muslim was converted to Islam in India long before the Muslims established their rule. Throughout the ages Hindus had remained Hindus and Muslims had remained Muslims, and they had not merged their entities A. Muhammad Ali Jinnah B. Fazal Haq C. Allama Iqbal D. All of them

Description : Pakistan started the moment the first non-Muslim was converted to Islam in India long before the Muslims established their rule. Throughout the ages Hindus had remained Hindus and Muslims had remained Muslims, ... their entities A. Muhammad Ali Jinnah B. Fazal Haq C. Allama Iqbal D. All of them

Last Answer : ANSWER: A

“Pakistan started the moment the first non-Muslim was converted to Islam in India long before the Muslims established their rule. Throughout the ages Hindus had remained Hindus and Muslims had remained Muslims, and they had not merged their entities A. Muhammad Ali Jinnah B. Fazal Haq C. Allama Iqbal D. All of them

Description : Pakistan started the moment the first non-Muslim was converted to Islam in India long before the Muslims established their rule. Throughout the ages Hindus had remained Hindus and Muslims had remained Muslims, ... their entities A. Muhammad Ali Jinnah B. Fazal Haq C. Allama Iqbal D. All of them

Last Answer : ANSWER: A

What are attributes of cursor?

Description : What are attributes of cursor?

Last Answer : %FOUND , %NOTFOUND , %ISOPEN,%ROWCOUNT

What are cursor attributes?

Description : What are cursor attributes?

Last Answer : %ROWCOUNT -%NOTFOUND -%FOUND -%ISOPEN

What are the cursor attributes used in PL/SQL ?

Description : What are the cursor attributes used in PL/SQL ?

Last Answer : %ISOPEN - to check whether cursor is open or not % ROWCOUNT - number of rows fetched/updated/deleted. % FOUND - to check whether cursor has fetched any row. True if rows are ... featched. These attributes are proceeded with SQL for Implicit Cursors and with Cursor name for Explicit Cursors.

What are visual attributes?

Description : What are visual attributes?

Last Answer : Visual attributes are the font, color, pattern proprieties that you set for form and menu objects that appear in your application interface.

A B C is a set of attributes. The functional dependency is as follows AB -> B AC -> C C -> B a) is in 1NF b) is in 2NF c) is in 3NF d) is in BCNF

Description : A B C is a set of attributes. The functional dependency is as follows AB -> B AC -> C C -> B a) is in 1NF b) is in 2NF c) is in 3NF d) is in BCNF

Last Answer : a) is in 1NF

The number of attributes in relation is called as its ..................... A) Cardinality B) Degree C) Tuples D) Entity

Description : The number of attributes in relation is called as its ..................... A) Cardinality B) Degree C) Tuples D) Entity

Last Answer : B) Degree

The one guideline to be followed while designing the database is A) A database design may be ambiguous. B) Unrelated data should be in the same table so that updating the data will be easy. C) It should avoid/reduce the redundancy. D) An entity should not have attributes.

Description : The one guideline to be followed while designing the database is A) A database design may be ambiguous. B) Unrelated data should be in the same table so that updating the data will be easy. C) It should avoid/reduce the redundancy. D) An entity should not have attributes.

Last Answer : C) It should avoid/reduce the redundancy.

What kind of mechanism is to be taken into account for converting a weak entity set into strong entity set in entity-relationship diagram ? (A) Generalization (B) Aggregation (C) Specialization (D) Adding suitable attributes

Description : What kind of mechanism is to be taken into account for converting a weak entity set into strong entity set in entity-relationship diagram ? (A) Generalization (B) Aggregation (C) Specialization (D) Adding suitable attributes

Last Answer : (D) Adding suitable attributes

What are Most Common types of Complex master-detail relationships?

Description : What are Most Common types of Complex master-detail relationships?

Last Answer : There are three most common types of complex master-detail relationships: master with dependent details master with independent details detail with two masters

Are the resulting relations of PRODUCT and JOIN operation the same?

Description : Are the resulting relations of PRODUCT and JOIN operation the same?

Last Answer : No. PRODUCT: Concatenation of every row in one relation with every row in another. JOIN: Concatenation of rows from one relation and related rows from another

Which of the following represents a procedure that the auditor may use because plausible relationships among financial statement balances are expected to exist? a. Attributes testing b. Enterprise risk assessment c. Inherent tests of control d. Analytical review

Description : Which of the following represents a procedure that the auditor may use because plausible relationships among financial statement balances are expected to exist? a. Attributes testing b. Enterprise risk assessment c. Inherent tests of control d. Analytical review

Last Answer : Analytical review

. ………………… is a special type of integrity constraint that relates two relations & maintains consistency across the relations. A) Entity Integrity Constraints B) Referential Integrity Constraints

Description : . ………………… is a special type of integrity constraint that relates two relations & maintains consistency across the relations. A) Entity Integrity Constraints B) Referential Integrity Constraints

Last Answer : B) Referential Integrity

suppose you are asked by your friends to take the membership of the teachers association. How could you take decision in this situation? Options: A) You will give priority to social relations, therefore, you will accept the offer. B) You will have, faith in unity so you will accept the membership. C) You will de-affiliate yourself from the colleagues instead of entity with the management. D) You will try to avoid the issue.

Description : suppose you are asked by your friends to take the membership of the teachers association. How could you take decision in this situation? Options: A) You will give priority to social relations, therefore, ... the colleagues instead of entity with the management. D) You will try to avoid the issue. 

Last Answer : D) You will try to avoid the issue. 

How will you swap objects into a different table space for an existing database ?

Description : How will you swap objects into a different table space for an existing database ?

Last Answer : Export the user Perform import using the command imp system/manager file=export.dmp indexfile=newrite.sql. This will create all definitions into newfile.sql. Drop necessary objects. Run the script newfile.sql after altering the tablespaces. Import from the backup for the necessary objects.

How to implement the multiple control files for an existing database ?

Description : How to implement the multiple control files for an existing database ?

Last Answer : Shutdown the database Copy one of the existing control file to new location Edit Config ora file by adding new control file. name Restart the database.

How can a break order be created on a column in an existing group? What are the various sub events a mouse double click event involves?

Description : How can a break order be created on a column in an existing group? What are the various sub events a mouse double click event involves?

Last Answer : By dragging the column outside the group.

In a relational model, relations are termed as (A) Tuples. (B) Attributes (C) Tables. (D) Rows.

Description : In a relational model, relations are termed as (A) Tuples. (B) Attributes (C) Tables. (D) Rows.

Last Answer : (C) Tables

The personal presentation by the firm’s sales force for the purpose of making salesand building customer relationships is called: A. Personal selling. B. Public relations. C. Direct marketing. D. Sales promotion.

Description : The personal presentation by the firm’s sales force for the purpose of making salesand building customer relationships is called: A. Personal selling. B. Public relations. C. Direct marketing. D. Sales promotion.

Last Answer : A. Personal selling.

Name two specific RAC background processes

Description : Name two specific RAC background processes

Last Answer : RAC processes are: LMON, LMDx, LMSn, LKCx and DIAG.

In the ........... normal form, a composite attribute is converted to individual attributes. A) First B) Second C) Third D) Fourth

Description : In the ........... normal form, a composite attribute is converted to individual attributes. A) First B) Second C) Third D) Fourth

Last Answer : A) First

Which of the following provides the best description of an entity type? (A) A specific concrete object with a defined set of processes (e.g. Jatin with diabetes) (B) A value given to a particular attribute (e.g. height-230 cm) (C) A thing that we wish to collect data about zero or more, possibly real world examples of it may exist. (D) A template for a group of things with the same set of characteristics that may exist in the real world

Description : Which of the following provides the best description of an entity type? (A) A specific concrete object with a defined set of processes (e.g. Jatin with diabetes) (B) A value given to a ... template for a group of things with the same set of characteristics that may exist in the real world

Last Answer : Answer: D

. Integrity in the project management field is accomplished through all of the following except which one? A. Training to learn how to manage relationships with others from different cultures B. Adhering to an ethical code C. Applying established project management processes D. Following the PMP Code of Professional Conduct

Description :  . Integrity in the project management field is accomplished through all of the  following except which one?  A. Training to learn how to manage relationships with others from different ... C. Applying established project management processes D. Following the PMP Code of Professional Conduct

Last Answer : A. Training to learn how to manage relationships with others from different cultures

The most formal definition of marketing is ________. A. Meeting needs profitably B. Identifying and meeting human and social needs C. The four Ps (product, price, place, promotion) D. An organizational function and a set of processes for creating, communicating, and delivering value to customers and for managing customer relationships in ways that benefit the organization and its stakeholders. E. Improving the quality of life for consumers

Description : The most formal definition of marketing is ________. A. Meeting needs profitably B. Identifying and meeting human and social needs C. The four Ps (product, price, place, promotion) D. ... ways that benefit the organization and its stakeholders. E. Improving the quality of life for consumers

Last Answer : D. An organizational function and a set of processes for creating, communicating, and delivering value to customers and for managing customer relationships in ways that benefit the organization and its stakeholders.

Water gets evaporated from water surfaces and land surfaces, get converted into water drops at lower temperatures, flows over ground surface and finally meets its source, i.e. lake, sea, etc. This entire process is generally known as (A) Hydrological cycle (B) Water cycle (C) Evaporation and precipitation cycle (D) All the above

Description : Water gets evaporated from water surfaces and land surfaces, get converted into water drops at lower temperatures, flows over ground surface and finally meets its source, i.e. lake, sea, etc. This ... Hydrological cycle (B) Water cycle (C) Evaporation and precipitation cycle (D) All the above

Last Answer : (D) All the above