anITpolo

Home

Vote MARCO REALUYO for Congressman (Antipolo City, 1st District)!

Vote for SOPHIA VILLADOLID for Congresswoman (Antipolo City, 2nd District)!

Vote CYRIL CORONADO for Mayor (Antipolo City)!

Vote ERNARD BELLEZA for Vice Mayor (Antipolo City)!

Vote WEBSTER CO for Councilor (Antipolo City)!

Back to IITS 1 Page

Members

Scrum Master: Ernard Belleza
Database Administrator: Cyril Coronado
Database Designer: Sophia Villadolid
Developer: Marco Realuyo
Scrum Member: Webster Co

Project

Department Information Systems
Be able to add/update department information as well as courses, research projects, clubs and activities being handled by the particular department. Reports regarding research projects, clubs and activities could be generated.

ERD
February 16, 2010

▼  Show

Business Rules
February 16, 2010

▼  Show

Business Rules
1. Students may view the contents, but only the Student Body may add or update the Clubs or Organizations.
2. Students must log in to be able to add or edit the Clubs or Organizations.
3. Student numbers must be in the form of ## – ####.
4. Pin numbers must be in the form of ####.
5. Only the Faculty of each Department may add or update Courses, Projects, and Activities.
6. Faculty must log in to be able to add or edit the Course Code, Course Description, and Course Unit.
7. Course codes must be in the form AAA###.
8. Course descriptions must be in the form of a String.
9. Course units must be in the form of #.
10. Projects must be arranged alphabetically by the Name of Author and the Title.
11. Name of Author and Title must be in the form of a String.
12. Activities must be arranged chronologically by the most recent Date of Activity.
13. Dates must be in the form of mm/dd/yyyy.

Student
• View
• Student Body
• Organizations / Clubs – add / edit

Faculty
• Courses – add / edit
• Projects – add / edit
• Activities – add / edit

HTML
February 16, 2010

▼  Show

Department Information Systems Home: http://itb322uap.wdfiles.com/local--files/anitpolo/Home.html
Employee View: http://itb322uap.wdfiles.com/local--files/anitpolo/Employee.html
Student View: http://itb322uap.wdfiles.com/local--files/anitpolo/Student.html

Seatwork

Seatwork # 1

▼  Show

Problem:

A General Hospital consists of a number of specialized wards (such as Maternity, Paediatry, Oncology, etc). Each ward hosts a number of patients, who were admitted on the recommendation of their own GP and confirmed by a consultant employed by the Hospital. On admission, the personal details of every patient are recorded. A separate register is to be held to store the information of the tests undertaken and the results of a prescribed treatment. A number of tests may be conducted for each patient. Each patient is assigned to one leading consultant but may be examined by another doctor, if required. Doctors are specialists in some branch of medicine and may be leading consultants for a number of patients, not necessarily from the same ward.

Answer:

---

Sitemap