Database Design Document(DDD)
Razvill Driving Academy is a driving school here in Lipa, Batangas. They used manual method in their enrollment system. As a result they encountered unexpected problems like confuse and slow transaction. Their system also involves errors and redundancy of data resulting troubles in organization. Enrollment is the process of entering and verifying data of student to register on a particular school. We will propose an online enrollment system for the company. Online enrollment system is used particularly in recording and retrieving student’s information online. Enrollment System is a good example of a computer generated process. This can lessen the workload and provides accurate information needed of the driving school. As a result, it will benefit not only the student but the company as a whole.
The purpose of this document is to define what database design of the system is. The intended audience for this document is the users, manager and staff. We expect that this document will describe the database design of our propose system. The security of the database design is having the encryption of password in the database and backing up of records of the enrollee.
The system will record the names and the number of total enrolled, also it will record the schedule of every student who enroll. It will have a complete record of every enrollee, the courses they will choose, the schedule of their driving lessons. If someone is done in their lesson, the admin will see the name that is finish taking their lesson. They will also see the schedule finish. It also provides the storing and recovering of data. It covers also the billing system of the company in the sense of managing all the accounts of the enrollee by means of the account number of the credit card of the enrollee. All the reports will automatically pass in the database of the company. The users can modify the system easily through the use of the database. It is good in creating semestral and monthly reports to be given to the head company. 3. ASSUMPTIONS/CONSTRAINTS/RISKS
The following are the assumptions software and hardware requirements: Hardware requirements
* RAM: Recommended 1G
* Hard Disk: Minimum of 320G
* Operating System – Certified Distribution of WINDOWS 7
*Adobe Dreamweaver CS5.5 (PHP)
* Database – Microsoft SQL Server 2005
In our database design there will be a security of records of the enrollee. The design has an efficiency of retrieving, viewing and updating of records. 3.2. Constraints
The limitation in our proposed system is that the database is only viewable by the admin which is the manager. No changes can be made in it until the system verifies the use log in and password. Only the admin can update and view the records. The database is updated every time there is a new enrollee so the schedule time of each enrollee will be updated once they had their lesson. The proposed system contains two databases so in case of error in the database, there is a backup. To back up the records while the first database is saving records the second database is also saving the records at the same time. In case of the error in first, the second database can be used. 3.3. Risks
These are the following risk in database design: There is only one admin in our database which is the manager. For power interruption, backup of database will be not a heavy problem because it will automatically save. The database must be monitored properly to prevent the system failure.
4. Design Decisions
The proponents study the security, reliability, efficiency of the database design. The proponents will be using MySQL Server, which is a free and robust database management system, to manage our database. In addition, PHP will be used as the programming language in Adobe Dreamweaver CS5.5 and the system will be running under Certified Distribution of...