Please enable JavaScript.

Coggle requires JavaScript to display documents.

Oblig 3 (Part I (Entity (Town (Street (segment (route (Schedule (pickup…

- - - - Street
        
        Home
        
        Garbage
        
        Truck
        
        garbage is collected by truck. carry one or more garbagetypes, not all types
        
        identified by unique license plate number. has a brandname, model, year of manufactoring. quantity of each garbagetype
        
        produced by home. can be: plastic, metal, glass, paper, compost and other. each type unique type
        
        A ENTITY ITSELF OR GARBAGE TYPE??
        
        unique number within street
        
        segment
        
        route
        
        Schedule
        
        every route has a schedule for different kinds of garbage #
        
        a date for a particular type of garbage. several types of garbage may be collected on the same route on the same date.
        
        pickup round
        
        a pickup round has round number and for a particular date on a route
        
        one driver and multiple loaders are assigned to a truck to conduct multiple rounds. howeber these workers may change betweenthe rounds. #
        
        a route consists of multiple segments
        
        unique route number and route name
        
        streets are divided into different segments
        
        segment number
        
        Unique name within a town. towns can have same street name
      - Unique Name. consists of varius streets
    - - social sequirity number, name (composite): first name, middlename, lastname. date of birth, adress, phonenumber
      - a worker is either driver or loader
        
        driver: valid dricer license