Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

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

Suppose that we have a table of house prices and a table of

Suppose that we have a table of house prices and a table of zip codes: • hprices(hid (PK),address,bedrooms,price,zipcode) • zipcodes(zipcode (PK),state) Write a SQL query that finds the average, maximum, and minimum pric ...

Sqlwrite a select statement that returns three columns from

SQL Write a SELECT statement that returns three columns from the Vendors table: VendorContactFName, VendorContactLName, and VendorName. Sort the result set by last name, then by first name.

Sqlquery 1 how many products have standard price less than

SQL Query 1. How many products have standard price less than 1000? Query 2: Display all attributes for products made of "Cherry" from Product table w/o referring to column names. Query 3: Display all product names having ...

Your taskyou have been commissioned to develop a database

Your task You have been commissioned to develop a database system that is capable of keeping records for FU's table tennis matches from now on. The database needs to keep a record of: - All team information, including pl ...

Project outline and requirements provide a brief

Project Outline and Requirements Provide a brief description of the organization (can be hypothetical) that will be used as the basis for the projects in the course. Include company size, location(s), and other pertinent ...

Sql injection on a searchthe way search performs its task

SQL injection on a search The way Search performs its task is by executing the following query (in a php script):          $var=stripslashes($_POST['search']);          $query = "SELECT username from lab1_login where use ...

Select from e d pwhere edeptddept and dcitypcity and

Select * From E, D, P WHERE E.dept=D.dept AND D.city=P.city AND D.budget>1M AND P.priority=A; Assuming relations have the same size and uniform distributions, what is the best plan with Nested Loop joins only? Write it a ...

Assignmentqueries functions and triggersdatabase

Assignment Queries, Functions and Triggers Database Systems Aims The aims of this assignment are to: formulate SQL queries; populate an RDBMS with a real dataset, and analyse the data; design test data for testing SQL qu ...

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 ...

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. ...

  • 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