IT243 – System Analysis and Design

Part-II – Short Answer Questions

[4 Questions – Each question carry 4 mark]

 

 

• What is referential integrity and how is it implemented in a relational database?     

 

 

 

 

 

 

Compare between the types of interface design prototypes.

 

 

 

 

 

Part IV – Long Answer Questions

[4 Questions – 19 points]

 

A university has an online registration systemthat enables thestaff of each academic department to examine the courses offered by their department, add andremove courses, and change the information about them (e.g., the maximum number of students permitted).It should permit students to examine currently available courses, add and drop courses toand from their schedules, and examine the courses for which they are enrolled. Department staffshould be able to print a variety of reports about the courses and the students enrolled in them. The systemshould ensure that no student takes too many courses and that students who have any unpaid feesare not permitted to register. (Assume that a fees data store is maintained by the university’s financialoffice, which the registration system accesses but does not change).                                                                                                                        

 

 

 

• Draw a level-0 data flow diagram (DFD) for the university registration system.     

 

 

 

 

 

 

 

Based on the data flow diagram created in section 1, create a structure chart for the system. Develop a use scenario for the university registration system.                                  IT243 – System Analysis and Design

Part-II – ShortAnswer Questions

 

[4Questions – Each question carry 4 mark]

 

 

 

1.   What is referential integrity andhow is it implemented in a relational database?     

 

 

 

 

 

 

 

 

 

 

 

 

 

2.     Compare between the types ofinterface design prototypes.

 

 

 

 

 

 

 

 

 

 

 

Part IV – Long Answer Questions

 

[4Questions – 19 points]

 

A university hasan online registration systemthat enables thestaff of each academicdepartment to examine the courses offered by their department, add andremovecourses, and change the information about them (e.g., the maximum number ofstudents permitted).It should permit students to examine currently availablecourses, add and drop courses toand from their schedules, and examine thecourses for which they are enrolled. Department staffshould be able to print avariety of reports about the courses and the students enrolled in them. Thesystemshould ensure that no student takes too many courses and that studentswho have any unpaid feesare not permitted to register. (Assume that a fees datastore is maintained by the university’s financialoffice, which the registrationsystem accesses but does not change).                                                                                                                       

 

 

 

 

 

 

 

1)     Draw a level-0 data flow diagram(DFD) for the university registration system.     

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

2)     Based on thedata flow diagram created in section 1, create a structure chart for thesystem.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

3)     Develop a usescenario for the university registration system.                                  

 

 

 

 

 

 

 

 

IT243 – System Analysis and Design Part-II – Short Answer Questions[4 Questions – Each question carry 4 mark]1.What is referential integrity and how is it implemented in a relational database?2.Compare between the types of interface design prototypes.Part IV – Long Answer Questions[4 Questions – 19 points]A university has an online registration systemthat enables thestaff of each academicdepartment to examine the courses offered by their department, add andremovecourses, and change the information about them (e.g., the maximum number ofstudents permitted).It should permit students to examine currently available courses,add and drop courses toand from their schedules, and examine the courses for whichthey are enrolled. Department staffshould be able to print a variety of reports aboutthe courses and the students enrolled in them. The systemshould ensure that nostudent takes too many courses and that students who have any unpaid feesare notpermitted to register. (Assume that a fees data store is maintained by the university’sfinancialoffice, which the registration system accesses but does not change).1)Draw a level-0 data flow diagram (DFD) for the university registration system.

 

• 1495767701-it 243 fahad.docx

ComputerScienceExpert

(11)

Status NEW Posted 26 May 2017 02:05 AM My Price 8.00

-----------

Attachments

file 1495767706-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer