System analysis and design methodology

System Analysis And Design Methodology

Introduction

My name is, Aung Zaw Hein. I am a student from MCC COMPUTER Training Center. I learn for International Advanced Diploma in Computer Studies (IADCS) from National Computing Center (NCC). I attend in the section-8 of IADCS.

In this section, I must do three assignments. Among them, we must do System Analysis & Design. The title of this assignment is for "NATIONAL HOSTELLING ASSOCIATION".

IADCS is aimed at college leavers who wish to take either a stand- alone recognized qualification in Information Technology. IADCS gives us the ability to "pick and mix" subjects, allowing them the freedom to explore the topics which will be of most benefit in developing their career.

Acknowledgement

Firstly, I am thankful U NYI NYI and for all Lecturer of MCC Computer Company Limited, who gives us the good and precious way to attend International Advanced Diploma in Computer Studies (IADCS). Finally, I would like to thank the Departmental Officers, the rest of teachers and classmates for their supports, supervision and encouragement during this assignment.

Myanmar Computer Company Limited Yangon

Task 1

a) A Context Diagram of the bed booking system

b) A statement of the aims and objectives

  • To provides budget holiday accommodation in cities and tourist destinations throughout your country.
  • To centralise bed booking into a single national booking office and to manage this centralised process
  • To release staff in hostels to carry out main domestic duties
  • To centralise the payment of bookings fees thus simplifying the association's accounting procedures
  • To create aggregate financial records of bookings

c) Data Flow Diagram for the bed booking system

Task 2

a) Entity Relationship Diagram

Customer-Payment entity

Customer entity is one to many relationship to Payment entity. One Customer have many payment. One payment have one customer.

Customer-Booking entity

Customer entity is one to many relationship to Booking entity. One customer have many booking. One booking have one customer.

Staff-Booking entity

Staff entity is one to many relationship to Booking entity. One Staff have many booking. One booking have one staff.

Payment-Booking entity

Customer entity is one to many relationship to Payment entity. One payment have many booking. One booking have one payment.

Customer Entity

  1. Customer No (Primary Key)
  2. Customer Name
  3. Passport No
  4. DOB
  5. Phone No
  6. Gender
  7. Email
  8. Country Name
  9. Address

Staff Entity

  1. Staff No (Primary Key)
  2. SPhone No
  3. SEmail

Booking Entity

  1. Booking No (Primary Key)
  2. Booking Date
  3. Room No
  4. Room Type
  5. Price
  6. Hotel Name
  7. Check in Date
  8. Check out Date
  9. Total Number Of Day

Payment Entity

  1. Payment No (Primary Key)
  2. Payment Amount
  3. Payment Date

Task 3

Entity Life History

Task 4

1. Normalisation

a) Un Normalisation Form

  • Customer No (Primary Key)
  • Customer Name
  • Passport No
  • DOB
  • Phone No
  • Gender
  • Email
  • Country Name
  • Address
  • Staff No (Primary Key)
  • Staff Phone No
  • Staff Email
  • Booking No (Primary Key)
  • Booking Date
  • Room No
  • Room Type
  • Price
  • Hotel Name
  • Check in Date
  • Check out Date
  • Total Number Of Day
  • Payment No (Primary Key)
  • Payment Date
  • Payment Amount

