Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

Practice Midterm Exam Solutions | Database Management Systems | MIS 331, Quizzes of Database Management Systems (DBMS)

Material Type: Quiz; Professor: Zhang; Class: Database Management Systems; Subject: Management Info Systems Main; University: University of Arizona; Term: Fall 2015;

Typology: Quizzes

2014/2015
On special offer
30 Points
Discount

Limited-time offer


Uploaded on 10/18/2015

miker55-1
miker55-1 🇺🇸

4

(2)

1 document

1 / 3

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Practice Midterm Exam
(These are intended to give you a sense for the types of multiple choice questions you might get. This is NOT a full
exam – the actual exam is LONGER.)
Multiple Choice
1. Which of the following is not a potential advantage of the database approach?
a. minimal data redundancy. (Stored attribute/data in multiple tables) (Data duplication- unnecessary
copy of files)
b. reduced program maintenance. (need programs, many programs, work will increase
c. improved sharing of data. (DBMS- many users can use it, sharing increases)
d. data independence. (aka program data independence, if need to change description of data
(metadata) but do not need to change anything in program, achieved in database system
structured independence- users still have access to data
e. none of the above (all ARE advantages).
2. Recognizing that there are two subtypes of customer (e.g., profit and non-profit), each with different
characteristics, is an example of:
a. generalization
b. specialization
c. weak entities
d. business rules
e. none of the above.
3. The primary key of the relation JOB is the attribute JobNumber. Two other attributes of JOB are
ContractorName and ContractorAddress. There is a functional dependency between ContractorName and
ContractorAddress (such that contractor name determines contractor address). In what normal form is the JOB
relation?
a. First (but not second) normal form.
b. Second (but not third) normal form.
c. Third normal form.
d. Fourth normal form.
e. none of the above.
JOB (Job Number, Contractor Name, Contractor Address
Functional Dependency between Contractor Name Contractor Address
4. The primary key of the relation SALE is the attribute SaleNumber. Two other attributes of SALE are VendorName
and VendorLocation. The VendorLocation is functionally dependent on the VendorName. This is an example of a
relation that has a:
a. partial functional dependency.
b. transitive dependency.
c. multivalued dependency.
d. repeating group.
e. none of the above.
1
pf3
Discount

On special offer

Partial preview of the text

Download Practice Midterm Exam Solutions | Database Management Systems | MIS 331 and more Quizzes Database Management Systems (DBMS) in PDF only on Docsity!

Practice Midterm Exam

(These are intended to give you a sense for the types of multiple choice questions you might get. This is NOT a full exam – the actual exam is LONGER.) Multiple Choice

  1. Which of the following is not a potential advantage of the database approach? a. minimal data redundancy. (Stored attribute/data in multiple tables) (Data duplication- unnecessary copy of files) b. reduced program maintenance. (need programs, many programs, work will increase c. improved sharing of data. (DBMS- many users can use it, sharing increases) d. data independence. (aka program data independence, if need to change description of data (metadata) but do not need to change anything in program, achieved in database system structured independence- users still have access to data e. none of the above (all ARE advantages).
  2. Recognizing that there are two subtypes of customer (e.g., profit and non-profit), each with different characteristics, is an example of: a. generalization b. specialization c. weak entities d. business rules e. none of the above.
  3. The primary key of the relation JOB is the attribute JobNumber. Two other attributes of JOB are ContractorName and ContractorAddress. There is a functional dependency between ContractorName and ContractorAddress (such that contractor name determines contractor address). In what normal form is the JOB relation? a. First (but not second) normal form. b. Second (but not third) normal form. c. Third normal form. d. Fourth normal form. e. none of the above. JOB (Job Number, Contractor Name, Contractor Address Functional Dependency between Contractor NameContractor Address
  4. The primary key of the relation SALE is the attribute SaleNumber. Two other attributes of SALE are VendorName and VendorLocation. The VendorLocation is functionally dependent on the VendorName. This is an example of a relation that has a: a. partial functional dependency. b. transitive dependency. c. multivalued dependency. d. repeating group. e. none of the above.
  1. A STUDENT takes a CLASS is an example of what type of relationship? a. unary b. binary c. ternary d. recursive e. none of the above.
  2. An entity is always a weak entity if the following is true: I. It has a unique primary key X II. It is on the one side of a one-to-many relationship. X III. Its existence depends on the existence of another entity. a. I only b. II only c. III only d. I and III only e. II and III only. Short answer
  3. Answer the questions below using the following information: Class (ClassID#, Section#, Class name, instructor, enrollment) FD: ClassID# --> Class name Section# --> instructor a. In what normal form is the original relation? _____1NF______________ b. Why is it in that normal form (and not a higher or lower one)? Format of a relation, there is a composite key, and there are no multivalued attributes. No fully functional dependency c. Transform the relation into a set of relations in (at least) 3NF. 1 NF Class (Class ID, Section ID, Class Name, Instructor, Enrollment) 2 NF Class (Class ID, Section ID, Enrollment) New Class (Class ID, Class Name) Section (Section ID, Instructor) 3 NF Already in 3 NF, no transitive dependency