Data Flow Diagram of Library Management System

Document Sample
Data Flow Diagram of Library Management System Powered By Docstoc
					              MIS Review
 Important points for this course
 Question types and examples for the
  final exam.
    Selection questions (example)20marks
     1. The stakeholders are those who have interests in the success of a new
         system. Suppose there are three people, called P1, P2 and P3 respectively.
         P1 pays for and owns the system, P2 uses the system on daily basis, and P3
         ensures that the system operates in the computing environment of the
         organization. Which of the following statement is correct?
         (A) P1 is a user stakeholder.
         (B) P1 is a client stakeholder.
         (C) P1 is a technical stakeholder.
         (D) P1 is both a client and a user stakeholder.

     2. A questionnaire consists of the following three questions:
     Question One: Are you a student?
     Question Two: How many classes do you have each day?
     Question Three: How can you make much achievement in your study?
         Which of the following statement is correct?
        (A)      Question One and Question Two are open-ended questions.
        (B)      Question One and Question three are open-ended questions.
        (C)      Question One and Question two are close-ended question.
        (D)      Question One and Question three are close-ended question.

    Judgement questions(example) 10marks
1.   If one customer can place many orders, but one order can only be placed by one customer,
     then the relationship between customer and order is a n-ary relationship.
2.   A foreign key of one relational database table must be the primary key of another relational
     database table.
3.   Extranet and intranet use totally different network protocols.
4.   Synchronization pseudostate is a method to represent the concurrent behavior of an object
     by dividing one state symbol into many compartments, with each compartment contains a

 Short answer questions(example)30marks
1. Bellow is a data flow diagram

                                                X            P3

                                P2           E,Y

The logic of the processes P1, P2 and P3 are respectively as follows:
        Process P1:             Process P2:             Process P3:
        if A>B then             if D=E+100 then         Y=B*E
              B=A                    Y=1000
        End if                  else
                                end if
    Are there any miracle or black hole on the above DFD? Give your reason
2. Please state the advantages and disadvantages of using the internet as a
    application platform.

System analysis and design questions(example)40marks
    ERD---Relational database Schema

 Customer                   Order                    OrderItem                   InventoryItem

 Name                       OrderDate                Price                       ItemName
 Address                    Tax                      Quantity                    QuantityOnHand
 Phone                      GrandTotal                                           AverageCost

 Draw ERD
 A library has many books and many readers. One reader can borrow many books, one book
can be borrowed by many readers at different time. If a book is lent to a reader, the lending date
and return date must also be recorded. Attributes about book and reader are given below:
           Book: book number, book name, author, price, publishing date, status;
           Reader: card number, reader name, gender, address, phone number;
Please draw an entity relationship diagram about book and reader, if necessary, add associative
entity to represent the relationship between book and reader

    Create event table and draw DFD(or from event table to DFD)

You are asked to develop a library management information system, the system contains only
     the following information:
      Book information including book number, book name, author, price, publishing date;
      Reader information including library card number, reader name, gender, address,
           phone number;
      Book lending and returning information including lending date and return date.
     Please answer the following questions based on the previous information and your
     reasonable assumptions:
Create an event table listing the main events that the system must respond, include event name,
trigger, source, activity, response, and destination for each event.
Draw a context diagram and event-partitioned diagram(diagram0) for this system.

     PERT/CPM or gantt chart
1.    Bellow is a list of tasks for an information system project. According to the list, answer the
      following questions:
      i.    Build the PERT/CPM chart
      ii. Determine the critical path
      iii. What is the meaning of slack time? Give an example from your PERT/CPM chart of
           the project.
     Task         Description                                Duration                        Precedence
      1           Task1                                      3                               --
      2           Task2                                      2                               --
      3           Task3                                      3                               1,2
      4           Task4                                      2                               3
      5           Task5                                      4                               3
      6           Task6                                      2                               5
      7           Task7                                      3                               4,6
      8           Task8                                      3                               7
2. Build a Gantt char based on the above task list

     DFD---Structure chart
The following is an event-partitioned data flow diagram for library management,
using transaction analysis technique to develop a structure chart for it.
                                                                                           book number
              Reader info   Reader
                            Register                                              4
                                               Reader info                       book
       Library card            2                                                             Library card
       number                Reader                                                           number
                                                                 Book lending info
                               3                                                             book number
              Book info       book
                             register                                              4
                                               Book info                         Return            Book query
                                                                                  book             request
            Book number       book
                            deregister                                                      4        Book
                                                                                          Book       information
    Draw Decision table/decision tree/structured English
5.   The rules of deciding the postage of a postal parcel is described as follows: if the parcel is
     to be sent by express, then the basic charge will be 6$/kg, otherwise the basic charge will
     be 4$/kg. If the distance is over 200km, then each kg will be charged for one more dollar. If
     the parcel’s weight is over 10kg, then another 0.5 dollar will be charged for each kg that
     exceeds 10 kg. Suppose a parcel’s weight is W kilograms, please draw a decision table to
     show the calculation of the postage for this parcel.
    Normalization
Improve the following table to third normal form(3NF) , identify each table’s primary key

Staff-wage table description:
StaffNumber, StaffName, WageLevel, BasicWage, EducationalLevel, GraduateDate

Shared By:
Description: Data Flow Diagram of Library Management System document sample