1 / 7

Project Goal

Project Goal. Design and implement a database to assist in the management of a kung fu school. Project Description (Business Logic). A kung fu school provides a variety of courses (offered multiple times a week) including: basic conditioning forms weapons sparring tai chi,

lisbet
Download Presentation

Project Goal

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Project Goal Design and implement a database to assist in the management of a kung fu school.

  2. Project Description (Business Logic) • A kung fu school provides a variety of courses (offered multiple times a week) including: • basic conditioning • forms • weapons • sparring • tai chi, • lion dancing • Classes are associated with a course of study and each class is taught by a lead instructors. • Students can take several classes a week.

  3. Project Description (Business Logic) • Instructors have several levels: • chief instructor • regular instructor • assistant instructor • special assistant • Every instructor is also a student and can only instruct a class that is below his/her current level of study. • Tests are conducted every two months by a board of instructors. Students may or may not participate in a test. Results of the tests must be recorded along with instructor’s comments for the student.

  4. Project Description(DB Capabilities) • Maintain administrative information: • students, instructors, courses of study, and classes related to a course of study. • Keep per student information: • contact data (phone numbers, address, email, photo) • emergency contact (phone numbers, address, photo) • billing data (address, credit card information) • class schedules • level of study • Provide instructors a means to access study related information on students enrolled in his/her classes.

  5. Functional Requirements • Provide means to maintain student information and student enrolment information. • Provide ability to Store/Retrieve contact, emergency and billing information for a student. • Ensure only those who need information have access, e.g. instructors only have access to class related data. • Provide ability to enter known medical issues

  6. Functional Requirements • Maintain (Add/Edit/Delete) student records, courses of study, classes per course and instructor information. • Maintain list of instructors and their levels. • Keep a schedule of the current list of classes offered with information such as course type, class time, class start and end dates, and class instructors • Provide means to register for classes.

  7. Functional Requirements • Keep track of tests for each student with results and comments from instructors • Generate a bill for each student for the classes in which they have enrolled • Generate an attendance sheet for each class • Generate a report on each student including current level of study, list of past tests, and comments for each test • Generate a schedule of classes • Generate basic statistics on class attendance

More Related