Database代写:CS353 Database Diagram


ER diagram for a system

A football club has a name, a stadium with a playing ground, and a team made up of players. A player can play for only one club. Each team is managed by a manager, represented by his name. A player has a registration number, name and age. A club manager also buys players. Each club plays against each other club in the league and matches have a date, stadium venue and score.

  1. Draw an ER diagram to represent the case above.
  2. Discuss how you managed the following:
    • What factors were considered for choosing entity, attribute and relationship for the above scenario?
    • Is a club manager the same as a team manager?
    • How did you represent the ‘league’ in the diagram?

DFD diagram for a system

A system handles purchasing customer tickets for a subway station. The user selects a destination and ticket type (e.g. single, return or day return) and the machine displays the price. When enough money has been put into the slot, the machine issues a date-stamped ticket containing the issuing station, the destination, ticket type and price. If necessary, the machine also gives change. The machine records the number of tickets issued for each destination and the number of tickets of each type for each day. Once a week, these statistics are transferred to the main computer.

  1. Draw a context diagram (DFD-0) for this system
  2. Draw DFD-1 diagram for this system

Network diagram

Table 1 shows list of the various activities in a software project development. The third column provides important additional information for coordinating the scheduling of the project members. For any given activity, its immediate predecessors are those activities that must be completed by no later than the starting time of the given activity.

ActivityActivity DescriptionImmediate PredecessorsEstimated Duration
AStake holder discussions-10 days
BFinalising business requirementA4 weeks
CRequirement specificationB10 weeks
DWork Break Down and job allocationC6 weeks
ESystem specificationC20 days
FSystem designE5 weeks
GFunctional SpecificationF, D7 weeks
HDevelopment specification and developmentG29 weeks
ITest Plan and Test caseG7 weeks
JUnit testing, integrating testing and bug fixingI8 weeks
KSystem Testing and bug fixingH, J4 weeks
LAcceptance Testing and bug fixingK25 days
MProject documentationH2 weeks
NClient Demonstration and Installation and testingL,M6 weeks
  1. Draw a network diagram with duration in weeks.
  2. Identify the early start, early finish, late start, late finish and slack for each activity in the network diagram (question ‘a’) and tabulate them.
  3. List one activity from the last that can be delayed, yet not affect the project schedule.
  4. List one activity which cannot be delayed to finish the project as per schedule. If that activity gets delayed, what corrective measures can be taken to keep the project on track?