A file contains records of students sorted into undergraduates followed by postgraduates. Undergraduate students pay fees at rate A and postgraduates at rate B. Students from other countries pay fees at rate E for undergraduates and rate G for postgraduates.
a) Draw a physical data structure diagram for the file
b) Draw a logical DSD when its required to produced a list of all students who have paid their fees.
c) Draw a logical DSD for a program listing foreign postgraduates students
d) Draw a DSD for a program listing undergraduates who have not paid their fees.
No comments:
Post a Comment