Question 1

An ER diagram that contains two entities involved in two separate M:N relationships will be mapped as how many relations?&#10;A)1&#10;B)2&#10;C)3&#10;D)4

Accepted Answer

Each M:N relationship is mapped to a separate relation, and each entity is also mapped to a relation. Therefore, two entities and two M:N relationships result in four relations.

Question 2

If an M:N relationship is optional on both sides,and if both relations resulting from the entities involved in the relationship each have 3 records,then the resulting bridge relation cannot have less than ________ records.

A)0
B)1
C)3
D)9

Accepted Answer

Since the relationship is optional on both sides, it's possible that none of the entities are related to each other, resulting in 0 records in the bridge relation.

Question 3

An entity with two multivalued attributes will be mapped as how many relations?&#10;A)1&#10;B)2&#10;C)3&#10;D)4

Accepted Answer

An entity with two multivalued attributes will be mapped as 3 relations: 
1. A relation for the entity itself 
2. A relation for one multivalued attribute and primary key of the entity 
3. Another relation for the other multivalued attribute and primary key of the entity

Question 4

Which of the following is NOT true? Mapping an M:N relationship that has no attributes will result in:&#10;A)A new relation&#10;B)Two foreign keys&#10;C)A composite primary key&#10;D)A foreign key in both of the relations mapped from the involved entities

Accepted Answer

In an M:N relationship without attributes, a new relation is created to map the relationship, which includes two foreign keys (one from each of the entities involved in the relationship) and often uses these foreign keys together as a composite primary key. However, it does not result in a foreign key being placed in both of the original entity relations; instead, the foreign keys are part of the new relation created to represent the M:N relationship.

Question 5

If an M:N relationship is mandatory on both sides,and if both relations resulting from the entities involved in the relationship each have 3 records,then the resulting bridge relation cannot have less than ________ records.

A)0
B)1
C)3
D)9

Accepted Answer

If an M:N relationship is mandatory on both sides,and if both relations resulting from the entities involved in the relationship each have 3 records,then the resulting bridge relation cannot have less than ________ records.

A)0
B)1
C)3
D)9

Question 6

If a 1:M relationship is mandatory on the M side and optional on the 1 side,and if the table resulting from the 1 side has 3 records,then the table resulting from the M side cannot have less than ________ records.

A)0
B)1
C)2
D)3

Accepted Answer

Since the relationship is mandatory on the M side, every record in the M side table must be associated with a record in the 1 side table. However, since it's optional on the 1 side, not every record on the 1 side needs to have a corresponding record on the M side. Given there are 3 records on the 1 side, the minimum number of records on the M side to satisfy the mandatory relationship is 3, one for each record on the 1 side.

Question 7

If a 1:M relationship is mandatory on both sides,and if the table resulting from the 1 side has 3 records,then the table resulting from the M side CANNOT have less than ________ records.&#10;A)0&#10;B)1&#10;C)2&#10;D)3

Accepted Answer

Since the relationship is mandatory on both sides, each record on the 1 side must be associated with at least one record on the M side, and there cannot be any record on the M side without a corresponding record on the 1 side. Therefore, with 3 records on the 1 side, there must be at least 3 records on the M side to satisfy the mandatory relationship.

Question 8

If a 1:M relationship is mandatory on both sides,which of the following is true?&#10;A)The resulting foreign key can have null (empty)values&#10;B)The resulting foreign key cannot have null (empty)values&#10;C)The resulting foreign key must have null (empty)values&#10;D)No foreign key is created as a result of mapping such a relationship

Accepted Answer

If the 1:M relationship is mandatory on both sides, then the resulting foreign key cannot have null (empty) values. This ensures that every record in the child table has a corresponding record in the parent table, and vice versa, with no missing or orphaned records.

Question 9

If a 1:M relationship is optional on the M side and mandatory on the 1 side,and if the table resulting from the 1 side has 3 records,then the table resulting from the M side CANNOT have less than ________ records.

A)0
B)1
C)2
D)3

Accepted Answer

The answer of If a 1:M relationship is optional on...

Question 10

If a 1:M relationship is optional on both sides,which of the following is true?&#10;A)The resulting foreign key can have null (empty)values&#10;B)The resulting foreign key cannot have null (empty)values&#10;C)The resulting foreign key must have null (empty)values&#10;D)No foreign key is created as a result of mapping such a relationship

Accepted Answer

