• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  • Level: GCSE
  • Subject: ICT
  • Word count: 1309

The following report clearly outlines and illustrates several design documents and models the theatre booking system in question

Extracts from this document...


SOFTWARE ENGINEERING ASSIGNMENT 1 Table of Contents Table of Contents 1 Introduction 2 Assumptions 2 AN ER Diagram for the Theatre System 3 Attribute Analysis 3 Context DFD 4 Level One DFD 5 Data Dictionary Elements 5 Data Dictionary/ Data Flows 6 Pseudo Code for the Level One DFD Above 7 Evaluation 9 Introduction The following report clearly outlines and illustrates several design documents and models the theatre booking system in question. The whole design has been based on the structured systems analysis hence the logical outline of the report. The report includes: > The whole design of the required system as stated by the user. > Clear and proper full documentation of the designed system. * A full-blown ER diagram showing all the entities for the designed system. * Attribute analysis and relational schema for the entities identified * A context and level one data flow diagram for the system in question * A data dictionary showing all the data flows and data stores in the data flow diagram. Assumptions Below is a list of all the assumptions, which have been considered in the design of the system. The design has been based on the given specification and also the following assumption: * Authorisation of credit cards is done out side the system hence it has not been included in the design. ...read more.


authorise payment DiscountID Auto number Primary key DiscountType Text Discount type Percentage integer Allowed percentage TimeAllowed Time Time when discount is allowed AgeGroup Text Age group for discounts PerformanceID Auto number Primary key PerformanceType Text Type of performance type Status Text Fully booked or not StartDate Date Start date for the performance StartTime Time/date Start time for the performance Price Currency Money to be paid PerformanceID Long Integer Foreign key BandId Long Integer Foreign key BandID Auto number Primary key BandName Text Band name (A or B or C) SeatID Auto number Primary key BandId Long Integer Primary key SeatLocation Text Position of seat AccountsID Auto number Account number primary key CustomerID Long Integer Foreign key CreditLimit Integer Allowed credit AccountStatus Text Overdrawn/Not Data Dictionary/ Data Flows Data Flow Description Request booking CustomerID,PerformanceID, Performance name Feed back Status,startDate, StartTime Check customer CustomerType Customer type CustomerID,CustomerName Enquiry Performance type, free seats, status Booking details BookingID,PerformanceID, Date, Time, Description Enquiry details AgencyID,AgencyName,CreditLimit, AuthorisationCode Credit details CreditLimit, CustomerName,AccountID Free seats Status,SeatID,SeatLocation Booked seats Status,SeatID,SeatLocation Allocate price Price,PerformanceID,BandId Add performance PerformanceName,PerformanceType,StartDate,StartTime Discount allocated DiscountID,DiscountType,Percentage,TimeAllowed,AgeGroup Booking details BookingId,CustomerID,PerformanceID,AgencyID,Date,Time Payment Price Price Price Booked details SeatID,Status Receipt Price,BandID,BandName Performance type Category Agency details Agency name, address, account details Agency request AgencyID,AgencyNAme Account number Integer Response Invalid details, Request being processed Request to be registered Agency name, address, account details Update ...read more.


THEN Price = Price + 1 //IF seats are in front the price goes up by 1 ELSEIF seat >= 11 AND seat <= 50 (seats in second and third row) THEN Price = price - 5 ELSEIF seat >= 51 AND seat <= 8 (seats in fourth and fifth row) THEN Price = price -10 IF they are old people THEN Price = price -25 ELSEIF time = last hour before performance THEN Price = price -10 ELSEIF //Confirm booking process and printing ticket If payment confirmed THEN Accept Payment. Confirm booking Get customer booking details and print ticket. //Update performance Log in as a Manager; IF log in successful THEN Open performance table for update. Update the table a; If update Complete THEN Lock the table and Close; Evaluation On the high level of abstraction it can be said that the design is fairly constructive. Some parts of the system have been left out but otherwise it is good enough to be implemented as it is. The implementation will be a direct mapping of the design itself. Some aspects have of course been left out simply because there are so many assumptions to be considered. Not all assumptions have been outlined hence some parts of the design not shown. 1 1 ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE ICT Systems and Application essays

  1. Producing documents for a company. Spreadsheet, Invoice and Website.

    I will make a list of the reference numbers in that cell. Security How will the data be secure? Software One way to keep my data secured is to prevent other accessing it by using passwords. This can be done with Microsoft Excel, as it has protect function(protect sheet function).

  2. Smarts Leisure Park Database Booking System

    It also needs quite a lot of ram to deal with the demands of the database. Data Requirement I will need certain data to make my booking system work. This data is the Customers, Activities and the bookings that are made.

  1. System requirements analysis

    card that is inside the computer, on the mother/main board will need to be installed. The same applies for speakers, the sound card will need to installed and most components. Consumers who buy a computer that is ready to use will not need to worry as every thing will be installed for them.

  2. Data analysis report - Factors influencing pocket expenses of college students

    The table tells us that 2.12 is the upper limit of acceptance region. For a significance level of ? = 0.05. Our calculated F value of 26.14 is far above 2.13 so we see that regression as a whole is highly significant.

  1. Database Design Guideline

    a computer system in accordance with predefined rules'' I will be using a validation rules in my database for my doctors and patients table, I will create a validation rule under the field of ward. My validation rule is in colours ("Red" Or "Blue" Or "Orange" Or "Green").

  2. System administration report

    - What threats are there to the system? - What physical forms of security are there for IT systems? Administrative Procedures - What does the system administrator carry out the general procedures? - How are side line items such as printer ink and paper purchased?

  1. I.T. System for a Newsagents

    The information that he would want to store, would need to be stored in an organised way-I could do this by using tables to present the information in a more clearer way to my client I.e. A spread sheet. The system would also have to be user friendly as I

  2. Critical evaluation of my design - MillionAir.

    The user guide, in the questionnaire, was also tested, and the users said that the new version was an 'easy to use, none confusing' method. Manual system. A system that requires handwork and does not consist of computerized input at all.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work