IS1060 数据库开发指引

使用数据管理软件进行数据库应用程序的分析、设计和开发。您的目标是让UOL相信您能够选择数据管理问题并应用适当的系统分析和设计技术，以解决问题并着手开发
数据库应用程序。你的作品必须展示知识的证据以及一些应用介绍了数据库管理软件的主要功能。对于这项任务，UOL的期望是使用数据管理构建一个简单的应用程序
软件，以帮助某人或社会/商业实体管理运营数据和记录。对于对于应用程序，您应该建立一个精心设计的数据库，用于存储操作数据和记录。您的应用程序应允许用户执行数据输入和维护操作和查询，以及使用数据库中的数据生成摘要报告。注意：您的应用程序必须提供数据输入、数据库查询和报告生成功能，以及用户界面，允许用户容易地选择和执行应用程序的任何功能。
.IS1060 Database Assignment

1. Objective & Expectation

This assignment is another mandatory coursework of IS1060 Introduction to Information Systems.The objective is to enable UOL to confirm that you have a good understanding of the basis ofanalysis, design and development of a database application using data management software.Your aim is to convince UOL that you are able to select a data management problem and applyappropriate systems analysis and design techniques to address the problem and proceed to developa database application. Your work must show evidence of knowledge as well as application of someof the main features of the database management software.For this assignment, UOL’s expectation is a simple application, built using data managementsoftware, to help someone or a social/business entity in managing operational data and records. Forthe application, you should establish a well-designed database for storing operational data andrecords. Your application should allow a user(s) to perform data entry and maintenance, datamanipulation and inquiry, and generation of summary reports, using the data in the database.Note: Your application must offer data entry, database query and report generation functions, and a mainuser interface to allow the user to select and perform any functions of the application easily.2. Work Requirements for the AssignmentBelow are the key work requirements for the assignment:1) The problem selected must be a data management problem, and the completed databaseapplication must be able to provide data entry, database query and report generation functions2) Data analysis work must be carried out on the data required by the application, recommendedto start with 3 to 5 entity classes, then apply data normalization3) A normalized class diagram (using UML notations) that represents a logical data model for theapplication must be established prior to the design of the database4) The logical data model must be implemented as a physical data model in a database using datamanagement software, with relevant tables defined with primary keys and non-key attributes,and the tables must be linked according to the relationships identified in the class diagram5) Design, development, implementation and testing of data entry forms for the application, andthen populate the database with data and records using the forms6) Design, development, implementation and testing of database queries, database reports and amain user interface for the application3. Reporting Requirements for the AssignmentUpon completing of the works for the assignment, you should prepare an assignment report andsubmit it to me for review, and later to UOL for final assessment. Below are the key requirementsfor the assignment report:1) Provide a brief description cum justification of the problem selected and tackled, including theobjective(s) and target user(s) of the application, and highlight the functions offered by theapplication (recommended to provide a use case diagram)2) Highlight the data analysis works you have carried out, the data normalization and final list ofnormalized entity classes, and create a normalized class diagram with brief explanations aboutthe relationships between the e

2.Entity classes

Highlight the physical tables you have implemented in a database, including the relationshiplinks between the tablesShow and explain the main user interface and some of the data entry forms, database queriesand database reports you have incorporated into the application5) Share your journey, challenges, system limitations and/or lessons learned from the assignment6) The report should be produced with the aid of a word processing software, e.g. Microsoft Word,and relevant diagrams should be prepared using a drawing software, e.g. Microsoft PowerPoint7) You must capture and include relevant screen shots from your forms, queries and reports to beshown as evidences of your works8) Every page of the report should be numbered and showing your UOL’s student number, and thereport must not exceed 8 pages (recommended 6~8 pages inclusive of appendix, if any)9) You should complete the assignment report and submit it to me for review by the proposeddate, and you must upload the final report to UOL by 1 March via VLE4. Work Schedule for the Assignment

3. Recommendations

It is strongly recommended that the idea for your DSS should be based on experience or interestthat you have, or an application area that you believe is needed, in the world around you. You arerequired to provide evidence of originality of the topic chosen and your personal involvement.Although your application should be a working system, the correctness of the technical solution isnot the most important criteria. The examiner is keen to know your journey in the analysis, designand development of the application. Therefore, in your assignment report, you must highlight andshare your problems, mistakes encountered, and how you overcome them.6. References
Before you start working on this assignment, you must read Chapter 2: Coursework and Chapter 18:Database Assignment of the Subject Guide.
WX：codehelp