How to do this?

format for the mini project report (50% of total project marks)

● table of content

● introduction

● requirement analysis (10%) - need use case diagram

● high-level design (10%) – identify classes, any diagram

● data modelling (10%) – relational database, normalization

● detail design (08%) – screen flow diagram, any other necessary diagrams

● test results (08%)

● conclusion or discussion

● references

● appendix – for any other relevant details such as screen layouts, report formats

● modularise your program and write enough comments to make it readable. 5% of the marks allocated for the program will be given for program readability. note : hard copy of the source code is not necessary

the project title for the assignment and mini project.

project.

develop a system to automate membership details and time allocation for swimmers in a swimming club. all users should take membership and pay monthly for usage. usage could be with a coach or without. the program should produce and income report for a given month.

(a) read the scenario 1 given below and draw a use case diagram and identify classes with their attributes and operations. (state your assumptions clearly) (20 marks)

assignment.

scenario 1

part of the process of course registration at ousl for a new applicant

when an applicant requests to register for a course, an officer from student affairs verifies whether he/she has relevant entry qualifications and paid the fees. if certificates to show entry qualifications are not brought the applicant is asked to bring them and return. if the fees are not paid the applicant is directed to the finance division to make the payment and come. to register for a course, the system checks whether the course prerequisites are satisfied and let the student register for the particular course.

a student is given a student id number and a registration number for the particular programme. all courses have unique course codes, titles, credit ratings and a set of pre-requisites.

(b) draw a use case diagram for the project and identify the classes in the domain with attributes, functions, and relationships among classes. (state your assumptions clearly). to complete this part you need to visit a relevant company/organization in your city/town/village, gather requirements and then analyse the requirements as guided. you may write the name and address of the organization/company that you selected.

read the scenario 2 given below and,

a) i. draw an er-diagram (entity relationship diagram) to analyse the data

ii. normalize the data to form a relational database up to 3rd normal form (only if needed, if not needed justify).

(15 marks)

scenario 2

the company named ‘good health’ is having a number of pharmacies in hospitals and supermarkets. a database system is required to manage these pharmacies.

• each pharmacy has a name, a code which you may assume to be unique, an address, and a phone number.

• each pharmaceutical company has a name, which you may assume to be unique, an address, and a phone number.

• for each drug, the trade name and formula must be recorded. from the trade name it can be identified from which pharmaceutical company it is supplied.

• pharmaceutical companies have long term contracts with pharmacies. one company have contracts with many pharmacies. for each contract there is a start date, end date and the text of the contract.

(b) design a database for the project. draw the following diagrams necessary to develop your database.

a. er-diagram (entity relationship diagram)

b. normalisation of the database up to 3rd normal form. (only if needed, if not needed justify).