|ICL-1004: Database Design and Management
- Use an appropriate design tool to design a relational database system for a substantial problem.
- Develop a fully functional relational database system, based on an existing system design.
- Test the system against user and system requirements.
- Produce technical and user documentation.
Purpose of this assignment
The database is a crucial part of most organizations. A database is defined as the skeleton of any application. An understanding of database tools and technologies is an essential skill for designing and developing systems to support them. The assignment provides opportunities for the students to develop an understanding of the concepts and issues relating to database design and development and to extend their practical skills to translate that understanding into the design and creation of complex databases. The completion of the assignment will make sure that the students have been able to use appropriate tools to design and develop a relational database system for the substantial problem. The students will have an opportunity to test the system ensuring that user and the system requirements are met. And also, fully document that system by providing the technical and user documentation.
The P.K college of Kathmandu has been teaching the course of Information Technology, Hotel Management, and Bachelor in Business Administration. The students of this college have to submit an assignment at the end of the semester. The assignment is given to the respective subject teacher. He/she will check the assignment and provide feedback or result. There is an assignment department to receive an assignment from the student and dispatch it to the teacher after checking. After this the assignment department contact student the redo the assignment including the lagging requirement. Till now the department performs it manually by keeping a record at the register. But with an increase in the number of students, the department is facing the problem to manage the flow of work. So the College administration has decided to build a desktop application to handle all these records. The name of the project would be “Assignment Management System.