• 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

    It is small enough to be put in your pocket which is why it is sometimes referred to as a "pocket drive", or, "pen drive". Furthermore, a USB port connection juts out from one side usually protected by removable cap and once again, makes excellent use of the USB ports I mentioned earlier.

  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 computerised system will make it easier to manipulate data. 3.2 Films in stock ( Finding out what films are in stock will be easy. It will be done through a query in the video table, based on a Yes/No field that tells you if the video is out on loan or not.

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

    * Could take up lots and lots of space. Adobe Dreamweaver CS4 (Web page) Advantages: * Easy access. * Easy to use. * Has many different designs * Easy to update * Sorts data Disadvantages: * Is slow when its large data * Hard to create and maintain * Can't relate data * Software needs to be purchased (very expensive)

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

    DVDs Used to keep files on like films, or for backup reasons He might need to burn some films on them A01 Task 3 Software Requirements Description Why John needs it Windows Vista Home Premium It is the operating system that enables the hardware and software to work together It

  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.

  2. ICT implementation report

    This is done by linking it with 'Column C' and this column shows a number which is the number of the car chosen on the combo-box and the number in the combo-box is the number which the cars are set as in the Data sheet. Hence displaying the selected car.

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