Database Management Quiz 1 & 2

A member of a subtype does NOT necessarily have to be a member of the supertype. True False

False

An enterprise data model describes the scope of data for only one information system. True False

False

In the figure below, Name would be an ideal identifier Student SID Name Address (Street, City, State, ZipCode) True False

False

In the figure shown below, a rental unit can be both a house and an apartment Rental Unit d Apartment House True False

False

The following diagram depicts a unary relationship with one-to-many cardinality Artist -> Album True False

False

The following figure is an example of total specialization. Student | Graduate | Undergraduate | Special True False

False

The physical structure and storage organization of the database is decided upon during the implementation phase of the systems development life cycle. True False

False

There can be multivalued attributes in a relation. True False

False

When transforming a one-to-one relationship, a new relation is always created True False

False

A person is an example of an entity. True False

True

A single occurrence of an entity is called an entity instance. True False

True

A well-structured relation contains minimal redundancy and allows users to manipulate the relation without errors or inconsistencies True False

True

Data modeling is about documenting rules and policies of an organization that govern data. True False

True

Entity clustering is a methodology for grouping one or more entity types and associated relationships into a single abstract entity type True False

True

In an E-R diagram, an associative entity is represented by a rounded rectangle. True False

True

In the figure shown below, there could be an instance of a rental unit that is neither an apartment nor a house. Rental unit | Apartment | House True False

True

One property of a relation is that each attribute within a relation has a unique name. True False

True

The default primary key for an associative relation consists of the two primary key attributes from the other two relations. True False

True

The following figure indicates that a person can marry at most one person and that the relationship is optional Person is_married_to True False

True

The user interface includes languages, menus, and other facilities by which users interact with various system components. True False

True

In the figure below, the primary key for "Order Line" is which type of key? Order Line Order_Line | Product_ID | Quality a. Composite b. Foreign c. Standard d. Grouped

a. Composite

Data that describes the properties of other data are: a. Metadata b.logical c. Physical d. Relationships

a. Metadata

The entity integrity rule states that: a. No primary key attribute can be null b. Referential integrity must be maintained across all entities c. Each entity must have a primary key d. A primary key must have only one attribute

a. No primary key attribute can be null

The process of defining one or more subtypes of a supertype and forming relationships is called: a. Specialization b. Generalization c. Creating discord d. Selecting classes

a. Specialization

The most common type of entities are: a. Strong b. Weak c. Associative d. Dependent

a. Strong

A primary key that consists of more than one attribute is called a: a. Foreign key b. Composite key c. Multivalued key d. Cardinal key

b. Composite key

In the SQL language, the _________ statement is used to make table definitions. a. Create session b. Create table c. Create index d. Create index

b. Create table

Data modeling may be the most important part of the systems development process because: a. The data in a system are generally less complex than the processes and play a central role in development. b. Data characteristics are important in the design of programs and other system components. c. It is the easiest. d. Limited program maintenance

b. Data characteristics are important in the design of programs and other system components.

________ is a component of the relational data model included to specify business rules to maintain the integrity of data when they are manipulated. a. Business rule constraint b. Data integrity c. Business integrity d. Data structure

b. Data integrity

The logical representation of an organization's is called a(n): a. Database model b. Entity-relationship model c. Relationship systems design d. Database entity diagram

b. Entity-relationship model

The following image represents: Agent No. Agent Name ABC011 IAN A HENDERSON ABC012 JUNE C MORTON ABC013 JANE E MARTIN ABC015 CARL R BREWER a. Data b. Information c. Knowledge d. Wisdom

b. Information

_____________ are established between entities in a well-structured database model so that the desired information can be retrieved. a. Entities b. Relationships c. Lines d. Attributes

b. Relationships

A simultaneous relationship between the instances of three entity types is called a ______________ relationship. a. Binary b. Ternary c. Unary d. Primary

b. Ternary

Because applications are often developed independently in file processing systems: a. The data is always non-redundant b. Unplanned duplicate data files are the rule rather than the exception. c. Data can always be shared with others d. There is a large volume of file I/O.

b. Unplanned duplicate data files are the rule rather than the exception.

The property by which subtype entities posses the values of all attributes of a supertype is called: a. Hierarchy reception b. Class management c. Attribute inheritance d. Generalization

c. Attribute inheritance

An attribute in a relation of a database that serves as the primary key of another relation in the same database is called a: a. Link attribute b. Link key c. Foreign key d. Foreign attribute

c. Foreign key

In the figure below, which of the following apply to both OUTPATIENTs and RESIDENT_PATIENTs? a. Checkback_Date b. Date_Dischard c. Patient_Name d. Bed_ID

c. Patient_Name

A property or characteristics of an entity type that is of interest to the organization is call a(n): a. co-existing entity b. Primary key c. Relation d. Attribute

d. Attribute

The following image represents: ABC011 IAN A HENDERSON ABC012 JUNE C MORTON ABC013 JANE E MARTIN ABC015 CARL R BREWER a. Information b. Knowledge c. Wisdom d. Data

d. Data

A two-dimensional table of a data sometimes called a: a. Group b. Set c. Declaration d. relation

d. relation