Computer Science
Compared to a file system, how does a database management system avoid redundancy in data through a database?
Relational Database
8 Likes
Answer
A database stores the data at a central location wherefrom all application programs can access data. This removes the need of saving own data by application program and thus it reduces data redundancy.
Answered By
5 Likes
Related Questions
Differentiate between primary key and foreign key.
Differentiate between degree and cardinality of a relation.
What are the limitations of file system that can be overcome by a relational DBMS?
A school has a rule that each student must participate in a sports activity. So each one should give only one preference for sports activity. Suppose there are five students in a class, each having a unique roll number. The class representative has prepared a list of sports preferences as shown below. Answer the following:
Table: Sports Preferences
Roll_no Preference 9 Cricket 13 Football 17 Badminton 17 Football 21 Hockey 24 NULL NULL Kabaddi - Roll no 24 may not be interested in sports. Can a NULL value be assigned to that student’s preference field ?
- Roll no 17 has given two preferences in sports. Which property of relational DBMS is violated here ? Can we use any constraint or key in the relational DBMS to check against such violation, if any?
- Kabaddi was not chosen by any student. Is it possible to have this tuple in the Sports Preferences relation ?