Database structural Modifications Page 2 (et seq.)—Database structural Modificat
ID: 3846060 • Letter: D
Question
Database structural Modifications
Page 2 (et seq.)—Database structural Modifications:
Create a Word document itemizing the structural changes you would make to your original database for the purposes of improving performance. List tables in alphabetical order followed by a numbered list itemizing the changes and briefly support (provide the reasons for) the your structural changes you propose. You may put more than one table's change information on one page but do not allow a single table's information to break across pages unless it is too large to fit on a single page.
Profe ssional CE Provider FEIN. ProviderFirstName FirstName Provider astName ast Name bmits Gender Starte Date Address MainPhone Number Application Enrollment qualifies Application ID Enrollm Enrollm ent StatusID license TypeID Code Renew License ID umber SubmissionDate SectionID has Decision Date Term Qualification has SSN cationID o Application License Type QualificationTypeID has icense Name Section equines requires SectionlD nstructorID Degree Lconana has icense ProviderID CE Course ID allif ion' QualificationTypeID Degree Type License Type License SectionNumber SSN Term School issue Date License TypeID Room Numbe Gradua Expiration Date ion Date Decision Date Approved BylD ExpirationDate Application ID receives Document ID Document Title Submission Date QualificationType ReviewBylD Applicant FirstName ific ionT eID ApplicantLastName QualificationName Document Description Received From Received Date QualificationID Revie WID ApprovalDate Document Status DenialDate ocument Status Received Date DMQAStaff NotReviewedD Approved Date Staff ID Disapproved Date StaffFirst Name dete StaffID Staff astName DepartmentID License RenewallD Date Position ID LoginID InstructorEmployment FEIN Employment Division Instructor struct orlD SSN uctorStart Date CE Course FEIN QualificationTypeID Course Number Course Name Course Hou hasExplanation / Answer
Single database table contains unnormalised data causes performance degradation. In the same way maintaining many tables is also causes performance degradation. Which means when we are creating a table in the database first we have to check whether is really needed to be created.
In this case the above database also contains some extra tables which those can be removed.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.