CSIS 325 - CH. 1-6 (Quiz 1)

Relationship cardinalities:

(All of the above) A) Constrain the number of objects that participate in a relationship B) Are shown for both directions of a relationship C) Indicate whether a relationship is mandatory or optional

The primary key of an entity type can be:

(All of the above) A) Directly derived B) Borrowed C) Inherited

When applying the optional 1-M relationship rule for converting an ERD into a relational table design, which of the following statements is true:

(All of the above) A) Each 1-M relationship with 0 for the minimum cardinality on the parent side becomes a new table. B) The primary key of the new table is the primary key of the entity type on the child (many) side of the relationship. C) The new table contains foreign keys for the primary keys of both entity types participating in the relationship. Both foreign keys in the new table do not permit null values.

Nonprocedural access to a database:

(All of the above) 1. Can provide a dramatic improvement in software productivity. 2. Allows a user to submit queries to a database without having to know how the data will be retrieved. 3.Is supported by more than one tool in most DBMSs.

The SQL database language includes statements for:

(All of the above) Database definition, database manipulation, database control

For the generalization hierarchy rule, which of the following is true?

(All of the above.) A) Each entity type of a generalization hierarchy becomes a table. B) The columns of a table are the attributes of the corresponding entity type plus the primary key of the parent entity type. C) For each table representing a subtype, define a foreign key constraint that references the table corresponding to the parent entity type.

When trying to determine a primary key for and entity, what characteristics of an attribute make an attribute a potential primary key?

(all of the above) A) the attribute should be unique for all instances of an entity B) the attribute should be stable (not an attribute that changes value over time) C) the attribute should be single purpose (used for identification of an entity instance, not other purposes)

RENTLENGTH shows the number of days for the rental number (Rtn) of the table Rentals (this table exists for the sake of testing SQL. Normally, the data here should be part of table Rentals.) The execution of the command SELECT Cname FROM Customer WHERE Resid_City = BirthPlace will produce the following number of rows:

1 or 2

The Hollywood studio BestFlick wants to have a database designed to have access to the following information about all the movies it ever produced: title, yearreleased, director, actors, stuntmen, "Oscars" awarded. A movie has only one director. In this description, the gender is irrelevant. "Actor", "director", "stuntman" can be male or female. "Oscar for best acting" refers to an Oscar for best actor or best actress and also includes best supporting actor or actress. You would show director OF movie by a:

1-M relationship

The execution of the SQL query SELECT DISTINCT C1.Cname FROM Customer C1, Customer C2 WHERE C1.BirthPlace = C2.Resid_City will produce the following number of rows:

3 or 4

For the 1-1 relationship rule, which of the following statements is correct?

A and B A. The 1-1 relationship is converted into two foreign keys. B. If the relationship is optional with respect to one of the entity types, the corresponding foreign key may be dropped to eliminate null values.

When applying the M-M relationship rule for converting an ERD into a relational table design, which of the following statements is true:

A and C A. Each M-N relationship becomes a separate table. C. The primary key of the table is a combined key consisting of the primary keys of the entity types participating in the M-N relationship.

When an equi-join is performed on a table of N rows and a table of M rows, the resulting table has the following number of rows:

A number in the range 0 to M*N

The Union of a table of N rows and of a table of M rows (M<=N) has the following number of rows:

A number in the range N to M+N

In the relational database terminology, a table is synonymous with:

A relation

Oscar for best acting would be an attribute of:

A relationship "Starring-in" between Movie and Actor

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?

Accept the deletion without any other action

With respect to transaction processing, and DBMS should be capable of

All of the above

In a systems development methodology, the following graphical model should be produced:

All of the above (Data model, process model, environment interaction model)

Which of the following statements is not true of a desktop DBMS?

Although useful for processing ad hoc queries, they cannot perform transaction processing.

Oscar for best director should be:

An attribute of movie

Which of the following decisions would be part of Physical Database Design?

An index file will be created on the last name of students in the Student table

A relational algebra operator applied to tables Dx and Ex produces the following result:

An outer join operator (Deptno 100,200,300)

Regarding connection rules for ERD's, which statement is not true:

B and C are not true B) Relationships can be connected to other relationships C) All entity types participate in at least one relationship

After execution of the query SELECT Resid_City, AVG(Age) AS Avgage FROM Customer GROUP BY Resid_City The largest value in the column under the heading Avgage will appear in the row showing the following value for Resid_City:

CARY

Which of the following is not a SQL database manipulation statement?

CREATE TABLE

An arrangement of components (clients and servers) and data among computers connected by a network. It supports efficient processing of messages between clients and servers.

