ECM38IS Database Systems and Administration Assignment

Added on - 28 May 2020

  • 10

    pages

  • 1020

    words

  • 1

    views

  • 0

    downloads

Showing pages 1 to 3 of 10 pages
Running head: PG-DSA-ECM38IS-Fall-17-CW2PG-DSA-ECM38IS-Fall-17-CW2PART AName of the StudentName of the UniversityAuthor Note
1PG-DSA-ECM38IS-Fall-17-CW2Table of ContentsTask 2:............................................................................................................................2Task 3:............................................................................................................................3Task 4:............................................................................................................................4Task 5:............................................................................................................................7
2PG-DSA-ECM38IS-Fall-17-CW2Task 2:The tables has been created as per the case study to cover the entire requirement.DHE had developed the previous version of their working procedure with the help of excel.The new system is to be developed using a database. The basic requirement of theorganization needs to be stored with the help of the following tables:1.colleges2.schools3.studentDetails4.eligibleStudents5.seatAllotment6.studentReporting7.fellowship8.detailsViewThe details are to be stored in the above tables in the form of:Colleges (collegeID (PK), names, address, affiliation, degreeOffered, duration,feesYearly)Schools (schoolID (PK), name, address, modulesOffered)studentDetails(studentID (PK), schoolID (FK), passingYear, modCY, modPY)eligibleStudents (studentID (FK), modulesTaken, modulesCleared, applyDate)seatAllotment(studentID (FK), totalMarks, allotment, payment, deadlineProvided)studentReporting (StudentID (FK), dadlineProvided, reportingDate)
desklib-logo
You’re reading a preview
card-image

To View Complete Document

Become a Desklib Library Member.
Subscribe to our plans

Unlock This Document