logo

ECM38IS Database Systems and Administration Assignment

10 Pages1020 Words229 Views
   

Database Systems and Administration (ECM38IS)

   

Added on  2020-05-28

ECM38IS Database Systems and Administration Assignment

   

Database Systems and Administration (ECM38IS)

   Added on 2020-05-28

ShareRelated Documents
Running head: PG-DSA-ECM38IS-Fall-17-CW2PG-DSA-ECM38IS-Fall-17-CW2PART AName of the StudentName of the UniversityAuthor Note
ECM38IS Database Systems and Administration Assignment_1
1PG-DSA-ECM38IS-Fall-17-CW2Table of ContentsTask 2:............................................................................................................................2Task 3:............................................................................................................................3Task 4:............................................................................................................................4Task 5:............................................................................................................................7
ECM38IS Database Systems and Administration Assignment_2
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)
ECM38IS Database Systems and Administration Assignment_3

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
System Analysis and Design for Middle East College and Sydney Dentist Centre
|8
|891
|316

Database Design and Development
|15
|1113
|118

System Analysis and Designing Assignment 2022
|13
|1571
|25