Client-server architecture

Entity Relationship Diagrams are output from the following phase of Database Development:

Conceptual Data Modeling

Activity that produces a table design from an ERD:

Conversion

Which of the following is not a phase of database development?

DBMS Selection

A support position that specializes in managing individuals databases and DBMS

Database administrator

Which of the following is not a statement type in SQL?

Database design

The following pair of tables is union compatible:

Dept1, Dept4

In an ERD, generalization hierarchies always contain:

Disjointness and completeness constraints

Because the user specifies what parts of the database to retrieve, the SELECT statement of SQL is a procedural way to access a database.

False

IBM's DB2 is one example of an embedded DBMS.

False

In a client-server environment, DBMS software typically executes only on the server.

False

In many organizations, power users are responsible for collecting database requirements and designing applications.

False

In most organizations, the data administrator has narrower responsibilities than the database administrator and usually reports directly to them.

False

The Three Schema Architecture is one of several types of client-server architecture.

False

Three characteristics of all databases are that the data is persistent, the database is distributed, and the data is interrelated.

False ( Persistent, inter-related, shared)

Converting from an ERD to a table design

Forward Engineering

After execution of the command SELECT Cname FROM Customer ORDER BY Resid_City, Cname the value shown first will be:

GREEN

The company that created SQL is:

IBM

Which of the following is not true of a DBMS?

It has evolved over the years into a fairly simple set of tools that are relatively easy to master.

Which of the following statements is not true of information resource management?

It is very different and much more challenging than managing the other physical resources of an organization.

Which of the following is an advantage of view design and integration over unique conceptual design?

It works better for large projects

Which statement is not true of the Three Schema Architecture?

Its details have been widely adopted in third- and fourth-generation DBMSs.

Following a power failure, the database is restored with a wrong price for a data item. This break in data quality was caused by:

Lack of reliability

You would show actor starring IN movie as a:

M-N relationship

In comparing ERD's to relational database diagrams, which of the following statements is true:

None of the above

In the evolution of database technology, third-generation products supplanted second-generation systems because:

Nonprocedural database access was an improvement over navigational access.

A scaled down version of a system, usually implemented quickly and used to clarify requirements

Prototype

Which of the following statements does not apply to relational databases?

Relational databases have a strong procedural orientation

In a SQL query that gets its data from two tables, and where the keywords WHERE, GROUP, ORDER and HAVING appear, which operation is performed before the other ones?

Restriction on WHERE conditions

In a SQL query that gets its data from two tables, and where the keywords WHERE, GROUP, ORDER and HAVING appear, which operation is performed last?

Restrictions on HAVING conditions

The recognized standard database language is:

SQL

Given the evolution of DBMSs, business data is now:

Stored only if it is relevant to business decisions.

In the traditional Systems Development Life Cycle, databases are actually produced during the following phase:

Systems Implementation

Logical database design takes place during:

Systems design

You would show stuntman doing stunts for actor in movie as a:

Ternary relationship (Chen's notation) or associative entity type (Crow's Foot notation)

A null value indicates:

The absence of a value

When converting the ERD to a relational table, what would be the primary key of the RoomAssign table?

The combination of Faculty_ID, Room_Number, Building_Number, and DateAssigned

When converting the ERD to a relational table, what would be the primary key of the Room table?

The combination of Room_Number and Building_Number

A relational algebra operator applied to tables Ex and Dx produces the following result: That operator is:

The extended cross product operator (Empdeptno, Deptno)

A relational algebra operator applied to tables Dx and Ex produces the following result: That operator is:

The natural join operator (Empdepton 300,200)

Which one of the following indicates poor data quality?

The same supplier is shown with two different addresses in two parts of the database

In the evolution of database technology, second-generation products are considered to be the first true DBMSs because:

They could manage multiple entities and relationships.

Most commercial DBMS systems support database definition, manipulation and tuning, as well as providing graphical application development tools and a procedural language interface.

True

Persistence of data in a database is dependent on the relevance of the business's intended usage.

True

With the growing importance of network computing and the internet, distributed processing has become a critical function of DBMSs.

True

Narrative analysis is one method of developing the data model. Which of the following are good techniques to help create the narrative analysis?

all of the above A) conducting interviews B) reviewing documents and system documentation C) examining existing data

Which of the following should be included in design documentation?

all of the above A) decisions that might be unclear to others even if there are no feasible alternatives B) documentation of inconsistency in a specification C) documentation of incompleteness in a specification

A goal of normalization is to:

minimize data redundancy

A database description

schema

When converting the ERD to a relational table, how many attributes with the RoomAssign table have?

three