To someone who can help me,
hi, i got a problem of designing a database system for a swiming school, can someone help me please...please
the statement of problem is:
SwimSafe is a Canberra based college, which administers lessons at various swimming pools within ACT and Queanbeyan. YOU have taken over the organisation of SwimSafe. YOU have inherited a computerised file-system that organises the information to run SwimSafe’s operations and administration. The file system consists of documents that are lists of facts that allow YOU to gather and organise basic data about class enrolment, payment and student progress.
YOU want to use the existing data to create a database system, which would track class enrolment, payments for the lessons and the progress of students. YOU would like to display financial reports to show the profitability of offering swimming lessons at particular swimming pools. As the SwimSafe grows you might desire from your database to provide more operations and functionalities, which could be achieved by modifying your database.
SwimSafe runs swimming classes during the three semesters in a year. As an example, the second semester of year 2001 is identified as 01b and is named as the winter semester. Classes are classified into seven separate levels from 1 to 7, and classified as Guppy, Minnow, Fish, Flying Fish, Shark, Dolphin and Life Guard. Different classes may run on different days, and one class’s timetable may involve several days per week. SwimSafe runs classes on all days except Sundays. Each class is run for an hour. Start time for the class is helpful in identifying a class on a particular day. Each pool has two sections and an instructor is assigned to each class. The classes have a limit of 12, 15 and 20 students. However, not all the classes are always full. The information on pools includes the code of the pool building, the name of the pool and the address of the pool. For example, the pool in the City is assigned CITY as the code and ‘Canberra Pool’ as the name
Information on students includes, students identification, first name, second name, middle name initial, date of birth, street, postcode, phone number, amount charged, amount paid. A payment can only be made in full and a receipt number is recorded in the database if the amount is paid in cash. Payment can also be made by check.
The details of payments would include payment number, payment type, date of payment, first name, second name and the initial of the middle name of the person making payment, their phone number, amount paid, Check number and the students information
Can someone please give me some idea to identify the entity.
thank you very very much
