Department of Computing FINAL ASSIGNMENT COURSE : DATABASE SYSTEMS COURSE CODE : BCI2023 LECTURER : Gamal Mohamed DATE : 11/06/2020 TIME : 11:59 PM TOTAL MARKS : 100 SEMESTER /SESSION : Semester 2 / 2019-2020 PROGRAMME : BCN/BCS/BCG The distribution of marks among the parts of the question is indicated. INSTRUCTIONS TO CANDIDATE Please upload your answers to the provided “Final Exam /Assignment” space on Moodle. You may either type your answers in Word or handwrite and scan / photograph them. It is essential that you write your student number at the top of your answers and, if handwriting, on every sheet you use. If you have written or drawn anything on paper, please keep your copy so further photographs can be sent if needed during marking. THIS IS AN OPEN-BOOK EXAM / ASSIGNMENT AND YOU MAY CONSULT YOUR NOTES, BUT YOU MAY NOT CONSULT ANY ONLINE RESOURCE. YOU MUST COMPLETE THE EXAM / ASSIGNMENT UNDER EXAM CONDITIONS. YOU MUST TALK TO NO ONE AND MUST WORK ALONE. INCLUDE THE FOLLOWING DECLARATION AT THE END OF YOUR SUBMISSION: "I DECLARE THAT THIS IS MY OWN WORK" DO NOT SIGN THIS DECLARATION. This assignment paper consists of THREE (3) printed pages including the front page. QUESTION 1 Final Assignment: [Open Book] [50 Marks]  Read the below case study very well , understand, anlaysis and extract the useful information from it that can help you in answering the two questions related to it shown below it.  Muscat College is well known for the quality of its academic programs which aim at providing students with a true college education. Established in 1996 the College started its first academic year in 1997. Since then, the College has produced thousands of undergraduate students. In its academic programs the college serves more than thousand students in its various foundation, diploma, bachelor with honors and master degrees programs.  The registration department in the college has appointed you as a member in a team to develop its registration system database which can cover the information in the areas of: Student, Result, Modules, Lecturer, Subjects, Programs, Semester, Library, Accountant, Labs, Class Rooms, Activities…etc. for each area mentioned earlier there could be many properties for example properties such as Module Name, Module Code, Number of Assessments could be related to Module and the same case could be done for other functioning areas. You have been asked to produce a final report that can help in either establishing a new registration database management system or developing the existing one. With this background you are asked to perform the below shown tasks: a) With a bit of analysis to the current scenario of the college strength and various programs, identify and propose at least SIX (6) main entities with their corresponding attributes. (12 Marks) b) With respect to the attributes you have identified for all entities show and explain with real examples the types of the attributes. (8 Marks) c) Show these entities with their attributes in an ER model following both Gen Model and Crow’s Foot Model. (15 Marks) d) Relationships is very important in database management, with relation to your identified entities and attributes show with a real examples and drawings how the FOUR(4) types of relationship could be established. BCN2023 (15 Marks) Page 2 QUESTION 2 [50 MARKS]  The college has employed a new employers Majid and Noor to assist you in producing a testing portfolio for the system been designed initially for the sake of testing its efficiency and reliability. For that a real output for converting the entities and its corresponding attributes suggested by you earlier to a real computerized data in a form of tables, queries and reports. With this background perform the below tasks and show their outputs in your final report: a) Show the implementation for the command for creating all the above tables with their corresponding fields suggested by your team from the already identified entities and attributes. (10 Marks) b) Show the insertion of the records in all of the above tables with their fields that you have created using step above in (a). One record for each table. (10 Marks) c) Your manager would like to make sure that your proposed software for registration management system has more facilities show this practically in some of selected fields of some of your tables like how to alter field information, updating of record information deletion of some records. (15 Marks) d) As a test for the students’ ability and possibility of applying quires you have been asked to write TWO (2) quires one of them using only one table in the query and the other using multiple tables in the same query. Those queries could be implemented to show the workability of the system in this area. (5 Marks) e) The new created system needs to be checked whether it can support full report generation or not for that you have been asked to generate ONE report in any of the student’s areas i.e. registration of subjects, payment of fees or results generation. **END OF ASSIGNMENT PAPER** (10 Marks)
Purchase answer to see full attachment