ECM38IS Database Systems and Administration Assignment

Added on - May 2020

Trusted by 2+ million users,
1000+ happy students everyday
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 are reading a preview
Upload your documents to download or

Become a Desklib member to get access