Table information is used to answer E6.8 (picture attached) Operational Database
ID: 3708893 • Letter: T
Question
Table information is used to answer E6.8 (picture attached)
Operational Databases TABLE A: INCOMING STUDENTS DEPOSITS DepositDeposit Amount Date 2/12/2013 $1,000 2/12/2013 $1,000 2/13/2013 $1,000 2/13/2013| $1,000 2/14/2013 $1.000 2/14/2013 $1,000 2/15/2013 $1,000 2/15/2013 $1,000 2/16/2013 $1,000 2/16/2013 $1,000 Total No of Students 10 Total Amount of $10,000 Deposits TABLE B INCOMING STUDENTS INFORMATION Student ID Student Student Passport Date of DepositStudent Home Student Home Town Detroin Country USA Lname Fname Number 200602 |Mc 200803 Suzuk Mark US2000001 02/12/2013 Akiko JA7000001 02/12/2013 USA 200604 Jones Mary US2000002 02/13/2013 200605 Lalime Patrick CA3000001 February 13th, 2013 MontrealCanada 200606Van Basten Robin NE4000001 02/14/2013 200607 Van Basten Rob NE4000001 02/14/2013 200608 Vrabec Alen CR5000001 02/14/2013 200609 Popov 200610 De Beers Inge NE4000002 02/15/2013 Amsterdam Neverland Netherlands Amsterdam Amsterdam Netherlands Zagreb Plovdiv Croatia Stilian BU6000001 02/15/2013 Number of 9 Incoming Students RE 6.38 Albus International Academy Tables SE TO-DEFAULT E6.8 Consider the following scenario. If a DBMS enforces an UPDATE option on the referential integrity constraint be- tween SALES REP and TERRITORY, show the records in tahles SALES REP and TERRITORY At Albus International Academy, every incon makes a $1,000 deposit. Albus International A 10 incomine studetExplanation / Answer
Answer)
Data Quality problems :
Accuracy - Accuracy is not maintained in the tables Table B INCOMING STUDENTS INFORMATION and Table A : INCOMING STUDENTS DEPOSITS. This is because the Total Number of Incoming Students in Table B is 9 while the Total number of Students in Table A is 10.
Uniqueness - We should have a Primary key and a Student ID column for Table A : INCOMING STUDENTS DEPOSITS to identify that which student deposited which money and on what date. Without this the uniqueness of the entries are not valid and nothing can be understood from the table.
Completeness - Incomplete data in entered in Table B INCOMING STUDENTS INFORMATION for StudentID 200603 where the Student Home Country field is left blank. Thus the table suffers from Incompleteness.
Consistency - Inconsistent data is entered in the Table B INCOMING STUDENTS INFORMATION. Here the Student ID 200606 and 200607 corresponds to the same student as they have the same passport number NE4000001. Thus there are 2 rows of the same data and 2 rows created for the same date with different Student Ids.
Timeliness - Timeliness is the data should be available when needed and data should be presentable when it is expected and needed. Here in above Tables A and B, the tables are filled with incomplete structuring and inconsistent and incomplete data. Thus, Timeliness is not maintained here, and the data would be unusable for such scenarios here.
Conformity - According to the Standards of Table B : INCOMING STUDENTS INFORMATION, we should have the date format as MM/DD/YYYY while we can find that for StudentID 200605 the Date Of Deposit field has other format than the format required as MM/DD/YYYY. Thus this voids the conformity of the table.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.