Q&A Hero

Q: An entity that must logically depend on another entity is called a(n) ________ entity.

Q: When an entity class has a relationship with itself, it is called a(n) ________ relationship.

Q: Relationships with the degree 2 are often called ________ relationships.

Q: Identifiers of an entity that are composed of two or more attributes are called ________ identifiers.

Q: ________ are descriptions of the ways users will employ the features and functions of the new information system.

Q: A(n) ________ is a working demonstration of selected portions of the future system.

Q: The ________ is a representation of the content, relationships, and constraints of the data needed to support the system requirements.

Q: The Microsoft Access 2013 report editor is a(n): A) banded report editor. B) wizard-based report editor. C) ASCII report editor. D) WYSIWYG report editor. E) Web-based report editor.

Q: The Microsoft Access 2013 form editor is a(n): A) banded form editor. B) wizard-based form editor. C) ASCII form editor. D) WYSIWYG form editor. E) Web-based form editor.

Q: Microsoft Access can be used to prototype databases for which of the following DBMS products? A) Microsoft Access B) SQL Server C) MySQL D) Oracle Database E) All of the above

Q: Microsoft Access is a good tool for creating mock-ups of forms and reports because: A) the form and report generators do not exist within Access itself. B) Access forms and reports are very simplistic. C) Access wizards make it easy to create the forms and reports. D) Access has a version of Microsoft PowerPoint built into it to allow easy creation of PowerPoint slide shows. E) Access has a version of Microsoft Excel built into it to allow easy exporting of data to spreadsheets.

Q: Microsoft Access can be used to build a prototype database, which allows users: A) to draw a crow's foot E-R diagram themselves. B) to normalize the tables in the E-R diagram. C) to validate the data model by demonstrating the consequences of data modeling decisions. D) to determine the functional dependencies in the data model. E) to determine the appropriate primary and foreign keys in the data model.

Q: In crow's foot style E-R diagrams, a single entity together with a related set of entities that each contain specific sets of attributes related to the single entity represent: A) a strong entity relationship. B) an ID-dependent weak entity relationship. C) a non-ID-dependent weak entity relationship. D) a supertype / subtype relationship. E) a recursive entity relationship.

Q: In crow's foot style E-R diagrams, a crow's foot mark on the relationship line near an entity indicates: A) a minimum cardinality of zero. B) a minimum cardinality of one. C) a maximum cardinality of one. D) a maximum cardinality of many. E) Both B and C

Q: In crow's foot style E-R diagrams, a circle across the relationship line near an entity indicates: A) a minimum cardinality of zero. B) a minimum cardinality of one. C) a maximum cardinality of one. D) a maximum cardinality of many. E) Both B and C

Q: In crow's foot style E-R diagrams, a hash mark across the relationship line near an entity indicates: A) a minimum cardinality of zero. B) a minimum cardinality of one. C) a maximum cardinality of one. D) a maximum cardinality of many. E) Both B and C

Q: An ID-dependent entity is: A) a special type of weak entity. B) an entity in which the identifier of the entity includes the identifier of another entity. C) a strong entity. D) an entity with a maximum cardinality of one. E) Both A and B

Q: A dashed line between entities indicates: A) a unique identifier. B) a minimum cardinality of zero. C) a minimum cardinality of one. D) an identifying relationship. E) a nonidentifying relationship.

Q: Whether or not an instance of one entity class must participate in a relationship with another entity class is indicated by the: A) degree. B) recursive cardinality. C) minimum cardinality. D) maximum cardinality. E) ordinality.

Q: Given only the following excerpt of an E-R model: If one instance of ENTITY B must be related to one and only one instance of ENTITY A, and one instance of ENTITY A may be related to many instances of ENTITY B, which of the following should be written on the end of the relationship line next to ENTITY B in the figure above? A) B) C) D) E) None of the above is correct.

Q: Given only the following excerpt of an E-R model: Which of the following is known to be true? A) A single instance of ENTITY A must be related to one instance of ENTITY B. B) Many instances of ENTITY A may be related to one instance of ENTITY B. C) ENTITY B has a degree of many. D) ENTITY B is a weak entity. E) Both A and C are true.

Q: Given only the following excerpt of an E-R model: Which of the following is known to be true? A) There are more instances of ENTITY A than there are instances of ENTITY B in the user's environment. B) A single instance of ENTITY B may be related to many instances of ENTITY A. C) A single instance of ENTITY A must be related to many instances of ENTITY B. D) ENTITY A has a minimum cardinality of one. E) The degree of the relationship is "many."

Q: The number of entity classes involved in a relationship is known as the relationship's: A) maximum cardinality. B) minimum cardinality. C) ordinality. D) degree. E) class.

Q: Which of the following is true about identifiers of entities? A) Identifiers must be unique. B) Identifiers are not normally used in a naming role. C) The value of an identifier may identify a set of entity instances. D) Identifiers may not be more than two attributes. E) An identifier in the E-R model is equivalent to a key in the relational model.

Q: In the Entity-Relationship data model, all instances of an entity of a given type are grouped into: A) entity objects. B) class objects. C) entity classes. D) identifiers. E) entity attributes.

Q: Which of the following is not a basic element of the E-R Model? A) Identifiers B) Entities C) Cardinalities D) Use cases E) Relationships

Q: A use case can be used to perform which of the following tasks? A) Transform the data model into the database design B) Validate the data model C) Fill the database with data D) Implement business rules E) Develop applications

Q: Which of the following would not be contained in a use case? A) Inputs provided to the system to perform a task B) A description of a task the user wants to perform C) A prototype of the system performing a given task D) Outputs generated by the system in performing a given task E) All of the above would be contained in a use case.

Q: Which of the following is not a source for user requirements during the requirements analysis stage of developing a database system? A) Business rules B) User interviews C) Forms D) Use cases E) All of the above are sources for user requirements.

Q: Which of the following activities is not performed during the implementation phase of developing a database system? A) Filling the database with data B) Transforming the data model into a database design C) Writing application programs D) Creating forms E) Creating reports

Q: The representation of the content, relationships, and constraints of the data needed to support the system requirements is the: A) relation design. B) implementation. C) data model. D) data view. E) application program.

Q: Which of the following is not a stage in the development of a database system? A) Requirements analysis B) Validation C) Component design D) Implementation E) All of the above are stages in the development of a database system.

Q: Microsoft Access 2013 uses banded form and report editors.

Q: Microsoft Access 2013 database files can be easily copied to create multiple copies of a database.

Q: Microsoft Access 2013 is only used to prototype databases where Microsoft Access itself will be the final DBMS.

Q: Microsoft Access 2013 wizards allow easy mock-ups of forms and reports for prototyping.

Q: Microsoft Access 2013 can be used to build a prototype database, which allows users to validate the data model by demonstrating the consequences of data modeling decisions.

Q: Subtype entities may be either exclusive or inclusive.

Q: In crow's foot E-R notation, the hash mark indicates both a minimum cardinality of one and a maximum cardinality of one.

Q: In crow's foot E-R notation, a circle indicates a minimum cardinality of zero.

Q: In crow's foot E-R notation, the crow's foot indicates a maximum cardinality of one.

Q: One type of strong entity is the ID-dependent entity.

Q: Maximum cardinality indicates whether or not an instance of one entity class must be related to at least one instance of another entity class.

Q: It is possible for an entity to have a relationship to itself.

Q: The number of entity classes involved in a relationship is the cardinality of the relationship.

Q: An entity identifier can be either unique or nonunique.

Q: The E-R Model assumes that all instances of a given entity class have the same attributes.

Q: There is usually only one instance of an entity in an entity class.

Q: An entity class is described by the structure of the entities in that class.

Q: The PRODUCT entity instance is the collection of all PRODUCT entity classes.

Q: Unified Modeling Language (UML) has quickly replaced the E-R Model as the most popular technique for creating data models.

Q: System requirements as documented by use cases, business rules, forms, reports, and queries are sufficient to design the database without using a formal data model.

Q: Use cases can be used to validate the data model, design, and implementation.

Q: A use case is a description of the way a user will employ the features and functions of the new system.

Q: During the design phase of developing a database system, the users are asked about the need for changes to existing forms and reports.

Q: When developing a database system, the database is constructed during the implementation phase.

Q: During the implementation phase of developing a database system, the data model is transformed into a database design.

Q: Given the table CUSTOMER(CustID, Name, PhoneNumber, AccountBalance) write the standard SQL query to retrieve the Name and Phone Number of customers whose name begins with 'S'.

Q: Given the table CUSTOMER(CustID, Name, PhoneNumber, AccountBalance) write the standard SQL query to retrieve the Name and Phone Number of customers with a balance greater than 50.

Q: Explain two methods for defining a primary key using SQL.

Q: Distinguish between Char and VarChar data types.

Q: Discuss SQL data types.

Q: Explain the essential format of the CREATE TABLE statement.

Q: Explain why it is important to learn SQL.

Q: Table and relationship properties not supported by Microsoft Access SQL can usually be set ________ in the appropriate window or dialog box.

Q: Microsoft Access SQL allows table structures to be modified by using the standard SQL ________ command.

Q: In Microsoft Access, tables are added to a QBE Query window by selecting the tables from the ________ dialog box.

Q: In Microsoft Access, the default method of creating and running a query is ________.

Q: Microsoft Access SQL commands are run in the ________ of a Query window.

Q: A complete table, including both the table structure and any data in the table, can be removed from the database by using the SQL ________ command.

Q: The values of existing data can be removed from a table using the SQL ________ command, which can even be used to remove all the data in the table at one time.

Q: The values of existing data can be modified using the SQL ________ command, which can be used to change several column values at once.

Q: Existing tables in a database can be structurally modified by using the SQL ________ command.

Q: Using SQL commands, multiple tables can be queried so that all the values from one table appear in the results, regardless of whether they have one or more corresponding values in the other table, by using the SQL ________ command.

Q: Using SQL commands, multiple tables can be queried using either subqueries or ________.

Q: Conditions in an SQL INSERT command and after the SQL ________ keyword require single quotes around values for Char and VarChar columns, but not around values for Integer and Numeric columns.

Q: One way to specify all of the columns of a table is to use the special character * after the SQL keyword ________.

Q: The SQL command used to add new data to a table is ________.

Q: An SQL data type of ________ means that values consist of seven decimal numbers with two numbers assumed to the right of the decimal point.

Q: An SQL data type of ________ would indicate a variable-length character string with maximum length 75.