MIS 430 Flashcards
18) Attribute B of EntityX is a:
A) Composite attribute
B) Multivalued attribute
C) Derived attribute
D) Unique composite attribute
A) Composite attribute
19) In the ER Diagram for the SUNSHINE AIRLINE COMPANY, which word should replace AAA?
A) AirplaneTypeID
B) AIRPLANETYPE
C) AirportID
D) AIRPORT
B) AIRPLANETYPE
20) In the ER Diagram for the SUNSHINE AIRLINE COMPANY, which word should replace BBB?
A) AirplaneTypeID
B) AIRPLANETYPE
C) AirportID
D) AIRPORT
D) AIRPORT
21) In the ER Diagram for the SUNSHINE AIRLINE COMPANY, which word should replace xxx?
A) AirplaneTypeID
B) NoOfEngines
C) AirportID
D) LengthOfRunway
A) AirplaneTypeID
22) In the ER Diagram for the SUNSHINE AIRLINE COMPANY, which word should replace ppp?
A) AirplaneTypeID
B) NoOfEngines
C) AirportID
D) LengthOfRunway
C) AirportID
23) In the ER Diagram for the SUNSHINE AIRLINE COMPANY, which word should replace qqq?
A) AirplaneTypeID
B) NoOfEngines
C) AirportID
D) LengthOfRunway
D) LengthOfRunway
24) In the ER Diagram for the SUNSHINE AIRLINE COMPANY, which two words should replace yyy and zzz?
A) AirplaneTypeID and NoOfSeats
B) NoOfEngines and NoOfSeats
C) AirportID and AirplaneTypeID
D) LengthOfRunway and NoOfSeats
B) NoOfEngines and NoOfSeats
25) In the ER Diagram for the SUNSHINE AIRLINE COMPANY, Symbol1 should be:
A) ||
B) >|
C) >○
D) |○
B) >|
26) In the ER Diagram for the SUNSHINE AIRLINE COMPANY, Symbol2 should be:
A) ||
B) |<
C) ○<
D) ○|
B) |<
23) How many columns will a relation resulting from mapping the Entity X have?
A) 2
B) 3
C) 4
D) 5
C) 4
24) How many columns will a relation resulting from mapping the Entity Y have?
A) 2
B) 3
C) 4
D) 5
B) 3
25) How many tables will the relational schema mapped from the ABC Retailer ER diagram have?
A) 2
B) 3
C) 4
D) 5
C) 4
26) How many columns will the relation PROMOTION have in the relational schema mapped from the ABC Retailer ER diagram?
A) 2
B) 3
C) 4
D) 5
B) 3
27) How many columns will the relation PRODUCT have in the relational schema mapped from the ABC Retailer ER diagram?
A) 2
B) 3
C) 4
D) 5
B) 3
28) How many columns will the relation BRAND have in the relational schema mapped from the ABC Retailer ER diagram?
A) 2
B) 3
C) 4
D) 5
A) 2
29) How many foreign keys will the relational schema mapped from the ABC Retailer ER diagram have?
A) 0
B) 1
C) 2
D) 3
D) 3
30) How many optional columns will the relational schema mapped from the ABC Retailer ER diagram have?
A) 0
B)1
C) 2
D) 3
A) 0
31) How many tables will the relational schema mapped from the Central School Library ER diagram have?
A) 2
B) 3
C) 4
D) 5
C) 4
32) How many bridge tables will the relational schema mapped from the Central School Library ER diagram have?
A) 0
B) 1
C) 2
D) 3
B) 1
33) How many columns will the relation LIBRARY BOOK have in the relational schema mapped from the Central School Library ER diagram?
A) 2
B) 3
C) 4
D) 5
A) 2
34) How many columns will the relation COPY have in the relational schema mapped from the Central School Library ER diagram?
A) 2
B) 3
C) 4
D) 5
B) 3
35) How many columns will the relation AUTHOR have in the relational schema mapped from the Central School Library ER diagram?
A) 2
B) 3
C) 4
D) 5
A) 2
36) How many tables in the relational schema mapped from the Central School Library ER diagram will have composite primary keys?
A) 0
B)1
C) 2
D) 3
C) 2
37) How many foreign keys will the relational schema mapped from the Central School Library ER diagram have?
A) 0
B) 1
C) 2
D) 3
D) 3
38) How many foreign keys in the relational schema mapped from the Central School Library ER diagram serve as a component of a primary key?
A) 0
B) 1
C) 2
D) 3
D) 3
39) How many optional columns will the relational schema mapped from the Central School Library ER diagram have?
A) 0
B) 1
C) 2
D) 3
A) 0
40) 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?
A) 1
B) 4
C) 5
D) 12
C) 5
41) How many tables will the relational schema mapped from the Eaglerun Trucking Dispatcher ER diagram have?
A) 2
B) 3
C) 4
D) 5
42) How many bridge tables will the relational schema mapped from the Eaglerun Trucking Dispatcher ER diagram have?
A) 0
B) 1
C) 2
D) 3
43) How many columns will the relation DRIVER have in the relational schema mapped from the Eaglerun Trucking Dispatcher ER diagram?
A) 0 or 1
B) 1 or 2
C) 2 or 3
D) 3 or 4
44) How many columns will the relation TRUCK have in the relational schema mapped from the Eaglerun Trucking Dispatcher ER diagram?
A) 0 or 1
B) 1 or 2
C) 2 or 3
D) 3 or 4
45) How many columns will the relation REGION have in the relational schema mapped from the Eaglerun Trucking Dispatcher ER diagram?
A) 2
B) 3
C) 4
D) 5
46) How many foreign keys will the relational schema mapped from the Eaglerun Trucking Dispatcher ER diagram have?
A)1
B) 2
C) 3
D) 4
47) How many foreign keys in the relational schema mapped from the Eaglerun Trucking Dispatcher ER diagram serve as a component of a primary key?
A) 0
B) 1
C) 2
D) 3
48) How many tables in the relational schema mapped from the Eaglerun Trucking Dispatcher ER diagram will have composite primary keys?
A) 0
B) 1
C) 2
D) 3
49) How many unique non-primary key columns will the relational schema mapped from the Eaglerun Trucking Dispatcher ER diagram have?
A) 0
B)1
C) 2
D) 3
C) 2
50) 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?
A)1
B) 4
C) 5
D) 12
B) 4
7) Which of the following (regarding the relation ENROLLMENT) represents the insertion anomaly?
A) Inability to insert a student without adding a class
B) Inability to insert a class without adding a student
C) Inability to insert a class name without a class ID
D) Inability to insert a student name without a student ID
B) Inability to insert a class without adding a student
8) Which of the following (regarding the relation ENROLLMENT) represents the deletion anomaly?
A) Deleting a student ID may delete a student name
B) Deleting a class ID may delete the class name
C) Deleting class may delete all information about a student a student
D) Deleting a student may delete all information about a class
9) Which of the following (regarding the relation ENROLLMENT) represents the modification anomaly?
A) If a class name changes, it may have to be changed in more than one record
B) If a student ID changes, we may have to change the class ID as well
C) If a class ID changes, we may have to change the student ID as well
D) If a student decides to use a longer version of his or her name, we cannot accommodate that modification
A) If a class name changes, it may have to be changed in more than one record
10) Which of the following actions in the table ENROLLMENT will be prevented by an insertion anomaly?
A) Entering a new student 444, Sue
B) Entering a new student 555, Lisa
C) Entering a new record 666, Bob, E1, English
D) Entering a new class M1, Math1
D
D) Entering a new class M1, Math1
11) Which of the following is in danger of being affected by the deletion anomaly in the table ENROLLMENT?
A) Student 111, Joe
B) Student 222, Bob
C) Class H1, History
D) Class El, English
C) Class H1, History
12) Which of the following actions in the table ENROLLMENT will be affected by a modification anomaly?
A) Changing the name of Joe to Joseph
B) Changing the name of English1 to English101
C) Changing the name of History1 to History101
D) Changing the name of Bob to Robert
B) Changing the name of English1 to English101
13) Which of the following functional dependencies does NOT exist in the table ENROLLMENT?
A) StudentID –> StudentName
B) Student Name –> StudentID
C) StudentID –> ClassID
D) ClassID –> ClassName
B
B) Student Name –> StudentID
14) What type of functional dependency does NOT exist in the table ENROLLMENT?
A) Trivial
B) Full key
C) Partial
D) Transitive
C
C) Partial
15) Table ENROLLMENT is:
A) Not in 1NF
B) In 1NF but not in 2NF
C) In 2NF but not in 3NF
D) In 3NF
C
16) Normalizing table ENROLLMENT to 3NF will result in:
A) No changes (table ENROLLMENT remains as is, no additional tables)
B) Two separate tables
C) Three separate tables
D) Four separate tables
B) Two separate tables
17) Which of the following (regarding the relation FLIGHT) represents the insertion anomaly?
A) Inability to insert a flight without its occurrence
B) Inability to insert an origin without a destination
C) Inability to insert a destination without an origin
D) Inability to insert a number of passengers without a flight ID and date
18) Which of the following functional dependencies does not exist in the table FLIGHT?
A) FlightID –> NoOffPassengers
B) FlightID –> Origin
C) FlightID –> Destination
D) FlightID, Date –> NoOfPassengers
A) FlightID –> NoOffPassengers
19) Which of the following functional dependencies in the table FLIGHT is an augmented functional dependency?
A) FlightID, Date -> NoOfPassengers
B) FlightID –> Origin
C) FlightID –> Destination
D) FlightID, Date –> Origin
D) FlightID, Date –> Origin
20) What type of functional dependency does NOT exist in the table FLIGHT?
A) Trivial
B) Full key
C) Partial
D) Transitive
21) Table FLIGHT is:
A) Not in 1NF
B) In 1NF but not in 2NF
C) In 2NF but not in 3NF
D) In 3NF
22) Normalizing table FLIGHT to 3NF will result in:
A) No changes (table FLIGHT remains as is, no additional tables)
B) Two separate tables
C) Three separate tables
D) Four separate tables
B) Two separate tables
23) What type of functional dependency exists in the table DOCTOR?
A) Trivial
B) Partial
C) Transitive
D) All of the above
24) Table DOCTOR is:
A) Not in 1NF
B) In INF but not in 2NF
C) In 2NF but not in 3NF
D) In 3NF
D
D) In 3NF
25) Normalizing table DOCTOR to 3NF will result in:
A) No changes (table DOCTOR remains as is, no additional tables)
B) Two separate tables
C) Three separate tables
D) Four separate tables
A) No changes (table DOCTOR remains as is, no additional tables)
10) What will be the result of the following query on table STUDENT? SELECT * from STUDENT;
A) The entire relation STUDENT will be displayed
B) StudentID column of the relation STUDENT will be displayed
C) First record of the relation STUDENT will be displayed
D) Last record of the relation STUDENT will be displayed
A) The entire relation STUDENT will be displayed
11) Which of the following queries on table STUDENT will return three values as a result?
A) SELECT name FROM student WHERE class 1= ‘Sophomore’;
B) SELECT name FROM student;
C) SELECT DISTINCT name FROM student;
D) SELECT class FROM student;
C
C) SELECT DISTINCT name
FROM student;
12) Which of the following queries on table STUDENT will return number 2 as a result?
A) SELECT COUNT(*) FROM student;
B) SELECT COUNT(name) FROM student;
C) SELECT COUNT(class) FROM student;
D) SELECT COUNT(DISTINCT class) FROM student;
13) How many records will the following query on table STUDENT return? SELECT FROM student WHERE name LIKE ‘%or%’;
A) 0
B) 2
C) 3
D) 4
D
D) 4
14) What will be the result of the following query on table STUDENT? SELECT COUNT( *) FROM student GROUP BY class;
A) Number 5
B) Number 2
C) Numbers 2 and 3
D) Numbers 1 and 1
C
C) Numbers 2 and 3
15) What will be the result of the following query on table STUDENT? SELECT COUNT( *) FROM student GROUP BY class HAVING COUNT(*) <3;
A) Number 5
B) Number 2
C) Numbers 2 and 3
D) Numbers 1 and 1
B) Number 2
16) Which of the following sequences of CREATE TABLE statements for HAPPY INSURANCE database is in correct order?
A) CREATE TABLE area CREATE TABLE client CREATE TABLE agent
B) CREATE TABLE area CREATE TABLE agent CREATE TABLE client
C) CREATE TABLE client CREATE TABLE agent CREATE TABLE area
D) CREATE TABLE agent CREATE TABLE client CREATE TABLE area
B
B) CREATE TABLE area CREATE TABLE agent CREATE TABLE client
17) Which of the following sequences of DROP TABLE statements for HAPPY INSURANCE database is in correct order?
A) DROP TABLE area DROP TABLE client DROP TABLE agent
B) DROP TABLE area DROP TABLE agent DROP TABLE client
C) DROP TABLE client DROP TABLE agent DROP TABLE area
D) DROP TABLE agent DROP TABLE client DROP TABLE area
C
C) DROP TABLE client DROP TABLE agent DROP TABLE area
18) What will be retrieved by the following query on the table CLIENT? SELECT DISTINCT clientname FROM client WHERE clientspousename = ‘Amy’;
A) Name Amy twice
B) Name Amy
C) Name Cole
D) Names Andy and Cole
D
D) Names Andy and Cole
19) How many records will be retrieved by the following query on table AGENT? SELECT a.agentname, s.agentname FROM agent a, agent s WHERE a.supervisedby = s.agentid;
A) 0
B) 1
C) 2
D) 4
20) How many records will be retrieved by the following query on tables AGENT and AREA? SELECT * FROM agent ag, area a WHERE ag.agentarea = a.areaid;
A) 0
B) 3
C) 4
D) 12
C) 4