b) 1NF

  • Customer No (Primary Key)
  • Customer Name
  • Passport No
  • DOB
  • Phone No
  • Gender
  • Email
  • Country Name
  • Address
  • Staff No (Primary Key)
  • Staff Phone No
  • Staff Email
  • Booking No (Primary Key)
  • Booking Date
  • Room No
  • Room Type
  • Price
  • Hotel Name
  • Check in Date
  • Check out Date
  • Total Number Of Day
  • Payment No (Primary Key)
  • Payment Date
  • Payment Amount
  • c) 2NF

  • Customer No (Primary Key)
  • Customer Name
  • Passport No
  • DOB
  • Phone No
  • Gender
  • Email
  • Country Name
  • Address
  • Staff No (Primary Key)
  • Staff Phone No
  • Staff Email
  • Booking No (Primary Key)
  • Booking Date
  • Room No
  • Room Type
  • Price
  • Hotel Name
  • Check in Date
  • Check out Date
  • Total Number Of Day
  • Payment No (Primary Key)
  • Payment Date
  • Payment Amount
  • d) 3NF

  • Customer No (Primary Key)
  • Customer Name
  • Passport No
  • DOB
  • Phone No
  • Gender
  • Email
  • Country Name
  • Address
  • Staff No (Primary Key)
  • Staff Phone No
  • Staff Email
  • Booking No (Primary Key)
  • Booking Date
  • Room No
  • Room Type
  • Price
  • Hotel Name
  • Check in Date
  • Check out Date
  • Total Number Of Day
  • Payment No (Primary Key)
  • Payment Date
  • Payment Amount
  • e) BCNF

  • Customer No (Primary Key)
  • Customer Name
  • Passport No
  • DOB
  • Phone No
  • Gender
  • Email
  • Country Name
  • Address
  • Staff No (Primary Key)
  • Staff Phone No
  • Staff Email
  • Booking No (Primary Key)
  • Booking Date
  • Room No
  • Room Type
  • Price
  • Hotel Name
  • Check in Date
  • Check out Date
  • Total Number Of Day
  • Payment No (Primary Key)
  • Payment Date
  • Payment Amount
  • Customer No (Foreign Key)
  • Booking No (Foreign Key)
  • Staff NO (Foreign Key)
  • Customer No (Primary Key)
  • Staff No (Primary Key)
  • Booking No ( Primary Key)
  • Payment No (Primary Key)
  • 2. Data Dictionary for bed booking system

    Task 5

    a) Searching for hostels with free beds on a particular date

    Searching For a free bed room

    We can search for hostels with free bed room on a particular date. We choice the particular date into the combo box and then click the Search button. And then, we can see the Hotel name, free Room type, free Room No, And Price.

    So that we can choice the Room Type and Room No and Price. So that it is very easy to booking.

    b) Processing a bed booking for an existing customer

    Booking for free bed room

    There we can see the processing a bed booking for an existing customer. They are Customer No, Booking No, Booking Date, Room No, Room Type, Price, Hotel Name, CheckInDate, CheckOutDate, and Total Number Of Day. If we want to see the existing customer and his room and hotel name, We can put the data onto the customer No or Booking No. And Save button for a new booking for a customer. If we fill the data onto the blank, we can click the Save button. we not want to booking if click the Clear button.

    c) Adding a new customer to the system

    Customer Registration Form

    If we want to add a new customer, we use this form. Fill up the blanks, and then we can click the Save button. If we want to add a new customer registration form, click the New button. If we want to clear the blanks, click the Clear button. If we want to edit the existing customer information, click the Update button. And Exit button is the exit this form.

    Task-6

    We were done an assignment for Systems Analysis and Design module. The assignment title is National Hostelling Association. This assignment allowed us to understand the modeling of a data-driven system. In this we were analysis and design a system for a Hotel that included the creation of a user interface for new system.

    In new system will know the Hotel information to global. But the display area of the store is a small section of Hotel holds in its storeroom. In the new system the store wishes to install a computerize system that will allow customers to search the Hotel name and room type and also description of the room information. This will allow customers to request Room and hotel that are not on display.

    The public side of the system will work as typical e-commerce solutions on the Internet but its operation purchases will be made via the staff. When the store is successful to expand as an online booking where the customers can make booking from their browser.

    The public workstation of store will be used to search the Hotel room by Room Type for sale. It is intended that customers will be able for search the Hotel by room type, and price range. The remaining workstations will be used for staff only. This will have all facilities available on the public workstation as well as for booking room recording and customers recording. There is one of requirement for the business.

    We were done this assignment by the guide line instruction of NCC education. This assignment has (6) Tasks as totally. In Task (1) we were created the process model for the computerizing of National Hostelling Association, Task (2) was to create a data model detailing the data structure required to support the information and process requirements of the National Hostelling Association, the creation of Entity Life History for a Bed booking was in Task (3), a database design for the National Hostelling Association was created in Task (4), Task (5) was need to create a prototype user interface for the National Hostelling Association, the final Task (6) was the reporting for the whole system preparation.

    Task (1), was the creation the process for the computerizing of National Hostelling Association. This task needed to include the three phases; first phase was to draw a Context Diagram of the Hotel, producing a statement of the aims and objectives of the Hotel was second phase, and the final phase was to draw a Data Flow Diagram for the Hotel that need included process descriptions, dataflow descriptions, data store contents and external entity definitions.

    Before the first phase, we were successfully needed to analyst the current system and user's requirements specification. Then we were design and requirement specification of the propose system. The designing of user's requirement specifications was the drawing of a Context Diagram. Then we were explaining the purpose of new system as the second phase. In third phase, we were also need to understand the Data Flow Diagram in detailing. In Data Flow Diagram have symbols, an external entity, a process, a data store and data flow.

    In Data Flow Diagram have four processes for the new National Hostelling Association. Process (1) was Search Process, in this process customer was entity. Room search data flow line meant the customer search the Hotel room by room type via categories, keywords or price ranges. Then sale assistant will be display the customer searching Hotel. For this Hotel will be stored in the Room files as data store.

    Task (2) was to create the Entity Relationship Diagram for the National Hostelling Association.ERD was in the light of new processing and information requirements to produce the ERD for new system. This new system ERD the basis for physical database or file design. But the logical structure may not represent the final physical structure of data; it does represent the most flexible from the point of view of data access. The new system ERD resulting from normalization. This task needed to make normalization process to provide a simple relation as the basic for the database designs. In normalization process have several stages and this can reduce the data duplication and data redundancy. By making the normalization of the National Hostelling Association, aids to provide finalize ERD for the National Hostelling Association, a list of attributes, primary key, foreign keys, relationship detailing optionality and relationship degree between entities. ERD and full sets of normalization are described in Task (2) and (4).

    After Task (2), we needed to draw Entity Life History diagram for a Bed Booking, Task (3). This diagram will be started by creation of new room information and the documents the sequence of changes until the Room information is removed from the National Hostelling Association. The Entity Life History process can be updated, enquired or retrieved and built on the three constructs basic of sequence, selection and iteration.

    To develop the Normalization and Data Dictionary for the National Hostelling Association was in Task (4). In normalization process have several stages and this can reduce the data duplication and data redundancy. By making the normalization of the National Hostelling Association, aids to provide a list of attributes, primary key, foreign keys, relationship detailing optionality and relationship degree between entities. In this task, attributes in a file was distinguished the primary key and foreign keys. The primary key of a file was represented by the underline and the foreign keys was represented by the asterisk (*). Now was to develop the Data Dictionaries for the National Hostelling Association. Data Dictionary meant a central repository for a computer system project, holding the system's metadata. Data Dictionary is a dynamic reference document which contains explicit definition of both logical and physical objects and links between them.

    Task (5) was to product the screen design for Room search by Hotel. And producing payment form for room booking. The design for room information adding. This case will be done by the staff of the store.

    Booking for free bed room

    There we can see the processing a bed booking for an existing customer. They are Customer No, Booking No, Booking Date, Room No, Room Type, Price, Hotel Name, CheckInDate, CheckOutDate, and Total Number Of Day. If we want to see the existing customer and his room and hotel name, We can put the data onto the customer No or Booking No. And Save button for a new booking for a customer. If we fill the data onto the blank, we can click the Save button. we not want to booking if click the Clear button.

    a) Adding a new customer to the system

    Customer Registration Form

    If we want to add a new customer, we use this form. Fill up the blanks, and then we can click the Save button. If we want to add a new customer registration form, click the New button. If we want to clear the blanks, click the Clear button. If we want to edit the existing customer information, click the Update button. And Exit button is the exit this form.

    Please be aware that the free essay that you were just reading was not written by us. This essay, and all of the others available to view on the website, were provided to us by students in exchange for services that we offer. This relationship helps our students to get an even better deal while also contributing to the biggest free essay resource in the UK!