If a 1:M relationship is optional on both sides, then it means that one record in the '1' table can be related to multiple records in the 'M' table, but it doesn't have to be mandatory to have a match. Similarly, a record in the 'M' table can be related to only one record in the '1' table or none at all. In this scenario, the resulting foreign key in the 'M' table can have null values because not every record in the 'M' table needs to have a match in the '1' table. Therefore, option A is correct.

Question 11

Which of the following statements regarding the table below is true?
$\begin{array} { | l | l | l |} \hline \text { ColumnA } & \text { ColumnB } & \text { ColumnC } \\\hline\end{array}$

A)Every value in Column A is unique
B)Every value in Column B is unique
C)Every combination of values in Column A and Column B within the same row is unique
D)All of the above

Accepted Answer

The answer of Which of the following statements regarding the...

Question 12

If an entity has three unique attributes,how many primary keys will its mapped relation have?&#10;A)0&#10;B)1&#10;C)2&#10;D)3

Accepted Answer

The answer of If an entity has three unique attributes,how...

Question 13

Which of the following is NOT true? In a relational database:&#10;A)Two tables can be a part of the same database&#10;B)Two tables can have the same number of columns&#10;C)Two tables can have the same number of rows&#10;D)Two tables can have the same names

Accepted Answer

The answer of Which of the following is NOT true?...

Question 14

If a 1:M relationship is optional on both sides,and if the table resulting from the 1 side has 3 records,then the table resulting from the M side CANNOT have less than ________ records.&#10;A)0&#10;B)1&#10;C)2&#10;D)3

Accepted Answer

The answer of If a 1:M relationship is optional on...

Question 15

If a 1:M relationship is mandatory on the 1 side and optional on the M side,which of the following is true?&#10;A)The resulting foreign key can have null (empty)values&#10;B)The resulting foreign key cannot have null (empty)values&#10;C)The resulting foreign key must have null (empty)values&#10;D)No foreign key is created as a result of mapping such a relationship

Accepted Answer

The answer of If a 1:M relationship is mandatory on...

Question 16

Relation is a synonym for&#10;A)Column&#10;B)Field&#10;C)Row&#10;D)Table

Accepted Answer

The answer of Relation is a synonym for&#10;A)Column&#10;B)Field&#10;C)Row&#10;D)Table...

Question 17

Tuple is a synonym for&#10;A)Column&#10;B)Field&#10;C)Row&#10;D)Table

Accepted Answer

The answer of Tuple is a synonym for&#10;A)Column&#10;B)Field&#10;C)Row&#10;D)Table...

Question 18

If an M:N relationship is mandatory on one side and optional on the other side,and if both relations resulting from the entities involved in the relationship each have 3 records,then the resulting bridge relation cannot have less than ________ records.

A)0
B)1
C)3
D)9

Accepted Answer

The answer of If an M:N relationship is mandatory on...

Question 19

Which of the following is NOT true? In a relational table:&#10;A)Two columns can have the same values&#10;B)All column names are different&#10;C)Two rows can have the same values&#10;D)All values in a column are from the same domain

Accepted Answer

The answer of Which of the following is NOT true?...

Question 20

If a 1:M relationship is optional on the 1 side and mandatory on the M side,which of the following is true?&#10;A)The resulting foreign key can have null (empty)values&#10;B)The resulting foreign key cannot have null (empty)values&#10;C)The resulting foreign key must have null (empty)values&#10;D)No foreign key is created as a result of mapping such a relationship

Accepted Answer

The answer of If a 1:M relationship is optional on...

Question 21

ABC RETAILER&#10;Observe the ER diagram for the ABC Retailer:&#10;  &#10;How many columns will the relation PROMOTION have in the relational schema mapped from the ABC Retailer ER diagram?&#10;A)2&#10;B)3&#10;C)4&#10;D)5

Accepted Answer

The answer of ABC RETAILER&#10;Observe the ER diagram for the...

Question 22

How many columns will a relation resulting from mapping the Entity Y have?&#10; &#10;A)2&#10;B)3&#10;C)4&#10;D)5

Accepted Answer

The answer of How many columns will a relation resulting...

Question 23

CENTRAL SCHOOL LIBRARY&#10;Observe the ER diagram for the CENTRAL SCHOOL LIBRARY&#10;  &#10;How many tables in the relational schema mapped from the Central School Library ER diagram will have composite primary keys?&#10;A)0&#10;B)1&#10;C)2&#10;D)3

Accepted Answer

The answer of CENTRAL SCHOOL LIBRARY&#10;Observe the ER diagram for...

