IT 353 SEU Designing University Data Structures Questions

College of Computing and Informatics Assignment 2 Deadline: Sunday 26/11/2023 @ 23:59 [Total Mark for this Assignment is 8] Student Details: Name: ### ID: ### CRN: ### Instructions: • You must submit two separate copies (one Word file and one PDF file) using the Assignment Template on Blackboard via the allocated folder. These files must not be in compressed format. • It is your responsibility to check and make sure that you have uploaded both the correct files. • Zero mark will be given if you try to bypass the SafeAssign (e.g. misspell words, remove spaces between words, hide characters, use different character sets, convert text into image or languages other than English or any kind of manipulation). • Email submission will not be accepted. • You are advised to make your work clear and well-presented. This includes filling your information on the cover page. • You must use this template, failing which will result in zero mark. • You MUST show all your work, and text must not be converted into an image, unless specified otherwise by the question. • Late submission will result in ZERO mark. • The work should be your own, copying from students or other resources will result in ZERO mark. • Use Times New Roman font for all your answers. Question One Pg. 01 Learning Outcome(s): CLO 3 & 5: Recognize different concepts, principles, and software modelling techniques. Illustrate most common analysis and design techniques in the form. Question One 3 Marks Consider the following description of a university system where professors teach courses in which students can enrol: Each professor has a name, address, phone number, email address, and salary. A student has also a name, address, phone number and email address. A student also has an average mark (of the final marks of his or her course). Each person in the university has a unique id. A Course has a name, a number, and fees. When a student is enrolled in a course, the marks for this enrolment are recorded and the current average as well as the final mark (if there is one) can be obtained from the enrolment. Each student can obtain a list of courses he or she is enrolled in. Professors teach courses. Each course has at least one and at most three teachers. a) Draw a class diagram for this university? b) Add attributes and methods (operations) when necessary. Question Two Pg. 02 Learning Outcome(s): Question Two 2 Marks What is the purpose of Usability, Explain the goal and list the Success Factors: CLO3: Recognize different concepts, principles, and software modelling techniques. Question Three Pg. 03 Learning Outcome(s): CL5: CLO1Illustrate most common Outline modern analysis and design techniques approaches to in the form of a group systemproject. analysis Question Three 3 Marks Consider the following relation for product for xyz company. Products Product_ID PaymentDate Salesman Commision_amount Discount_amount With the following dependencies and design • PaymentDate -> Discount_amount • Salesman -> Commission_amount Apply normalization until the relationship meets the requirements of 3nf.