Create a user account and add and activate the tag by id

Assignment Help Database Management System
Reference no: EM131465781

A state-wide toll road system (MyStateTolls) allows users to buy an RF tag for use in paying tolls on their system. Each tag includes a unique tagID. In order to use the newly purchased tag a user must create a user account and add and activate the tag by ID. A user is either personal or commercial. The user registration system requires first and last name, street address, city, state, zip, and a bank account which will be charged for the tolls.

The bank account is identified by nameOfBank, routingNumber, accountNumber, nameOnAccount, and permission to create reoccurring charges. Additionally a tag can be registered to only one vehicle. The vehicle must be identified by VIN, make, model, year, registrationID, stateOfRegistration, and class. The registration process allows for four classes of vehicle (passenger, commercial2axle, commercial4axle, commercialHeavy). A user can register more than one vehicle but each must have its own tag.

Once the registration has been completed an initial balance is set on the MyStateTolls account. Additionally the user selects the level of charge to be drawn from the bank whenever the account balance is below the current charge level. The levelOfCharge can be either $15, $30, or $50, so the initial balance will also be one of these values. While driving the tag is read directly by the MyStateTolls system and the account charged with the appropriate road travel fee.

At the time of the charge a toll is identified by tagID, location, timeStamp including date, vehicleClass, and amount charged. When the balance on a toll account drops below the level to pay the current charge, the levelOfCharge is deducted from the registered bank account and added to the Toll account balance so that the balance always remains positive. If a vehicle is disposed of, the tag must be made inactive. The tag is not transferrable to another vehicle or user.

Reference no: EM131465781

Questions Cloud

What ways did various paleolithic societies : In what ways did various Paleolithic societies differ from one another and how did they change over time?
Which ideology played a role in fueling ethnic conflicts : What is the extent to which ideology played a role in fueling ethnic conflicts in Rwanda?
Business environment can pose challenges stemming : The business environment can pose challenges stemming from cultural differences between the home country and China.
How does each work to mitigate technical threats : Contrast and compare Management Controls and Operational Controls. How does each work to mitigate technical threats? Be sure to provide examples
Create a user account and add and activate the tag by id : A state-wide toll road system (MyStateTolls) allows users to buy an RF tag for use in paying tolls on their system. Each tag includes a unique tagID.
Find the average number of users during the sample period : The number of users that were logged into an Internet server was monitored every minute, over a period of 100 minutes. Here are the results.
Analysing yes or no questions based on elements of the crime : Analysing a series of yes or no questions based on the elements of the crime
Construct a histogram of the distribution : A farm-implement manufacturer in the Midwest purchases castings from the Omaha Steel foundry. Thirty castings were selected at random and weight!d.
Identified needs of each of actors that interact with system : The Product Owner has identified the needs of each of the actors that will interact with the system, and has assembled these into a prioritized Product Backlog

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd