Advantages of using a DMBS approach

What are the problems this example pose to the business operations?

1 pts

volume_mute

In a university, the course registration personnel and the accounting office are processing the students details in two separate excel sheets. Each group has its own version of the students. The accounting office keeps data on registration and related billing information, whereas the registration office keeps track of student courses and grades. Other groups may further duplicate some or all of the same data in their own files.

Increased network traffic

Duplication of effort, wasted storage, and potential data inconsistency

Slower processor speed

Incompatibility with object-oriented programming languages

note_alt Add notes

flag Flag

Correct Answer

Explanation

In the ideal database approach, data normalization means every logical data item is stored in exactly one place in the database.

1 pts

volume_mute

True

False

note_alt Add notes

flag Flag

Correct Answer

Explanation

Redundancy control

1 pts

The practice of intentionally introducing redundancy to improve query performance is called (1). The DBMS must then have mechanism to (2) this redundancy to prevent inconsistencies.

Please drag and drop the selected option in the right place or type it instead

control

denormalization

note_alt Add notes

flag Flag

Correct Answer

Explanation

Identify the inconsistency between the two tables

1 pts

volume_mute

These two tables have been purposely kept redundant to improve query peformance. However, the DBMS controls were not effective. Can you identify which attribute is inconsistent?

STUDENT TABLE

number	name	class	major
17	Smith	1	CS
8	Brown	2	CS

GRADE REPORT TABLE

number	name	identifier	course	grade
17	Brown	112	MATH2410	B

The student number is 17

The student name is 'Brown'

The Grade is 'B'

The course number is 'MATH2410'

note_alt Add notes

flag Flag

What are the problems this example pose to the business operations?

Correct Answer

Explanation

In the ideal database approach, data normalization means every logical data item is stored in exactly one place in the database.

Correct Answer

Explanation

Redundancy control

Correct Answer

Explanation

Identify the inconsistency between the two tables

Correct Answer

Explanation

Quran Recitation

Query Dictionary

Select a result: