Database Project on University Timetable

Only available on StudyMode
  • Download(s) : 247
  • Published : September 20, 2010
Open Document
Text Preview
Table of Contents
1.3.Technologies to be used2
2.Overall Description2
2.1.Goals of proposed system2
2.3.Project Requirements2
2.4.User Characteristics2
2.5.Hardware Requirements2
2.5.1.Processor RAM Disk Space2
2.6.Software Requirements2
2.6.1.Operating System2
2.6) Definitions of problems2
2.7.Alternative Solutions2
3.Feasibility Study2
3.1.Steps in feasibility analysis2
3.2.Technical feasibility2
3.2.1.Front-end and back-end selection2
3.2.2.Front-end selection2
3.3.Economical feasibility2
3.4.Operational Feasibility2
3.5.Schedule feasibility2
4.General Information2
4.2.ERD Diagram2
4.3.Data Dictionary and Normalization2

List of Tables
Table 1: Entity course2
Table 2: Entity Lecturer2
Table 3: Entity Room2
Table 4: Entity subject2
Table 5: Entity subject_timetable2

1. Introduction
The project aims to make an online university timetable which provides facilities to teachers and student to check out the classes that are going on presently. The purpose of creating a database is to keep track of class schedules and location. As current work is all paper based, an approach towards automation is being made to reduce human efforts by preventing them to look for a particular class in an index. The purpose of database on the whole is to:

* Maintain daily time table such as information related to class schedule. * Provide information about teacher, room number and subject being taught Scope
Interface and database on a back end that are being used can provide a greater scope and opportunities for students and teachers to look for their room number rather than contacting Admin Dept. to ask for the room number. Technologies to be used

Initially, our intended goal was to create web-based application but due to lack of knowledge on working ASP.NET and other related technologies, our application will be desktop based. This application will be designed on Visual Studio 2005. Following technologies are used in our project * MS Visio (For designing ERD diagram)

* SQL Server 2005 (Database design and creation of database schema) * Visual Studio (for form design, interface and testing)
Main facilities that are associated with this project are:- • Maintaining records of Classes, Room No, Computer lab, Teacher Information. • Maintaining Notice Board for the students.
• Maintaining Every Section records.
Overall Description

Goals of proposed system
* Planned approach towards working: - It is necessary that the process, for its smooth on-going, should be well organized and structured. All the data will be stored properly in data stores, which will help in retrieval of information as well as its storage. * Accuracy: - The level of accuracy in the proposed system will be higher. All operation would be done correctly and it ensures that whatever information is coming from the center is accurate. * Reliability: - The reliability of the proposed system will be high due to the above stated reasons. The reason for the increased reliability of the system is that now there would be proper storage and retrieval of information. * No Redundancy: - In the proposed system, we can assure that no Information is repeated anywhere, in storage or otherwise. On the contrary, if a proposed system is paper based, there are high chances of redundant data. * Immediate retrieval of information: - The main objective of proposed system is to provide for a quick and efficient retrieval of information. * Immediate storage of information: - In manual system, there are many problems to store the huge amount of data and handling them. * Easy to Operate: - The system should be easy to operate and should...
tracking img