BUS4 112
The PRODUCT of STUDENT table and INSTRUCTOR table will produce a table with
24 Rows
A table that contains order details, such as OrderID, ProductID, Quantity, and Price, violates 2NF if the Price attribute is dependent only on the ProductID attribute, not on the entire primary key (OrderID and ProductID).
True
A table that is 3NF is also 1NF.
True
Choose the correct answer. An academic department is chaired by one professor; a professor may chair only one academic department.
1:1 Relation
Choose the correct answer. A customer may generate many invoices; each invoice is generated by one customer.
1:M relation
Table A has 9 records and 5 attributes. Table B has 5 records and 6 attributes. When a CROSS JOIN is performed between A and B, how many records would the resultant set have?
45
Which of the following is true about strong entity?
An Entity that is not existence dependent on some other entity type
A ____ consists of a group of programs that manipulate the database and provide an interface between the database and its users and other application programs.
DBMS
The attribute WAGE is calculated from multiplying HOURLY_RATE with HOURS_WORKED. The attribute WAGE is ____.
Derived Attribute
The method of joining tables so that the result includes unmatched rows of both tables is called ____.
Full outer
Which join returns all records from the left table, and the matched records from the right table?
Left outer join
Choose the correct answer. A student may have earned many degrees; a degree may have been earned by many students.
M:N relation
A ____ is a database model that describes data in which all data elements are placed in two-dimensional tables, called relations.
Relational Model
A relation is in 1NF if it doesn't contain any ____________.
Repeating Groups
Which join retrieves all the rows from both the tables that satisfy the join condition along with the unmatched rows of the right table?
Right Outer Join
_______is logical grouping of database objects, such as tables, indexes, views, and queries that are related to each other.
Schema
A recursive join is joining a table to itself.
True
A table that records customer orders with a column for "items ordered" that includes multiple items in a single cell would violate 1NF
True
CROSS JOIN returns the Cartesian product of rows from tables in the join. In other words, it will produce rows which combine each row from the first table with each row from the second table.
True
In 3NF, a table is in second normal form (2NF) and every non-key column is functionally dependent on the primary key.
True
Natural join eliminates duplicate columns in the resulting set after join is performed.
True
While normalization has many benefits, some potential disadvantages are increased complexity and slower query performance.
True
A foreign key is used to maintain ___________.
referential integrity
Which of the following is a characteristic of a table that is in First Normal Form (1NF)?
All of these
Which of the following is a characteristic of a table that is in Second Normal Form (2NF)?
All of these
For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.
Domain
A table is in 2NF if the table is in 1NF and what other condition is met?
Each non-key attribute must be dependent on the entire primary key, not just a part of it
In order to perform a join between two tables, there must be a common attribute among those two tables.
False
Relational databases are suitable for storing unstructured data.
False
In which normal form, a multivalued attribute is converted to individual attributes?
First
Which of the following is a characteristic of a table that is in Third Normal Form (3NF)?
It is 2NF and contains no transitive dependencies
_____ is a process for evaluating and correcting table structures to minimize data redundancies, thereby reducing the likelihood of data anomalies.
Normalization
Which key consists of an attribute or combination of attributes that uniquely identifies a row?
Primary Key
Consider an entity called EMPLOYEE. An EMPLOYEE may manage many EMPLOYEEs, and each EMPLOYEE is managed by one EMPLOYEE. This is an example of ____.
Recursive Relationship
For a weak entity to be meaningful, it must be associated with another entity, called ___.
Strong entity
Which one is the natural join of the following tables?
Table 3
A DOCTOR writes one or more PRESCRIPTIONs. A PATIENT may receive one or more PRESCRIPTIONs. This is an example of ____.
Ternary Relationship
Please select the best answer. A relation is in 1NF if it doesn't contain any ____________?
There are no multivalued or composite attributes
A table is in 2NF if the table is in 1NF and what other condition is met?
There are no partial dependencies
M:N relationships in a relational model are implemented by using a _____ entity.
composite
