Which of the following is not a key element of E-R models? a. objects b. identifiers c. attributes d. entities.... Which of the following is not a phase of building a database system? a. implementation b. application c. designd. requirements........ Which of the following is not true with regards to logical data flow diagrams? a. they document the physical structure of an existing system or proposed system.......

The notion of database normalization was developed to a. reduce data intefrity. b. increase data integrity. c. increase data redundancy. d. reduce data redundancy...... The notion of database ____ was developed to reduce data redundancy. a. schema b. key c. normalization. d. redundancy check..... The relationship between two entity types A and B is 1:1, and the relationship is optional at the A end. ......

Select the true statement: a. Context diagram contains one process node that generalizes the functiob of the entire system in relationship to external entities. b. Context diagram haven’t process node that generalizes the function to the entire system in relationship to external entities. c. Context diagram contains two process node that generalizes the function of the entire system in relationship to external enties. d. Context diagram contains many process node that generalizes the function of the entire system in relationship to external entities...... Select the right option(s): a. The notion of database normalization was developed reduce data redundancy as much as possible. b. All of these answers.....

Partitioning DFDs: a. The process of analyzing a DFD and deriving a series of manual procedures b. Adding controls to ensure the processes are done property c. The process of analyzing a DFD and deriving a series manual procedures and computer programs d. None of these answers...... Physical data flow diagram: a. describing processes in greater detail b. show sequencing processes in the order they must be executed c. show how the system operates or how the new system will be implemented d. all of these answers......

In an E-R diagram, a one-to-many relationship is indicated by: a. a "1" and an "N" placed on the approprnate lines b. a double-line with symbol 1-N c. a double-line d. a line pointing from the "one" to the "many"....... In an E-R diagram, relationships are drawn as: a. lines b. diamonds c. rectangles d. cirles......

Consider the following relation definition and sample data in picture. Assume that all of the functional dependencies and constraints are apparent in this data. Which of the following statements is NOT true? a. (TaskID.Phone->(TotalHours, ProjectID) b. EmployeeName->ProjectID c. (EmployeeName.ProjectID)->TaskID d. EmployeeName->TotalHours..... Consider the following relation definition and sample data in picture. Assume that all of the functional dependencies and constraints are apparent in this data. The set of candidate keys in this table are: a. (ProjectID,EmployeeName).(ProjectID.TaskID).(EmployeeName.TaskID).(TaskID) b. (ProjectID.EmployeeName).(ProjectID.TaskID).(EmployeeName.TaskID).(ProjectID) c. (TaskID.ProjectID).(ProjectID.EmployeeName) d. (EmployerName).(ProjectID).(TaskID)......

Advantages of logical DFDs is/are: a. Better communication with users b. More stable systems, since the design is based on a business framework c. Increased understanding of the business by analysts d. All of these answers.... Advantages of logical DFDs: a. Better communication with users. More stable systems b. Better understanding of the business by analysts. Flexibility and maintenance c. Elimination of redundancies and easier creation of the physical model d. All of these answers..... An entity type whose existence depends on another entity type is called a(n) ____ entity.....

A data model is ____ a. transformed into tables and relationships b. shown as an entity-relationship diagram c. All of these answers d. a logical representation of the structure of the database... A DBMS is a good tool for all of the following reasons except a. Enforces data and procedural standardsb. Improves data security and integrity c. Reduces data redundancy d. Ensures data independence...... A decision table is: a. (I) & (II) b. a two dimensional matrix.....

Which is/are derived sttribute(s): a. Name. b. All of these answers. c. Interest. d. Social number....... Which of the following is not correct? a. Entity Relationship Diagrams use four items; rectangles, circles, lines, degree of relation (such as one to many). b. Entity Relationship Diagrams show entities, how the entities interact and the attributes. c. Entity Relationship Diagrams are a graphical approach to modeling that helps the user design systems. d. In transforming Entity Relationship Diagrams to a database, entities become tables.......

For a unary one-to-one relationship between two entities A and B, the relationship is represented by: a. adding the primary key of A as a foreign key of B adding the primary key of B as a foreign key of A. b. none of the others. c. combining the two entities into one relation adding the primary key of A as a foreign key of B. d. combining the two entities into one relation adding the primary key of B as a foreign key of A..... Given four image present relationship between two entities A and B. The statement "Each instance of A is related to minimum of zero and a maximum of one instance of B" correlative with image: a. 1 b. 2 c. 3d. 4......