Solution:1) List the names of all students majoring in computer science department(query)
2) change the major of smith to mechanical(update)
3) list the course names based on departments(query)
Solution: Controlled redundancy: Ensuring all the relavent data collected in one place and then collected into single database without any duplicates is called controlled redundancy.
For example take an organization which has two groups. The relavent data which is present in two groups must combined into a single database without any duplicates.
DBMS ensures the controlled redundancy over the data as the views of different users are combined during design phase.
Uncontrolled redundancy: If the data has redundancy