Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
Data Redundancy-A lot of information is being repeated in the relation. For instance, the information that MCS-014 is named SSAD is repetitive, address of Rahul is "D- 27, Main road, Ranchi" is being repetitive in the first 3 records. Please search the other duplicate information. So we search that the course name, student name, address, instructor name and office number are being repeated often, thus, the table has Data Redundancy.
Please also note that each time we wish to insert a student record for a subject taken by him/her, say for instance, MCS-013, we have to insert the name of the course as well as the name and office number of its instructor. Also, every time we insert a new course we have to repeat the name and address of the student who has taken it. This replication of information results in troubles in addition to the wastage of space. Notice these problems in the STUDENT relation. What are these problems? Let us explain them.
ERD Diagram of Medical Recruitment Agency?
sy bcs project of hospital managment system
Consider the two relations given below Given that A is the primary key of R, D is the primary key of S and there is a referential integrity among S.A and R.A, discuss all
Define hot swapping? Hot swapping permits the removal of faulty disks and changes it by new ones without turning power off. Hot swapping decreases the mean time to repair.
How persistent programming languages differ from traditional programming languages? Database languages vary from traditional programming languages in that they directly manipul
Consider the relations EMPLOYEE(emp#, name) ASSIGNED_TO(project#, emp#) PROJECT(project#, project_name, chief) Express the subsequent queries in Relational Algebra (i) Ge
various techniques of hashing?
In this exercise you will create ten records, each containing the following fields: student name, class: Freshman, Sophomore, Junior or Senior, Major: Liberal Arts or General Sci
What is a Name? A user-supplied name is used for identity. This form of identity is used for files in file systems. The user gives every file a name that uniquely identifies it
What is a checkpoint? List the operations to be performed by the system when a checkpoint is to be taken. What does the recovery system do if there is a crash? There is large n
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd