• 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. ICT Report 2b: ICT in Organisations

    workers, and it helps the staff at Boots because it means there is limited ways of damaging their component devices when removing them from their computers. Finally, it helps the customers because it is the back bone of the R&D department who provide the products they desire.

  2. Database Design Guideline

    the two tables is, to click on the 'start', and go to programmes to find 'Microsoft Access'. After, this document is open I will have to select the button which says 'open existing files' then click 'ok'. After this stage, I will have to go on the file where I

  1. Database design.

    The employee had a computer to use before but it was stolen in a burglary. So from this I was able to find that the employee has got computer experience. The name of the business is called Cinema World. They keep records on file paper since the burglary.

  2. Database &amp;amp; design.

    The software will notice when you type another letter in that field and will remind you what you ought to be typing. 3.3 Videos taken out ( Finding out what films are in stock will be easy. It will be done through a query in the members' table based on field 'videos currently out'.

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

    Excel is excellent spreadsheet creating software. * Microsoft excel (2007) this software are well known and trusted. The tools that I think that I will need are the IF FUNCTION and the programs outstanding use of cells and formulas as well as VLOOOKUP.

  2. Designing an IT system for an A level Student.

    Adobe Photoshop Used to edit images John might want to edit the pictures he took from his camera Adobe Dreamweaver Used to create websites He will need this for his work at school FL Studio 8 Used to create original music John likes making his own music RossetaStone(c)

  1. 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.


    In the orthodontic case modem routers are a very important tool as they enable Data's to be shared around so that the doctor as well as the person at the reception knows what is going on. For example if the Doctor wants to tell the person at the reception when

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