Question 24

CENTRAL SCHOOL LIBRARY&#10;Observe the ER diagram for the CENTRAL SCHOOL LIBRARY&#10;  &#10;How many columns will the relation COPY have in the relational schema mapped from the Central School Library ER diagram?&#10;A)2&#10;B)3&#10;C)4&#10;D)5

Accepted Answer

The answer of CENTRAL SCHOOL LIBRARY&#10;Observe the ER diagram for...

Question 25

CENTRAL SCHOOL LIBRARY&#10;Observe the ER diagram for the CENTRAL SCHOOL LIBRARY&#10;  &#10;What is the minimal number of records that can be entered in the database whose relational schema is mapped from the Central School Library ER diagram?&#10;A)1&#10;B)4&#10;C)5&#10;D)12

Accepted Answer

The answer of CENTRAL SCHOOL LIBRARY&#10;Observe the ER diagram for...

Question 26

ABC RETAILER&#10;Observe the ER diagram for the ABC Retailer:&#10;  &#10;How many foreign keys will the relational schema mapped from the ABC Retailer ER diagram have?&#10;A)0&#10;B)1&#10;C)2&#10;D)3

Accepted Answer

The answer of ABC RETAILER&#10;Observe the ER diagram for the...

Question 27

CENTRAL SCHOOL LIBRARY&#10;Observe the ER diagram for the CENTRAL SCHOOL LIBRARY&#10;  &#10;How many tables will the relational schema mapped from the Central School Library ER diagram have?&#10;A)2&#10;B)3&#10;C)4&#10;D)5

Accepted Answer

The answer of CENTRAL SCHOOL LIBRARY&#10;Observe the ER diagram for...

Question 28

CENTRAL SCHOOL LIBRARY&#10;Observe the ER diagram for the CENTRAL SCHOOL LIBRARY&#10;  &#10;How many bridge tables will the relational schema mapped from the Central School Library ER diagram have?&#10;A)0&#10;B)1&#10;C)2&#10;D)3

Accepted Answer

The answer of CENTRAL SCHOOL LIBRARY&#10;Observe the ER diagram for...

Question 29

Autonumber data type option:&#10;A)Automatically converts the existing data type into a number type&#10;B)Assigns a number to each of the used data types&#10;C)Enables automatic generation of consecutive numeric data values in a column&#10;D)Enables automatic counting of columns in a table

Accepted Answer

The answer of Autonumber data type option:&#10;A)Automatically converts the existing...

Question 30

ABC RETAILER&#10;Observe the ER diagram for the ABC Retailer:&#10;  &#10;How many tables will the relational schema mapped from the ABC Retailer ER diagram have?&#10;A)2&#10;B)3&#10;C)4&#10;D)5

Accepted Answer

The answer of ABC RETAILER&#10;Observe the ER diagram for the...

Question 31

CENTRAL SCHOOL LIBRARY&#10;Observe the ER diagram for the CENTRAL SCHOOL LIBRARY&#10;  &#10;How many foreign keys in the relational schema mapped from the Central School Library ER diagram serve as a component of a primary key?&#10;A)0&#10;B)1&#10;C)2&#10;D)3

Accepted Answer

The answer of CENTRAL SCHOOL LIBRARY&#10;Observe the ER diagram for...

Question 32

ABC RETAILER&#10;Observe the ER diagram for the ABC Retailer:&#10;  &#10;How many columns will the relation BRAND have in the relational schema mapped from the ABC Retailer ER diagram?&#10;A)2&#10;B)3&#10;C)4&#10;D)5

Accepted Answer

The answer of ABC RETAILER&#10;Observe the ER diagram for the...

Question 33

ABC RETAILER&#10;Observe the ER diagram for the ABC Retailer:&#10;  &#10;How many optional columns will the relational schema mapped from the ABC Retailer ER diagram have?&#10;A)0&#10;B)1&#10;C)2&#10;D)3

Accepted Answer

The answer of ABC RETAILER&#10;Observe the ER diagram for the...

Question 34

CENTRAL SCHOOL LIBRARY&#10;Observe the ER diagram for the CENTRAL SCHOOL LIBRARY&#10;  &#10;How many columns will the relation LIBRARY BOOK have in the relational schema mapped from the Central School Library ER diagram?&#10;A)2&#10;B)3&#10;C)4&#10;D)5

Accepted Answer

The answer of CENTRAL SCHOOL LIBRARY&#10;Observe the ER diagram for...

Question 35

CENTRAL SCHOOL LIBRARY&#10;Observe the ER diagram for the CENTRAL SCHOOL LIBRARY&#10;  &#10;How many foreign keys will the relational schema mapped from the Central School Library ER diagram have?&#10;A)0&#10;B)1&#10;C)2&#10;D)3

Accepted Answer

The answer of CENTRAL SCHOOL LIBRARY&#10;Observe the ER diagram for...

Question 36

A relation resulting from a weak entity has a non-composite primary key when the identifying relationship is:&#10;A)Optional on both sides&#10;B)1:1&#10;C)1:M&#10;D)M:N

Accepted Answer

The answer of A relation resulting from a weak entity...

Question 37

CENTRAL SCHOOL LIBRARY&#10;Observe the ER diagram for the CENTRAL SCHOOL LIBRARY&#10;  &#10;How many columns will the relation AUTHOR have in the relational schema mapped from the Central School Library ER diagram?&#10;A)2&#10;B)3&#10;C)4&#10;D)5

Accepted Answer

The answer of CENTRAL SCHOOL LIBRARY&#10;Observe the ER diagram for...

Question 38

CENTRAL SCHOOL LIBRARY&#10;Observe the ER diagram for the CENTRAL SCHOOL LIBRARY&#10;  &#10;How many optional columns will the relational schema mapped from the Central School Library ER diagram have?&#10;A)0&#10;B)1&#10;C)2&#10;D)3

Accepted Answer

The answer of CENTRAL SCHOOL LIBRARY&#10;Observe the ER diagram for...

Question 39

How many columns will a relation resulting from mapping the Entity X have?&#10; &#10;A)2&#10;B)3&#10;C)4&#10;D)5

Accepted Answer

The answer of How many columns will a relation resulting...

Question 40

ABC RETAILER&#10;Observe the ER diagram for the ABC Retailer:&#10;  &#10;How many columns will the relation PRODUCT have in the relational schema mapped from the ABC Retailer ER diagram?&#10;A)2&#10;B)3&#10;C)4&#10;D)5

Accepted Answer

The answer of ABC RETAILER&#10;Observe the ER diagram for the...

Question 41

EAGLERUN TRUCKING DISPATCHER&#10;Observe the ER diagram for the Eaglerun Trucking Dispatcher:&#10;  &#10;How many foreign keys in the relational schema mapped from the Eaglerun Trucking Dispatcher ER diagram serve as a component of a primary key?&#10;A)0&#10;B)1&#10;C)2&#10;D)3

Accepted Answer

The answer of EAGLERUN TRUCKING DISPATCHER&#10;Observe the ER diagram for...

Question 42

EAGLERUN TRUCKING DISPATCHER&#10;Observe the ER diagram for the Eaglerun Trucking Dispatcher:&#10;  &#10;How many tables in the relational schema mapped from the Eaglerun Trucking Dispatcher ER diagram will have composite primary keys?&#10;A)0&#10;B)1&#10;C)2&#10;D)3

Accepted Answer

The answer of EAGLERUN TRUCKING DISPATCHER&#10;Observe the ER diagram for...

Question 43

EAGLERUN TRUCKING DISPATCHER&#10;Observe the ER diagram for the Eaglerun Trucking Dispatcher:&#10;  &#10;What is the minimal number of records that can be entered in the database whose relational schema is mapped from the Eaglerun Trucking Dispatcher ER diagram?&#10;A)1&#10;B)4&#10;C)5&#10;D)12

Accepted Answer

The answer of EAGLERUN TRUCKING DISPATCHER&#10;Observe the ER diagram for...

Question 44

EAGLERUN TRUCKING DISPATCHER&#10;Observe the ER diagram for the Eaglerun Trucking Dispatcher:&#10;  &#10;How many columns will the relation TRUCK have in the relational schema mapped from the Eaglerun Trucking Dispatcher ER diagram?&#10;A)0 or 1&#10;B)1 or 2&#10;C)2 or 3&#10;D)3 or 4

Accepted Answer

The answer of EAGLERUN TRUCKING DISPATCHER&#10;Observe the ER diagram for...

Question 45

EAGLERUN TRUCKING DISPATCHER&#10;Observe the ER diagram for the Eaglerun Trucking Dispatcher:&#10;  &#10;How many columns will the relation REGION have in the relational schema mapped from the Eaglerun Trucking Dispatcher ER diagram?&#10;A)2&#10;B)3&#10;C)4&#10;D)5

