Autumn 2010, CS 508 Database Systems / CO 302 Database Management
Term Project
Develop a database application in Oracle for the problem mentioned against your
roll numbers. The problems contain only a brief description and you need
to define the problem completely including additional assumption, if necessary.
The project report should contain the following:
- Intrduction and Problem Definition
- ER/EER model
- Relational Model
- Snapshots of input/output forms and reports
MCA
| Roll No. | Assign. Nos. | | Roll No. | Assign. Nos. | | Roll No. | Assign. Nos. | | Roll No. | Assign. Nos. |
| 02, 28 | 1 | | 09, 06 | 2 | | 36 | 3 | | 33, 47 | 4 | | |
| 14, 35 | 8 | | 18, 23 | 7 | | 26, 11 | 6 | | 12, 15 | 5 | | |
| 10, 27 | 9 | | 16, 03 | 10 | | 41, 45 | 11 | | 04, 39 | 12 | | |
| 46, 07, 49 | 4 | | 01, 24 | 3 | | 50, 42 | 2 | | 37, 38 | 1 | | |
| 44, 13 | 5 | | 21, 19 | 6 | | 43, 48 | 7 | | 17, 20 | 8 | | |
| 34, 51 | 11 | | 22, 31 | 10 | | 25, 08 | 9 | | 52, 05 | 12 | | |
| 32, 30 | 1 | | | | | | | | | | | |
B.Tech
| Roll No. | Assign. Nos. | | Roll No. | Assign. Nos. | | Roll No. | Assign. Nos. | | Roll No. | Assign. Nos. |
| 08, 03 | 4 | | 16, 04 | 3 | | 27, 35 | 2 | | 10, 17 | 1 | | |
| 14, 06 | 5 | | 07, 21 | 6 | | 11, 28 | 7 | | 12, 18 | 8 | | |
| 31, 34 | 9 | | 23, 24 | 10 | | 22, 32, 33 | 11 | | 13, 25 | 12 | | |
| 2, 26 | 4 | | 29, 30 | 3 | | | | | | | | |
-
An information system for the students of CSE department.
-
An informtion system for the students of B.Tech programmes of SoE of TU
-
An informtion system for the boarders of a hostel of TU
- A database is being constructed to keep track of the teams and games of a football league. A team has a number of players, not all of whom participate in each game. It is desired to keep track of the player participating in each game for each team, the position they played in the game, and result of the game. Each player is described by their name, address and age. Include additional information if necessary.
- It is necessary to construct a database to keep track of the passed out students of Tezpur University (Alumni). The students are described by Name, TU registration number, home address, current address, present job and organization, e-mail address. It is desired to keep track of the programme(s) the student completed at TU and the CGPA. It is also necessary to keep track of experiences of the student after leaving TU, which includes organization name, job position and duration.
- A bank database to store information about its customers, accounts(savings a/c, current a/c...), loans(car loan, housing loan, ...), transaction made by customers for each loan(payments)/account(withdrawal, deposite).
- Library information system : Database should store information about books, journals, megazines etc., Their issue/receipt/reservation. It should be possible to search books by author, title, subject. Similarly journals should possible to search by subject area, publisher etc.
- Payroll system of Tezpur University
- Hospital information system : Patients - indoor/outdoor, medicines/lab tests(including results) prescribed to patients, information if a patient if referred to other expert/hospital. Doctors - specialization, patients attended etc. Different wards/beds and patients alloted to them etc.
- An information system for a departmental store
- An information system for faculty members of TU. The system stores the personal information like, name, address, date of birth, date of joining etc;
academic information like - qualifications, publications, area of
specialization, conferrences/workshops attended, courses taught by him/her, other resposibilities/duties etc.
- Extra-curricular activity information system of the students of TU
Back to my Home page