My first database of NAC as database assignment

As a first year assignment of database we have to create a database for the NAC.

During the observation of the system and the works of the staffs I get that they are using the old version of the data stored record systems since from there establishment. According to the staffs of the Ministry that is too hard to operate and consume lot of time to do a single works.

In the present context the Ministry has to perform very high level task that need to be stored in the database which cannot fulfill by the current system. But different tasks done in dissimilar software is a hard method of management for them. For example, they use dissimilar software systems to view, add or remove records of a particular district.  This proved to be extremely time consuming for staffs. So they wanted to replace the old version of the software system by a new one which is easy to use and which can perform the entire task that needs to be performed.

The assignment should submit within the 2 month and do many research. i do alot of research on this sector and complete my project. some of the feature that is used in the database are listed below 

Current Business activities and operations

1. Reservation

Customer can do reservation any time through phone call or by filling form online as per their necessity according to the rule and regulation provided by the company. The customer can also reserved the airline through direct visiting any branches of the airlines reservation company. At the time of the reservation the customer can choose what type of service they want. They must choose at which date and time they want to do reservation for how many members. The customers are then fixed with a confirmation number after the reservation has been done. A customer can renew/revoke reservations.

.  

2. Ticketing

Once the customer reserved the ticket the costumer has to fixed date and time. When the customer fixed it the record will store in the system. If the customer wants to change the date time or cancel the reservation then the customer has to fulfill the rule and regulation of the company.

3. Full Payment

The customer has to full pay when they reserved the ticket for plane. They have to provide their identification number, address, phone numbers for the company record.

4. Payment type

Payment can do in many ways like cash payment, cheque payment or online transfers or through the credit cards. The customer will give the discount according to the facilities that they are using. Price depends upon the types of the airlines they are reserved. If they want to cancel the reservation then the 25% will be cut of the total amount.

5. Customer care

This allows customer to know or to take suggestion about airlines. If they need any help then they can contact to the customer care.

6. Employee

There are many employees in company. Which are divided according to their qualification in different department?

7. Plane

The customer has facilities to choose the Plane of different airlines according to their will. Different airlines plane has different facilities and the rate.

8. Rate

The rate of the ticketing is different according to the planes of the airlines. If the customer comes in group then there is special discount offer which affect the rate of the ticketing.