INF3703 Assignment 2 (COMPLETE ANSWERS) 2026 - Due 26 June 2026

Databases II - INF3703 Assignment 2 2026 - Due 26 June 2026; 100 % TRUSTED workings, Expert Solved, Explanations and Solutions. For assistance call or W.h.a.t.s.a.p.p us on ...(.+.2.5.4.7.7.9.5.4.0.1.3.2)........... INF3703_ Assignment 02_2026 Due date 26th of June 2026 Submission Instruction -Write in word document -Convert to pdf -Submit/upload to Myunisa link on module site 1. This assignment covers the following areas: 1.1 Detail study Chapter 10 – 12 and some of 13. 1.2 Identification of organization or generating a case-study. 1.3 Designing of database, covering all the outcomes of the assignment rubric. 1.4 Adhering to the evaluation criteria. 2. What are you required to do in this assignment? 2.1. Each student must find a business, school, organisation etc. or generate a case-study. 2.2. Each student must design a database using the database using the information gathered from database initial study. 2.3. Students can work in group if you want but unique individual assignment will be submitted. 3.4. A rubric is provided on how the marks will be allocated and also how marks can be deducted. 3.8. The goal of this assignment is to apply the fundamental design principles to design a database. 1. Organisation and problem identification Find an organization, community business, school, NGOs of your choice in your area or outside your area. Analyze the organization and identify database issues they have, which can be addressed by either designing a new database or improving the existing one. 24 marks For students struggling to get a physical real-world organisation/business (that can allowed access) to analyze, your database design can be based on a case study. You will need to do some research and come up with a detailed description of an organisation/business. 1 1 If you are using your own organization (where you physically contacted and went to the organization) please ensure to obtain signed permission from the organization. 2. Information or data gathering The next time after identification of organizational issues is to collect information you will need to conceptualize a database that would address the issue. You would have to discuss with the stakeholder or other resourceful individuals in the case of physical real-world or articulate information you will generate in the case-study (hence it might be necessary to have discussion with other students’ to brainstorm). You might also need to read other documents to get a better understanding of the domain of expertise of the organisation. The aim of this activity is for you to get a better understanding of the organisation business and the problems at hand (or perceived problem) in order to propose an adequate database. 16 Marks 3. Proposed design models 25 marks Once you have developed an understanding of the problem to be addressed, design the conceptual model based on the business rules you have developed. If you are modifying existing database first present the existing conceptual module then the proposed new one. Transform the conceptual model into a logical model. As with the conceptual model, if it is for database improvement, first present the existing logical model and later the new one. Once you have the logical database model use it to develop Physical model for those improving an existing database, do the same as with conceptual and logical model. 4. SQL Queries - Define and explained transactions - Formulate possible transactional queries (SQL statements) that is in line with the objectives of the database you created. - Example, formulate the SQL statement that you can be used to create database tables for the identified entities. and formulate. -If you have access to database software you use in INF3708, Like Oracle Database 21c Express Edition (XE), you can use it for the creation of table if not you can just create a table using any means. 25 marks 5. Evaluation Criteria: Each student must submit an assignment document of 10 – 20 pages. The layout and style, including front page, margins, table of contents, font, headings, spacing, alignment, paragraphs, lists, figures, tables, captions, headers, footers, pages, academic/scientific writing conventions, must be professional. Language, grammar and spelling must be properly checked. Instructions: The pages should be numbered (bottom center) Include table of content Use “time new romans” Font size 12 The paragraphs should be justified and single spacing. EXAMPLE OF COMPANIES TO CONSIDER READING MORE ON AND USE AS A CASE-STUDY 10 marks - Huurkor Property Group -University of South Africa -Any other South African universities © Unisa2026