Relational Database Exam Study
Questions Solved 100% Correct
update anomaly - ANSWER changes to existing data are not correctly recorded, due
to the multiple records with the same data attributes
insert anomaly - ANSWER unable to add a records to the database
delete anomaly - ANSWER removing a record also removes unintended data from
the database
update anomaly - ANSWER Suppose Alice Simpson changes her phone number. You
need to make the change in three places. If you fail to change it in all three places or
change it incorrectly in one place, then the records for Alice will be inconsistent
insert anomaly - ANSWER What happens if you have a new student to add, but
he hasn't signed up for any courses yet?
Or what if there is a new class to add, but there are no students enrolled in it yet?
In either case, the record will be partially blank.
delete anomaly - ANSWER If Ned withdraws from all his classes and you eliminate all
three of his rows from the table, then you will no longer have a record of Ned. If Ned is
planning to take classes next semester, then you probably didn't really want to delete all
records of him.
, Design requirements for relational data base - ANSWER 1. Every column must be
single valued.
2. Primary keys must contain data (Not
Null). Entity Integrity
3.Foreign Keys must contain the same data as the primary key in another
table. Referential Integrity
4.All other attributes must identify a characteristic of the table identified by the primary
key.
Describe the DATA Hierarchy - ANSWER Field- Attributes about an entity
Record- Related group of fields
File- related group of records
Database- related group of a files
What are the advantages of Database Systems - ANSWER Data Integration- Combined
and accessible
Data Sharing-easily to access
Minimizing Redundancy & Data inconsistency- Eliminates same data
storage Data independence- data separate from programs
Cross functional analysis- Departments can be more easily combined
Questions Solved 100% Correct
update anomaly - ANSWER changes to existing data are not correctly recorded, due
to the multiple records with the same data attributes
insert anomaly - ANSWER unable to add a records to the database
delete anomaly - ANSWER removing a record also removes unintended data from
the database
update anomaly - ANSWER Suppose Alice Simpson changes her phone number. You
need to make the change in three places. If you fail to change it in all three places or
change it incorrectly in one place, then the records for Alice will be inconsistent
insert anomaly - ANSWER What happens if you have a new student to add, but
he hasn't signed up for any courses yet?
Or what if there is a new class to add, but there are no students enrolled in it yet?
In either case, the record will be partially blank.
delete anomaly - ANSWER If Ned withdraws from all his classes and you eliminate all
three of his rows from the table, then you will no longer have a record of Ned. If Ned is
planning to take classes next semester, then you probably didn't really want to delete all
records of him.
, Design requirements for relational data base - ANSWER 1. Every column must be
single valued.
2. Primary keys must contain data (Not
Null). Entity Integrity
3.Foreign Keys must contain the same data as the primary key in another
table. Referential Integrity
4.All other attributes must identify a characteristic of the table identified by the primary
key.
Describe the DATA Hierarchy - ANSWER Field- Attributes about an entity
Record- Related group of fields
File- related group of records
Database- related group of a files
What are the advantages of Database Systems - ANSWER Data Integration- Combined
and accessible
Data Sharing-easily to access
Minimizing Redundancy & Data inconsistency- Eliminates same data
storage Data independence- data separate from programs
Cross functional analysis- Departments can be more easily combined