Ask DBMS Expert


Home >> DBMS

Data flow Diagram case

Rockland county in Long Island has an active taxi workforce of over 1500 taxi drivers and a very active taxi union. Any licensed taxi driver of Rockland county can become a member of the local taxi union - local 330. A driver can walk into the local office and after showing his taxi drivers commercial grade license (CGL) fill in a membership form and pay the required membership dues. A driver can also fill out a membership form online and schedule an appointment to come into the office for the credentials verification prpocess. Once a drivers CGL has been verified as valid through the County's municipal database, the member is issued a Membership ID card and a receipt for his her dues payment. dues received from embers are logged into the Revenues Fil. The driver can either beome a member for a whole year at a discounted rate or go for monthly membership. Further, with a whole years dues payments, the driver is issued a Rockland Union T Shirt. Last but not the least, if the driver can fill in a separate form to enable automatic deductions of dues from his checking account as part of this initial payment process.

All members current information is maintained and regular checks are done to ensure that the information is up to date. Every month postcards are sent out to all members with industry updates and all returned postcards result in a follow up call/email to the member to seek his/her new address. Similarly, Rockland Taxi Union staffer, Jean Dunnet, sets into motion an automated greeting to all members via their phone system (and software) that records all dud calls. All members whose phone numbers do not work receive an letter/email with a request for a new phone number which then is updated. In a few cases all forms of contact with a member fail. Such members are placed in a Suspended Communications Status.n

For all members who have not enabled automatic dues collection from their checking acciunts, a comprehensive dues follow up process happens each month. The Dues follow process begins with the system automaticallygenerating a Dues Reminder mailer to all members when their dues expire. Members can pay either online, or by check or bring in their dues in cash to the office. All monies that come in response are processed and records updated to indicate the members staus as a "member in good standing." All members who fail to respond to the first reminder are sent a second reminder - a Membership Red Alert - 21 days after the first mailer went out. F a member fails to respond, his/her record is automatically moved into a Lapsed Member Status.

When a member has a ticket/summons issued by the local police for a driving violation, he/she can again bring it into the office of the local. The benefits administrator logs the ticket, processes the requisite payment and forwards the ticket details electronically to the local law firm - Shimmer Inc. The payment for a ticket is determined by the number of different violations that the driver has been charged with, each violation attracting a different degree of complexity of law and potential fine. The law firm schedules a lawyer and goes to court for the member. Once the court decision is known the law firms informs the union office of the outcome or new dates received and the records are updated forthwith.

Finally, members often have a myriad of other problems such as injury on the job, insurance irregularities, disputes with the Taxi owners etc. Any member who comes into the office with such problems goes through an Advocacy Case Intake Process. Each morning the Unions staff attorney examines the Advocacy Case files from the previous day. He sorts the files based on the area or domain of the case. All matters related to Workmans Compensation, Obama Care applications, Immigration, Taxes and Child Support cases are referred to an External Law Firm. He hands such files over to the Office secretary who calls the Law Firm and sets up an initial appointment for each driver. she then calls each driver and informs them of their appointment and what papers they need to carry with them when they go in for the appointment. All Taxi Industry related matters are then further divided up into two categories. Disputes with taxi fleets/brokers on one side and all Municipal Regulator related problems on the other. The staff attorney then calls the Rockland Municipality Transportation Depts attorney or other appropriate staff and develops a solution for each drivers problem from the second pile - Municipality related problems. Later that afternoon the Staff attorney has a 30 min meeting with the Unions Exec Director and Chief Organizer and develops a plan for all the drivers who have disputes with fleets/brokers. He hands all such cases over to the Chief Organizer who then makes the necessary calls to setup Dispute Resolution meetings with the Fleets/Brokers. The Advocacy Case database is updated at the end of each day by the Secretary.

Draw a LEVEL 1 DFD for the HANDLE ADVOCACY process.

ENSURE YOU USE DISTINCT SYMBOLS FOR EXTERNAL ENTITIES (SQUARE), PROCESSEA (CIRCLE) AND DATASTORES (OPEN RECTANGLE)

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M92013462
  • Price:- $35

Priced at Now at $35, Verified Solution

Have any Question?


Related Questions in DBMS

Data mining assignment -in this assignment you are asked to

Data Mining Assignment - In this assignment you are asked to explore the use of neural networks for classification and numeric prediction. You are also asked to carry out a data mining investigation on a real-world data ...

Sql query assignment -for this assignment you are to write

SQL Query Assignment - For this assignment you are to write your answers in a word document. This assignment is in three parts: Part A (reporting queries), Part B (query performance), Part C (query design). For this assi ...

The groceries datasetimagine 10000 receipts sitting on your

The groceries Dataset Imagine 10000 receipts sitting on your table. Each receipt represents a transaction with items that were purchased. The receipt is a representation of stuff that went into a customer's basket. That ...

You are in a real estate business renting apartments to

You are in a real estate business renting apartments to customers. Your job is to define an appropriate schema using SQL DDL in MySQL. The relations are Property(Id, Address, NumberOfUnits), Unit(ApartmentNumber, Propert ...

Objectivethe objective of this lab is to be familiar with a

OBJECTIVE: The objective of this lab is to be familiar with a process in big data modeling. You're required to produce three big data models using the MS PowerPoint software. This tool is available on UMUC Virtual Deskto ...

The relation memberstudentid organizationid roleid stores

The relation Member(StudentId, OrganizationId, RoleId) stores the membership information of student joining organization. For example, ('S1', 'O2', 'R3') indicates that student with Id 'S1' joined the organization with i ...

Relational database exerciseyou have been assigned to a new

Relational Database Exercise: You have been assigned to a new development team. A client is requesting a relational database system to manage their present store with the anticipation of adding more stores in the future. ...

Relational database design a given the following business

Relational Database Design A) Given the following business rules, identify entity types, attributes (at least two attributes for each entity, including the primary key) and relationships, and then draw an Entity-Relation ...

We can represent a data set as a collection of object nodes

We can represent a data set as a collection of object nodes and a collection of attribute nodes, where there is a link between each object and each attribute, and where the weight of that link is the value of the object ...

Data model development and implementationpurpose of the

Data model development and implementation Purpose of the assessment (with ULO Mapping) The purpose of this assignment is to develop data models and map Database System into a standard development environment to gain unde ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As