Accepted Answer

The answer of EAGLERUN TRUCKING DISPATCHER&#10;Observe the ER diagram for...

Question 46

A relational schema is a visual depiction of the relational database model.

Accepted Answer

The answer of A relational schema is a visual depiction...

Question 47

EAGLERUN TRUCKING DISPATCHER&#10;Observe the ER diagram for the Eaglerun Trucking Dispatcher:&#10;  &#10;How many tables will the relational schema mapped from the Eaglerun Trucking Dispatcher ER diagram have?&#10;A)2&#10;B)3&#10;C)4&#10;D)5

Accepted Answer

The answer of EAGLERUN TRUCKING DISPATCHER&#10;Observe the ER diagram for...

Question 48

EAGLERUN TRUCKING DISPATCHER&#10;Observe the ER diagram for the Eaglerun Trucking Dispatcher:&#10;  &#10;How many columns will the relation DRIVER have in the relational schema mapped from the Eaglerun Trucking Dispatcher ER diagram?&#10;A)0 or 1&#10;B)1 or 2&#10;C)2 or 3&#10;D)3 or 4

Accepted Answer

The answer of EAGLERUN TRUCKING DISPATCHER&#10;Observe the ER diagram for...

Question 49

Two columns of a relational table can have the same names.

Accepted Answer

The answer of Two columns of a relational table can...

Question 50

Two columns of a relational table can have the same values.

Accepted Answer

The answer of Two columns of a relational table can...

Question 51

An optional attribute of an entity is not mapped as a column of a relation.

Accepted Answer

The answer of An optional attribute of an entity is...

Question 52

A foreign key column must have the same name as the primary key column it refers to.

Accepted Answer

The answer of A foreign key column must have the...

Question 53

EAGLERUN TRUCKING DISPATCHER&#10;Observe the ER diagram for the Eaglerun Trucking Dispatcher:&#10;  &#10;How many foreign keys will the relational schema mapped from the Eaglerun Trucking Dispatcher ER diagram have?&#10;A)1&#10;B)2&#10;C)3&#10;D)4

Accepted Answer

The answer of EAGLERUN TRUCKING DISPATCHER&#10;Observe the ER diagram for...

Question 54

EAGLERUN TRUCKING DISPATCHER&#10;Observe the ER diagram for the Eaglerun Trucking Dispatcher:&#10;  &#10;How many bridge tables will the relational schema mapped from the Eaglerun Trucking Dispatcher ER diagram have?&#10;A)0&#10;B)1&#10;C)2&#10;D)3

Accepted Answer

The answer of EAGLERUN TRUCKING DISPATCHER&#10;Observe the ER diagram for...

Question 55

Within one relation,two rows can be identical.

Accepted Answer

The answer of Within one relation,two rows can be identical....

Question 56

Two columns of two different tables in the same relational database can have the same names.

Accepted Answer

The answer of Two columns of two different tables in...

Question 57

A row of a relation can have in its column two values from the column's domain.

Accepted Answer

The answer of A row of a relation can have...

Question 58

If one of two identical relational tables has the first row moved to the last place,those two relational tables are no longer identical.

Accepted Answer

The answer of If one of two identical relational tables...

Question 59

If one of two identical relational tables has the last column row moved to the first place,those two relational tables are no longer identical.

Accepted Answer

The answer of If one of two identical relational tables...

Question 60

EAGLERUN TRUCKING DISPATCHER&#10;Observe the ER diagram for the Eaglerun Trucking Dispatcher:&#10;  &#10;How many unique non-primary key columns will the relational schema mapped from the Eaglerun Trucking Dispatcher ER diagram have?&#10;A)0&#10;B)1&#10;C)2&#10;D)3

Accepted Answer

The answer of EAGLERUN TRUCKING DISPATCHER&#10;Observe the ER diagram for...

Question 61

GENERIC ERD&#10;Observe the GENERIC ER Diagram below:&#10;  &#10;If in the GENERIC ERD the Symbol 1 is >| and the Symbol2 is ||,then the number of optional columns in the relational schema resulting from mapping the GENERIC ERD is 0.

Accepted Answer

The answer of GENERIC ERD&#10;Observe the GENERIC ER Diagram below:&#10;...

Question 62

The relation resulting from mapping a weak entity (with a 1:M identifying relationship)has a composite primary key that is composed of the partial identifier and a foreign key corresponding to the primary key of the owner entity.