Computer Science Question
College of Computing and Informatics Assignment 2 Deadline: Day 5/5/2024 @ 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): CLO4:Demonstrat e the role of software quality assurance and software testing for successful software development. Question One 2 Marks Given the Saudi Electronic University’s shift towards a more comprehensive online learning environment, assess the critical design considerations for a robust distributed system that supports both synchronous and asynchronous learning across diverse geographic locations. – Discuss the trade-offs involved in ensuring scalability, reliability, and security within this distributed system. – Provide examples of potential system architectures, such as client/server and cloud computing, that could be utilized to enhance the university’s virtual learning capabilities. Question Two Pg. 02 Learning Outcome(s): CLO3: Recognize Question Two 2 Marks The Smart Health Clinic is looking to improve its patient management system by incorporating a new data model. The clinic handles various activities such as patient registration, appointment scheduling, medical tests, treatment histories, and billing. different concepts, principles, and Task: • software modelling techniques • Design a Conceptual Data Model: • Create an Entity-Relationship (E-R) diagram to represent the data model of the Smart Health Clinic system. Your model should include the following entities: • Patient (with attributes such as Patient_ID, Name, DOB, Address, and Contact_Number) • Doctor (including attributes like Doctor_ID, Name, Specialty, and Contact_Number) • Appointment (featuring Appointment_ID, Date, Time, and Status) • Medical Test (including Test_ID, Test_Name, and Price) • Treatment (with attributes like Treatment_ID, Description, and Cost) • Billing (featuring Bill_ID, Amount, Date, and Payment_Status) • Define the relationships between these entities with appropriate cardinalities. • Annotate key business rules that govern these relationships (e.g., a patient can have multiple appointments, but each appointment is with one specific doctor). Discuss Conceptual Integrity: • Explain how entity and referential integrities are maintained in your model. • Identify any potential areas where the model might be normalized to prevent data redundancy and maintain data integrity. Question Three Pg. 03 Learning Outcome(s): CLO3 Recognize Question Three 2 Marks You are provided with an initial table structure for an Employee Management System of a medium-sized company. This table contains data about employees, their department, and their project assignments. Initial Table: EmployeeProjects different concepts, principles, and EmployeeID EmployeeName Department Salary ProjectCode ProjectName ProjectBudget software modelling This table is not normalized and contains several anomalies. Use the normalization process to techniques. organize this data into well-structured tables that eliminate redundancy, insertion anomalies, deletion anomalies, and update anomalies. . Tasks: 1. Identify Anomalies: • Describe any insertion, deletion, and update anomalies present in the original EmployeeProjects table. 2. First Normal Form (1NF): • Convert the table to 1NF and explain the changes made to achieve 1NF, addressing any repeating groups and partial dependencies. 3. Second Normal Form (2NF): • Progress the table from 1NF to 2NF. Identify and remove any partial dependencies that do not meet the rules of 2NF. Explain which data was moved to new tables and the rationale behind these changes. 4. Third Normal Form (3NF): • Move the table from 2NF to 3NF by eliminating transitive dependencies. Describe the transformation process and justify the creation of any new tables. 5. Final Schema: • Provide the schema of the final normalized tables, including primary keys and foreign keys for each table. 6. Reflective Analysis: • Discuss how normalization improves the integrity and efficiency of the database. Reflect on how the new schema supports better data management practices compared to the original table structure. Question Four Pg. 04 Learning Outcome(s): CLO3: Recognize different concepts, principles, and software modelling techniques. Question Four 2 Marks Go online and find four different forms for four different e-commerce applications. Compare the forms using the general usability guidelines in table 10-9 “course textbook”.
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
