ISTM 4121 – Fall 2016.

Added on - 13 Sep 2019

  • 4

    Pages

  • 635

    Words

  • 71

    Views

  • 0

    Downloads

Trusted by +2 million users,
1000+ happy students everyday
Showing pages 1 to 2 of 4 pages
ISTM 4121 – Fall 2016Name:Ans:NAMEGPAMAJORIDADDRESSCOURSE-IDC-DESCGRADECREDITLincolnPlatoPlatoJonesJonesJonesJonesDunnWilliamWilliamWilliamBrownBrown3.63.43.43.03.03.03.03.23.13.13.13.53.5Poly-sciPhiloPhiloEngEngEngEngEngPhysPhysPhysChemChem444412341234789078907890789033331111111111112233223333Main11 1st11 1st22 2nd22 2nd22 2nd22 2nd33 3rd44 4th44 4th44 4th1 Broad1 BroadSA101SA101BA202SA101BA202DP209AC101DP209SA101AC101BA202DP209AC101Sandbox 1Sandbox 1Bskweav 2Sandbox 1Bskweav 2DatabaseAcctngDatabaseSandbox 1AcctngBskweav 2DatabaseAcctngAACDEABBFADCA3323233333233Primary Key:here primary key is a composite key that is: (courseID and ID)Insertion:If want to addnewcourse with new course id and its description then currently according to thisdatabase we are unable to add new course details. We have to add at least one student details toadd new course details.Deletion:Suppose the batch of students are done with the course and know we need to delete the record ofstudents from the database but we also want to keep course details because they are still runningin university. This type of database design create a problem because we have to delete unwanteddata too.There may be one more reason for deletion anomaly and that is supposed we want to keep datafor all student but we want to delete that course details from the database that is not supposed to
run anymore by the university. This also creates a problem where we have to delete unwanteddata too.Modification:Suppose the student wants to change his/her address. This requires that all tuples correspondingto that student name of the table are modified by given new address. If we fail to update all thetuples for that student then two different records for that student may store and this leadsinconsistent database.
desklib-logo
You’re reading a preview
Preview Documents

To View Complete Document

Click the button to download
Subscribe to our plans

Download This Document